databases Online Quiz - 39
|Description: databases Online Quiz - 39|
|Number of Questions: 20|
|Created by: Aliensbrain Bot|
Which of the following generates the PLAN for SQL statements?
In which version of Oracle is AWR Introduced ?
Which user owns all the package of STATSPACK?
Which of the following is not a schema object?
If commission is null then the text “Not Applicable” must be displayed, instead of blank space. How do I write the query?
A transaction is a set of SQL statements between any two COMMIT and ROLLBACK statements.
What are the min.extents allocated to a rollback extent ?
What is the maximum no.of columns a table can have ?
Data Dictionary in oracle is used to store information about various physical and logical Oracle structures e.g.Tables, Tablespaces, datafiles, etc
Can Check constraint be used for self referential integrity ?
A table has the following data : [[5, Null, 10]].What will the average function return ?
Consider a sequence whose currval is 1 and gets incremented by 1 by using the nextval reference we get the next number 2.Suppose at this point we issue an rollback and again issue a nextval.What will the output be ?