单选题You have been asked to create three users， PUB1， PUB2 and PUB3， for three newly hired employees and to allocate unlimited quota on their default tablespace PUBLISHER_TBS with no other privileges. After creating the users， which method can you use for g

第1题：

You have three temporary tablespace groups named G1, G2, and G3 in your database. You are creating a new temporary tablespace as follows: CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE '/u1/data/temp1.dbf' SIZE 10M TABLESPACE GROUP ''; Which statement regarding the above command is correct?（）

• A、It will create the tablespace TEMP1 in group G1.
• B、It will create the tablespace TEMP1 in group G3.
• C、It will not add the tablespace TEMP1 to any group.
• D、It will create the tablespace TEMP1 in the default group.

第2题：

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；

第3题：

While creating a database using Database Configuration Assistant tool， you created a database default temporary tablespace. Which activity would cause the default temporary tablespace of the database to be used？（）

• A、the CREATE TABLE .. command
• B、sorting of the SYSTEM tablespace’s data
• C、sorting of data required by recursive SQL statements
• D、the CREATE TABLE .. ORGANIZATION EXTERNAL .. command
• E、sorting of data if the users have not been allocated temporary tablespace explicitly
• F、sorting of data if the users have been allocated temporary tablespace explicitly

第4题：

While setting up the database for your production environment， you want to create a user with following requirements.   1.The objects created by the user must be stored in a tablespace， TBS1， if the  TABLESPACE option is not defined during the object creation.   2.The user should be able to use 10MB of space in the tablespace TBS1.   3.The user must change the password immediately after logging in for the first time.   Which three options of the CREATE USER command would you use to achieve this objective？（）

• A、profile
• B、account lock
• C、account unlock
• D、password expire
• E、quota 10MB on TBS1
• F、password never expire
• G、default tablespace TBS1
• H、quota unlimited on TBS1
• I、temporary tablespace TEMP
• J、temporary tablespace SYSTEM

第5题：

View the Exhibit.You executed the following command to perform a backup of the USERS tablespace： RMAN> BACKUP TABLESPACE USERS；  Which three types of files are backed up？ （）

• A、 all the data files belonging to the USERS tablespace
• B、 password file
• C、 online redo log files
• D、 the current control file
• E、 archived redo log files
• F、 the current server parameter file
• G、 data files belonging to the USERS tablespace and all the default tablespaces

第6题：

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

The EMPLOYEES table is stored in the USERS tablespace. You need to check if the EMPLOYEES table is affected by the block corruption found in the USERS tablespace. Which option would you use？（）

• A、 the RMAN LIST command
• B、 the DBNEWID utility
• C、 the RMAN REPORT command
• D、 the RMAN BLOCKRECOVER command
• E、 the RMAN CROSSCHECK command
• F、 the ANALYZE command

第14题：

Which option is best practice for creating a recovery catalog owner in the catalog database？（）  

• A、 Granting UNLIMITED QUOTA on the SYSTEM tablespace to the owner
• B、 Allocating the SYSTEM tablespace as the default tablespace and granting the SYSDBA privilege to the user
• C、 Creating a new tablespace，allocating this as the default， and granting UNLIMITED QUOTA on this tablespace to the user
• D、 Allocating the SYSAUX tablespace as the default tablespace and granting UNLIMITED QUOTA on this tablespace to the user

第15题：

You have been asked to create three users， PUB1， PUB2 and PUB3， for three newly hired employees and to allocate unlimited quota on their default tablespace PUBLISHER_TBS with no other privileges. After creating the users， which method can you use for granting the required privileges？（）

• A、grant CONNECT role to all of the three users
• B、grant RESOURCE role to all of the three users
• C、grant both CONNECT and RESOURCE role to all of the three users
• D、execute ALTER USER .. QUOTA UNLIMITED ON publisher_tbs command for all of the three users
• E、create role with UNLIMITED TABLESPACE system privilege and assign the role to all of the three users

第16题：

You have three temporary tablespace groups named G1， G2， and G3 in your database. You are creating a new temporary tablespace as follows：   CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE ’/u1/data/temp1.dbf’ SIZE 10M TABLESPACE GROUP ；   Which statement regarding the above command is correct？（）  

• A、 It will create the tablespace TEMP1 in group G1.
• B、 It will create the tablespace TEMP1 in group G3.
• C、 It will not add the tablespace TEMP1 to any group.
• D、 It will create the tablespace TEMP1 in the default group.

第17题：

You upgraded a computer to Windows 2000 Professional and kept the FAT32 file system. You want each of three employees who use this computer to have their own documents area that no one else can access. You create a shared folder for each of the three users. You give only the owner permission to use the folder. Later in the week you are informed that User1's folder was modified while User1 was on vacation. What is wrong with your security configuration? （）

• A、Local computer policy must restrict the rights of the three users.
• B、You gave each share the same name under the users’ Documents and Settings folders.
• C、Shared folder security only works when accessing the folder over the network.
• D、Domain authentication should be required at log on.

第18题：

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：