单项选择题

You have created a locally managed tablespace by issuin……

You have created a locally managed tablespace by issuing the following command：
CREATE TABLESPACE data1
DATAFILE ’data1_file1.dbf’ SIZE 10M AUTOEXTEND ON MAXSIZE
UNLIMITED；
For the DATA1 tablespace， you have set the warning level alert limit to 70 percent. In which situation will a warning level alert be generated？（）

A. when 700 KB is used
B. when 700 KB is left as free space
C. when 7MB is used
D. when 7MB is left as free space
E. no alert will be generated because an autoextensible datafile is included in the tablespace

<上一题目录下一题>

热门试题

单项选择题Matthew has recently joined NetFx Corporation as a junior-level Database Administrator （DBA）. He is asked by his supervisor to verify the database for data block corruptions. He uses the DBVERIFY utility and finds that two data blocks are corrupted in the database. What should Matthew use to identify the corrupted blocks as well as datafiles containing these blocks？（）

A. datafile
B. alert log
C. dynamic views
D. control file script

单项选择题Whileperformingmonitoringandtuningthedatabase，youwanttoviewthesummarizedinformationaboutthewarninglevelalertsandcriticallevelalerts.WhichsectionoftheOracleEnterprisemanagerdisplaysthesummarizedinformationaboutthewarningandcriticallevelalerts？（）

A.General
B. High Availability
C. Space Usage
D. Diagnostic Summary

单项选择题Youpreviouslysecuredyourlistenerwithanencryptedpassword.However，youneedtosetanewpasswordforsecurityreasons.WhatisthecorrectmethodforsettinganewencryptedpasswordforthelistenerusingtheListenerControlutility？（）

A. executing the SET PASSWORD command and then the SAVE_CONFIG command
B. executing the CHANGE_PASSWORD command and then the SAVE_CONFIG command
C. executing the CHANGE_PASSWORD command and then the SET PASSWORD command
D. executing the SET PASSWORD command， then the CHANGE_PASSWORD command and finally， the SAVE_CONFIG command

单项选择题Thelistenerhasshutdownunexpectedly.Youwanttoviewthelistenerlogfileandlistenertracefiletofindthecauseoftheproblem.Howcanyouviewthecontentsofthelistenerlogfileandthelistenertracefile？（）

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