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;
5 Cards in this Set
- Front
- Back
|
Question: 1 You executed the followingcommand to drop a user: DROP USER scott CASCADE; Whichtwo statements regarding the above command are correct? (Choose two.) A. All the objects of scottare moved to the Recycle Bin B. Any objects in the RecycleBin belonging to scott are purged C. All the objects owned byscott are permanently dropped from the database D. All the objects of scott inthe Recycle Bin must be purged before executing the DROP command E.Any objects in the Recycle Bin belonging to scott will not be affected by theabove DROP command |
Answer: B,C Any objects in the Recycle Bin belonging to scott are purged All the objects owned by scott are permanently dropped from the database |
|
|
Question: 2 Which client requests to the database can be capturedas a part of the workload capture? (Choose all that apply.) A. Flashback query B. Distributed transactions C. Logging in and logging out of sessions D. All DDL statements having bind variables E. Direct path load of data from external files |
Answer: C,D Logging in and logging out of sessions All DDL statements having bind variables |
|
|
Question: 3 You executed the following SQLstatement to shrink the EMPLOYEES table segment stored in the EXAMPLEtablespace: ALTER TABLE employees SHRINKSPACE CASCADE;Whichstatement is correct in this scenario? A. The EMPLOYEES table will bechanged to read-only mode during the shrink operation B. The indexes created on theEMPLOYEES table will need to be rebuilt after the shrink operation is over C. The shrink behavior will becascaded to all dependent segments of the table that support a shrink operation D.Data manipulation language (DML) operations will not be possible on theEMPLOYYES table during the COMPACTION phase of the shrink operation |
Answer: C The shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation |
|
|
Question: 4 You want to convert your existing non-ASM files to ASMfiles for the database PROD. Which method or command would you use toaccomplish this task? A. Data Pump Export and Import B. Conventional export andimport C. The CONVERT command of RMAN D.The BACKUP AS COPY….. command of RMAN |
Answer: D The BACKUP AS COPY….. command of RMAN |
|
|
Question: 5 You have three productiondatabases, HRDB, FINDB and ORGDB that use the same ASM instance. At the end ofthe day, while all three production database instances are running, you executethe following command on the ASM instance. SQL> shutdown immediate;Whatis the result of executing this command? A. The ASM instance is shut down, but the other instances are still running B. It results in an error because other database instances are connected to it C. All the instances, including the ASM instance, are shut down in the IMMEDIATE mode D. HRDB, FINDB and ORGDB instances are shut down in the ABORT mode and the ASM instance is shut down in the IMMEDIATE mode |
Answer: B It results in an error because other database instances are connected to it |
