MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 139 Mcqs, each offering curated multiple-choice questions to sharpen your Technical Programming knowledge and support exam preparation. Choose a topic below to get started.
| 101. |
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 processes – Many user processes |
| Answer» D. Many server processes – Many user processes | |
| 102. |
Which of the following queries displays the sum of all employee salaries for those employees not making commission, for each job, including only those sums greater than 2500? |
| A. | select job, sum(Sal) from Emp where sum(Sal) > 2500 and comm is null; |
| B. | select job, sum(Sal) from Emp where comm is null group by job having sum(Sal) > 2500; |
| C. | select job, sum(Sal) from Emp where sum(Sal) > 2500 and comm is null group by job; |
| D. | select job, sum(Sal) from Emp group by job having sum(Sal) > 2500 and comm is not null; |
| Answer» C. select job, sum(Sal) from Emp where sum(Sal) > 2500 and comm is null group by job; | |
| 103. |
What is the result of the following ‘PAN’NULL’KAJ’? |
| A. | Error |
| B. | PAN KAJ |
| C. | PANKAJ |
| D. | NULL |
| Answer» D. NULL | |
| 104. |
Which of the following statement is false ? |
| A. | Any procedure can raise a error and return an user message and error number |
| B. | Error number is ranging from 20000 to 20999 are reserved for user defined messages |
| C. | Oracle checks Uniqueness of User defined errors |
| D. | Raise_Application_error is used for raising an user defined error |
| Answer» D. Raise_Application_error is used for raising an user defined error | |
| 105. |
What is SQL * FORMS ? |
| A. | SQL * FORMS is a 4GL tool for developing and executing Oracle based interactive based application |
| B. | SQL * FORMS is a 3GL tool for connecting to a Database |
| C. | SQL * FORMS is a reporting tool |
| D. | None of the Mentioned |
| Answer» B. SQL * FORMS is a 3GL tool for connecting to a Database | |
| 106. |
In Oracle, which of the following package procedure is UNRESTRICTED ? |
| A. | CALL_INPUT |
| B. | CLEAR_BLOCK |
| C. | EXECUTE_QUERY |
| D. | USER_EXIT |
| Answer» E. | |
| 107. |
The system variable that records the select statement that SQL * FORMS most recently used to populate a block is __________ |
| A. | SYSTEM.LAST_RECORD |
| B. | SYSTEM.CURSOR_RECORD |
| C. | SYSTEM.CURSOR_FIELD |
| D. | SYSTEM.LAST_QUERY |
| Answer» E. | |
| 108. |
POST-BLOCK trigger is also a ? |
| A. | Navigational Trigger |
| B. | Key Trigger |
| C. | Transaction Trigger |
| D. | All of the Mentioned |
| Answer» B. Key Trigger | |
| 109. |
What does DLL stand for ? |
| A. | Dynamic Link Library |
| B. | Dynamic Language Library |
| C. | Dynamic Load Library |
| D. | None of the Mentioned |
| Answer» B. Dynamic Language Library | |
| 110. |
When a transaction modifies the database, Oracle copies the original data before modifying it. The original copy of the modified data is called |
| A. | Undone Data |
| B. | Archive Data |
| C. | Redo Data |
| D. | Undo Data |
| Answer» E. | |
| 111. |
Recycle bin can be turned on or off this. This parameter is stored in which of the below file? |
| A. | PARAMETER FILE |
| B. | PARFILE |
| C. | DATAFILES |
| D. | PFILE |
| Answer» B. PARFILE | |
| 112. |
What is the purpose of SMON (System Monitor Process) background process? |
| A. | Performs crash recovery when a failed instance starts up again |
| B. | Performs recovery when a user process fails |
| C. | Writes redo log entries to disk |
| D. | All of the Mentioned |
| Answer» B. Performs recovery when a user process fails | |
| 113. |
Which of the following rule below are categories of index? |
| A. | Column and Functional |
| B. | Multiple Column and Functional |
| C. | To create an index in another schema |
| D. | None of the Mentioned |
| Answer» B. Multiple Column and Functional | |
| 114. |
The ORDER BY clause can only be used in ___________ |
| A. | SELECT queries |
| B. | INSERT queries |
| C. | GROUP BY queries |
| D. | HAVING queries |
| Answer» B. INSERT queries | |
| 115. |
In the below given query, which expression is evaluated first? SELECT id_number, (quantity – 100 / 0.15 – 35 * 20) FROM inventory |
| A. | 0.15-35 |
| B. | quantity – 100 |
| C. | 35*20 |
| D. | 100 / 0.15 |
| Answer» E. | |
| 116. |
How we can force a log switch? |
| A. | By using ALTER SYSTEM LOG |
| B. | By using ALTER SYSTEM SWITCH LOGFILE |
| C. | By using ALTER SYSTEM SWITCH LOGS |
| D. | By using ALTER SYS LOGFILES |
| Answer» C. By using ALTER SYSTEM SWITCH LOGS | |
| 117. |
Which of the following object types below cannot be replicated? |
| A. | Data |
| B. | Trigger |
| C. | View |
| D. | Sequence |
| Answer» E. | |
| 118. |
Which schema object instructs Oracle to connect to remotely access an object of a database? |
| A. | Sequence |
| B. | Remote Link |
| C. | Database Link |
| D. | Data Link |
| Answer» E. | |
| 119. |
Where is data dictionary kept? |
| A. | SYSTEM Tablespace |
| B. | Stack Space |
| C. | Data File |
| D. | None of the Mentioned |
| Answer» B. Stack Space | |
| 120. |
A _____________ is a set of tables physically stored together as one table that shares a common column |
| A. | Index |
| B. | Object |
| C. | Datafiles |
| D. | Cluster |
| Answer» E. | |
| 121. |
A _______________ is used to logically group data together |
| A. | Database |
| B. | Tablespace |
| C. | Datafiles |
| D. | Object |
| Answer» C. Datafiles | |
| 122. |
Modification schema of oracle database in one level without affecting the schema in high level is called as _______ |
| A. | Data Migration |
| B. | Data Isolation |
| C. | Data Independence |
| D. | Data Abstraction |
| Answer» D. Data Abstraction | |
| 123. |
Map entities, attributes and relations in Oracle is represented by___________ |
| A. | Conceptual Schema |
| B. | Logical Schema |
| C. | Physical Schema |
| D. | All of the Mentioned |
| Answer» C. Physical Schema | |
| 124. |
What do the schema objects comprise of? |
| A. | Table |
| B. | Index |
| C. | Cluster |
| D. | All of the Mentioned |
| Answer» E. | |
| 125. |
What are the valid Oracle database schemas? |
| A. | Logical Schema |
| B. | Physical Schema |
| C. | Logical and Physical Schema |
| D. | None of the Mentioned |
| Answer» D. None of the Mentioned | |
| 126. |
Oracle database’s design is also called as_____________ |
| A. | Database Abstraction |
| B. | Database Instance |
| C. | Database Schema |
| D. | None of the Mentioned |
| Answer» D. None of the Mentioned | |
| 127. |
Collection of information stored in database at particular instance of time is called as ___________ |
| A. | Instance of Database |
| B. | Objects in Databases |
| C. | Data structure |
| D. | Database Schema |
| Answer» B. Objects in Databases | |
| 128. |
Which is the smallest unit of storage in an Oracle database? |
| A. | Data Block |
| B. | Segment |
| C. | Extent |
| D. | Data File |
| Answer» B. Segment | |
| 129. |
The Oracle environment of database is called as ___________ |
| A. | Database Schema |
| B. | Database Instances |
| C. | Data Structure |
| D. | All of the Mentioned |
| Answer» C. Data Structure | |
| 130. |
The redo log buffer and Shared pool are elements of? |
| A. | PGA |
| B. | Buffer cache |
| C. | PGA and Buffer cache |
| D. | SGA |
| Answer» E. | |
| 131. |
In Oracle, which of below are types of segments? |
| A. | Permanent Segment |
| B. | Object Segment |
| C. | Data Segment |
| D. | All of the Mentioned |
| Answer» D. All of the Mentioned | |
| 132. |
The ____________ contains a set of tables and views that Oracle uses as a reference to the database. |
| A. | PGA |
| B. | Library cache |
| C. | Data dictionary |
| D. | SGA |
| Answer» D. SGA | |
| 133. |
Which area of PGA stores binding variables and run-time buffers information? |
| A. | SQL area |
| B. | Private SQL area |
| C. | Stack space |
| D. | Session area |
| Answer» C. Stack space | |
| 134. |
What is the use of extent in Oracle? |
| A. | Stores user data within the database |
| B. | Stores rollback information used when data must be rolled back |
| C. | Minimize the amount of wasted (empty) storage |
| D. | None of the Mentioned |
| Answer» D. None of the Mentioned | |
| 135. |
Which of the following components comprise an Oracle architecture? |
| A. | Database related background processes |
| B. | Tablespaces |
| C. | Datafiles |
| D. | All of the Mentioned |
| Answer» E. | |
| 136. |
What is the use of an index? |
| A. | Retrieve data more quickly and efficiently |
| B. | Related data requires much less I/O overhead if accessed simultaneously |
| C. | Simplify the user’s perception of data access |
| D. | All of the Mentioned |
| Answer» B. Related data requires much less I/O overhead if accessed simultaneously | |
| 137. |
Which of the following segment is destroyed when the SQL statement is finished? |
| A. | Data Segment |
| B. | Object Segment |
| C. | Temporary Segment |
| D. | All of the Mentioned |
| Answer» D. All of the Mentioned | |
| 138. |
Which processes is an instance made of Oracle? |
| A. | Oracle background processes |
| B. | Memory processes |
| C. | Data processes |
| D. | All of the Mentioned |
| Answer» B. Memory processes | |
| 139. |
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 |
| Answer» C. Log of changes made to the database | |