Explore topic-wise MCQs in Database.

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.
Discussion
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;
Discussion
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
Discussion
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
Discussion
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
Discussion
6.

DML changes are

A. Insert
B. Update
C. Create
D. Both Insert and Update
Answer» E.
Discussion
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.
Discussion