Rapid Application Development - DBMS

1.

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

Answer: Option 'A'

100 / 0.15

2.

Which of the following object types below cannot be replicated?

   A.) Data
   B.) Trigger
   C.) View
   D.) Sequence

Answer: Option 'D'

Sequence

3.

The ORDER BY clause can only be used in

   A.) SELECT queries
   B.) INSERT queries
   C.) GROUP BY queries
   D.) HAVING queries

Answer: Option 'A'

SELECT queries

4.

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

Answer: Option 'A'

Performs crash recovery when a failed instance starts up again

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: Option 'B'

By using ALTER SYSTEM SWITCH LOGFILE

Rapid Application Development Download Pdf