单项选择题

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.

<上一题目录下一题>

热门试题

单项选择题You are maintaining the database of a company. The listener process， listener1， is configured for remote access. You have issued the following command： LSNRCTL>STATUS listener1 Which information will NOT be displayed when you issue the above command？（）

A. whether the password is set in the listener or a file or not
B. the number of client connections the service handler has refused
C. the information will be displayed whether the instance can accept connections or not
D. the protocol addresses on which the listener is configured to listen

多项选择题YouarerequiredtoremovethedefaultEXTPROCentryfromthedefaultlistenerconfigurationtocreatealistenerthatwilllistenspecificallyforEXTPROCcalls.WhichtwomethodscanyouusetoremovethedefaultEXTPROCentryfromthedefaultlistenerconfiguration？（）

A. the RMAN utility
B. the import/export utility
C. the Oracle Enterprise Manager
D. the change tracking feature
E. the Net Manager utility

单项选择题You executed the following procedure to collect statistics regarding an index： SQL>ANALYZE INDEX EMP_ID VALIDATE STRUCTURE； Which view will you use to determine whether you need to rebuild the index or not？（）

A. INDEX_STATS
B. DBA_INDEXES
C. DBA_IND_COLUMNS
D. V$OBJECT_USAGE

单项选择题Theonlineredologgroupconfigurationforyourdatabaseisasfollows：Whatwillhappeniftheonlineredologfile’ora02 oradata redo02b.log’iscorruptedwhileworkingonthedatabase？（）

A. The database will hang.
B. The database will be crashed.
C. The database will be shut down.
D. The LGWR process writes redo log entries to the other redo log member of the Group2 group

单项选择题Youaremaintainingadatabaseofcreditcardtransactions.YouwantthedatatobereturnedautomaticallyinthechronologicalorderofthecreditcardnumberswithoutusingtheORDERBYclauseinthequery.Whichtypeofclusterwillyouusetoobtainthedesiredresult？（）

A. Hash cluster
B. Index cluster
C. Sorted hash cluster
D. Real Application cluster