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. Which one of these is type of DDL command BR इनमें से कौन DDL कमांड का?Data Definition Language Commands-DDL Commands विभिन्न Database Objects; जैसे—table (Table), व्यू (View), इन्डेक्स (Index) इत्यादि, को क्रिएट (Create) और मॉडिफाई (Modify) करने के लिए प्रयोग की जाती हैं। CREATE DROP एवं ALTER डेटा डेफिनिशन लैंग्वेज (DDL) की प्रमुख कमाण्ड्स (Commands) है।
DDL कमांड क्या है?DDL “Data Definition Language” के लिए जाना जाता है। डीडीएल एक ऐसी भाषा है जिसका उपयोग डेटा संरचनाओं को परिभाषित करने और डेटा को संशोधित करने के लिए किया जाता है। उदाहरण के लिए, DDL कमांड का उपयोग database में तालिकाओं को जोड़ने, हटाने या संशोधित करने के लिए किया जा सकता है।
DML क्या है Hindi?डेटा मैनीपुलेशन लैंग्वेज (Data Manipulation Language-DML), कमाण्ड्स (Commands) के एक ऐसे सेट (Set) को परिभाषित करती है, जिनका प्रयोग डेटाबेस ऑब्जेक्ट्स (Database Objects), जैसे—table (Table), को मॉडिफाई (Modify) करने के लिए किया जाता है।
|