This set of Oracle Database Multiple Choice Questions & Answers (MCQs) focuses on “DDL Commands”. 1. Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables? Answer: a 2. Which of the following is/are the DDL statements? Answer: d 3. In SQL, which command(s) is(are) used to change a table’s storage characteristics? Answer: a 4. In SQL, which of the following is not a data definition language commands? Answer: a 5. ________clause is an additional filter that is applied to the result. Answer: c 6. ___________ defines rules regarding the values allowed in columns and is the standard mechanism for enforcing database integrity. Answer: b 7. SQL has how many main commands for DDL: Answer: c 8. Which command defines its columns, integrity constraint in create table: Answer: a 9. Which command is used for removing a
table and all its data from the database: Answer: b 10. Which command allows the removal of all rows from a table but flushes a table more efficiently since no rollback information is retained: Answer: a Sanfoundry Global Education & Learning Series – Oracle Database. To practice all areas of Oracle Database, here is complete set of 1000+ Multiple Choice Questions and Answers. Manish Bhojasia, a technology veteran with 20+ years @ Cisco & Wipro, is Founder and CTO at Sanfoundry. He lives in Bangalore, and focuses on development of Linux Kernel, SAN Technologies, Advanced C, Data Structures & Alogrithms. Stay connected with him at LinkedIn. Subscribe to his free Masterclasses at Youtube & technical discussions at Telegram SanfoundryClasses.
Question 6 - Past Year - 1 Mark Questions - Chapter 9 - Structured Query LanguageLast updated at June 29, 2022 by
(A) SELECT(B) ALTER(C) INSERT(D) UPDATEAnswer: DDL(Data Definition Language) commands are used to create and modify the structure of a database and database objects.
Checking the options
So, the correct answer is (B) TranscriptThis question asked in CBSE SQP-2021 Which of the following is a DDL command? (A) SELECT (B) ALTER (C) INSERT (D) UPDATE Answer: DDL(Data Definition Language) commands are used to create and modify the structure of a database and database objects. DDL Command Description CREATE Used to create databases and tables ALTER Used to add, delete or edit columns and remove or create constraints in a table DESCRIBE Used to view the structure of an already created table DROP Used to permanently remove a database or a table from the system Checking the options (A) SELECT - It is not a DDL command (B) ALTER - It is a DDL command (C) INSERT - It is not a DDL command (D) UPDATE - It is not a DDL command So, the correct answer is (B)
Past Year - 1 Mark Questions |