Advanced SQL MCQ

Test your knowledge with important Advanced SQL MCQ and their applications. These MCQs are beneficial for competitive exams too. Explore 30+ more Advanced SQL MCQs on Bissoy. Bissoy App

• A correlated subquery is where the outer query depends on data from the inner query.
  ক

  True

  খ

  False
• The most frequently used relational operation, which brings together data from two or more related tables into one resultant table, is called an equi-join.
  ক

  True

  খ

  False
• When AUTOCOMMIT is set on, changes will be made automatically at the end of each SQL statement.
  ক

  True

  খ

  False
• There should be one condition within the WHERE clause for each pair of tables being joined.
  ক

  True

  খ

  False
• The joining technique is useful when data from several relations are to be retrieved and displayed and the relationships are not necessarily nested.
  ক

  True

  খ

  False
• Which of the following is true concerning triggers?
  ক

  You do not create them with SQL.

  খ

  They execute against only some applications that access a database.

  গ

  They have an event, condition, and action.

  ঘ

  They cannot cascade (cause another trigger to fire).
• The following SQL is which type of join: SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T WHERE CUSTOMER_T. CUSTOMER_ID = ORDER_T. CUSTOMER_ID
  ক

  Equi-join

  খ

  Natural join

  গ

  Outer join

  ঘ

  Cartesian join
• Which of the following is true concerning systems information in an RDBMS?
  ক

  RDBMS store database definition information in system-created tables.

  খ

  This information can be accessed using SQL.

  গ

  This information often cannot be updated by a user.

  ঘ

  All of the above.
• Which of the following statements is true concerning routines and triggers?
  ক

  Both consist of procedural code.

  খ

  Both have to be called to operate.

  গ

  Both run automatically.

  ঘ

  Both are stored in the database.
• A CASE SQL statement is which of the following?
  ক

  A way to establish an IF-THEN-ELSE in SQL.

  খ

  A way to establish a loop in SQL.

  গ

  A way to establish a data definition in SQL.

  ঘ

  All of the above.
• Which of the following is true concerning a procedure?
  ক

  You do not create them with SQL.

  খ

  They do not need to have a unique name.

  গ

  They include procedural and SQL statements.

  ঘ

  They are the same thing as a function.