The tablespace would require recovery to go back online.
A checkpoint is taken on all data files that are associated with the SALES tablespace.
The sessions that subsequently try to access the objects in the SALES tablespace receive an error
The new status of the SALES tablespace is recorded in the control file when the database instance isclosed
第1题:
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?()
第2题:
You issued the following statement: SQL>ALTER DATABASE ENABLE RESUMABLE TIMEOUT n; What will be the result of issuing the above statement?()
第3题:
A. Because row IDs may change during the flashback operation
B. Because the object number changes after the flashback operation
C. Because the rows are retrieved from the recycle bin during the flashback operation
D. Because the table is moved forward and back to a temporary during the flashback opertion
第4题:
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()
第5题:
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?()
第6题:
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? ()
第7题:
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?()
第8题:
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: RMAN>CHANGE BACKUPSET 231 NOKEEP; What is the implication of this command?()
第9题:
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()
第10题:
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?()