|
Question |
Rating |
View Answer |
|
What is the advantage of the library? |
|
View Answer |
|
At which stage of the database start-up is the control file opened? |
|
View Answer |
|
What is advantage of having disk shadowing/ Mirroring ? |
|
View Answer |
|
How does one do off-line database backups? |
|
View Answer |
|
Which password parameter in the profile definitions can restrict the user from using the old password for 90 days? |
|
View Answer |
|
Which role is created by default to administer databases? |
|
View Answer |
|
What are the Back ground processes in Oracle and what are they? |
|
View Answer |
|
What are Schema Objects? |
|
View Answer |
|
Which view would you query to see whether John has the CREATE TABLE privilege?
a. DBA_SYS_PRIVS b. DBA_USER_PRIVS c. DBA_ROLE_PRIVS d. DBA_TAB_PRIVS
|
|
View Answer |
|
If you need to have your archive log files named with the log sequence numbers as arch_0000001, arch_0000002, and so on (zero filled, fixed width), what should be the value of the LOG_ARCHIVE_FORMAT parameter? |
|
View Answer |
|
When a SELECT statement is issued, which stage checks the user’s privileges? |
|
View Answer |
|
What are the Key Words Used in Oracle? |
|
View Answer |
|
What is Restricted Mode of Instance Startup ? |
|
View Answer |
|
What is the difference between OLE Server & Ole Container? |
|
View Answer |
|
what is pga ? |
|
View Answer |
|
What is a Static Record Group? |
|
View Answer |
|
What does the parameter DIRECT=Y in the export parameter file signify? a. When exporting table data, bypass the SQL buffer cache and read the data blocks directly form the disk to the export file. b. When exporting table data, bypass the SQL processing layer and read data from disk to the buffer cache, and copy them directly to the export files c. When importing data using the export file create, write data blocks directly to the file, rather than going through the buffer. d. To perform a direct import, the export file must be created sing the direct method.
|
|
View Answer |
|
What is a join ? Explain the different types of joins ? |
|
View Answer |
|
What is a difference between pre-select and pre-query? |
|
View Answer |
|
How you open and close a cursor variable. Why it is required? |
|
View Answer |