|
|
Authorized user can see question and answers. Please log in or sign up. 
|
#13. You are attempting to create an Oracle-Managed Files (OMF) table space in a production database with the following statement and receive the following error message: CREATE TABLE SPACE tbsl;
ORA-02199: missing DATA FILE/TEMPFILE clause oerr ora 2199 02199, 00000, “missing DATA FILE/TEMPFILE clause” *Cause: A CREATE TABLE SPACE statement has no DATA FILE/TEMPFTLE clause. *Action: specify DATA FILE/TEMPFILE clause. What is the corrective action to create the OMF based table space?
Show comments for this question (1)
Add comments
Link to this question
|
|
#17. The Oracle Shared Server architecture reduces memory usage by reducing the number of server processes required. To process a request for a server process, the following tasks are performed: 1. A shared server picks up the request from the request queue and processes the request. 2. The dispatcher retrieves the response from the response queue. 3. A user sends a request to its dispatcher. 4. The dispatcher returns the response to the user. 5. The shared sever places the response on the calling dispatcher’s response queue. 6. The dispatcher places the request into the request queue in the SGA. Put the above task in the order in which they are performed.
Show comments for this question (1)
Add comments
Link to this question
|
|
#18. You issue this RMAN command:
RMAN> CREATE script Level0Backup { backup incremental LEVEL 0 format ‘/u01/db01/backup/%d_%_Sp’ fileperset 5 (DATABASE include CURRENT CONTROLFILE); SQL ‘ALTER DATABASE archive LOG CURRENT’; }
Which three statements are true about the Level0Backup script you just created? (Choose three)
Show comments for this question (1)
Add comments
Link to this question
|
|
|
|
gen. 0.073
|
Server date 06:20 02-12-2008
|
Developed by Zip © 2006
|
|
 |
|
|