单选题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?()AThe database instance is not available.BThe ALTER TABLE command does not have WAIT optionCThe table or a row in the table is currently locked by another user session.DThe database instance is busy processing other user sessions commands.EThe CUSTOMERS table has no long running query active at the time when this request is made.FThe server process executing the ALTER TABLE command is busy with another command execution
单选题
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
参考解析
解析:
暂无解析
相关考题:
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 containerB. 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$SEEDD. Data files that belong to the root container and all the PDBs excluding PDB$SEED
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 itB、Execute appcmd command on the command prompt on the serverC、Open the IIS Manager Console and select the website. Select Add ApplicationD、Execute appcmd -t on the command prompt on the server
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 filesB、 The database must be in the MOUNT state to execute the commandC、 The database must be in the NOMOUNT state to execute the commandD、 The database must be opened in RESTRICTED mode before this operationE、 The database must be opened with the RESETLOGS option after the flashback operation
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 openedB、All redo files are openedC、The password file is openedD、The parameter file is openedE、All online data files are opened
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 datafileB、 when you drop a table from the databaseC、 when you take an export of the databaseD、 when you back up the database using OS utilitiesE、 when you issue an ALTER SYSTEM SWITCH LOGFILE statementF、 when you issue a BACKUP command from inside the RMAN run block
You issued the following statement: SQLALTER 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.
You execute the following command to start an Automatic Storage Management (ASM) instance: SQLSTARTUP; In which of the following modes will the ASM instance start?()A、 OPENB、 MOUNTC、 NORMALD、 NOMOUNT
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.
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
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 DSB、Execute an unattended installation of AD DSC、Execute RODC through AD DSD、Execute AD DS by using deploying the image of AD DSE、none of the above
The corporate network of Certkiller consists of a Windows Server 2008 single Active Directory domain. The domain has two servers named Certkiller 1 and Certkiller 2. To ensure central monitoring of events you decided to collect all the events on one server, Certkiller 1. To collect events from Certkiller 2. and transfer them to Certkiller 1, you configured the required event subscriptions. You selected the Normal option for the Event delivery optimization setting by using the HTTP protocol. However, you discovered that none of the subscriptions work. Which of the following actions would you perform to configure the event collection and event forwarding on the two servers()A、Through Run window execute the winrm quickconfig command on Certkiller 2.B、Through Run window execute the wecutil qc command on Certkiller 2.C、Add the Certkiller 1 account to the Administrators group on Certkiller 2.D、Through Run window execute the winrm quickconfig command on Certkiller 1.E、Add the Certkiller 2 account to the Administrators group on Certkiller 1.F、Through Run window execute the wecutil qc command on Certkiller 1.
Your network contains an Active Directory domain named contoso.com.You run nslookup.exe as shown in the following Command Prompt window. You need to ensure that you can use Nslookup to list all of the service location (SRV) resource records for contoso.com. What should you modify()A、the root hints of the DNS serverB、the security settings of the zoneC、the Windows Firewall settings on the DNS serverD、the zone transfer settings of the zone
Certkiller .com has a server that runs on Windows Server 2008. The server also has an instance of Active Directory Lightweight Directory Services (AD LDS) running. In order to test AD LDS, you need to replicate the AD LDS instance on a test computer located on the network. What should you do to achieve this objective()A、Execute AD LDS Setup wizard on the test computer to create and install a replica of AD LDS.B、Execute repadmin/bs command on the test computerC、Install and configure a new AD LDS instance on the test computer by copy and pasting the entire partition on the test computerD、Execute the Dsmgmt command on the test computer and create a naming context
You work as a network Exchange administrator at Company.com.The Company.com network currently consists of a single Active Directory forest containing a single domain named Company.com.The Company.com organization makes use of Microsoft Exchange Server as their messaging solution.During the course of the business week you receive instruction from Company.com to perform an automated installation of Microsoft Exchange Server 2010.What should you do?()A、You should consider having the msiexec.eex command included in your script.B、You should consider having the Ipsetupui.exe command included in your script.C、You should consider having the setup.exe command included in your script.D、You should consider having the setup.com command included in your script.
单选题You work as an application developer at Certkiller .com. You have been asked by you superiors at Certkiller .com to create a child application domain. The new child application domain has to specify a different assembly path than that of the parent application domain.You need to ensure that your solution meets Certkiller .com’s requirements.What should you do?()A AB BC CD D
单选题You issued the following statement: SQLALTER DATABASE ENABLE RESUMABLE TIMEOUT n; What will be the result of issuing the above statement?()AThe 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.
单选题You work as a network Exchange administrator at Company.com.The Company.com network currently consists of a single Active Directory forest containing a single domain named Company.com.The Company.com organization makes use of Microsoft Exchange Server as their messaging solution.During the course of the business week you receive instruction from Company.com to perform an automated installation of Microsoft Exchange Server 2010.What should you do?()AYou should consider having the msiexec.eex command included in your script.BYou should consider having the Ipsetupui.exe command included in your script.CYou should consider having the setup.exe command included in your script.DYou should consider having the setup.com command included in your script.
多选题You work as a database administrator for Certkiller .com. You decided to manage client and server connections using Local Naming method in Certkiller .com. When you try to connect to the database you get the following error: ERROR: ORA-12154:TNS:couldnot resolve service name Which network configuration files would you look into to resolve this error?()Asnmp.oraBnames.oraCspfile.oraDsqlnet.oraElistener.oraFtnsnames.ora
单选题You execute the following command to start an Automatic Storage Management (ASM) instance: SQLSTARTUP; In which of the following modes will the ASM instance start?()A OPENB MOUNTC NORMALD NOMOUNT
多选题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?()AExecute the ALTER DATABASE ARCHIVELOG statementBSelect ARCHIVELOG option in the database control and restart the database to apply the changes.CShut down and start the instance, and in the NOMOUNT state execute the ALTER DATABASE ARCHIVELOG statement.DShut down and start the instance, mount the database, then execute the ALTER DATABASE ARCHIVELOG statement.
单选题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?()AData files that belong to only the root containerBData files that belong to the root container and all the pluggable databases (PDBs)CData files that belong to only the root container and PDB$SEEDDData files that belong to the root container and all the PDBs excluding PDB$SEED
单选题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
多选题You work as an application developer at Certkiller .com. You have recently created an application domain for Certkiller .com. A few weeks later you are asked to retrieve information from this application domain, which is the current application domain. What can you do to achieve this objective?()AUse the following code: AppDomain appInfo = ApplicationDomain.Current;BUse the following code: AppDomain appInfo = AppDomain.CurrentDomain ();CUse the following code: AppDomain appInfo = Thread.GetDomain ();DUse the following code: AppDomain appInfo = MainThread.GetDomain ();
多选题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? ()Awhen you change the name of a datafileBwhen you drop a table from the databaseCwhen you take an export of the databaseDwhen you back up the database using OS utilitiesEwhen you issue an ALTER SYSTEM SWITCH LOGFILE statementFwhen you issue a BACKUP command from inside the RMAN run block
单选题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?()AThe database instance is not available.BThe ALTER TABLE command does not have WAIT optionCThe table or a row in the table is currently locked by another user session.DThe database instance is busy processing other user sessions commands.EThe CUSTOMERS table has no long running query active at the time when this request is made.FThe server process executing the ALTER TABLE command is busy with another command execution
单选题You work as a database administrator for Certkiller .com. Redo log files are not multiplexed in your database. Redo log blocks are corrupted in group 2, and archiving has stopped. All the redo logs are filled and database activity is halted. Database writer has written everything to disk. Which command would you execute to proceed further?()ARECOVER LOFIEL BLOCK GROUP 2;BALTER DATABASE DROP LOGFILE GROUP 2;CALTER DATABASE CLEAR LOGFILE GROUP 2;DALTER DATABASE RECOVER LOGFILE GROUP 2;EALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 2;
多选题You work as a database administrator for Supportcenter.cn. 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?()AAll control files are openedBAll redo files are openedCThe password file is openedDThe parameter file is openedEAll online data files are opened