多选题Evaluate the following command and its output: Which two statements correctly interpret the output?（）AFREE_SPACE indicates only the space that is currently unallocated.BALLOCATED_SPACE indicates only the space currently allocated and in use.CFREE_SPAC

第1题：

Which of the following conclusions is most appropriate to draw to describe why du shows fewer blocks used than df?（）

• A、 The df command only counts the number of disk blocks and superblocks. 
• B、 The df command ignores space used for inodes, gnodes, and vnodes.
• C、 The du command does not take into account filesystem metadata. 
• D、 The du command counts indirect blocks and superblocks in its calculations. 

第2题：

The df command indicates that a filesystem is full， however， the du command indicates that not all space is allocated.  How would the system administrator isolate the discrepancy（）

• A、Use the fuser command to identify deleted but open files.
• B、Use the ipcs command to view orphan shared memory segments.
• C、Use the defrag command to determine if the filesystem is fragmented.
• D、Use the topas command to identify processes using the most system resources.

第3题：

Evaluate the following command and its output：   SQL>SELECT * FROM dba_temp_free_space；  TABLESPACE_NAME TABLESPACE_SIZE ALLOCATED_SPACE FREE_SPACE  LMTEMP 250609664 101048576 149561088 Which two statements correctly interpret the output？（）

• A、 FREE_SPACE indicates only the space that is currently unallocated.
• B、 ALLOCATED_SPACE indicates only the space currently allocated and in use.
• C、 FREE_SPACE indicates only the space that is currently allocated and available for reuse.
• D、 ALLOCATED_SPACE indicates both the space currently allocated and used，and the space that is available for reuse.
• E、 FREE_SPACE indicates both the space that is currently allocated and available for reuse，and the space that is currently unallocated.

第4题：

Which statement describes the information returned by the DBMS_SPACE.SPACE_USAGE procedure for LOB space usage？（）

• A、 It returns space usage of only BasicFile LOB chunks.
• B、 It returns space usage of only SecureFile LOB chunks.
• C、 It returns both BasicFile and SecureFile LOB space usage for only nonpartitioned tables.
• D、 It returns both BasicFile and SecureFile LOB space usage for both partitioned and nonpartitioned tables.

第5题：

Your multitenant container database (CDB) is running in ARCHIVELOG mode. You connect to the CDB RMAN. Examine the following command and its output: You execute the following command: RMAN > BACKUP DATABASE PLUS ARCHIVELOG; Which data files will be backed up?（）

• A、Data files that belong to only the root container
• B、Data files that belong to the root container and all the pluggable databases (PDBs)
• C、Data files that belong to only the root container and PDB$SEED
• D、Data files that belong to the root container and all the PDBs excluding PDB$SEED

第6题：

Which of the following options describes Segment Shrink？（）  

• A、 Reclaims space above and below the high-water mark without using additional space
• B、 Moves rows to a new physical location，resetting the high-water mark，but uses additional space during the operation
• C、 Deallocates space above the high-water mark that is currently not in use
• D、 None of the above

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

Which two statements are true when using the configure exclusive CLI command?（）

• A、Multiple users can enter configuration mode and have their own private configuration.
• B、When a user commits, only the user's changes are committed.
• C、A message indicates which other users are in configuration mode and what portion of the configuration they are editing.
• D、Only a single user can edit the configuration.

第14题：

An administrator needs to apply a Technology Level update. During the preview install， the output indicates that there is insufficient space in the /usr filesystem. Review of the root volume group indicates there are no available physical partitions， but the /test jfs2 filesystem is only 8% used.  What is the most efficient method to use the available space in the /test filesystem to apply the update？（）

• A、Use chfs to reduce the /test filesystem
• B、Use cplv to copy the /test filesystem to a smaller logical volume
• C、Use migratepv l to move the /test filesystem to a different volume group
• D、Backup the /test filesystem， remove it， and recreate it with a smaller size

第15题：

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.

第16题：

Examine the following query output: You issue the following command to import tables into the hr schema: $ > impdp hr/hr directory = dumpdir dumpfile = hr_new.dmp schemas=hr TRANSFORM=DISABLE_ARCHIVE_LOGGING: Y Which statement is true?（）

• A、All database operations performed by the impdp command are logged.
• B、Only CREATE INDEX and CREATE TABLE statements generated by the import are logged.
• C、Only CREATE TABLE and ALTER TABLE statements generated by the import are logged.
• D、None of the operations against the master table used by Oracle Data Pump to coordinate its activities are logged.

第17题：

You issued the following statement：   SQL>ALTER DATABASE ENABLE RESUMABLE TIMEOUT n；   What will be the result of issuing the above statement？（）

• A、The command will not execute successfully because TIMEOUT is an invalid clause with the ALTER DATABASE ENABLE RESUMABLE command.
• B、 The command will not execute successfully because resumable space allocation is enabled at the session level.
• C、 The command will execute successfully and resumable space will be allocated at the session level.
• D、 The command will execute successfully and resumable space will be allocated at the instance level.

第18题：

An administrator needs to apply a Technology Level update. During the preview install, the output indicates that there is insufficientspace in the /usr filesystem. Review of the root volume group indicates there are no available physical partitions, but the /test jfs2 filesystem is only 8% used. What is the most efficient method to use the available space in the /test filesystem to apply theupdate?（）

• A、Use chfs to reduce the /test filesystem
• B、Use cplv to copy the /test filesystem to a smaller logical volume
• C、Use migratepv l to move the /test filesystem to a different volume group
• D、Backup the /test filesystem, remove it, and recreate it with a smaller size

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：