In SQL, which command is used to issue multiple CREATE TABLE, CREATE VIEW and GRANT statements in a single transaction?

Related MCQs

•                  dump, writes out SQL DDL statements and SQL insert statements to a file, which can then be reexecuted to re- create the database.
• Consider a hash table of size seven, with starting index zero, and a hash function (3x + 4)mod7. Assuming the hash table is initially empty, which of the following is the contents of the table when the sequence 1, 3, 8, 10 is inserted into the table using closed hashing? Note that ‘_’ denotes an empty location in the table.
• If we wish to grant a privilege and to allow the recipient to pass the privilege on to other users, we append the                      clause to the appropriate grant command.
• View the Exhibit and examine the data in the EMPLOYEES tables. Evaluate the following SQL statement: SELECT employee_id, department_id FROM employees WHERE department_id= 50 ORDER BY department_id UNION SELECT employee_id, department_id FROM employees WHERE department_id= 90 UNION SELECT employee_id, department_id FROM employees WHERE department_id= 10; What would be the outcome of the above SQL statement?
• Which of the following SQL command can be used to modify existing data in a database table?
• Which TCL command undo all the updates performed by the SQL in the transaction?
• Which command is used to create a new relation in SQL
• The SQL command to creating a table is:
• What SQL command will allow you to change the table STUDENT to add the constraint named GradeCheck that states that the values of the Grade column must be greater than 0?
• Which SQL function is used to count the number of rows in a SQL query?