多选题Examine the commands executed in a DBA session：SQL> CREATE BIGFILE TABLESPACE MRKT 2 DATAFILE ’/u01/app/oracle/oradata/orcl/mrkt.dbf’ size 10M LOGGING 3 EXTENT MANAGEMENT LOCALSEGMENT SPACE MANAGEMENT AUTO； Tablespace created. SQL> ALTER DATABASE DEFAU

第1题：

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？（）

• A、set PCTFREE and PCTUSED to 50
• B、specify extent allocation as Uniform
• C、specify extent allocation as Automatic
• D、create the tablespace as bigfile tablespace
• E、create the tablespace as smallfile tablespace
• F、set segment space management to Automatic
• G、use the RESIZE clause while creating the tablespace

第2题：

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.

第3题：

You executed the following command: RMAN> RECOVER COPY OF DATAFILE '/u01/app/oracle/oradata/orcl/users01.dbf'; Which statement regarding the above command is correct?（）

• A、The '/u01/app/oracle/oradata/orcl/users01.dbf' data file is recovered from the image copy
• B、The '/u01/app/oracle/oradata/orcl/users01.dbf' data file is recovered from the last incremental backup
• C、  Image copies of the '/u01/app/oracle/oradata/orcl/users01.dbf' data file are updated with all changes up to incremental backup SCN. '/ u01/app/oracle/oradata/orcl/users01.dbf
• D、Image copies of the '/u01/app/oracle/oradata/orcl/users01.dbf' data file are recovered using the above command if data file recovery fails

第4题：

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；

第5题：

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（）

• A、The database automatically determines the extent-sizing policy for the tablespace.
• B、The segments are automatically shrunk when the contents are removed from them.
• C、The allocation of extents within the tablespace is managed through the dictionary tables.
• D、The space utilization description of the data blocks in segments is recorded in bitmap blocks.
• E、The space utilization description of the data blocks in segments is managed through free lists.

第6题：

Examine the statement：   SQL> CREATE TABLESPACE user_data  2> EXTENT MANAGEMENT LOCAL  3> SEGMENT SPACE MANAGEMENT AUTO；   Which twp assumptions must be true for this statement to execute successfully？（）

• A、Oracle Managed Files are used for this instance.
• B、The USER_DATA tablespace is managed using FET$/UET$ tables.
• C、The COMPATIBLE initialization parameter must be 9.0.0 or higher.
• D、Space within segments in the USER_DATA tablespace is managed with freelists.

第7题：

You specified extent management as local for a tablespace. How will it affect space management in the tablespace？（）

• A、All the extents will be of the same size.
• B、Bitmap will be used to record free and allocated extents.
• C、Free extents will be managed by the data dictionary tables.
• D、The tablespace will be system managed and the users cannot specify the extent size.

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

Which two statements about bigfile tablespaces are true？ （）

• A、The bigfile tablespace have only one data file.
• B、The segment space management is automatic.
• C、The extent management is dictionary managed.
• D、The database can have only one bigfile tablespace.
• E、The bigfile tablespace can be converted to a smallfile tablespace.

第14题：

You executed the following command：   RMAN> RECOVER COPY OF DATAFILE ’/u01/app/oracle/oradata/orcl/users01.dbf’；   Which statement regarding the above command is correct？（）  

• A、 The ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file is recovered from the image copy.
• B、 The ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file is recovered from the last incremental backup.
• C、 Image copies of the ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file are updated with all changes up to incremental backup SCN.
• D、 Image copies of the ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file are recovered using the above command if data file recovery fails.

第15题：

You are creating a recovery catalog for use with RMAN. You have issued these commands： SQL> CREATE TABLESPACE rman_ts DATAFILE  ’/DISK1/rman_ts01.dbf’ 2> SIZE 20M 3> DEFAULT STORAGE （initial 100K next 100K pctincrease 0）； SQL> CREATE USER rman_db01 IDENTIFIED BY rman_db01 2> DEFAULT TABLESPACE rman_ts 3> QUOTA unlimited ON rman_ts；  Which command should you issue next？（）

• A、RESYNC CATALOG；
• B、REGISTER DATABASE；
• C、CREATE CATALOG TABLESPACE rman_ts；
• D、GRANT recovery_catalog_owner TO rman_db01；

第16题：

You execute the following set of commands to create a database user and to grant the system privileges in your production environment.  SQL> CREATE USER user01  IDENTIFIED BY oracle DEFAULT TABLESPACE tbs1  TEMPORARY TABLESPACE temp PROFILE default  /  SQL> GRANT create session， create table TO user01； While executing the command to create a table， the user gets the following error message and the CREATE TABLE.. command fails.  ERROR at line 1： ORA-01950： no privileges on tablespace  What could be the possible reason for this error message？（）

• A、The tablespace TBS1 is full.
• B、The user is not the owner of the SYSTEM tablespace.
• C、The user does not have quota on the TBS1 tablespace.
• D、The user does not have sufficient system privileges to create table in the TBS1 tablespace.
• E、The user does not have sufficient privileges to create table on the default permanent tablespace.

第17题：

Examine the commands executed in a DBA session：SQL> CREATE BIGFILE TABLESPACE MRKT 2 DATAFILE ’/u01/app/oracle/oradata/orcl/mrkt.dbf’ size 10M LOGGING 3 EXTENT MANAGEMENT LOCALSEGMENT SPACE MANAGEMENT AUTO； Tablespace created. SQL> ALTER DATABASE DEFAULT TABLESPACE MRKT； Database altered.  Which two statements are trueregarding the MRKT tablespace（）

• A、No more data files can be added to the tablespace.
• B、Segment space is managed by free lists in the tablespace.
• C、A user created without being assigned a default tablespace uses this tablespace.
• D、The tablespace can be dropped with the current setting with segments present in it

第18题：

You executed the following command to create a tablespace called SALES_DATA：  > CREATE TABLESPACE sales_data DATAFILE SIZE 100M SEGMENT SPACE MANAGEMENT AUTO；  Which two statements are true about the SALES_DATA tablespace （）

• A、The database automatically determines the extent-sizing policy for the tablespace.
• B、The segments are automatically shrunk when the contents are removed from them.
• C、The allocation of extents within the tablespace is managed through the dictionary tables.
• D、The space utilization description of the data blocks in segments is recorded inbitmapblocks.
• E、The space utilization description of the data blocks in segments is managed through free lists.MANUAL

第19题：

You issue the following command in Oracle: CREATE TABLESPACE DAT_TBS DATAFILE "dat_tbs.dbf" SIZE 2M;. Later queries against the database reveal that the tablespace is located in the /u01/oradata/oracle directory. Which of the following choices identifies how Oracle likely determined what directory to place dat_tbs.dbf file in?（）

• A、DB_CREATE_FILE_DEST 
• B、DB_CREATE_ONLINE_LOG_1 
• C、DB_CREATE_ONLINE_LOG_2
• D、The directory is an operating system-specific default value in Oracle that can neigher be specified manually nor changed

第20题：

第21题：

第22题：

第23题：

第24题：