|
Related Questions |
View Answer |
|
Which two statements are true about sequences created in a single instance database? (Choose two.) A. The numbers generated by a sequence can be used only for one table B. DELETE <sequencename> would remove a sequence from the database C. CURRVAL is used to refer to the last sequence number that has been generated D. When the MAXVALUE limit for a sequence for reached, you can increase the MAXVALUE limit by using the ALTER SEQUENCE statement E. When a database instance shuts down abnormally, the sequence numbers that have been cached but not used would be available once again when the database instance is restarted
|
View Answer
|
|
What are transportable table spaces and the need to use them?
|
View Answer
|
|
What are transportable table spaces and the need to use them?
|
View Answer
|
|
What are the benefits of system-managed locally managed tablespace ?
|
View Answer
|
|
How do you use STANDBY_ARCHIVE_DEST parameter and explain it's need?
|
View Answer
|
|
What is the use of PARALLEL_ADAPTIVE_MULTI_USER initialization parameter
|
View Answer
|
|
How do you create a multiple databases with the same configuration?
|
View Answer
|
|
What will be the output for this query: select 1 from dual minus select 'a' from dual;
|
View Answer
|
|
What is row chaining and row migration?
|
View Answer
|