SQL – Manipulating Data Questions 1.What does ACID mean with respect to relational database? Accuracy, Consistency, Isolation, Database Accuracy, Concurrency, Isolation, Durability Atomicity, Consistency, Isolation, Durability Atomicity, Concurrency, Isolation, Durability Answer: C. All Oracle transactions comply with the basic properties of a database transaction, known as ACID properties. Atomicity states that all tasks of a […]
Category Archives: sql Certificate
SQL – Using DDL Statements Questions 1.What is the full form of DDL in Oracle DB? Data Deleting Language Data Definition Language Data Delegating Language Dummy Data Language Answer: B. DDL is one of the categories of SQL which stands for Data Definition Language. Other SQL types are DML, DCL, and TCL. 2.DDL statements are […]
SQL – Get Data from Multiple Tables Questions 1.Which of the following is not related to a Relational Database? Selection Projection Joining None of the above Answer: D. The options A, B and C are the major capabilities of the Oracle Relational Database. 2.Which of the following methods is used for writing a query with […]