单选题You issued the following command to mount the DATA disk group in restricted mode： ALTER DISKGROUP data MOUNT RESTRICT； What is the implication of this command？（）A The client RDBMS instance can access the file as a read-only file.B A new disk cannot be added to a disk group.C A disk in a disk group can be taken offline.D The client RDBMS instance cannot access the files in the disk group.
单选题
You issued the following command to mount the DATA disk group in restricted mode： ALTER DISKGROUP data MOUNT RESTRICT； What is the implication of this command？（）
A
The client RDBMS instance can access the file as a read-only file.
B
A new disk cannot be added to a disk group.
C
A disk in a disk group can be taken offline.
D
The client RDBMS instance cannot access the files in the disk group.
参考解析
解析：
暂无解析
相关考题：
You issued the following commands to configure setting in RMAN;Then you issued the following command to take the backup:RMAN BACKUP DATABASE PLUS ARCHIVELOG;Which statement is true about the execution of the above command?（）A. The backup will terminate because the FORMAT clause was not configured for the channelB. It backs up two copies of data files to tape and disk, and two copies of archived log file on tapeC. It backs up the data files and archived log files to disk, making two copies of each data file and archived log fileD. It backs up the data files and archived log files to tape, making two copies of each data file and archived log file
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 Oracle Database 11g instance with ASM storage. The ASM instance is down. To know the details of the disks in the DATA disk group , you issued the following ASMCMD command:ASMCMD lsdsk -I -d DATAWhich statement is true regarding the outcome of this command?（）A. The command succeeds but it retrieves only the disk names.B. The command produces an error because the ASM instance is down.C. The command succeeds but it shows only the status of the ASM instance.D. The command succeeds and retrieves information by scanning the disk headers based on an ASM_DISKSTRING value.
You opened the encryption wallet and then issued the following command:Then you closed the wallet. Later, you issued the following command to create the EMPLOYEES table in the SECURESPACE tablespace and you use the NO SALT option for the EMPID column.What is the outcome?（）A. It creates the table and encrypts the data in it.B. It generates an error because the wallet is closed.C. It creates the table but does not encrypt the data in it.D. It generates an error because the NO SALT option cannot be used with the ENCRYPT option.
You execute a command to resize a data file， sales.dbf， of size 200 MB in your database： ALTER DATABASE DATAFILE ’/remorse/sales.dbf’ RESIZE 150M； Which statement is true about this command（）A、The command must be issued in MOUNT state.B、The command succeeds only if the data file is offline.C、The command must be issued when the database is in the archivelog mode.D、The command succeeds if no extent in the tablespace is currently allocated above the 150 MB boundary of the file.
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
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.
You issued the following command to drop the PRODUCTS table: SQL DROP TABLE products; What is the implication of this command?（）A、All data along with the table structure is deleted B、The pending transaction in the session is committed C、All indexes on the table will remain but they are invalidated D、All views and synonyms will remain but they are invalidated E、All data in the table are deleted but the table structure will remain
Sales details are being stored on a daily basis in the SALES_2007 table. A large amount of data is added to the table daily. To save disk space, you issued the following command: ALTER TABLE sales_2007 COMPRESS FOR ALL OPERATIONS; What would be the outcome of this command?（）A、It produces an error because data already exists in the table.B、It produces an error because compression can be enabled at table creation only.C、It compresses all data added or modified henceforth but the existing data in the table is not compressed immediately.D、It immediately compresses all existing data as well as new data, resulting from either fresh additions or modifications to existing data.
You are managing an Oracle Database 11g instance with ASM storage. The ASM instance is down. To know the details of the disks in the DATA disk group , you issued the following ASMCMD command: ASMCMD lsdsk -I -d DATA Which statement is true regarding the outcome of this command?（）A、The command succeeds but it retrieves only the disk names.B、The command produces an error because the ASM instance is down.C、The command succeeds but it shows only the status of the ASM instance.D、The command succeeds and retrieves information by scanning the disk headers based on an ASM_DISKSTRING value.
You issued the following command to mount the DATA disk group in restricted mode： ALTER DISKGROUP data MOUNT RESTRICT； What is the implication of this command？（）A、 The client RDBMS instance can access the file as a read-only file.B、 A new disk cannot be added to a disk group.C、 A disk in a disk group can be taken offline.D、 The client RDBMS instance cannot access the files in the disk group.
单选题You are managing an Oracle Database 11g instance with ASM storage. The ASM instance is down. To know the details of the disks in the DATA disk group ，you issued the following ASMCMD command： ASMCMD lsdsk -I -d DATA Which statement is true regarding the outcome of this command？（）A The command succeeds but it retrieves only the disk names.B The command produces an error because the ASM instance is down.C The command succeeds but it shows only the status of the ASM instance.D The command succeeds and retrieves information by scanning the disk headers based on an ASM_DISKSTRING value.
多选题You are administering a database stored in Automatic Storage Management (ASM). You use RMAN to back up the database and the MD_BACKUP command to back up the ASM metadata regularly. You lost an ASM disk group DG1 due to hardware failure. In which three ways can you re-create the lost disk group and restore the data?（）AUse the MD_RESTORE command to restore metadata for an existing disk group by passing the existing disk group name as an input parameter and use RMAN to restore the data.BUse the MKDG command to restore the disk group with the same configuration as the backed-up disk group and data on the disk group.CUse the MD_RESTORE command to restore the disk group with the changed disk group specification, failure group specification, name, and other attributes and use RMAN to restore the data.DUse the MKDG command to restore the disk group with the same configuration as the backed-up disk group name and same set of disks and failure group configuration, and use RMAN to restore the data.EUse the MD_RESTORE command to restore both the metadata and data for the failed disk group.FUse the MKDG command to add a new disk group DG1 with the same or different specifications for failure group and other attributes and use RMAN to restore the data.
单选题Sales details are being stored on a daily basis in the SALES_2007 table. A large amount of data is added to the table daily. To save disk space, you issued the following command: ALTER TABLE sales_2007 COMPRESS FOR ALL OPERATIONS; What would be the outcome of this command?（）AIt produces an error because data already exists in the table.BIt produces an error because compression can be enabled at table creation only.CIt compresses all data added or modified henceforth but the existing data in the table is not compressed immediately.DIt immediately compresses all existing data as well as new data, resulting from either fresh additions or modifications to existing data.
单选题You issued the following command： ALTER TABLE SCOTT.EMP SHRINK SPACE； The SCOTT.EMP table is stored in the DATA1 tablespace that has the following properties： DATA1 is a read/write tablespace. DATA1 is not autoextensible to an unlimited size. DATA1 is online. Segment space management for the DATA1 tablespace is manual. You issued the ALTER TABLE SCOTT.EMP SHRINK SPACE； command that generates the following error： ORA-10635： Invalid segment or tablespace type What could be the reason for the failure of the command？（）A The tablespace， DATA1， is not read-only.B The tablespace， DATA1， is not autoextensible.C The tablespace， DATA1， is not offline.D The segment space management for the tablespace， DATA1， is manual.
单选题Examine the RMAN command： SWITCH DATAFILE ’/DISK3/user_data01.dbf’； Which command do you need to issue before you issue the above command， so that RMAN finds the file in the restored location of ’DISK2/user_data01.dbf’？ （）ARESTORE DATAFILE ’/DISK2/user_data01.dbf’BRESTORE DATAFILE ’/DISK3/user_data01.dbf’CSET NEWNAME FOR ’/DISK3/user_data01.dbf’ TO’/DISK2/user_data01.dbf’DSET NEWNAME FOR ’/DISK2/user_data01.dbf’ TO’/DISK3/user_data01.dbf’
单选题You issued the following commands to configure setting in RMAN; Then you issued the following command to take the backup: RMAN BACKUP DATABASE PLUS ARCHIVELOG; Which statement is true about the execution of the above command?（）A The backup will terminate because the FORMAT clause was not configured for the channelB It backs up two copies of data files to tape and disk, and two copies of archived log file on tapeC It backs up the data files and archived log files to disk, making two copies of each data file and archived log fileD It backs up the data files and archived log files to tape, making two copies of each data file and archived log file
多选题You issued the following command to drop the PRODUCTS table: SQL DROP TABLE products; What is the implication of this command?（）AAll data along with the table structure is deletedBThe pending transaction in the session is committedCAll indexes on the table will remain but they are invalidatedDAll views and synonyms will remain but they are invalidatedEAll data in the table are deleted but the table structure will remain
单选题You opened the encryption wallet and then issued the following command： SQLCREATE TABLESPACE securespace DATAFILE ’/home/user/oradata/secure01.dbf’ SIZE 150M ENCRYPTION USING ’3DES168’ DEFAULT STORAGE（ENCRYPT）； Then you closed the wallet. Later， you issued the following command to create theEMPLOYEES table in the SECURESPACE tablespace and you use the NO SALT option for the EMPID column. What is the outcome？（）A It creates the table and encrypts the data in it.B It generates an error because the wallet is closed.C It creates the table but does not encrypt the data in it.D It generates an error because the NO SALT option cannot be used with the ENCRYPT option.
单选题You issued the following command to mount the DATA disk group in restricted mode： ALTER DISKGROUP data MOUNT RESTRICT； What is the implication of this command？（）A The client RDBMS instance can access the file as a read-only file.B A new disk cannot be added to a disk group.C A disk in a disk group can be taken offline.D The client RDBMS instance cannot access the files in the disk group.
单选题You issued the following commands to configure setting in RMAN; RMAN CONFIGURE DEVICE TYPE sbt PARALLELISM 1; RMAN CONFIGURE DEFAULT DEVICE TYPE TO sbt; RMAN CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE sbt TO 2; RMAN CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE sbt TO 2; RMAN CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2; Then you issued the following command to take the backup: RMAN BACKUP DATABASE PLUS ARCHIVELOG; Which statement is true about the execution of the above command?（）AThe backup will terminate because the FORMAT clause was not configured for the channelBIt backs up two copies of data files to tape and disk, and two copies of archived log file on tapeCIt backs up the data files and archived log files to disk, making two copies of each data file and archived log fileDIt backs up the data files and archived log files to tape, making two copies of each data file and archived log file
单选题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
单选题What is the net effect of the following command？（） alter diskgroup dgroup1 drop disk abc；A The disk ABC will be dropped from the disk group. Since you did not issue a rebalance command，the data on that disk will be lost.B The command will raise an error indicating that you need to rebalance the disk group to remove the data from that disk prior to dropping the disk.C The disk group will be automatically rebalanced during the drop operation. Once the rebalancing is complete，the disk will be dropped.D This command will fail because you cannot drop a specific disk in an ASM disk group.E The disk drop command will be suspended for a predetermined amount of time，waiting for you to also issue an alter diskgroup rebalance command. Once you have issued the rebalance command，ASM will proceed to rebalance the disk group and then drop the disk.
单选题You execute a command to resize a data file， sales.dbf， of size 200 MB in your database： ALTER DATABASE DATAFILE ’/remorse/sales.dbf’ RESIZE 150M； Which statement is true about this command（）AThe command must be issued in MOUNT state.BThe command succeeds only if the data file is offline.CThe command must be issued when the database is in the archivelog mode.DThe command succeeds if no extent in the tablespace is currently allocated above the 150 MB boundary of the file.
多选题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
单选题You are managing an Oracle Database 11g instance with ASM storage. The ASM instance is down. To know the details of the disks in the DATA disk group , you issued the following ASMCMD command: ASMCMD lsdsk -I -d DATA Which statement is true regarding the outcome of this command?（）AThe command succeeds but it retrieves only the disk names.BThe command produces an error because the ASM instance is down.CThe command succeeds but it shows only the status of the ASM instance.DThe command succeeds and retrieves information by scanning the disk headers based on an ASM_DISKSTRING value.
单选题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？（）AThe command drops the file +tdgroupA·231.45678.BThe command physically relocates the file to +tdgroupA/data and renames the file to datafile.dbf.CThe command creates a copy of the +tdgroupA·231.45678 file and places it in +tdgroupA/data after renaming the file to datafile.dbf.DThe command creates an alias， datafile.dbf， and places it in +tdgroupA/data and does not remove the +tdgroupA·231.45678 file.EThe command creates a file， datafile.dbf， in +tdgroupA/data and removes the references for +tdgroupA·231.45678 from the data dictionary views.