DEFAULT STORAGE
EXTENT MANAGEMENT
AUTOEXTEND
DATAFILE
第1题:
Which two statements are true regarding undo tablespaces()
第2题:
You have a database with the following tablespaces: SYSTEM, SYSAUX, UNDO, USERS, TEMP. You want to"roll back" the data in the USERS tablespace to the way it looked yesterday. Which tablespaces do you need to perform a point-in-time restore operation on in order to complete this task?()
第3题:
You are the Database Administrator for WonderWeb, which has recently acquired a media company TXGlobal. You have been assigned the task to migrate all the database applications of TXGlobal to the database server of WonderWeb. To accommodate more database applications, you need to add disks to the existing disk group. Whenever you add or remove disks from the disk group, Automatic Storage Management (ASM) rebalancing distributes the data evenly across all the disks of the disk group. Which background process performs this actual rebalancing activity, resulting in the movement of data extents in the disk groups?()
第4题:
In order to enable remote administration of users and tablespaces on an Oracle database, which of the following types of files must exist in the database?()
第5题:
You are designing the physical database layout on your host machine. What is the relationship between tablespaces and datafiles in the Oracle database?()
第6题:
The ORDERS table in the database of a company contains one million records. The table is stored in the DATA tablespace and the index created on the ORDERS table is stored in the index tablespace named INDEXES. On Monday, you failed to start the database because the datafiles of the INDEXES tablespace were missing. You dropped and recreated the INDEXES tablespace by issuing the following command: SQL>DROP TABLESPACE INDEXES INCLUDING CONTENTS; SQL> CREATE TABLESPACE INDEXES DATAFILE ’C:///ORACLE/ORADATA/ORA101t/INDEX01.DBF’ SIZE 50m; After that, you issued the following command to recreate the index: CREATE UNIQUE INDEX sales_index_pk ON sales (order_id) PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE indexes STORAGE ( INITIAL 1m NEXT 1m PCTINCREASE 0 MINEXTENTS 1 MAXEXTENTS 8192 ) NOLOGGING PARALLEL( degree 4) Which two clauses are responsible for reducing the time for the recreation of the index?()
第7题:
Drop the affected tablespace, re-create the tablespace, restore the datafiles, and the tablespace.
Take the affected datafile offline (if not already offline), restore the damaged image of the datafile, and then bring it online.
Restart the database in MOUNT mode, restore the damaged datafile, recover the datafile and then open the database with resetlogs.
Put the database in RESTRICTED mode, restore all the datafiles in the affected datafile and recover the tablespace, and then put the database in normal operational mode.
第8题:
One tablespace has only one datafile
Many tablespaces can share one datafile
One tablespace can have many datafiles
One datafile can contain many tablespaces
第9题:
The database can have more than one undo tablespace.
The UNDO_TABLESPACE parameter is valid in both automatic andmanualundo management.
Undo segments automatically grow and shrink as needed, acting as circular storage buffer for their assigned transactions.
An undotablespaceis automatically created if the UNDO_TABLESPACEparameter is not set and the UNDO_MANAGEMENT parameter is set to AUTO during the database instance start up.
第10题:
Drop the affected tablespace,re-create the tablespace,restore the datafiles,and the tablespace.
Take the affected datafile offline(if not already offline),restore the damaged image of the datafile,and then bring it online.
Restart the database in MOUNT mode,restore the damaged datafile,recover the datafile and then open the database with resetlogs.
Put the database in RESTRICTED mode,restore all the datafiles in the affected datafile and recover the tablespace,and then put the database in normal operational mode.
第11题:
the datafiles associated with the SYSTEM tablespace
the datafiles associated to the DATA1 tablespace
the datafiles associated to the SYSTEM and DATA1 tablespaces
all the datafiles in the database
第12题:
Archive log generation is suspended until the tablespaces are taken out of hot backup mode.
Datafiles are not written to during hot backups.
Changes to the database are cached during the backup and not written to the datafiles to ensure that the datafiles are consistent when recovered.
The datafile headers are not updated during the backup.
The way data is written to the online redo logs is unchanged during the backup.
第13题:
You are creating a locally managed tablespace to meet the following requirements: All the extents should be of the same size. The data should be spread across two data files. A bitmap should be used to record the free space within the allocated extents. Which three options would you choose?()
第14题:
You are creating tablespaces in Oracle. Which of the following keywords or clauses permits the datafiles of a database to grow automatically in order to accommodate data growth?()
第15题:
You executed the following command to create a tablespace called SALES_DATA: SQL> CREATE TABLESPACE sales_data DATAFILE SIZE 100M SEGMENT SPACE MANAGEMENT AUTO; Which two statements are true about the SALES_DATA tablespace()
第16题:
Your database is in ARCHIVELOG mode. On Friday evening, you perform an online database backup by using the BACKUP DATABASE command at the Recovery Manager (RMAN) prompt and close the database. On Monday, the System Administrator informs you about the failure of two hard disks. One of the lost disks contains two datafiles, HR1.DBF and HR2.DBF, both of which belong to a read/write tablespace named HR. The disk also contains a datafile, USERS.DBF, which belongs to a read/write tablespace named USERS. You need to restore and recover the database backup that was performed on Friday evening. After mounting the database, you issue the following RMAN commands: RMAN>RESTORE DATABASE; RMAN>RECOVER DATABASE; After successfully executing these RMAN commands, you issue the following statement using SQL*Plus: SQL>ALTER DATABASE OPEN; You receive the following errors when attempting to open the database: ORA-01157: cannot identify/lock data file 10 see DBWR trace file ORA-01110: data file 10: ’D:///USERS.DBF’ What is the cause of these errors?()
第17题:
Which of the following statements is true when the database is in ARCHIVELOG mode and tablespaces are in hot backup mode?()
第18题:
set PCTFREE and PCTUSED to 50
specify extent allocation as Uniform
specify extent allocation as Automatic
create the tablespace as bigfile tablespace
create the tablespace as smallfile tablespace
set segment space management to Automatic
use the RESIZE clause while creating the tablespace
第19题:
All datafiles of a database
All datafiles, archive logs, and control files
All datafiles and control files
All the used blocks in a datafile
第20题:
DEFAULT STORAGE
EXTENT MANAGEMENT
AUTOEXTEND
DATAFILE
第21题:
The USERS.DBF datafile is corrupted and cannot be restored by RMAN.
The USERS.DBF datafile was not backed up using the RMAN BACKUP DATABASE command.
The USERS.DBF datafile was not restored using the RMAN RESTORE DATABASE command.
The USERS.DBF datafile was not recovered using the RMAN RECOVER DATABASE command.
第22题:
The database automatically determines the extent-sizing policy for the tablespace.
The segments are automatically shrunk when the contents are removed from them.
The allocation of extents within the tablespace is managed through the dictionary tables.
The space utilization description of the data blocks in segments is recorded inbitmapblocks.
The space utilization description of the data blocks in segments is managed through free lists.MANUAL
第23题:
use automatic extent allocation
disable threshold for the tablespace
use freelists to manage the free space
use automatic segment space management
create the tablespace as a bigfile tablespace
use the RESIZE clause while creating the tablespace
enable AUTOEXTEND for at least one of the data files in the tablespace
第24题:
ASMB
ARBn
RBAL in the ASM instance
RBAL in the database instance