The client RDBMS instance can access the file as a read-only file.
A new disk cannot be added to a disk group.
A disk in a disk group can be taken offline.
The client RDBMS instance cannot access the files in the disk group.
第1题:
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()
第2题:
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?()
第3题:
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?()
第4题:
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?()
第5题:
Use 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.
Use the MKDG command to restore the disk group with the same configuration as the backed-up disk group and data on the disk group.
Use 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.
Use 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.
Use the MD_RESTORE command to restore both the metadata and data for the failed disk group.
Use 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.
第6题:
The tablespace, DATA1, is not read-only.
The tablespace, DATA1, is not autoextensible.
The tablespace, DATA1, is not offline.
The segment space management for the tablespace, DATA1, is manual.
第7题:
The backup will terminate because the FORMAT clause was not configured for the channel
It backs up two copies of data files to tape and disk, and two copies of archived log file on tape
It backs up the data files and archived log files to disk, making two copies of each data file and archived log file
It backs up the data files and archived log files to tape, making two copies of each data file and archived log file
第8题:
It creates the table and encrypts the data in it.
It generates an error because the wallet is closed.
It creates the table but does not encrypt the data in it.
It generates an error because the NO SALT option cannot be used with the ENCRYPT option.
第9题:
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
第10题:
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.
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.
The disk group will be automatically rebalanced during the drop operation. Once the rebalancing is complete,the disk will be dropped.
This command will fail because you cannot drop a specific disk in an ASM disk group.
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.
第11题:
All control files are opened
All redo files are opened
The password file is opened
The parameter file is opened
All online data files are opened
第12题:
The command drops the file +tdgroupA·231.45678.
The command physically relocates the file to +tdgroupA/data and renames the file to datafile.dbf.
The command creates a copy of the +tdgroupA·231.45678 file and places it in +tdgroupA/data after renaming the file to datafile.dbf.
The command creates an alias, datafile.dbf, and places it in +tdgroupA/data and does not remove the +tdgroupA·231.45678 file.
The command creates a file, datafile.dbf, in +tdgroupA/data and removes the references for +tdgroupA·231.45678 from the data dictionary views.
第13题:
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?()
第14题:
You issued the following command to drop the PRODUCTS table: SQL> DROP TABLE products; What is the implication of this command?()
第15题:
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?()
第16题:
The command succeeds but it retrieves only the disk names.
The command produces an error because the ASM instance is down.
The command succeeds but it shows only the status of the ASM instance.
The command succeeds and retrieves information by scanning the disk headers based on an ASM_DISKSTRING value.
第17题:
It produces an error because data already exists in the table.
It produces an error because compression can be enabled at table creation only.
It compresses all data added or modified henceforth but the existing data in the table is not compressed immediately.
It immediately compresses all existing data as well as new data, resulting from either fresh additions or modifications to existing data.
第18题:
RESTORE DATAFILE ’/DISK2/user_data01.dbf’
RESTORE DATAFILE ’/DISK3/user_data01.dbf’
SET NEWNAME FOR ’/DISK3/user_data01.dbf’ TO’/DISK2/user_data01.dbf’
SET NEWNAME FOR ’/DISK2/user_data01.dbf’ TO’/DISK3/user_data01.dbf’
第19题:
All data along with the table structure is deleted
The pending transaction in the session is committed
All indexes on the table will remain but they are invalidated
All views and synonyms will remain but they are invalidated
All data in the table are deleted but the table structure will remain
第20题:
The backup will terminate because the FORMAT clause was not configured for the channel
It backs up two copies of data files to tape and disk, and two copies of archived log file on tape
It backs up the data files and archived log files to disk, making two copies of each data file and archived log file
It backs up the data files and archived log files to tape, making two copies of each data file and archived log file
第21题:
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
第22题:
The command must be issued in MOUNT state.
The command succeeds only if the data file is offline.
The command must be issued when the database is in the archivelog mode.
The command succeeds if no extent in the tablespace is currently allocated above the 150 MB boundary of the file.
第23题:
The command succeeds but it retrieves only the disk names.
The command produces an error because the ASM instance is down.
The command succeeds but it shows only the status of the ASM instance.
The command succeeds and retrieves information by scanning the disk headers based on an ASM_DISKSTRING value.