Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
8 Cards in this Set
- Front
- Back
|
Which view would you query to determine whether a user has been granted EXECUTE privilege on a procedure? |
DBA_TAB_PRIVS |
|
|
Which files must be included in a backup following a SHUTDOWN IMMEDIATE, if the database is not running in archivelog mode? |
Controlfiles Permanent tablespace datafiles |
|
|
What events cause a full checkpoint? |
Executing ALTER SYSTEM CHECKPOINT A SHUTDOWN IMMEDIATE A SHUTDOWN TRANSACTIONAL |
|
|
What are attributes of database roles? |
ROLES can have passwords just like users |
|
|
if a session terminates in a disorderly fashion, which process is responsible for freeing up any server resources that is may be using |
PMON |
|
|
What conditions will make a SQL*Loader direct load impossible? |
the target table is a clustered table there is an uncommitted transaction involving one or more rows of the target table. |
|
|
When starting a database instance, how can you specify the name and location of the server parameter file? |
a non-default server parameter file can be specified when one is registering the database with Oracle Restart |
|
|
If a database has been upgraded to release 12c from earlier releases, it may contain dictionary-managed tablespaces with freelist-managed segments. How can you change these to the more efficient locally managed tablespaces with automatic segment space management? |
Convert the tablespaces but not the segments |
