网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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 in NOARCHIVELOG mode. After which two operations you should take the backup of control file？（）Aadding a new user to the databaseBdropping a user from the databaseCdropping a table from the databaseDdropping a data file from a tablespaceEadding a new tablespace to the database
考题
单选题You work as a database administrator for Supportcenter.cn. Your database is functional. One of the disks containing a mirrored redo log member has bad sectors in it. You are unable to fix the damaged file. How does the loss of a redo log member affect the instance of the database that is currently running？（）A
The instance would normally abort.B
The instance would not be affected.C
The instance would be invalid， so would have to be aborted.D
The instance would remain open， but the LGWR process would fail.E
The instance would remain open and would automatically create the missing file
考题
单选题You work as a database administrator for Certkiller .com. You find that users with DBA role are using more CPU resources than what is allocated in their profiles. Which action would you take to ensure that resources limits are imposed on these users？ （）A
Assign the DEFAULT profile to the usersB
Set the RESOURCE_LIMIT parameter to TRUE in the parameter fileC
Create a new profile with CPU restrictions and assign it to the usersD
Specify the users as members of the DEFAULT_CONSUMER_GROUPE
Revoke the DBA role and grant CONNECT and RESOURCE role to the users
考题
单选题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？（）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 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 received complaints about the degradation of SQL query performance. You identified top SQL queries that consume time. What would be your next step to find out recommendations about statistics collection and restructuring of the SQL statement to improve query performance？（）A
run Segment AdvisorB
run SQL Tuning Advisor on top SQL statementsC
run the Automatic Workload Repository （AWR） reportD
run the Automatic Database Diagnostic Monitor （ADDM）on top SQL statements
考题
单选题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 onto 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.
考题
单选题The customer and order tables are often used in joins， thereby resulting in complex queries. You created views to simplify the writing of queries. These views are stored in（）.A
user tablesB
view segmentC
table segmentD
data dictionaryE
object segmentF
performance tables
考题
多选题Which two operations require undo data？（）Acommitting a transactionBrolling back a transactionCrecovering from failed transactionsDrecording a transaction to redo log filesErolling forward during instance recovery
考题
多选题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.
热门标签
最新试卷