|
Question |
Rating |
View Answer |
|
What is strip sources generate options? |
|
View Answer |
|
Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each? |
|
View Answer |
|
What is the biggest advantage of having the control files on different disks? |
|
View Answer |
|
What is USING Clause and give example? |
|
View Answer |
|
Which command will “bounce” the database-that is, shut down the database and start up the database in a single command? |
|
View Answer |
|
Which data dictionary view shows information about the status of a procedure? |
|
View Answer |
|
What are the advantages of having a Package ? |
|
View Answer |
|
What is the remove on exit property? |
|
View Answer |
|
Which parameter in the ORAPWD utility is optional? |
|
View Answer |
|
What is COST-based approach to optimization ? |
|
View Answer |
|
How do you find the numbert of rows in a Table ? |
|
View Answer |
|
How many data files can be specified in the DATAFILE clause when creating a database? |
|
View Answer |
|
When transporting a tablespace from one database to another, it should be a. Read-only. b. Offline. c. Online. d. Tablespace status does not matter.
|
|
View Answer |
|
Which script creates the CHAINED_ROWS table? A. catproc.sql B. catchain.sql C. utlchain.sql D. No script is necessary: ANALYZE TABLE LIST CHAINED ROWS creates the table.
|
|
View Answer |
|
What does a Control file Contain ? |
|
View Answer |
|
Which role in the following list is not a predefined role from Oracle? a. SYSDBA b. CONNECT c. IMP_FULL_DATABASE d. RESOURCE
|
|
View Answer |
|
Can you pass values to-and-fro from foreign function ? how ? |
|
View Answer |
|
What is the maximum number of database writer processes allowed in an Oracle instance? |
|
View Answer |
|
What are the uses of Database Trigger ? |
|
View Answer |
|
When a table is updated, where is the before image information (which can be used for undoing the changes) stored? |
|
View Answer |