单选题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 operationC It mounts disks in the disk group for which the drop-disk operation has already been co pletedD It restores all the dropped disks in the disk group for which the drop-disk operation has already been completedE It adds previously dropped disks back into the disk group
单选题
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 co pleted
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
参考解析
解析：
暂无解析
相关考题：
You want to perform the following operations for the DATA ASM disk group: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;
You are managing an ASM instance. You previously issued the following statements:ALTER DISKGROUP dg1 DROP DISK disk2;ALTER DISKGROUP dg1 DROP DISK disk3;ALTER DISKGROUP dg1 DROP DISK disk5;You want to cancel the disk drops that are pending for the DG1 disk group.Which statement should you issue?（）A. ALTER DISKGROUP dg1 UNDROP disk2, disk3, disk5;B. ALTER DISKGROUP dg1 UNDROP;C. ALTER DISKGROUP dg1 UNDROP DISKS;D. You cannot cancel the pending disk drops.
RMAN offers the equivalent of the SQL command alter database backup controlfile to trace.（）A、 TrueB、 False
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*';
You just issued the following statement: ALTER TABLE SALES DROP COLUMN PROFIT. Which of the following choices identifies when the column will actually be removed from Oracle?（）A、Immediately following statement execution B、After the ALTER TABLE DROP UNUSED COLUMNS command is issued C、After the ALTER TABLE SET UNUSED COLUMN command is issued D、After the ALTER TABLE MODIFY command is issued
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*';
Examine the following commands executed in your database： SQL ALTER SESSION RECYCLEBIN=ON； Session altered SQL CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees； Table created. Further， you executed the following command to drop the table： SQL DROP TABLE emp；Table dropped. What happens in this scenario？（）A、The table is moved to the SYSAUX tablespace.B、The table is moved to the SYSTEM tablespace.C、The table is removed from the database permanently.D、The table is renamed and remains in the TBSFD tablespace.
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 CHECKB、 ALTER DISKGROUP data CHECK DISKC、 ALTER DISKGROUP data CHECK FILED、 ALTER DISKGROUP data CHECK DISK IN FAILURE GROUP 1
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 DISKGROUD、 Retrieve the disk from the Recycle Bin after the operation completes.
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 checkedE、It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.
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 groupB、It restores disks that are being dropped as the result of a DROP DISKGROUP operationC、It mounts disks in the disk group for which the drop-disk operation has already been completedD、It restores all the dropped disks in the disk group for which the drop-disk operation has already been completedE、It adds previously dropped disks back into the disk group
Which two commands never trigger an implicit rebalancing within the disk group？（） A、 ALTER DISKGROUP misc MOUNTB、 ALTER DISKGROUP misc DROP DISK misc2C、 ALTER DISKGROUP misc CHECK ALL NOREPAIRD、 ALTER DISKGROUP misc RESIZE ALL SIZE 1023mE、 ALTER DISKGROUP dgroupA ADD DISK ’/devices/A*’
单选题How can you reverse the effects of an ALTER DISKGROUP ... DROP DISK command if it has alreadycompleted?（）AIssue the ALTER DISKGROUP ... ADD DISK command.BIssue the ALTER DISKGROUP ... UNDROP DISKS command.CIssue the ALTER DISKGROUP ... DROP DISK CANCEL command.DRetrieve the disk from the Recycle Bin after the operation completes
单选题View the Exhibit and examine the parameters. User A executes the following command to update the TRANS table： SQL UPDATE B.trans SET tr_amt=tr_amt+500 WHERE c_code=’C005’； Before user A issues a COMMIT or ROLLBACK command， user B executes the following command onthe TRANS table： SQL ALTER TABLE trans MODIFY （tr_type VARCHAR2（3））； What would happen in this scenario（）A The ALTER TABLE command modifies the column successfully.B The DDL operation gets higher priority and transaction for user a is rolled back.C The ALTER TABLE command waits indefinitely until user a ends the transaction.D The ALTER TABLE command fails after waiting for 60 seconds due to the resource being busy.
单选题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 DISKGROUD Retrieve the disk from the Recycle Bin after the operation completes.
单选题How can you reverse the effects of an ALTER DISKGROUP ... DROP DISK command if it has not yetcompleted?（）AIssue the ALTER DISKGROUP ... ADD DISK command.BIssue the ALTER DISKGROUP ... UNDROP DISKS command.CIssue the ALTER DISKGROUP ... DROP DISK CANCEL command.DRetrieve the disk from the Recycle Bin after the operation completes.
单选题Flashback is enabled for your multitenant container database (CDB), which contains two pluggable database (PDBs). A local user was accidently dropped from one of the PDBs. You want to flash back the PDB to the time before the local user was dropped. You connect to the CDB and execute the following commands: SQL SHUTDOWN IMMEDIATE SQL STARTUP MOUNT SQL FLASHBACK DATABASE to TIME “TO_DATE (‘08/20/12’ , ‘MM/DD/YY’)”; Examine following commands: 1. ALTER PLUGGABLE DATABASE ALL OPEN; 2. ALTER DATABASE OPEN; 3. ALTER DATABASE OPEN RESETLOGS; Which command or commands should you execute next to allow updates to the flashback back schema?（）AOnly 1BOnly 2COnly 3D3 and 1E1 and 2
单选题Which of the following represents the correct way to perform an online recovery of datafile 4， which is assigned to a tablespace called USERS？（）A shutdown restore datafile 4； recover datafile 4； alter database open；B Sql alter database datafile 4 offline； restore datafile 4； recover datafile 4； alter database open；C Sql alter database datafile 4 offline； restore datafile 4； Sql alter database datafile 4 online；D Sql alter database datafile 4 offline； restore database datafile 4； recover database datafile 4；Sql alter database datafile 4 online；E Sql alter database datafile 4 offline； restore datafile 4； recover datafile 4； Sql alter database datafile 4 online；
单选题Examine the following ALTER command: SQL ALTER DISKGROUP dgroup1 UNDROP DISKS; What is the purpose of the command?（）AIt cancels all pending disk drops within the disk groupBIt restores disks that are being dropped as the result of a DROP DISKGROUP operationCIt mounts disks in the disk group for which the drop-disk operation has already been completedDIt restores all the dropped disks in the disk group for which the drop-disk operation has already been completedEIt adds previously dropped disks back into the disk group
单选题You are managing an ASM instance. You previously issued the following statements: ALTER DISKGROUP dg1 DROP DISK disk2; ALTER DISKGROUP dg1 DROP DISK disk3; ALTER DISKGROUP dg1 DROP DISK disk5; You want to cancel the disk drops that are pending for the DG1 disk group. Which statement should you issue?（）AALTER DISKGROUP dg1 UNDROP disk2, disk3, disk5;BALTER DISKGROUP dg1 UNDROP;CALTER DISKGROUP dg1 UNDROP DISKS;DYou cannot cancel the pending disk drops.
单选题You are managing an ASM instance. You previously issued the following statements： ALTER DISKGROUP dg1 DROP DISK disk2； ALTER DISKGROUP dg1 DROP DISK disk3； ALTER DISKGROUP dg1 DROP DISK disk5； You want to cancel the disk drops that are pending for the DG1 disk group. Which statement should you issue？（）A ALTER DISKGROUP dg1 UNDROP disk2，disk3，disk5B ALTER DISKGROUP dg1 UNDROPC ALTER DISKGROUP dg1 UNDROP DISKSD You cannot cancel the pending disk drops
单选题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 CHECKB ALTER DISKGROUP data CHECK DISKC ALTER DISKGROUP data CHECK FILED ALTER DISKGROUP data CHECK DISK IN FAILURE GROUP 1
单选题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 offlineD when some disks in a failure group for a disk group are rebalancing
单选题Examine the following command: ALTER DISKGROUP data MOUNT FORCE; In which scenario can you use the above command to mount the disk group? （）Awhen ASM disk goes offlineBwhen one or more ASM files are droppedCwhen some disks in a disk group are offlineDwhen some disks in a failure group for a disk group are rebalancing
单选题How can you reverse the effects of an ALTER DISKGROUP ... DROP DISK command if it has not yet completed？（）A Issue the ALTER DISKGROUP ... ADD DISK command.B Issue the ALTER DISKGROUP ... UNDROP DISKS command.C Issue the ALTER DISKGROUP ... DROP DISK CANCEL command.D Retrieve the disk from the Recycle Bin after the operation completes.
单选题User A executes the following command to update the TRANS table） SQL UPDATE B.trans SET tr_amt=tr_amt+500 WHERE c_code=’C005’； Before user A issues a COMMIT or ROLLBACK command， user B executes the following command on the TRANS table： SQl ALTER TABLE trans MODIFY （tr_type VARCHAR2 （3））； What would happen in this scenario？（）AThe transaction for user A is rolled back.BThe ALTER TABLE command modifies the column successfully.CThe ALTER TABLE command fails due to the resource being busy.DThe ALTER TABLE command waits until user A ends the transaction.
单选题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 operationC It mounts disks in the disk group for which the drop-disk operation has already been co pletedD It restores all the dropped disks in the disk group for which the drop-disk operation has already been completedE It adds previously dropped disks back into the disk group
单选题If you issue the command shutdown abort prior to trying to put the database in ARCHIVELOG mode， what will be the result when you issue the command alter database archivelog？（）A The alter database archivelog command will failB The alter database archivelog inconsistent command must be used to put the database in ARCHIVELOG modeC The alter database archivelog command will succeedD The alter database archivelog command will ask if you want to make the database consistent firstE There is no alter database archivelog command. The correct command is alter database alterlogging