单选题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（）AThe command must be issued in MOUNT state.BThe command succeeds only if the data file is offline.CThe command must be issued when the database is in the archivelog mode.DThe command succeeds if no extent in the tablespace is currently allocated above the 150 MB boundary of the file.
单选题
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.
参考解析
解析：
暂无解析
相关考题：
You issued the following commands to configure setting in RMAN;Then you issued the following command to take the backup:RMAN BACKUP DATABASE PLUS ARCHIVELOG;Which statement is true about the execution of the above command?（）A. The backup will terminate because the FORMAT clause was not configured for the channelB. It backs up two copies of data files to tape and disk, and two copies of archived log file on tapeC. It backs up the data files and archived log files to disk, making two copies of each data file and archived log fileD. It backs up the data files and archived log files to tape, making two copies of each data file and archived log file
Youexecuteacommandtoresizeadatafile,sales.dbf,ofsize200MBinyourdatabase:ALTERDATABASEDATAFILE’／remorse／sales.dbf’RESIZE150M;Whichstatementistrueaboutthiscommand() A.ThecommandmustbeissuedinMOUNTstate.B.Thecommandsucceedsonlyifthedatafileisoffline.C.Thecommandmustbeissuedwhenthedatabaseisinthearchivelogmode.D.Thecommandsucceedsifnoextentinthetablespaceiscurrentlyallocatedabovethe150MBboundaryofthefile.
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.
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.
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.
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.
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 containerB、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$SEEDD、Data files that belong to the root container and all the PDBs excluding PDB$SEED
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 openedC、The password file is opened.D、The parameter file is opened.E、All online data files are opened.
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 filesB、only the current SPFILE and data files if autobackup is disabledC、only the data files and the archived redo logsD、the control file, current SPFILE file, data files, and archived redo logs
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
You received the following error： ORA-01578： ORACLE data block corrupted （file # %s， block # %s） Which file will you check to view additional information regarding the cause of this error？（）A、the alert log file and the trace filesB、 the redo log filesC、 the control fileD、 the change tracking file
You have lost all your database control files. To recover them， you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact. Which of the following is true regarding your recovery？（） A、 You will need to open the database with the resetlogs command.B、 All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.C、 You will use the resetlogs version of the create controlfile command.D、 You will use the noresetlogs version of the create controlfile command.E、 You will use the trace file to create a backup control file， and then you will recover the database with the recover database using backup controlfile command
You execute the following command to change the status of the SALES tablespace：SQL ALTER TABLESPACE sales OFFLINE； Which statements describe the effect of the command（）A、The tablespace would require recovery to go back online.B、A checkpoint is taken on all data files that are associated with the SALES tablespace.C、The sessions that subsequently try to access the objects in the SALES tablespace receive an errorD、The new status of the SALES tablespace is recorded in the control file when the database instance isclosed
多选题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？（）AAll control files are opened.BAll redo log files are openedCThe password file is opened.DThe parameter file is opened.EAll online data files are opened.
单选题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?（）Aonly the control file, the current SPFILE, and data filesBonly the current SPFILE and data files if autobackup is disabledConly the data files and the archived redo logsDthe control file, current SPFILE file, data files, and archived redo logs
单选题In Recovery Manager （RMAN）， you are taking image copies of the data files of your production database and rolling them forward at regular intervals. You attempt to restart your database. After a regular maintenance task， you realize that one of the data files that belongs to the USERS tablespace is damaged and you need to recover the data file by using the image copy. Because a media failure caused the data file to be damaged， you want to place the data file in a different location while resto ing the file. Which option must you consider for this task？（）A using only the RMAN SWITCH command to set the new location for the data fileB placing the database in the MOUNT state for the restore and recovery operationsC using an RMAN RUN block with the SET NEWNAME and then the SWITCH commandD configuring two channels： one for the restore operation and the other for the recovery operation
单选题You are administering a database stored in Automatic Storage management (ASM). The files are storedin the DATA disk group. You execute the following command:SQL ALTER DISKGROUP data ADD ALIAS ‘+data/prod/myfile.dbf’ FOR ‘+data.231.45678’;What is the result?（）AThe file ‘+data.231.54769’ is physically relocated to ‘+data/prod’ and renamed as ‘myfile.dbf’.BThe file ‘+data.231.54769’ is renamed as ‘myfile.dbf’, and copied to ‘+data/prod’.CThe file ‘+data.231.54769’ remains in the same location and a synonym 'myfile.dbf' is created.DThe file ‘myfile.dbf’ is created in ‘+data/prod’ and the reference to ‘+data.231.54769’ in the data dictionary removed.
多选题After performing a clean shut down of the database instance for maintenance， you mount thedatabase and then execute a command to open the database： SQL ALTER DATABASE OPEN； Which two statements are true（）AThe online redo log files and online data files are opened.BAll the online data file headers are checked for consistency.CInstance recovery is performed before opening the database.DThe path and existence of all the log file members are checked
单选题In Recovery Manager (RMAN), you are taking image copies of the data files of your production database and rolling them forward at regular intervals. You attempt to restart your database. After a regular maintenance task, you realize that one of the data files that belongs to the USERS tablespace is damaged and you need to recover the data file by using the image copy. Because a media failure caused the data file to be damaged, you want to place the d ata file in a different location while restoring the file. Which option must you consider for this task?（）Ausing only the RMAN SWITCH command to set the new location for the data fileBplacing the database in the MOUNT state for the restore and recovery operations.Cusing an RMAN RUN block with the SET NEWNAME and then the SWITCH command.Dconfiguring two channels: one for the restore operation and the other for the recovery operation
单选题You issued the following commands to configure setting in RMAN; Then you issued the following command to take the backup: RMAN BACKUP DATABASE PLUS ARCHIVELOG; Which statement is true about the execution of the above command?（）A The backup will terminate because the FORMAT clause was not configured for the channelB It backs up two copies of data files to tape and disk, and two copies of archived log file on tapeC It backs up the data files and archived log files to disk, making two copies of each data file and archived log fileD It backs up the data files and archived log files to tape, making two copies of each data file and archived log file
单选题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 filesB only the current SPFILE and data files if autobackup is disabledC only the data files and the archived redo logsD the control file，current SPFILE file，data files，and archived redo logs
单选题You have lost all your database control files. To recover them， you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact. Which of the following is true regarding your recovery？（）A You will need to open the database with the resetlogs command.B All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.C You will use the resetlogs version of the create controlfile command.D You will use the noresetlogs version of the create controlfile command.E You will use the trace file to create a backup control file， and then you will recover the database with the recover database using backup controlfile command
单选题Consider the MySQL Enterprise Audit plugin. On attempting to start the MySQL service after a crash, notice the following error: [ERROR] Plugin ‘audit_log’ init function returned error. In the audit log file, you notice the final entry: … What action should you take to fix the error and allow the service to start?（）A Re-install the audit pluginB Execute the command FLUSH LOGSC Execute the command SET GLOBAL audit_log_fiush= OND Move or rename the existing audit.log file
多选题After performing a clean shut down of the database instance for maintenance， you mount the database andthen execute a command to open the database：SQL ALTER DATABASE OPEN； Which two statements are true（）AThe online redo log files and online data files are opened.BAll the online data file headers are checked for consistency.CInstance recovery is performed before opening the database.DThe path and existence of all the log file members are checked
单选题In Recovery Manager (RMAN), you are taking image copies of the data files of your production database and rolling them forward at regular intervals. You attempt to restart your database. After a regular maintenance task, you realize that one of the data files that belongs to the USERS tablespace is damaged and you need to recover the data file by using the image copy. Because a media failure caused the data file to be damaged, you want to place the data file in a different location while restoring the file. Which option must you consider for this task?（）Ausing only the RMAN SWITCH command to set the new location for the data fileBplacing the database in the MOUNT state for the restore and recovery operations.Cusing an RMAN RUN block with the SET NEWNAME and then the SWITCH command.Dconfiguring two channels: one for the restore operation and the other for the recovery operation
多选题You work as a database administrator for Supportcenter.cn. Your 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？（）AAll control files are openedBAll redo files are openedCThe password file is openedDThe parameter file is openedEAll online data files are opened
单选题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？（）AThe command drops the file +tdgroupA·231.45678.BThe command physically relocates the file to +tdgroupA/data and renames the file to datafile.dbf.CThe command creates a copy of the +tdgroupA·231.45678 file and places it in +tdgroupA/data after renaming the file to datafile.dbf.DThe command creates an alias， datafile.dbf， and places it in +tdgroupA/data and does not remove the +tdgroupA·231.45678 file.EThe command creates a file， datafile.dbf， in +tdgroupA/data and removes the references for +tdgroupA·231.45678 from the data dictionary views.