单选题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?()AIt terminates all user sessions.BIt prevents users from logging in to the database remotely.CIt halts the server until all user transactions are completed.DThe server hangs, so users will receive an error asking them to login again.EConnected users would get an error with the message End of communication channel.

单选题
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?()
A

It terminates all user sessions.

B

It prevents users from logging in to the database remotely.

C

It halts the server until all user transactions are completed.

D

The server hangs, so users will receive an error asking them to login again.

E

Connected users would get an error with the message End of communication channel.


参考解析

解析: 暂无解析

相关考题:

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 purgedB. Only the table with the oldest DROPSCN is purgedC. The command returns an error because multiple entries with the same name exist in the recycle binD. Only the table with the latest DROPSCN is purged

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).

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

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?()A、It terminates all user sessions.B、It prevents users from logging in to the database remotely.C、It halts the server until all user transactions are completed.D、The server hangs, so users will receive an error asking them to login again.E、Connected users would get an error with the message "End of communication channel".

Which of the following commands should Mike, a technician, use to display the available switches of a command line utility?()A、DIR /SB、MSINFOC、ATTRIB -HD、HELP

Which of the following switches for the FORMAT command line utility allows Bob, a technician, toformat a floppy disk the FASTEST?()A、/cB、/qC、/xD、/v

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?()A、Image of the control fileB、Location of the control fileC、Contents of the control file in text formatD、SQL command to re-create the databaseE、SQL command to re-create the control fileF、Contents of the control file in binary format

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.   lsnrctlSTART   What statement is true?()A、It would attempt to start the default listenerB、It would 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 start.

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?()A、 FILEB、 PARFILEC、 LOGFILED、 FEEDBACK

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?()A、 Open the file at the location specified by the BACKGROUND_DUMP_DEST parameter in the pfile.B、 Open the file at the location specified by the USER_DUMP_DEST parameter in the pfile.C、 Issue the SERVICES command at the LSNRCTL prompt.D、 Issue the STATUS command at the LSNRCTL prompt.

Examine the following commands executed in your database: SQL ALTER SESSION RECYCLEBIN=ON; Session altered  SQL  CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees;  Table created.  Further, you executed the following command to drop the table:  SQL DROP TABLE emp;Table dropped.  What happens in this scenario?()A、The table is moved to the SYSAUX tablespace.B、The table is moved to the SYSTEM tablespace.C、The table is removed from the database permanently.D、The table is renamed and remains in the TBSFD tablespace.

You executed the following command to back up your control file:  ALTER DATABASE BACKUP CONTROLFILE TO TRACE;  Which initialization parameter is used to specify the location of the trace file?()A、USER_DUMP_DESTB、CORE_DUMP_DESTC、TRACE_DUMP_DESTD、BACKUP_DUMP_DESTE、BACKGROUND_DUMP_DEST

You issue these LSNRCTL commands:  LSNRCTL SET CURRENT_LISTENER listener01 LSNRCTL START listener02  What is the result of issuing these commands?()A、A listener named LISTENER is started.B、A listener named LISTENER01 is started.C、A listener named LISTENER02 is started.D、The START command fails and no listener is started.

Your company has a domain controller server that runs the Windows Server 2008 R2 operating  system. The server is a backup server. The server has a single 500-GB hard disk that has three  partitions for the operating system, applications, and data. You perform daily backups of the  server.     The hard disk fails. You replace the hard disk with a new hard disk of the same capacity. You  restart the computer on the installation media. You select the Repair your computer option.     You need to restore the operating system and all files.     What should you do()A、Select the System Image Recovery option.B、Run the Imagex utility at the command prompt.C、Run the Wbadmin utility at the command prompt.D、Run the Rollback utility at the command prompt.

You have a listener process, L1, currently listening for the connections to the PROD and ADMIN databases. You create a new database, PAY, using CREATE  DATABASE.. command. You have not enabled dynamic instance registration. You modified the LISTENER.ORA file manually to include PAY database for L1 listener process.  Which command of Listener control utility (LSNRCTL) would you use to enable L1 process to start listening for the connections to the PAY database without disrupting any existing database communications?()A、STARTB、RELOADC、RESTARTD、REFRESHE、START L1F、RELOAD L1G、RESTART L1H、REFRESH L1

单选题You executed the following command to back up your control file:  ALTER DATABASE BACKUP CONTROLFILE TO TRACE;  Which initialization parameter is used to specify the location of the trace file?()AUSER_DUMP_DESTBCORE_DUMP_DESTCTRACE_DUMP_DESTDBACKUP_DUMP_DESTEBACKGROUND_DUMP_DEST

单选题You work as a database administrator for Certkiller .com. 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.  lsnrctlSTART  What statement is true?()AIt would attempt to start the default listenerBIt would start the most recently created listener.CIt would display an error with a message asking for the listener name to be specified.DIt would show you a list of listeners and prompts for the listener name that you want to start.

单选题You decided to change the location of the flash recovery area. You executed the following command: Which statement is true?()AThe location can be changed only if the flash recovery area is empty.BAfter executing the command, all new flash recovery area files will be created in the new location.CThe command will generate an error because you cannot change the flash recovery area while the database is open.DAll the existing files in the flash recovery area will be moved to the new location, and all new Flash Recovery Area files will be created in the new location.

多选题You executed the following command to drop a user: DROP USER scott CASCADE; Which two statements regarding the above command are correct?()AAll the objects of scott are moved to the Recycle Bin.BAny objects in the Recycle Bin belonging to scott are purged.CAll the objects owned by scott are permanently dropped from the database.DAll the objects of scott in the Recycle Bin must be purged before executing the DROP command.EAny objects in the Recycle Bin belonging to scott will not be affected by the above DROP command.

单选题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?()AIt terminates all user sessions.BIt prevents users from logging in to the database remotely.CIt halts the server until all user transactions are completed.DThe server hangs, so users will receive an error asking them to login again.EConnected users would get an error with the message End of communication channel.

单选题You executed the following command in Recovery Manager (RMAN):  RMAN RESTORE CONTROLFILE;  Which operation must you perform before this command is executed?()A back up the control file to traceB bring database to the MOUNT stateC open a connection to the RMAN recovery catalog, which contains the RMAN metadata for the target databaseD set the database ID (DBID), but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog

单选题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?()A FILEB PARFILEC LOGFILED FEEDBACK

单选题You executed the following commands in an RMAN session for your database instance that has failures: RMAN LIST FAILURE; After some time, you executed the following command in the same session: RMAN ADVISE FAILURE; But there are new failures recorded in the Automatic Diagnostic Repository (ADR) after the execution of the last LIST FAILURE command. Which statement is true for the above ADVISE FAILURE command in this scenario?()AIt produces a warning for new failures before advising for CRITICAL and HIGH failures.BIt ignores new failures and considers the failures listed in the last LIST FAILURE command only.CIt produces an error with recommendation to run the LIST FAILURE command before the ADVISE FAILURE command.DIt produces advice only for new failures and the failures listed in the last LIST FAILURE command are ignored.

单选题You have a listener process, L1, currently listening for the connections to the PROD and ADMIN databases. You create a new database, PAY, using CREATE  DATABASE.. command. You have not enabled dynamic instance registration. You modified the LISTENER.ORA file manually to include PAY database for L1 listener process.  Which command of Listener control utility (LSNRCTL) would you use to enable L1 process to start listening for the connections to the PAY database without disrupting any existing database communications?()ASTARTBRELOADCRESTARTDREFRESHESTART L1FRELOAD L1GRESTART L1HREFRESH L1

单选题You issue these LSNRCTL commands:  LSNRCTL SET CURRENT_LISTENER listener01 LSNRCTL START listener02  What is the result of issuing these commands?()AA listener named LISTENER is started.BA listener named LISTENER01 is started.CA listener named LISTENER02 is started.DThe START command fails and no listener is started.

单选题You executed the following command in Recovery Manager (RMAN):  RMAN RESTORE CONTROLFILE;  Which operation must you perform before this command is executed?()Aback up the control file to traceBbring database to the MOUNT stateCopen a connection to the RMAN recovery catalog, which contains the RMAN metadata for the target databaseDset the database ID (DBID), but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog

单选题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?()AImage of the control fileBLocation of the control fileCContents of the control file in text formatDSQL command to re-create the databaseESQL command to re-create the control fileFContents of the control file in binary format

单选题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?()A Open the file at the location specified by the BACKGROUND_DUMP_DEST parameter in the pfile.B Open the file at the location specified by the USER_DUMP_DEST parameter in the pfile.C Issue the SERVICES command at the LSNRCTL prompt.D Issue the STATUS command at the LSNRCTL prompt.