网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
Oracle数据库中，初始化参数AUDIT_TRAIL为静态参数，使用以下（）命令可以修改其参数值。
- A、ALTER SYSTEM SETAUDIT_TRAIL=DB
- B、ALTER SYSTEM SETAUDIT_TRAIL=DBDEFERRED
- C、ALTER SESSION SETAUDIT_TRAIL=DB
- D、ALTER SYSTEM SETAUDIT_TRAIL=DBSCOPE=SPFILE
参考答案
更多 “Oracle数据库中，初始化参数AUDIT_TRAIL为静态参数，使用以下（）命令可以修改其参数值。A、ALTER SYSTEM SETAUDIT_TRAIL=DBB、ALTER SYSTEM SETAUDIT_TRAIL=DBDEFERREDC、ALTER SESSION SETAUDIT_TRAIL=DBD、ALTER SYSTEM SETAUDIT_TRAIL=DBSCOPE=SPFILE” 相关考题
考题
You want to enable resumable space allocation at the instance level.Which two actions would enable resumable space allocation at the instance level?()
A. issuing the ALTER SYSTEM ENABLE RESUMABLE; statementB. issuing the ALTER SESSION ENABLE RESUMABLE; statementC. modifying the RESUMABLE_TIMEOUT initialization parameter to a nonzero valueD. issuing the ALTER SYSTEM SET RESUMABLE_TIMEOUT=nonzero value; statement
考题
You want to enable resumable space allocation at the instance level.Which two actions would enable resumable space allocation at the instance level? ()(Choose two.)
A. issuing the ALTER SYSTEM ENABLE RESUMABLE; statementB. issuing the ALTER SESSION ENABLE RESUMABLE; statementC. modifying the RESUMABLE_TIMEOUT initialization parameter to a nonzero valueD. issuing the ALTER SYSTEM SET RESUMABLE_TIMEOUT=; statement
考题
如何强制执行日志切换()
A.ALTER SYSTEM CHECKPOINT;B.ALTER SYSTEM CHECKPOINT FORCE;C.ALTER SYSTEM SWITCH LOGFILE;D.ALTER SYSTEM SWITCH LOGFILE FORCE;E.ALTER DATABASE LOG SWITCH;
考题
You want to enable resumable space allocation at the instance level.Which two actions would enable resumable space allocation at the instance level?（）A、issuing the ALTER SYSTEM ENABLE RESUMABLE; statementB、issuing the ALTER SESSION ENABLE RESUMABLE; statementC、modifying the RESUMABLE_TIMEOUT initialization parameter to a nonzero valueD、issuing the ALTER SYSTEM SET RESUMABLE_TIMEOUT=nonzero value; statement
考题
oracle数据库采用spfile启动，执行下面的命令修改LOG_BUFFER大小。ALTER SYSTEM SETLOG_BUFFER=32M SCOPE=BOTH；以下哪项是该命令的输出结果？（）A、执行命令报错，因为log buffer不能动态的修改B、如果自动内存管理没有启用，那么该命令执行成功C、参数值已经改变，尽可能快的在sga中生效D、命令执行成功，需要重启数据库使命令生效
考题
下列（）语句是杀死ORACLE数据库中会话的命令格式。A、alter system kill’SID，SERIAL#’B、alter system killsession’SID，SERIAL#’C、alter system killsession’SID’D、alter system kill’SID’
考题
（）命令将数据库实例切换到挂起状态。A、ALTER SYSTEMSUSPENDB、ALTER DATABASESUSPENDC、ALTER SYSTEM QUIESCE RESTRICTEDD、ALTER SYSTEM OFFLINE
考题
How is block-change tracking enabled?（）A、With alter database enable block change trackingB、With alter system enable block change tracking C、With an init.ora parameter change D、With an spfile parameter change
考题
You have not configured Oracle Managed Files （OMF） in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature. Which statement will you use to enable the block change tracking feature？（）A、 ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING；B、 ALTER DATABASE ENABLE BLOCK CHANGE TRACKING；C、 ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE ；D、 ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE ；
考题
如何强制执行日志切换（）A、ALTER SYSTEM CHECKPOINT;B、ALTER SYSTEM CHECKPOINT FORCE;C、ALTER SYSTEM SWITCH LOGFILE;D、ALTER SYSTEM SWITCH LOGFILE FORCE;E、ALTER DATABASE LOG SWITCH;
考题
How is block-change tracking enabled？（） A、 With alter database enable block change trackingB、 With alter system enable block change trackingC、 With an init.ora parameter changeD、 With an spfile parameter change
考题
You want to enable resumable space allocation at the instance level. Which two actions would enable resumable space allocation at the instance level？（） A、 issuing the ALTER SYSTEM ENABLE RESUMABLE；statementB、 issuing the ALTER SESSION ENABLE RESUMABLE；statementC、 modifying the RESUMABLE_TIMEOUT initialization parameter to a nonzero valueD、 issuing the ALTER SYSTEM SET RESUMABLE_TIMEOUT=；statement
考题
You want to enable resumable space allocation at the instance level.Which two actions would enable resumable space allocation at the instance level? （）(Choose two.)A、issuing the ALTER SYSTEM ENABLE RESUMABLE; statementB、issuing the ALTER SESSION ENABLE RESUMABLE; statementC、modifying the RESUMABLE_TIMEOUT initialization parameter to a nonzero valueD、issuing the ALTER SYSTEM SET RESUMABLE_TIMEOUT=; statement
考题
You are attempting to clear an unarchived redo log file. In order to manually enact a log switch, which of the following statements is appropriate?（）A、ALTER DATABASE B、ALTER SYSTEM C、ALTER USER D、ALTER REDO LOG
考题
To allocate another role to a user, which command is most appropriate?（）A、ALTER USER B、ALTER DATABASE C、ALTER SYSTEM D、GRANT
考题
You are working as a DBA in an organization. The flash recovery area files are created in ’+disk1’. You want to create new flash recovery area files in the ’+disk2’ location. The new location of the flash recovery area files should be written in the control file and the spfile.Which command will you issue to change the location of the flash recovery area files？（） A、 ALTER SYSTEM SET DB_RECOVERY_FILE_DEST = ’+disk2’ ；B、 ALTER SYSTEM SET DB_RECOVER_FILE_DEST = ’+disk2’ SCOPE = BOTH；C、 ALTER SYSTEM SET DB_CREATE_FILE_DEST = ’+disk2’；D、 ALTER SYSTEM SET DB_CREATE_ONLINE_LOG_DEST_n = ’+disk2’；
考题
Which statement must you issue to an already-running Automatic Storage Management （ASM） instance to prevent database instances from connecting to the ASM instance？（） A、 ALTER SYSTEM KILL SESSIONB、 ALTER SYSTEM DISCONNECT SESSIONC、 ALTER SYSTEM QUIESCE RESTRICTEDD、 ALTER SYSTEM ENABLE RESTRICTED SESSION
考题
You discover an out-of-space condition in the database. You decide to suspend a session for five minutes. You issue the following command to suspend the session： ALTER SESSION ENABLE RESUMABLE； Which command could you issue to enable the resumable space allocation feature at the session level？（） A、 ALTER SESSION ENABLE RESUMABLE_TIMEOUT = 5；B、 ALTER SYSTEM ENABLE RESUMABLE_TIMEOUT = 5；C、 ALTER SESSION ENABLE RESUMABLE_TIMEOUT = 300；D、 ALTER SYSTEM ENABLE RESUMABLE TIMEOUT = 300；
考题
The current time zone for one of the user sessions is set to the database local time zone. For one application， the user session requires the time zone to be set to the local operating system time zone without affecting other user sessions. Which two solutions could the user implement to achieve this objective？ （）A、 use the ALTER SYSTEM command to change the time zoneB、 use the ALTER SESSION command to change the time zoneC、 use the ALTER DATABASE command to change the time zoneD、 set the value for the operating system variable ORA_SDTZ on the client machineE、 set the value for the operating system variable ORA_SDTZ on the database server machine
考题
Which is the correct command to put the database in ARCHIVELOG mode？（） A、 alter database archivelogB、 alter system enable archivelog modeC、 alter database enable archiveD、 alter database archivelog enableE、 None of the above
考题
在Oracle中，以下（）命令可用于是强制切换日志文件。A、alter system switchlogfile；B、alterdata base switchlogfileC、Alter switchlogfileD、1和2选项均可以
考题
单选题How is block-change tracking enabled?（）A
With alter database enable block change trackingB
With alter system enable block change tracking C
With an init.ora parameter change D
With an spfile parameter change
考题
单选题How is block-change tracking enabled？（）A
With alter database enable block change trackingB
With alter system enable block change trackingC
With an init.ora parameter changeD
With an spfile parameter change
考题
单选题oracle数据库采用spfile启动，执行下面的命令修改LOG_BUFFER大小。ALTER SYSTEM SETLOG_BUFFER=32M SCOPE=BOTH；以下哪项是该命令的输出结果？（）A
执行命令报错，因为log buffer不能动态的修改B
如果自动内存管理没有启用，那么该命令执行成功C
参数值已经改变，尽可能快的在sga中生效D
命令执行成功，需要重启数据库使命令生效
考题
单选题Which is the correct command to put the database in ARCHIVELOG mode？（）A
alter database archivelogB
alter system enable archivelog modeC
alter database enable archiveD
alter database archivelog enableE
None of the above
考题
单选题Which statement must you issue to an already-running Automatic Storage Management （ASM） instance to prevent database instances from connecting to the ASM instance？（）A
ALTER SYSTEM KILL SESSIONB
ALTER SYSTEM DISCONNECT SESSIONC
ALTER SYSTEM QUIESCE RESTRICTEDD
ALTER SYSTEM ENABLE RESTRICTED SESSION
考题
单选题You discover an out-of-space condition in the database. You decide to suspend a session for five minutes. You issue the following command to suspend the session： ALTER SESSION ENABLE RESUMABLE； Which command could you issue to enable the resumable space allocation feature at the session level？（）A
ALTER SESSION ENABLE RESUMABLE_TIMEOUT = 5；B
ALTER SYSTEM ENABLE RESUMABLE_TIMEOUT = 5；C
ALTER SESSION ENABLE RESUMABLE_TIMEOUT = 300；D
ALTER SYSTEM ENABLE RESUMABLE TIMEOUT = 300；
热门标签
最新试卷
