You specified extent management as local for a tablespace. H

第1题：

You have a share on your local computer. This share contains some sensitive applications in theform of .exe files. You want to audit the users who are trying to execute these programs. What should you do？（）

• A、Turn on auditing for objects in the Local Security Policy and Select 'Process Tracking'.
• B、Turn on auditing for objects in the Local Security Policy and Select 'Object Access'.
• C、Use Windows Explorer to turn on auditing for the specific files. 
• D、Have the administrator for domains log you on as an administrator and enable auditing for a  specific file.
• E、Turn on auditing for objects in the Local Security Policy and Select 'Account Management'.
• F、Allow only one account at a time to log on to your shared folder. Check the event viewer to  see who logged on. 

第2题：

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

第3题：

第4题：

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 DBNEWID utility
• B、the ANALYZE command
• C、the RMAN LIST command
• D、the RMAN REPORT command
• E、the RMAN CROSSCHECK command
• F、the RMAN BLOCKRECOVER command

第5题：

You specified segment space management as automatic for a tablespace. What effect would this have on space management？（）

• A、Extents would be managed by the freelists.
• B、The segment would be managed by bitmaps.
• C、The segment would be managed by the freelists.
• D、Free space would be managed by the data dictionary.

第6题：

An administrator is looking for the "Open Restricted Shell Terminal" option on the HMC GUI. Under which panel is this option available？（） 

• A、HMC Management， but only from a local connection
• B、Service Management， but only from a local connection.
• C、Systems Management， but only from a local connection.
• D、Systems Management， but only from a remote connection.

第7题：

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.

第8题：

第9题：

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

• A、DEFAULT STORAGE 
• B、EXTENT MANAGEMENT 
• C、AUTOEXTEND 
• D、DATAFILE

第10题：

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.