Table of Contents
Which of the following is not a DDL command?
Options:
A. UPDATE
B. TRUNCATE
C. ALTER
D. None of the Mentioned
The Correct Answer Is:
- A. UPDATE
Related Questions,
In the above DDL command the foreign key entries are got by using the keyword
A. references
B. key reference
C. relating
D. none of the mentioned
Answer» A. references
Which of the following information does an SQL DDL not specify?
A. The schema for each relation
B. The integrity constraints
C. The operations on the tuples
D. The security and authorization information for each relation
Answer» C. The operations on the tuples
Which of the following is/are the DDL statements?
A. Create
B. Drop
C. Alter
D. All of the above
Answer» D. All of the above
________________ is not a category of SQL command.
A. TCL
B. SCL
C. DCL
D. DDL
Answer» B. SCL
Which of the following SQL command can be used to modify existing data in a database table?
A. modify
B. update
C. change
D. new
Answer» B. update
Which of the following command makes the updates performed by the transactionpermanent in the database?
A. ROLLBACK
B. COMMIT
C. TRUNCATE
D. DELETE
Answer» B. COMMIT
Which of the following command is used to delete a trigger?
A. DELETE TRIGGER
B. REPLACE TRIGGER
C. DROP TRIGGER
D. None of the above
Answer» C. DROP TRIGGER
In SQL, which command is used to issue multiple CREATE TABLE, CREATE VIEW and GRANT statements in a single transaction?
A. create package
B. create schema
C. create cluster
D. all of the mentioned
Answer» B. create schema