This set of Oracle Database Multiple Choice Questions & Answers (MCQs) focuses on “DCL ,TCL Command”. 1. DCL stands for : a) Data Control Language b) Data Console Language c) Data Console Level d) Data Control Level 2. TCL stands for: a) Transaction control languages b) Transaction command languages c) Transaction connect languages d) None … Read more
This set of Oracle Database Multiple Choice Questions & Answers (MCQs) focuses on “DML Command”. 1. The language used application programs to request data from the DBMS is referred to as __________ a) DML b) DDL c) Query language d) All of the Mentioned 2. In SQL, which of the following is not a data … Read more
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? a) Data Definition Language(DDL) b) Data Manipulation Language(DML) c) DML and DDL d) None of the Mentioned 2. Which of the following is/are the … Read more
This set of Oracle Database Multiple Choice Questions & Answers (MCQs) focuses on “Structured Query Language”. 1. What is the full form of SQL? a) Structured Query Language b) Structured Query List c) Simple Query Language d) None of the Mentioned 2. Which is the subset of SQL commands used to manipulate Oracle Database structures, … Read more
This set of Oracle Database Multiple Choice Questions & Answers (MCQs) focuses on “Attribute, tuple and Entity”. 1. In an E-R diagram an entity set is represent by a a) Rectangle b) Ellipse c) Diamond box d) Circle 2. A relational database developer refers to a record as a) A criteria b) A relation c) … Read more
This set of Oracle Database Multiple Choice Questions & Answers (MCQs) focuses on “Foreign, Candidate, Primary, Composite, Unique Keys”. 1. How can a SQL developer add a key on a table? a) While creating a table b) With Alter table command c) With SQL server Properties window d) All of the Mentioned 2. A _______________ … Read more
This set of Oracle Database Multiple Choice Questions & Answers (MCQs) focuses on “Normalization”. 1. A table is in BCNF if it is in 3NF and if every determinant is a ___________ key. a) Dependent b) Normal c) Candidate d) Both Normal and Candidate 2. The ___________ normalization introduced by Chris Date, Hugh Darwen, and … Read more
This set of Oracle Database Multiple Choice Questions & Answers (MCQs) focuses on “Data Entry ,Query and Reporting”. 1. A BI reporting system does not _____________ a) Create meaningful information b) Deliver information to users on a timely basis c) Use statistical procedures to predict future events d) Use disparate data sources 2. The “curse … Read more
This set of Oracle Database Multiple Choice Questions & Answers (MCQs) focuses on “The Atomic Data Models and Business Models”. 1. A collection of data designed to be used by different people is called a/an a) Organization b) Database c) Relationship d) Schema 2. Which of the following is the oldest database model? a) Relational … Read more
This set of Oracle Database Multiple Choice Questions & Answers (MCQs) focuses on “Planning Oracle Applications—Approaches, Risks, and Standards”. 1. Database management systems are intended to _____________ a) Eliminate data redundancy b) Establish relationship among records in different files c) Manage file access d) All of the Mentioned 2. One approach to standardization storing of … Read more
