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
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
No comments:
Post a Comment