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 at Bissoy

• With the UNION clause, each query involved must output the same number of columns, and they must be UNION compatible.
  ক

  True

  খ

  False
• A function returns one value and has only output parameters.
  ক

  True

  খ

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

  True

  খ

  False
• Outer join is the same as equi-join, except one of the duplicate columns is eliminated in the result table.
  ক

  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
• ROLLBACK WORK asks SQL to empty the log file.
  ক

  True

  খ

  False
• The UNION clause is used to combine the output from multiple queries together into a single result table.
  ক

  True

  খ

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

  True

  খ

  False
• A transaction is the complete set of closely related update commands that must all be done, or none of them done, for the database to remain valid.
  ক

  True

  খ

  False
• The code to create triggers and routines is stored in only one location and is administered centrally.
  ক

  True

  খ

  False
• Subqueries can be nested multiple times.
  ক

  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
• Triggers are stored blocks of code that have to be called in order to operate.
  ক

  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.