This set of Oracle Database Multiple Choice Questions & Answers (MCQs) focuses on “Installing Oracle Database 11g and Creating a Database”. 1. Oracle server configuration is dedicated for a) One server process – Many user processes b) Many server processes – One user process c) One server process – One user process d) Many server … Read more
This set of Oracle Database Multiple Choice Questions & Answers (MCQs) focuses on “Storing and Guarding the Data”. 1. Where is data dictionary kept? a) SYSTEM Tablespace b) Stack Space c) Data File d) None of the Mentioned 2. Which schema object instructs Oracle to connect to remotely access an object of a database? a) … Read more
This set of Oracle Database Multiple Choice Questions & Answers (MCQs) focuses on “Programmatic Oracle Structures”. 1. What does DLL stand for ? a) Dynamic Link Library b) Dynamic Language Library c) Dynamic Load Library d) None of the Mentioned 2. POST-BLOCK trigger is also a ? a) Navigational Trigger b) Key Trigger c) Transaction … Read more
This set of Oracle Database Multiple Choice Questions & Answers (MCQs) focuses on “Databases and Instances”. 1. The Oracle environment of database is called as ___________ a) Database Schema b) Database Instances c) Data Structure d) All of the Mentioned 2. Which is the smallest unit of storage in an Oracle database? a) Data Block … Read more
This set of Oracle Database Multiple Choice Questions & Answers (MCQs) focuses on “Oracle Database 11g Architecture”. 1. What is the use of Library cache? a) Contains User information, such as user privileges b) Used to store shared SQL c) Log of changes made to the database d) All of the Mentioned 2. Which processes … Read more
