CMS专题
单选题Examine the following command: ALTER DISKGROUP data MOUNT FORCE; In which scenario can you use the above command to mount the disk group? （）A when ASM disk goes offlineB when one or more ASM files are droppedC when some disks in a disk group are offlin
题目
when ASM disk goes offline
when one or more ASM files are dropped
when some disks in a disk group are offline
when some disks in a failure group for a disk group are rebalancing
相似问题和答案
第1题：
Which two commands never trigger an implicit rebalancing within the disk group?（） (Choose two.)
- A、ALTER DISKGROUP misc MOUNT;
- B、ALTER DISKGROUP misc DROP DISK misc2;
- C、ALTER DISKGROUP misc CHECK ALL NOREPAIR;
- D、ALTER DISKGROUP misc RESIZE ALL SIZE 1023m;
- E、ALTER DISKGROUP dgroupA ADD DISK '/devices/A*';
正确答案:A,C
第2题：
You are managing a single instance Oracle 10g database that utilizes the following parameters： Which of the following set of commands must you execute to enable Flashback Database？（）
- A、 STARTUP MOUNT EXCLUSIVE ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN；
- B、 STARTUP MOUNT ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN RESETLOGS；
- C、 STARTUP MOUNT EXCLUSIVE ATLER DATABASE ARCHIVELOG； ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN RESETLOGS；
- D、 STARTUP MOUNT ALTER DATABASE ARCHIVELOG； ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN；
正确答案:D
第3题：
A. ALTER DISKGROUP data CHECK;
B. ALTER DISKGROUP data CHECK DISK;
C. ALTER DISKGROUP data CHECK FILE;
D. ALTER DISKGROUP data CHECK DISK IN FAILURE GROUP 1;
第4题：
Examine the following statement that is used to modify the constraint on the SALES table： SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE； Which three statements are true regarding the above command（）
- A、The constraint remains valid.
- B、The index on the constraint is dropped.
- C、It allows the loading of data into the table using SQL*Loader.
- D、New data conforms to the constraint， but existing data is not checked
- E、It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.
正确答案:A,B,C
第5题：
You want to perform the following operations for the DATA ASM disk group： -Verify the consistency of the disk. -Cross-check all the file extent maps and allocation tables for consistency. check whether the alias metadata directory and file directory are linked correctly. -Check that ASM metadata directories do not have unreachable allocated blocks. Which command accomplishes these tasks（）？
- A、 ALTER DISKGROUP data CHECK
- B、 ALTER DISKGROUP data CHECK DISK
- C、 ALTER DISKGROUP data CHECK FILE
- D、 ALTER DISKGROUP data CHECK DISK IN FAILURE GROUP 1
正确答案:A
第6题：
Consider the following scenario： You have a directory， data， under the disk group tdgroupA. You want to create an alias for one of the data files and you execute the following command： ALTER DISKGROUP tdgroupA ADD ALIAS ’+tdgroupA/data/datafile.dbf’ FOR ’+tdgroupA.231.45678’； Which task would be accomplished by the command？（）
- A、The command drops the file +tdgroupA·231.45678.
- B、The command physically relocates the file to +tdgroupA/data and renames the file to datafile.dbf.
- C、The command creates a copy of the +tdgroupA·231.45678 file and places it in +tdgroupA/data after renaming the file to datafile.dbf.
- D、The command creates an alias， datafile.dbf， and places it in +tdgroupA/data and does not remove the +tdgroupA·231.45678 file.
- E、The command creates a file， datafile.dbf， in +tdgroupA/data and removes the references for +tdgroupA·231.45678 from the data dictionary views.
正确答案:D
第7题：
Which two commands never trigger an implicit rebalancing within the disk group?（）
- A、ALTER DISKGROUP misc MOUNT;
- B、ALTER DISKGROUP misc DROP DISK misc2;
- C、ALTER DISKGROUP misc CHECK ALL NOREPAIR;
- D、ALTER DISKGROUP misc RESIZE ALL SIZE 1023m;
- E、 ALTER DISKGROUP dgroupA ADD DISK '/devices/A*';
正确答案:A,C
第8题：
Upon starting your database, you receive the following error:You can choose from the following steps:1.Restore the database datafiles.2.Issue the alter database clear unarchived logfile group 1 command.3.Issue the alter database open command.4.Issue the alter database open resetlogs command.5.Recover the database using point-in-time recovery.6.Issue the Startup Mount command to mount the database.7.Back up the database.Which is the correct order of these steps in this case?（）
A. 1,6,5,4,7
B. 6,5,4
C. 6,2,3,7
D. 1,6,3
E. The database cannot be recovered
第9题：
How can you reverse the effects of an ALTER DISKGROUP ... DROP DISK command if it has already completed？（）
- A、 Issue the ALTER DISKGROUP ... ADD DISK command.
- B、 Issue the ALTER DISKGROUP ... UNDROP DISKS command.P.... DROP DISK CANCEL command.
- C、 Issue the ALTER DISKGROU
- D、 Retrieve the disk from the Recycle Bin after the operation completes.
正确答案:A
第10题：
Examine the following ALTER command: SQL> ALTER DISKGROUP dgroup1 UNDROP DISKS; What is the purpose of the command?（）
- A、It cancels all pending disk drops within the disk group
- B、It restores disks that are being dropped as the result of a DROP DISKGROUP operation
- C、It mounts disks in the disk group for which the drop-disk operation has already been completed
- D、It restores all the dropped disks in the disk group for which the drop-disk operation has already been completed
- E、It adds previously dropped disks back into the disk group
正确答案:A