单选题You execute the following command in your Supportcenter.cn production database to change the width of the CUST_NAME column of the CUSTOMERS table： ALTER TABLE customers MODIFY （cust_nameVARCHAR2 （40）） / When you execute the command， it displays

题目

单选题

You execute the following command in your Supportcenter.cn production database to change the width of the CUST_NAME column of the CUSTOMERS table： ALTER TABLE customers MODIFY （cust_nameVARCHAR2 （40）） / When you execute the command， it displays the following error message： ERROR at line 1： ORA-00054： resource busy and acquire with NOWAIT specified What could be the reason for the error message？（）

The database instance is not available.

The ALTER TABLE command does not have WAIT option

The table or a row in the table is currently locked by another user session.

The database instance is busy processing other user sessions commands.

The CUSTOMERS table has no long running query active at the time when this request is made.

The server process executing the ALTER TABLE command is busy with another command execution

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

相似问题和答案

第1题：

Your multitenant container database (CDB) is running in ARCHIVELOG mode. You connect to the CDB RMAN.Examine the following command and its output:You execute the following command:RMAN > BACKUP DATABASE PLUS ARCHIVELOG;Which data files will be backed up?（）

A. Data files that belong to only the root container

B. Data files that belong to the root container and all the pluggable databases (PDBs)

C. Data files that belong to only the root container and PDB$SEED

D. Data files that belong to the root container and all the PDBs excluding PDB$SEED

参考答案：B

第2题：

Your database is up and running and one of your three control files is accidentally erased. You start RMAN and run the following command： RESTORE CONTROLFILE FROM AUTOBACKUP； Which of the following statements is true？（）

A、 The command restores only the missing control file.
B、 The command restores all the control files.
C、 The command fails because the database is running.
D、 This is the correct way to address this problem.
E、 This is not the correct way to address this problem.

正确答案:C,E

第3题：

You are a network administrator for your company. You currently automate backups of the System State data on the servers in your network by using NTBackup. Your manager instructs you to document the procedure for restoring a server from a backup of the System State data.You need to select the correct method for performing a restoration of a backup of the System State data.What should you do?（）

A. Run the following command: ntbackup.exe backup /F {"FileName"}

B. Run the following command: ntbackup.exe backup systemstate /F {"FileName"}

C. In Control Panel, open System, and configure the Startup and Recovery settings on the Advanced tab.

D. Use NTBackup interactively.

参考答案：D

第4题：

You issued the following statement： SQL>ALTER DATABASE ENABLE RESUMABLE TIMEOUT n； What will be the result of issuing the above statement？（）

A、The command will not execute successfully because TIMEOUT is an invalid clause with the ALTER DATABASE ENABLE RESUMABLE command.
B、 The command will not execute successfully because resumable space allocation is enabled at the session level.
C、 The command will execute successfully and resumable space will be allocated at the session level.
D、 The command will execute successfully and resumable space will be allocated at the instance level.

正确答案:B

第5题：

Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt： RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON； After executing this command， in which of the following cases will RMAN make an auto-backup of the control file？（）

A、 when you change the name of a datafile
B、 when you drop a table from the database
C、 when you take an export of the database
D、 when you back up the database using OS utilities
E、 when you issue an ALTER SYSTEM SWITCH LOGFILE statement
F、 when you issue a BACKUP command from inside the RMAN run block

正确答案:A,E,F

第6题：

You are troubleshooting a WAN connection for TestKing, and on the router you execute the, "debug ppp authentication" command, and view the following output:What kind of handshake was used for the PPP authentication?（）

A. one-way

B. two-way

C. three-way

D. No handshakes required during authentication

E. None of the above

参考答案：C

第7题：

You plan to execute the following command to perform a Flashback Database operation in your database： SQL> FLASHBACK DATABASE TO TIMESTAMP （SYSDATE -5/24）； Which two statements are true about this？（）

A、 The database must have multiplexed redo log files
B、 The database must be in the MOUNT state to execute the command
C、 The database must be in the NOMOUNT state to execute the command
D、 The database must be opened in RESTRICTED mode before this operation
E、 The database must be opened with the RESETLOGS option after the flashback operation

正确答案:B,E

第8题：

View the Exhibit and examine the output.You execute the following RMAN command to perform the backup operation:What is the multiplexing level in the preceding backup process()

A. 4

B. 8

C. 7

D. 0

参考答案：A

第9题：

In your Automatic Storage Management （ASM） instance， one of the nonempty disk groups， DGROUP1， is no longer required and you want this disk group to be removed. You execute the following command to achieve this objective： DROP DISKGROUP dgroup1 EXCLUDING CONTENTS； What would be the result of this command？（）

A、 This command would result in an error because the disk group is not empty.
B、 The command would distribute the contents of the specified disk group among all other disk groups and then drop the specified disk group.
C、 The command would result in the contents being moved to the parent disk group and dropping of the disk group.
D、 The command would result in the disk group being marked as INVALID because it cannot be dropped.
E、 The command would drop the disk group， ignoring the EXCLUDING CONTENTS option.

正确答案:A

第10题：

You are maintaining the PROD database for NetFx Corporation. You have configured controlfile autobackup in your database. At 6：00 P.M. on Monday， you issue the following command： RMAN>BACKUP DATABASE； At 8：00 A.M. on Tuesday， you are unable to start the database because all the control files are missing. You decide to restore the control files from the backup by using the RMAN> RESTORE CONTROLFILE FROM AUTOBACKUP； command. Which operation should you perform before using the RMAN> RESTORE CONTROLFILE FROM AUTOBACKUP； command？（）

A、 Start the database in the MOUNT stage.
B、 Back up the control file to trace.
C、 Set the DBID
D、 Issue the RECOVER DATABASE command.

正确答案:C

You execute the following command in your Supportcenter.cn p

题目

相似问题和答案

更多相关问题

相关内容