多选题You execute the following command to change the status of the SALES tablespace:  SQL ALTER TABLESPACE sales OFFLINE;  Which statements describe the effect of the command()AThe tablespace would require recovery to go back online.BA checkpoint is taken on all data files that are associated with the SALES tablespace.CThe sessions that subsequently try to access the objects in the SALES tablespace receive an error.DThe new status of the SALES tablespace is recorded in the control file when the database instance is closed.

多选题
You execute the following command to change the status of the SALES tablespace:  SQL> ALTER TABLESPACE sales OFFLINE;  Which statements describe the effect of the command()
A

The tablespace would require recovery to go back online.

B

A checkpoint is taken on all data files that are associated with the SALES tablespace.

C

The sessions that subsequently try to access the objects in the SALES tablespace receive an error.

D

The new status of the SALES tablespace is recorded in the control file when the database instance is closed.


参考解析

解析: 暂无解析

相关考题:

Before a Flashback Table operation, you execute the following command:ALTER TABLE employees ENABLE ROW MOVEMENT;Why would you need this to be executed?() A. Because row IDs may change during the flashback operationB. Because the object number changes after the flashback operationC. Because the rows are retrieved from the recycle bin during the flashback operationD. Because the table is moved forward and back to a temporary during the flashback opertion

You performed the RMAN database backup having a backupset key number 231 with the KEEP FOREVER option. After some days, you want to change the status of the database backup and you issued the following command: RMANCHANGE BACKUPSET 231 NOKEEP; What is the implication of this command?()A、The backup is deleted.B、The backup is marked unavailable.C、The backup overrides the backup retention policy.D、the backup becomes eligible for deletion according to the existing retention policy

You are working in an online transaction processing (OLTP) environment. You used the FLASHBACK TABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE command, the System Change Number (SCN) was 663571. After flashing back the CUSTOMERS table,you realize that the table is not in the correct state and the resultant changes are not what you had desired. So, you need to reverse the effects of the FLASHBACK TABLE command while ensuring that:  a) No other user data in the database is affected.  b) The operation takes the minimum possible time.  Which option would you choose?() A、use the ROLLBACK command with SCN 663571B、perform Flashback Transaction Query with SCN 663571C、execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571D、execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571

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 Supportcenter.cn. You are using Recovery Manager (RMAN) for backup and recovery of your database. You executed the delete command in RMAN to delete a backup of a tablespace. Which statement is true in this scenario?()A、The backup status will be marked expired in RMAN recovery catalog.B、The backup status will be marked deleted in RMAN recovery catalog after you execute the crosscheck command.C、The backup will be deleted physically from the OS (Operating system)and the backup information is removed from the recovery cataloglD、The backup status will be marked deleted and you must delete the backup file manually from the OS (Operating system).E、The backup status will be marked deleted and you must delete the backup file manually from the OS (Operating system), if you are not using Oracle Managed Files (OMF).

You execute the following command to change the status of the SALES tablespace:SQL ALTER TABLESPACE sales OFFLINE; Which statements describe the effect of the command()A、The tablespace would require recovery to go back online.B、A checkpoint is taken on all data files that are associated with the SALES tablespace.C、The sessions that subsequently try to access the objects in the SALES tablespace receive an errorD、The new status of the SALES tablespace is recorded in the control file when the database instance isclosed

Your network contains a domain controller that runs Windows Server 2008 R2. You run the  following command on the domain controller:   dsamain.exe -dbpath c:/$SNAP_201006170326_VOLUMEC$/Windows/NTDS/ntds.dit -ldapport  389 -allowNonAdminAccess     The command fails.     You need to ensure that the command completes successfully.     How should you modify the command()A、Include the path to Dsamain.B、Change the value of the -dbpath parameter.C、Change the value of the -ldapport parameter.D、Remove the -allowNonAdminAccess parameter.

Your company runs Terminal Services on a server named Server2.  You need to prevent new sessions on the Terminal Server without affecting current user sessions. Which command should you run?()A、Change logon /disableB、Change user /execute disableC、Tskill /server:Server2 /AD、Taskkill /S Server2 /fi "MODULES eq TermSrv"

单选题You work as a database administrator for Supportcenter.cn. You are using Recovery Manager (RMAN) for backup and recovery of your database. You executed the delete command in RMAN to delete a backup of a tablespace. Which statement is true in this scenario?()AThe backup status will be marked expired in RMAN recovery catalog.BThe backup status will be marked deleted in RMAN recovery catalog after you execute the crosscheck command.CThe backup will be deleted physically from the OS (Operating system)and the backup information is removed from the recovery cataloglDThe backup status will be marked deleted and you must delete the backup file manually from the OS (Operating system).EThe backup status will be marked deleted and you must delete the backup file manually from the OS (Operating system), if you are not using Oracle Managed Files (OMF).

多选题Examine the following command used to perform incremental level 0 backup: RMAN BACKUP INCREMENTAL LEVEL 0 DATABASE; To enable the block change tracking, after the incremental level 0 backup you issued the following command: SQL ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE '/mydir/ rman_change_track.f'; To perform incremental level 1 cumulative backup, you issued the following command: RMAN BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE; Which two statements are true in the above situation?()AThe block change tracking data will be used only from the next incremental 0 backup.BThe incremental backup will use change tracking data for accomplishing the backup.CThe incremental backup will not use change tracking data for accomplishing the backup.DThe block track file will scan all the blocks and create bitmap for all the blocks backed up in the level 0 backup.

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

单选题A server named Server2 runs Windows Server 2008. The Terminal Services server role is installed on Server2.  You plan to deploy a new Terminal Services application on Server2. The application vendor confirms that the application can be deployed in a Terminal Services environment. The application does not use Microsoft Windows Installer packages for installation. The application makes changes to the current user registry during installation.  You need to install the application to support multiple user sessions. What should you do?()ARun the mstsc /v:Server2 /console command from the client computer to log on to Server2. Install the application.BRun the change user /execute command on Server2. Install the application and run the change user /install command on Server2.CRun the change user /install command on Server2. Install the application and run the change user /execute command on Server2.DRun the change logon /disable command on Server2. Install the application and run the change logon /enable command on Server2.

单选题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 performed the RMAN database backup having a backupset key number 231 with the KEEP FOREVER option.  After some days, you want to change the status of the database backup and you issued the following command:   RMANCHANGE BACKUPSET 231 NOKEEP;   What is the implication of this command?()A The backup is deleted.B The backup is marked unavailable.C The backup overrides the backup retention policy.D the backup becomes eligible for deletion according to the existing retention policy.

多选题You execute the following command to change the status of the SALES tablespace:SQL ALTER TABLESPACE sales OFFLINE; Which statements describe the effect of the command()AThe tablespace would require recovery to go back online.BA checkpoint is taken on all data files that are associated with the SALES tablespace.CThe sessions that subsequently try to access the objects in the SALES tablespace receive an errorDThe new status of the SALES tablespace is recorded in the control file when the database instance isclosed

单选题Before a Flashback Table operation, you execute the following command: ALTER TABLE employees ENABLE ROW MOVEMENT; Why would you need this to be executed?()ABecause row IDs may change during the flashback operationBBecause the object number changes after the flashback operationCBecause the rows are retrieved from the recycle bin during the flashback operationDBecause the table is moved forward and back to a temporary during the flashback operation

单选题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 enable block change tracking. You issue the following command: BACKUP INCREMENTAL LEVEL 0 DATABASE; The next day, you issue the following command: BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE; Which statement about the use of the change tracking file is true?()ARMAN reads the block change tracking file only when it performs the incremental level 0 backup.BRMAN reads the block change tracking file when it performs both incremental backups.CRMAN reads the block change tracking file only when it performs the incremental level 1 backup.DRMAN does not read the block change tracking file when it performs either incremental backup.

多选题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

单选题Before a Flashback Table operation,you execute the following command:   ALTER TABLE employees ENABLE ROW MOVEMENT;   Why would you need this to be executed?()A Because row IDs may change during the flashback operationB Because the object number changes after the flashback operationC Because the rows are retrieved from the recycle bin during the flashback operationD Because the table is moved forward and back to a temporary during the flashback opertion

多选题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