a) select job, sum(sal) from emp where sum(sal) > 2500 and comm is null;
View QuestionWhich of the following queries are legal?
a) SELECT deptno, count(deptno) FROM emp GROUP BY ename; b) SELECT deptno, ...
View QuestionWhat is the purpose of SMON background process?
a) Performs crash recovery when a failed instance starts up again b) Performs recovery when a ...
View QuestionWhich of the following rule below are categories of an index?
a) Column and Functional b) Multiple Column and functional c) Column, ...
View QuestionThe ORDER BY clause can only be used in
a) SELECT queries b) INSERT queries c) GROUP BY queries
View Question
In the following query, which expression is evaluated first?
SELECT id_number, (quantity – 100 / 0.15 – 35 * 20) FROM inventory
In the following query, which expression is evaluated first? SELECT id_number, (quantity - 100 / 0.15 - 35 ...
View QuestionHow to force a log switch?
a) By using ALTER SYSTEM LOG b) By using ALTER SYSTEM SWITCH LOGFILE c) ...
View QuestionWhich of the following object types below cannot be replicated?
a) Data b) Trigger c) View d) ...
View QuestionWhich 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 ...
View Question