网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
单选题
You are using the backup scheduler in Enterprise Manager (EM) to schedule a backup of your database. Which type of script does the backup scheduler generate?()
A
SQL script
B
PL/SQL script
C
Operating System (OS) script
D
Enterprise Manager (EM) script
E
Recovery Manager (RMAN) script
参考答案
参考解析
解析:
暂无解析
更多 “单选题You are using the backup scheduler in Enterprise Manager (EM) to schedule a backup of your database. Which type of script does the backup scheduler generate?()A SQL scriptB PL/SQL scriptC Operating System (OS) scriptD Enterprise Manager (EM) scriptE Recovery Manager (RMAN) script” 相关考题
考题
单选题Your database is not configured for session failover. Your tnsnames.ora file contains the following details: test.us.oracle.com= (DESCRIPTION= (ADDRESS_LIST= (LOAD_BALANCE=off) (FAILOVER=ON) (ADDRESS= (PROTOCOL=tcp)(HOST=test1-server)(PORT=1521)) (ADDRESS= (PROTOCOL=tcp)(HOST=test2-server)(PORT=1521))) (CONNECT_DATA= (SERVICE_NAME=test.us.oracle.com))) Which feature is enabled in this case?()A
Load balancingB
Instance failoverC
Database failoverD
Connect-time failoverE
Transparent Application Failover (TAF)
考题
单选题You work as a database administrator for Certkiller .com. In your Oracle database10g installation you have set ORACLE_BASE to /u01/app/oracle. Which objective will be achieved by this setting?()A
The Oracle kernel will be placed in this location.B
The Oracle software will be placed in this location.C
The server parameter file (SPFILE) will be placed in this location.D
The database files will be placed in this location, if not specified explicitly.E
The location will be considered for the base of Oracle Managed Files (OMF).F
The location will be considered for the base of Optimal Flexible Architecture (OFA).
考题
多选题You work as a database administrator for Supportcenter.cn. Your listener process, L1, is currently listening to three databases: CertK INDB04, SupportCenter DB05 and SupportCenter DB06. Using Database Configuration Assistant (DBCA) you create one more database, SupportCenter DB07, and enable dynamic registration. Which two commands of Listener Control Utility (lsnrct1) would you use to determine whether the dynamic registration occurred for the database, SupportCenter DB07, with the L1 listener process?()ASHOW L1BSPAWN L1CSTATUS L1DSERVICES L1ESTATUS LISTENERFSERVICES LISTENERGSHOWcurrent_listener
考题
多选题You work as a database administrator for Certkiller .com. You have set the retention period for Automatic Repository (AWR) statistics to four days and collection interval to 15 minutes. You want to view the statistics collected and stored in AWR snapshot. Which two methods would you use to view the AWR statistics?()Ause enterprise managerBuse DBMS_SQL packageCuse DBMS_AWR packageDuse PRVT_WORKLOAD packageEquery the AWR snapshot repository objectsFuse DBMS_WORKLOAD_REPOSITORY package
考题
单选题You work as a database administrator for Certkiller .com. Redo log files are not multiplexed in your database. Redo log blocks are corrupted in group 2, and archiving has stopped. All the redo logs are filled and database activity is halted. Database writer has written everything to disk. Which command would you execute to proceed further?()A
RECOVER LOFIEL BLOCK GROUP 2;B
ALTER DATABASE DROP LOGFILE GROUP 2;C
ALTER DATABASE CLEAR LOGFILE GROUP 2;D
ALTER DATABASE RECOVER LOGFILE GROUP 2;E
ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 2;
考题
多选题You work as a database administrator for Supportcenter.cn. You want to create your database with the automatic undo management feature enable.Which two tasks must you perform to achieve this?()ASet the UNDO_RETENTION parameter to AUTO.BCreate an initial undo segment in undotablespace.CSet the UNDO_RETENTION parameter to 900 or moreDSet the initialization parameter UNDO_MANAGEMENT to AUTOESet the UNDO_MANAGEMENT parameter to the name of an undotablespace
考题
单选题The ST_INFO master table has millions of rows that are updated very rarely. It has a STATE_CODE column that contains the value for 25 states. The table is frequently queried on the STATE_CODE column. Which type of index would you suggest to improve the query performance?()A
B-treeB
bitmapC
reverse keyD
function based
热门标签
最新试卷