ORACLE MCQ Test – 3 Que.1. 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 Right Answer: D Que.2. DML changes are A: insert B: update C: create D: both a and b Right Answer: D Que.3. Is global temporary table session specific? A: Yes B: No Right Answer: A Que.4. Which of the following object types below cannot be replicated? A: Data B: Trigger C: View D: Sequence Right Answer: D Que.5. Procedures and functions that are created within a package are called standalone subprograms A: True B: False Right Answer: B Que.6. 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 Right Answer: B Que.7. The SYSDBA and SYSOPER system privileges allow access to a database instance even when the database is not open A: True B: False Right Answer: A Que.8. In the following query, which expression is evaluated first? SELECT id_number, (quantity - 100 / 0.15 - 35 * 20) FROM inventory A: 100 / 0.15 B: quantity - 100 C: 35*20 D: 0.15-35 Right Answer: A Que.9. The ORDER BY clause can only be used in A: SELECT queries B: INSERT queries C: GROUP BY queries D: HAVING queries Right Answer: A Que.10. Which of the following rule below are categories of index? A: Column and Functional B: Multiple Column and functional C: Both and b D: None of the above Right Answer: A Que.11. 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: Both a and b D: Writes redo log entries to disk Right Answer: A Que.12. Recycle bin can be turned on or off in the recyclebin=on/off in A: Parameter file B: PARFILE C: datafiles D: PFILE Right Answer: A Que.13. The ______________ records all changes made to data A: Redo log B: Archive log C: Both a and b D: Data file Right Answer: A Que.14. 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 Right Answer: D Que.15. 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; Right Answer: D Que.16. 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; Right Answer: B Que.17. A stored procedure is only executed A: implicitly B: when asked explicitly C: when the trigger associated with it is also invoked D: none of the above Right Answer: B Que.18. When an Oracle database is created, which user is automatically created and granted the DBA role A: SYS B: SYSTEM C: SGA D: Both a and b Right Answer: D Que.19. Each tablespace in an Oracle database consists of one or more files called A: Files B: name space C: datafiles D: PFILE Right Answer: C Que.20. Even though a table space may be dropped, the objects and data in it are still available A: True B: False Right Answer: B
Posted on: Sat, 20 Jul 2013 04:56:57 +0000