DBMS - SQL MCQ

Database

Title
How many tables may be included with a join?
Which of the following is one of the basic approaches for joining tables?
Which of the following statements is true concerning subqueries?
Which of the following is a correlated subquery?
A UNION query is which of the following?
Which of the following is true concerning triggers?
Which of the following is true concerning a procedure?
Which of the following is true concerning systems information in an RDBMS?
A CASE SQL statement is which of the following?
In SQL, which command is used to make permanent changes made by statements issue since the beginning of a transaction?
In SQL, which command(s) is(are) used to enable/disable a database trigger?
Which command is used to remove an index from the database in SQL?
Which command is used to remove a table from the database in SQL?
In SQL, GRANT command is used to
In SQL, which command(s) is(are) used to enable/disable all triggers on a table?
In SQL, which command is used to add new rows to a table?
An operation that will increase the length of a list is
In SQL, which command is used to add a column/integrity constraint to a table
In SQL, which command is used to changes data in a table?
Which of the following command(s) is(are) used to recompile a stored procedure in SQL?

Questions

Views

Best Answers

Points