What is the maximum number of statements that can be specified in a trigger statement?
1
2
3
4
Which of the following is not a schema object?
Index
Tables
Public Synonymns
Triggers
What is the maximum number of Nested SubQueries used in WHERE Clause?
255
256
300
225
Where would you look for errors from the database engine?
Database Log
Alert Log
Error Log
Session Log
What are the min.extents allocated to a rollback extent?
What is the maximum number of triggers, can apply to a single table?
11
14
10
12
When the 'SELECT' clause of the SQL has the aggregate function, it is must to have this clause to prevent error
WHERE
ORDER BY
GROUP BY
Aggregate Function
Identify the OLAP function from the given options
MSUM
SUM
AVG
All of the above
This table will have duplicate rows
Volatile Table
Global Temporary table
MultiSet Table
Permanent Table
When Database A has 5GB of spool space, Database B is created as child of Database A with 3GB of spool space, then Database A will have
2GB of spool space
5GB of spool space
2GB of permanent space
3GB of spool space