单项选择题

A.The database instance is not available.B.The ALTER TA……

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？（）

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

<上一题目录下一题>

热门试题

单项选择题YourbossatSupportcenter.cnwantsyoutoclarifyOracle10g.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.

多项选择题YouworkasadatabaseadministratorforSupportcenter.cn.YouareusingRecoveryManager（RMAN）toperformbackupsinyourdatabases.WhichfourbackupoperationscanbeperformedusingRMAN？（）

A.A backup of the target database when it is mounted
B.A backup of online redo log files when the database is open
C.A backup of only used data blocks in the file beingbeingbackup up
D.A backup of online， read/write data files when the database is open
E.A backup of only those data blocks that have changed since a previous backup
F.A backup of online， read/write data files when the database is in the NOMOUNT state.

多项选择题YouworkasadatabaseadministratorforSupportcenter.cn.Youwanttoadministeryourdatabaseservers，whicharerunningondifferenthostmachines，usingtheWeb-enabledgridcontrolinterface.Youhaveconfiguredtheagentonthehostmachines.YouhavestartedtheOracleDatabase10gGridControlutilityonyourmachine.Whichtwoadditionalcomponentswouldyouconfiguretoachievethisobjective？（）

A.Application Server Control
B.Oracle Management Service
C.Oracle Enterprise Manager Repository
D.Oracle Enterprise Manager Database Control

单项选择题YouworkasadatabaseadministratorforSupportcenter.cn.Youwanttoconfiguredatabasebackupstoberunautomatically.Whichtoolorutilitywouldyouusetoachievethis？（）

A.The DBMS_JOB package
B.The BACKUP_JOB package
C.The DBMS_BACKUP_RESTORE package
D.The calendar tool in the Operating System （OS）
E.The backup scheduler in Enterprise Manager （EM）
F.The DBMS_BACKUP_SCHEDULER packager inline mode

多项选择题You work as a database administrator for Supportcenter.cn. While setting up the database for your production environment， you want to create a user according to the requirements in the exhibit. Which three options of the CREATE USER command would you use to achieve this objective？（）

A.Profile
B.Account lock
C.Account unlock
D.Password expire
E.Quota 10MB on SupportCenter TBS1
F.Password never expire
G.Defaulttablespace SupportCenter TBS1
H.Quota unlimited on SupportCenter TBS1
I.TemporarytablespaceTEMP
J.TemporarytablespaceSYSTEM