|
Related Questions |
View Answer |
|
Which two statements are true regarding working with dates? (Choose two.) A. The default internal storage of dates is in the numeric format B. The default internal storage of dates is in the character format C. The RR date format automatically calculates the century from the SYSDATE function and does not allow the user to enter the century D. The RR date format automatically calculates the century from the SYSDATE function but allows the user to enter the century if required
|
View Answer
|
|
Which three statements are true regarding subqueries? (Choose three.) A. Subqueries can contain GROUP BY and ORDER BY clauses B. Main query and subquery can get data from different tables C. Main query and subquery must get data from the same tables D. Subqueries can contain ORDER BY but not the GROUP BY clause E. Only one column or expression can be compared between the main query and subqeury F. Multiple columns or expressions can be compared between the main query and subquery
|
View Answer
|
|
Which three statements/commands would cause a transaction to end? (Choose three.) A. COMMIT B. SELECT C. CREATE D. ROLLBACK E. SAVEPOINT
|
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
|