网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
Examine the following command; ALTER SYSTEM SET enable_ddl_logging = TRUE; Which statement is true?（）
A
Only the data definition language (DDL) commands that resulted in errors are logged in the alert log file.
B
All DDL commands are logged in the alert log file.
C
All DDL commands are logged in a different log file that contains DDL statements and their execution dates.
D
Only DDL commands that resulted in the creation of new segments are logged.
E
All DDL commands are logged in XML format in the alert directory under the Automatic Diagnostic Repository (ADR) home.
参考答案
参考解析
解析：
暂无解析
更多 “单选题Examine the following command; ALTER SYSTEM SET enable_ddl_logging = TRUE; Which statement is true?（）A Only the data definition language (DDL) commands that resulted in errors are logged in the alert log file.B All DDL commands are logged in the alert log file.C All DDL commands are logged in a different log file that contains DDL statements and their execution dates.D Only DDL commands that resulted in the creation of new segments are logged.E All DDL commands are logged in XML format in the alert directory under the Automatic Diagnostic Repository (ADR) home.” 相关考题
考题
Examine the following RMAN command:RMAN CONFIGURE ENCRYPTION FOR DATABASE ON;RMAN BACKUP DATABASE PLUS ARCHIVELOG;Which prerequisite must be met before accomplishing the backup?()
A. Provide a password for the encryptionB. Set up an Oracle wallet for the encryptionC. No setup is required as it is a default encryption methodD. Both Oracle wallet and password must be set up for the encryption
考题
Examine the following command;ALTER SYSTEM SET enable_ddl_logging = TRUE;Which statement is true?()
A. Only the data definition language (DDL) commands that resulted in errors are logged in the alert log file.B. All DDL commands are logged in the alert log file.C. All DDL commands are logged in a different log file that contains DDL statements and their execution dates.D. Only DDL commands that resulted in the creation of new segments are logged.E. All DDL commands are logged in XML format in the alert directory under the Automatic Diagnostic Repository (ADR) home.
考题
After adding a new Ethernet card to a system and rebooting， the system administrator notices the card was not configured. How can the system administrator determine if there were errors during the configuration process for the card？（）A、Examine the bootlog with the command： alog -o -f /var/adm/ras/bootlogB、Display the device attributes and errors with the command： lsdev -C -l ent0C、Examine the AIX errlog for configuration method errors with the command： errpt -a -C ent0D、Examine the ODM for configuration errors with the command： odmget -q "method_errors" ent0
考题
While applying a service update on a system using SMIT, the system administrates SMIT Command Status screen shows "Command: failed". Which of the following procedures should be performed to investigate the failure?（）A、Exit the SMIT session and re-apply the update.B、Select the SMIT option to Clean UP After an Interrupted Installation.C、Examine the installation summary report to determine the cause of the failure.D、Examine the console log to view the error messages generated by the failure.
考题
A system has a critical need for network services on a small network with a limited number of hosts. System overhead is not a concern. Which of the following should the system administrator do to help ensure connectivity in the event of a gateway failure？（）A、Use the ifconfig command to enable dead gate detectionB、Use the no command to set active dead gateway detectionC、Use the route command to set active dead gateway detectionD、Add the line active_dgd=1 to the /etc/gated.conf command and refresh the gated daemon
考题
You just issued the following statement: ALTER TABLE SALES DROP COLUMN PROFIT. Which of the following choices identifies when the column will actually be removed from Oracle?（）A、Immediately following statement execution B、After the ALTER TABLE DROP UNUSED COLUMNS command is issued C、After the ALTER TABLE SET UNUSED COLUMN command is issued D、After the ALTER TABLE MODIFY command is issued
考题
Examine the following RMAN command： RMAN CONFIGURE ENCRYPTION FOR DATABASE ON； RMAN BACKUP DATABASE PLUS ARCHIVELOG； Which prerequisite must be met before accomplishing the backup？（）A、 Provide a password for the encryptionB、 Set up an Oracle wallet for the encryptionC、 No setup is required as it is a default encryption methodD、 Both Oracle wallet and password must be set up for the encryption
考题
To allocate another role to a user, which command is most appropriate?（）A、ALTER USER B、ALTER DATABASE C、ALTER SYSTEM D、GRANT
考题
Examine the following commands executed in your database： SQL ALTER SESSION RECYCLEBIN=ON； Session altered SQL CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees； Table created. Further， you executed the following command to drop the table： SQL DROP TABLE emp；Table dropped. What happens in this scenario？（）A、The table is moved to the SYSAUX tablespace.B、The table is moved to the SYSTEM tablespace.C、The table is removed from the database permanently.D、The table is renamed and remains in the TBSFD tablespace.
考题
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；
考题
You decided to increase the value for the SHARED_SERVERS parameter by using the following command： SQL ALTER SYSTEM SET SHARED_|SERVERS=3 SCOPE=？； Which three values can be specified for the SCOPE clause？（）A、ALLB、PFILEC、BOTHD、NONEE、SPFILEF、MEMORYG、INSTANCEH、DATABASE
考题
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
考题
Examine the following ALTER command: SQL ALTER DISKGROUP dgroup1 UNDROP DISKS; What is the purpose of the command?（）A、It cancels all pending disk drops within the disk groupB、It restores disks that are being dropped as the result of a DROP DISKGROUP operationC、It mounts disks in the disk group for which the drop-disk operation has already been completedD、It restores all the dropped disks in the disk group for which the drop-disk operation has already been completedE、It adds previously dropped disks back into the disk group
考题
You issued the following command at the UNIX environment： % setenv ORA_SDTZ ’OZ_TZ’ What will be the impact of issuing the above command？（） A、 The operating system local time zone will be set for a user session using the operating system environment variable.B、 The database local time zone will be set for a user session using the operating system environment variable.C、 The operating system local time zone will be set for the database using the operating system environmentD、 The database local time zone will be set for the database using the operating system environment variable.
考题
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
考题
多选题You decided to increase the value for the SHARED_SERVERS parameter by using the following command： SQL ALTER SYSTEM SET SHARED_|SERVERS=3 SCOPE=？； Which three values can be specified for the SCOPE clause？（）AALLBPFILECBOTHDNONEESPFILEFMEMORYGINSTANCEHDATABASE
考题
单选题View the Exhibit and examine the parameters. User A executes the following command to update the TRANS table： SQL UPDATE B.trans SET tr_amt=tr_amt+500 WHERE c_code=’C005’； Before user A issues a COMMIT or ROLLBACK command， user B executes the following command onthe TRANS table： SQL ALTER TABLE trans MODIFY （tr_type VARCHAR2（3））； What would happen in this scenario（）A
The ALTER TABLE command modifies the column successfully.B
The DDL operation gets higher priority and transaction for user a is rolled back.C
The ALTER TABLE command waits indefinitely until user a ends the transaction.D
The ALTER TABLE command fails after waiting for 60 seconds due to the resource being busy.
考题
单选题You issued the following command at the UNIX environment： % setenv ORA_SDTZ ’OZ_TZ’ What will be the impact of issuing the above command？（）A
The operating system local time zone will be set for a user session using the operating system environment variable.B
The database local time zone will be set for a user session using the operating system environment variable.C
The operating system local time zone will be set for the database using the operating system environmentD
The database local time zone will be set for the database using the operating system environment variable.
考题
单选题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’；
考题
单选题Examine the following commands executed in your database： SQL ALTER SESSION RECYCLEBIN=ON； Session altered SQL CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees； Table created. Further， you executed the following command to drop the table： SQL DROP TABLE emp；Table dropped. What happens in this scenario？（）A
The table is moved to the SYSAUX tablespace.B
The table is moved to the SYSTEM tablespace.C
The table is removed from the database permanently.D
The table is renamed and remains in the TBSFD tablespace.
考题
单选题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
考题
多选题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？ （）Ause the ALTER SYSTEM command to change the time zoneBuse the ALTER SESSION command to change the time zoneCuse the ALTER DATABASE command to change the time zoneDset the value for the operating system variable ORA_SDTZ on the client machineEset the value for the operating system variable ORA_SDTZ on the database server machine
考题
单选题Examine the following command： ALTER DISKGROUP data MOUNT FORCE； In which scenario can you use the above command to mount the disk group？（）A
when ASM disk goes offlineB
when one or more ASM files are droppedC
when some disks in a disk group are offlineD
when some disks in a failure group for a disk group are rebalancing
考题
单选题Examine the following command:ALTER SYSTEM SET enable_ddl_logging=FALSE;Which statement is true?（）A
None of the data definition language (DDL) statements are logged in the trace file.B
Only DDL commands that resulted in errors are logged in the alert log file.C
A new log.xml file that contains the DDL statements is created, and the DDL command details are removed from the alert log file.D
Only DDL commands that resulted in the creation of new database files are logged.
考题
单选题Examine the following command: ALTER DISKGROUP data MOUNT FORCE; In which scenario can you use the above command to mount the disk group? （）A
when ASM disk goes offlineB
when one or more ASM files are droppedC
when some disks in a disk group are offlineD
when some disks in a failure group for a disk group are rebalancing
考题
单选题User A executes the following command to update the TRANS table） SQL UPDATE B.trans SET tr_amt=tr_amt+500 WHERE c_code=’C005’； Before user A issues a COMMIT or ROLLBACK command， user B executes the following command on the TRANS table： SQl ALTER TABLE trans MODIFY （tr_type VARCHAR2 （3））； What would happen in this scenario？（）A
The transaction for user A is rolled back.B
The ALTER TABLE command modifies the column successfully.C
The ALTER TABLE command fails due to the resource being busy.D
The ALTER TABLE command waits until user A ends the transaction.
考题
单选题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；
热门标签
最新试卷
