MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 7 Mcqs, each offering curated multiple-choice questions to sharpen your Database knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
WHAT_IS_THE_PURPOSE_OF_SMON_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. | None of the mentioned |
| Answer» E. | |
| 2. |
Which_of_the_following_queries_are_legal?$ |
| A. | SELECT deptno, count(deptno) FROM emp GROUP BY ename; |
| B. | SELECT deptno, count(deptno), job FROM emp GROUP BY deptno; |
| C. | SELECT deptno, avg(sal) FROM emp; |
| D. | SELECT deptno, avg(sal) FROM emp GROUP BY deptno; |
| Answer» C. SELECT deptno, avg(sal) FROM emp; | |
| 3. |
Which of the following rule below are categories of an index? |
| A. | Column and Functional |
| B. | Multiple Column and functional |
| C. | Column, Multiple Column and functional |
| D. | None of the mentioned |
| Answer» B. Multiple Column and functional | |
| 4. |
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 | |
| 5. |
How to 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 | |
| 6. |
DML changes are |
| A. | Insert |
| B. | Update |
| C. | Create |
| D. | Both Insert and Update |
| Answer» E. | |
| 7. |
Which schema object instructs Oracle to connect to a remotely access an object of a database? |
| A. | Sequence |
| B. | Remote link |
| C. | Database link |
| D. | Data link |
| Answer» E. | |