网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
You are working on a 24x7 （available 24 hours per day， 7 days per week） production database. An operating system （OS） user deletes the alert log file accidentally. Which statement in this scenario is true？（）
A
The database crashes.
B
The DBA needs to re-create the file.
C
The file gets re-created automatically.
D
The file gets restored automatically from the last backup.
E
The DBA needs to perform a complete database recovery.
F
The DBA needs to perform an incomplete database recovery.
参考答案
参考解析
解析：
暂无解析
更多 “单选题You are working on a 24x7 （available 24 hours per day， 7 days per week） production database. An operating system （OS） user deletes the alert log file accidentally. Which statement in this scenario is true？（）A The database crashes.B The DBA needs to re-create the file.C The file gets re-created automatically.D The file gets restored automatically from the last backup.E The DBA needs to perform a complete database recovery.F The DBA needs to perform an incomplete database recovery.” 相关考题
考题
单选题You are working on the Certkiller database. What is the default name of the alert log file in this database？（）A
alert_ Certkiller .logB
alertlog_ Certkiller .logC
alert_log_ Certkiller .logD
Certkiller _alert_log.logE
log_alert_： Certkiller .logF
trace_alert_ Certkiller .log
考题
单选题While creating a database using Database Configuration Assistant tool， you created a database default temporary tablespace. Which activity would cause the default temporary tablespace of the database to be used？（）A
the CREATE TABLE .. commandB
sorting of the SYSTEM tablespace’s dataC
sorting of data required by recursive SQL statementsD
the CREATE TABLE .. ORGANIZATION EXTERNAL .. commandE
sorting of data if the users have not been allocated temporary tablespace explicitlyF
sorting of data if the users have been allocated temporary tablespace explicitly
考题
单选题A user complains that he gets the following error message repeatedly after executing some SQL statements. The error message forces the user to log off from and log on to the database to continue his work. ORA-02392： exceeded session limit on CPU usage， you are being logged off Which action would you take to increase the session limit on CPU usage？（）A
Modify the profile assigned to the user.B
Modify the roles assigned to the users.C
Modify the object privileges assigned to the user.D
Modify the system privileges assigned to the users.E
Modify the value for the RESOURCE_LIMIT parameter in the parameter file.
考题
多选题You plan to use static database registration for a new listener when you create it. What could be the two reasons for this？（）AMore than one database is to be registered with the listener.BThe users will connect the database by using the host naming method.CThe Oracle Enterprise Manager is to be used to monitor an Oracle9i database.DThe database that is to be registered with the listener is configured in shared server mode.EThe listener is not configured on the default port of 1521 and the instance is not configured to register with a nondefault port.
考题
单选题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
考题
单选题Redo log files are multiplexed in your database. The disk in which you have one of the redo log members is highly fragmented. In the process of defragmentation you lose the redo log member， which is not a member of the current group. How would you recover from the loss of the redo log member？（）A
SMON would automatically restore the lost file.B
You would need to restore the whole database from the last backup.C
You would need to restore the file from the last full database backup.D
You would need to use flashback technology to restore the lost redo log member.E
You would need to use Recovery Manager （RMAN） to restore the lost redo log member.F
You would need to restore the missing log file by copying one of the remaining files from the same group.
考题
单选题In your database， you may be forced to perform a recovery using the RESETLOGS option during which the redo logs would be reset to sequence number 1. You want to avoid the overwriting of old log files. Which archived log file name format ensures this？ （）A
%t_%s.dbfB
arch_%t.arcC
arch_%d.arcD
arch_%t_%d.arcE
arch_%d_%s_.dbfF
arch_%t_%s_%r.arc
考题
单选题You find that the database performance degrades while you backup the PROD database using Recovery Manager （RMAN）. The PROD database is running in shared server mode. The database instance is currently using 60% of total operating system memory. You suspect the shared pool fragmentation to be the reason. Which action would you consider to overcome the performance degradation？（）A
Configure Java Pool to cache the java objects.B
Configure Streams Pool to enable parallel processing.C
Increase Shared Pool size to cache more PL/SQL objects.D
Increase Database Buffer Cache size to increase cache hits.E
Configure Large Pool to be used by RMAN and shared server.F
Increase the total System Global Area （SGA） size to increase memory hits.
热门标签
最新试卷
