It terminates all user sessions.
It prevents users from logging in to the database remotely.
It halts the server until all user transactions are completed.
The server hangs, so users will receive an error asking them to login again.
Connected users would get an error with the message End of communication channel.
第1题:
Your database is open and the LISTENER listener running. You stopped the wrong listener LISTENER byissuing the following command:lsnrctl >STOPWhat happens to the sessions that are presently connected to the database Instance?()
A. They are able to perform only queries.
B. They are not affected and continue to function normally.
C. They are terminated and the active transactions are rolled back.
D. They are not allowed to perform any operations until the listener LISTENER is started
第2题:
Which of the following commands should Mike, a technician, use to display the available switches of a command line utility?()
第3题:
Examine the output of the query that you executed to list the objects in the recycle bin:You verified that no table named SALES_TAB exists in the schema. Then you executed the following command to purge the objects in the recycle bin:SQL> PURGE TABLE sales_tab;What would be the outcome of this command?()
A. All three tables in the recycle bin are purged
B. Only the table with the oldest DROPSCN is purged
C. The command returns an error because multiple entries with the same name exist in the recycle bin
D. Only the table with the latest DROPSCN is purged
第4题:
You are using the DBVERIFY utility to check the datafiles for any block corruption. You want to write the output of the dbv command to a file not to the screen. Which parameter of the DBVERIFY utility will you use?()
第5题:
You executed the following command to back up the control file: ALTER DATABASE BACKUP CONTROLFILE TO TRACE; What do you find in the trace file?()
第6题:
You executed the following command in the lsnrctl utility to stop the listener: lsnrctl> STOP L1 What is the effect of this command if L1 is the only listener configured for your database?()
第7题:
Which of the following switches for the FORMAT command line utility allows Bob, a technician, toformat a floppy disk the FASTEST?()
第8题:
View the Exhibit to examine the error during the database startup.You open an RMAN session for the database instance. To repair the failure, you executed the following as the first command in the RMAN session:RMAN> REPAIR FAILURE;Which statement describes the consequence of the command?()
A. The command performs the recovery and closes the failures.
B. The command only displays the advice and the RMAN script required for repair.
C. The command produces an error because the ADVISE FAILURE command has not been executed before the REPAIR FAILURE command.
D. The command executes the RMAN script to repair the failure and removes the entry from the Automatic Diagnostic Repository (ADR).
第9题:
You work as a database administrator for Supportcenter.cn. When you tried to connect to the database, you received the following error: ERROR: ORA-12541:TNS:no_listener 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. lsnrctl>START What statement is true?()
第10题:
The listener has shut down unexpectedly. You want to view the listener log file and listener trace file to find the cause of the problem. How can you view the contents of the listener log file and the listener trace file?()