term1 Definition1term2 Definition2term3 Definition3
Please sign in to your Google account to access your documents:
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
Need help typing ? See our FAQ (opens in new window)
Please sign in to create this set. We'll bring you back here when you are done.
Discard Changes Sign in
Please sign in to add to folders.
Sign in
Don't have an account? Sign Up »
You have created 2 folders. Please upgrade to Cram Premium to create hundreds of folders!