You execute the following command in your Certkiller .com pr

题目
单选题
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

参考答案和解析
正确答案: C
解析: 暂无解析
如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

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

第2题:

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

第3题:

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

第4题:

You have lost all your database control files. To recover them, you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact.  Which of the following is true regarding your recovery?()  

  • A、 You will need to open the database with the resetlogs command.
  • B、 All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.
  • C、 You will use the resetlogs version of the create controlfile command.
  • D、 You will use the noresetlogs version of the create controlfile command.
  • E、 You will use the trace file to create a backup control file, and then you will recover the database with the recover database using backup controlfile command

正确答案:D

第5题:

You execute the following command to start an Automatic Storage Management (ASM) instance:   SQL>STARTUP;   In which of the following modes will the ASM instance start?()

  • A、 OPEN
  • B、 MOUNT
  • C、 NORMAL
  • D、 NOMOUNT

正确答案:B

第6题:

You work as a database administrator for Certkiller .com. Your database is in the MOUNT state and you execute the following command to open it ALTER DATABASE OPEN; What two actions are performed as a result of this command?()

  • A、All control files are opened
  • B、All redo files are opened
  • C、The password file is opened
  • D、The parameter file is opened
  • E、All online data files are opened

正确答案:B,E

第7题:

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

第8题:

As an administrator at Cer-tech .com, you install Web server (IIS) role on a server that runs WindowsServer 2008. You created a new site called Cer-tech .com. You need to install an application on thewebsite called web content. You copy the application to the server. What should you do to add theapplication on the website?()

  • A、Create a virtual directory and copy the website contents in it. Copy the application in the directory andinstall it
  • B、Execute appcmd command on the command prompt on the server
  • C、Open the IIS Manager Console and select the website. Select Add Application
  • D、Execute appcmd -t on the command prompt on the server

正确答案:C

第9题:

You work as a database administrator for Certkiller .com. Your database is opened in NOARCHIVEKLOG mode. You decide to place the database in ARCHIVELOG mode.  How would you do this?()

  • A、Execute the ALTER DATABASE ARCHIVELOG statement 
  • B、Select ARCHIVELOG option in the database control and restart the database to apply the changes. 
  • C、Shut down and start the instance, and in the NOMOUNT state execute the ALTER DATABASE ARCHIVELOG statement. 
  • D、Shut down and start the instance, mount the database, then execute the ALTER DATABASE ARCHIVELOG statement. 

正确答案:B,D

第10题:

Certkiller .com has a main office and a branch office. Certkiller .com’s network consists of a single Active Directory forest. Some of the servers in the network run Windows Server 2008 and the rest run Windows server 2003.  You are the administrator at Certkiller .com. You have installed Active Directory Domain Services (AD DS) on a computer that runs Windows Server 2008. The branch office is located in a physically insecure place. It has not IT personnel onsite and there are no administrators over there. You need to setup a Read-Only Domain Controller (RODC) on the Server Core installation computer in the branch office. What should you do to setup RODC on the computer in branch office()

  • A、Execute an attended installation of AD DS
  • B、Execute an unattended installation of AD DS
  • C、Execute RODC through AD DS
  • D、Execute AD DS by using deploying the image of AD DS
  • E、none of the above

正确答案:B

更多相关问题