Unformatted text preview: user sessions commands.
E.The CUSTOMERS table has no long running query active at the time when this
request is made.
F.The server process executing the ALTER TABLE command is busy with another
Actualtests.com - The Power of Knowing 1Z0-042 Answer: C
You work as a database administrator for Certkiller .com. When you tried to connect
to the database, you received the following error:
You found that the listener is not running on the server, so you issued the following
command in the Listener Control utility to start the listener.
What statement is true?
A.It would attempt to start the default listener
B.itwould start the most recently created listener.
C.It would display an error with a message asking for the listener name to be specified.
D.It would show you a list of listeners and prompts for the listener name that you want to
You work as a database administrator for Certkiller .com. One of the database users
accidentally deleted all the rows of a critical table and committed the delete at 1:30
p.m. You senior database administrator, Certkiller, asks you to retrieve the lost
Which two actions would you use to ensure that there is no impact on other
connected users while retrieving the deleted rows? Choose two.
A.Use a flashback query to retrieve the rows that were deleted
B.Useconventialincremental export and then import the affected object
C.Shutdown the database inNORMALmode and restart the database instance
D.Use DBMS_META package to reconstruct the object using undo segments
E.UseTablespacePoint in Time Recovery (TSPITR) method to recover the table and the
F.Use Oracle DataPumptwithflashback_timeoption toentableflashback export and then
import the affected object.
Answer: B, E
You work as a database administrator for Certkiller .com. You need to rename a
data file of atablespace.
Actualtests.com - The Power of Knowing 1Z0-042
How would you...
View Full Document
- Fall '09
- administrator, Oracle Database, Certkiller