Dropping a table causes its synonym to drop.
True
False
can we rename a Synonym?
If a table is dropped, then triggers created on it will also be dropped.
Select belongs to which type of language?
DDL
DML
DCL
None of the Above
DESC belongs to
None the above
Dropped table can be got back without recreating it.
How can we calculate average of a column?
using AVG () function
Using AVERAGE() function
using SUM() and Count() functions
using Total() function
what are the functions used for calculating sub totals ?
Using Rollup() function
Using SUBTOT() function
Using SUBSUM() function
All the above
Which process registers the logfile in a standby database ?
RFS
MRP
ARCH
LGWR
Which process reads data from the data file into the database buffer cache ?
Server process
DBWR
CKPT
PMON