You execute a command to resize a data file， sales.dbf， of s

第1题：

The user HR receives the following error while inserting data into the TTK table： ERROR at line 1：  ORA-01653： unable to extend table HR.TTK by 128 in tablespace SMDUpon  investigation， you find that SMD is a small file tablespace.  Which three action would allow the user to insert data（）

• A、Add a data file to the SMD tablespace.
• B、Add a data file to the temporary tablespace associated with the user HR.
• C、Resize the data file associated with the SMD tablespace to make it larger.
• D、Alter the data file associated with the SMD tablespace to grow automatically.
• E、Change the segment space management for the SMD tablespace to automatic. n segments is managed through free lists.

第2题：

You execute a command to resize a data file， sales.dbf， of size 200 MB in your database： ALTER DATABASE DATAFILE ’/remorse/sales.dbf’ RESIZE 150M；  Which statement is true about this command（）

• A、The command must be issued in MOUNT state.
• B、The command succeeds only if the data file is offline.
• C、The command must be issued when the database is in the archivelog mode.
• D、The command succeeds if no extent in the tablespace is currently allocated above the 150 MB boundary of the file.

第3题：

第4题：

Your database is running in ARCHIVELOG mode,and the database is open. You execute an RMAN backup and specify the KEEP clause.Which components are backed up when this option is specified?（）

• A、only the control file, the current SPFILE, and data files
• B、only the current SPFILE and data files if autobackup is disabled
• C、only the data files and the archived redo logs
• D、the control file, current SPFILE file, data files, and archived redo logs

第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题：

The character mode sales report is stored on the network drive as a .REX. You need to make changes to the report layout. Using the report builder how would you change this file?（）

• A、Open the file using the menu option file->open make the changes and recompile the report. 
• B、Convert the file into .REP file using the report compiler make the changes and convert the file back to a .REX file. 
• C、Execute the R30CONV command to convert the file to a .RDF file, make the changes and convert the file back to a .REX file. 
• D、Choose file -> administration->compile. Convert the file to a .REP file, make the changes and convert the file back to a .REX file. 
• E、Execute the R30CONV command to convert the file to a .REP file, make the changes and convert the file back to a .REX file.

第7题：

Consider the following scenario： You have a directory， data， under the disk group tdgroupA. You want to create an alias for one of the data files and you execute the following command： ALTER DISKGROUP tdgroupA  ADD ALIAS ’+tdgroupA/data/datafile.dbf’  FOR ’+tdgroupA.231.45678’；  Which task would be accomplished by the command？（）

• A、The command drops the file +tdgroupA·231.45678.
• B、The command physically relocates the file to +tdgroupA/data and renames the file to datafile.dbf.
• C、The command creates a copy of the +tdgroupA·231.45678 file and places it in +tdgroupA/data after renaming the file to datafile.dbf.
• D、The command creates an alias， datafile.dbf， and places it in +tdgroupA/data and does not remove the +tdgroupA·231.45678 file.
• E、The command creates a file， datafile.dbf， in +tdgroupA/data and removes the references for +tdgroupA·231.45678 from the data dictionary views.

第8题：

第9题：

our database is in the MOUNT state and you execute the following command to open it：  ALTER DATABASE OPEN  What two actions are performed as a result of this command？（）

• A、All control files are opened.
• B、All redo log files are opened
• C、The password file is opened.
• D、The parameter file is opened.
• E、All online data files are opened.

第10题：

The user HR receives the following error while inserting data into the TTK table：ERROR at line 1： ORA-01653： unable to extend table HR.TTK by 128 in tablespace SMD Upon investigation， you find that SMDis a small file tablespace. Which three action would allow the user to insert data（）

• A、Add a data file to the SMD tablespace.
• B、Add a data file to the temporary tablespace associated with the user HR.
• C、Resize the data file associated with the SMD tablespace to make it larger.
• D、Alter the data file associated with the SMD tablespace to grow automatically.
• E、Change the segment space management for the SMD tablespace to automatic