单项选择题
You execute the following command in your Certkiller .com 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?()
A.The database instance is not available.
B.The ALTER TABLE command does not have WAIT option
C.The table or a row in the table is currently locked by another user session.
D.The database instance is busy processing other user sessions commands.
E.The CUSTOMERS table has no long running query active at the time when this request is made.
F.The server process executing the ALTER TABLE command is busy with another command execution
相关考题
-
单项选择题
YourbossatCertkiller.comwantsyoutoclarifyOracle10g.Whichstatementregardingtheusageofredologfilesduringinstancerecoveryistrue?()
A.Transactions are rolled back using redo log files.
B.Transactions are rolled forward using redo log files.
C.Transactions are rolled back using redo log files and archived log files.
D.Transactions are rolled forward using redo log files and rolled back using redo log files. -
单项选择题
You work as a database administrator for Certkiller .com. You determine that archiving was not successful in one of thedestinators. You want to check the alert log file for more information on this. Which initialization parameter gives you the location of the alert log file?()
A.USER_DUMP_DEST
B.CORE_DUMP_DEST
C.ALERT_LOG_DEST
D.ALERT_DUMP_DEST
E.TRACE_DUMP_DEST
F.BACKGROUND_DUMP_DEST -
单项选择题
You work as a database administrator for Certkiller .com. You want to create a new optimized database for your transactional production environment to be used by a financial application. While creating the database, you want the Oracle Software to take care of all basic settings to optimize the database performance. Which method would you use to achieve this objective?()
A.A
B.B
C.C
D.D
E.E
