单选题You are maintaining the SALES database of a company. You have never backed up the USERS tablespace that is currently offline. On Sunday， you issued the following commands： CONFIGURE DEFAULT DEVICE TYPE TO sbt； CONFIGURE BACKUP OPTIMIZATION ON； CONFIGURE RETENTION POLICY TO REDUNDANCY 3； From Monday to Saturday， you performed the following actions： Day Action Monday BACKUP DATABASE Tuesday BACKUP DATABASE Wednesday BACKUP DATABASE Thursday BACKUP DATABASE Friday BACKUP DATABASE Saturday BACKUP DATABASE How many times will the backup of the USERS tablespace be performed？（）A The backup will not be performed at all.B three timesC four timesD six times

考题单选题The current time is 12：00 noon. You want to recover the USERS tablespace from a failure that occurred at 11：50 a.m. You discover that the only member of an unarchived redo log group containing information from 11：40 a.m. onwards is corrupt. With reference to this scenario， if you are not using Recovery Manager （RMAN）， which recovery method would you use？（）A timebased recoveryB log sequence recoveryC cancelbased recoveryD changebased recovery

查看答案

考题单选题You want to rebuild a free list in the free lists of the EMPLOYEE table in the Scott schema. Which package will you use to accomplish this？（）A DBMS_REPAIRB DBMS_SCHDULERC DBMS_STATSD DBMS_RESOURCE_MANAGER

查看答案

考题单选题You are creating a job class. You want access to the detailed information for all the runs of each job in the class and every operation performed on every job in the class. Which setting will you use for the LOGGING_LEVEL parameter？（）A LOGGING_OFFB LOGGING_RUNSC LOGGING_FULLD LOGGING_NULL

查看答案

考题单选题You are a Database Administrator with TXGlobal. You use a password file to establish remote connections to the HR database on the server located at the home office. Currently， two active remote sessions exist to this database. These sessions were established using the SYSDBA privilege from the remote machines. You accidentally deleted the password file. What will be the consequence of this action？（）A Both the sessions will be killed， and no new sessions will be created using the SYSDBA or SYSOPER privilege.B Both the sessions will remain active， but no new sessions will be created using the SYSDBA or SYSOPER privilege.C Both the sessions will be killed， but new sessions will be created using the SYSDBA or SYSOPER privilege when the database restarts.D The database will crash， and no new sessions will be created using the SYSDBA or SYSOPER privilege when the database restarts.

查看答案

考题多选题The ORDERS table in the database of a company contains one million records. The table is stored in the DATA tablespace and the index created on the ORDERS table is stored in the index tablespace named INDEXES. On Monday， you failed to start the database because the datafiles of the INDEXES tablespace were missing. You dropped and recreated the INDEXES tablespace by issuing the following command： SQLDROP TABLESPACE INDEXES INCLUDING CONTENTS； SQL CREATE TABLESPACE INDEXES DATAFILE ’C:///ORACLE/ORADATA/ORA101t/INDEX01.DBF’ SIZE 50m； After that， you issued the following command to recreate the index： CREATE UNIQUE INDEX sales_index_pk ON sales （order_id） PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE indexes STORAGE （ INITIAL 1m NEXT 1m PCTINCREASE 0 MINEXTENTS 1 MAXEXTENTS 8192 ） NOLOGGING PARALLEL（ degree 4） Which two clauses are responsible for reducing the time for the recreation of the index？（）APCTFREEBMAXTRANSCPCTINCREASEDINITIALENOLOGGINGFPARALLEL

查看答案

考题多选题Your database operates in ARCHIVELOG mode and all the tablespaces are online. Due to a user error， you decided to perform an incomplete recovery. Which two tasks would you be required to perform in the recovery process？（）Aopen the database with the RESETLOGS optionBopen the database with the RESTRICTED optionCrecover all the data files to the same system change number （SCN）Drecover to the required SCN only that data file in which the error occurred

查看答案

考题多选题When performing a backup using Recovery Manager （RMAN）， which four types of files can be backed up with the RMAN BACKUPcommand？（）Adata fileBpassword fileCarchivelog fileDtemporary fileEonline redo log fileFthe current control fileGthe tnsnames.ora fileHcurrent server parameter file

查看答案

考题单选题You work as a database administrator at Certkiller .com. In your production database there is a job， CALC_STAT， which has been scheduled to run every Friday at 5.00 p.m. CALC_STATupdates the optimizer statistics for the objects owned by the APPSschema. You want the task to be generic， thereby allowing users to modify the attributes of the task at run time without affecting the original task.Which component of Oracle Scheduler must you define to achieve this？（）A WindowB ProgramC Job classD Window group

查看答案

考题单选题Very soon you will be performing maintenance operations. You would have several jobs to run as soon as the maintenance period starts. Which method would you use to create jobs without specifying the time period when the job should be run？（）A use DBMS_IJOB packageB use Oracle SchedulerC use DBMS_JOB packageD use Oracle Data Pump Export and Import

查看答案

考题单选题You are using an Automatic Storage Management （ASM） instance to manage the database files of your production database. After adding a new disk group to the ASM instance， you execute the following command： ALTER DISKGROUP dg3 REBALANCE POWER 0; What would be the result of this command？（）A The rebalancing of the disk group would be stopped.B The rebalancing of the disk group would be completed as fast as possible.C The command would result in an error because the value of POWER cannot be 0.D The rebalancing of the disk group would be completed without affecting the disk group DG3. E The command would result in an error because the disk groups cannot be manually rebalanced.

查看答案

考题单选题Every Sunday， consistent backups are performed on your database. Because of a user error， you performed an incomplete recovery on Tuesday and opened the database with the RESETLOGS option. A user error occurs again on Thursday， which necessitates an incomplete recovery. Sunday’s backup is the most recent backup available.What would you do in this scenario？（）A recovery cannot be performed because a backup was not performed after the last incomplete recoveryB restore all the files from Sunday’s backup， and then recover up to the point in time when the RESETLOGS operation was performed on TuesdayC restore all the files from Sunday’s backup， and open the database to reset the database to the point in time when the backup was performed on SundayD restore all the files from Sunday’s backup， and then perform an incomplete recovery up to the point in time when the user error occurred on Thursday

查看答案

考题单选题Your database is using shared server configuration. Which optional memory structure would you configure to store the User Global Area （UGA） information and improve the shared pool performance？（）A large poolB streams poolC keep buffer cacheD recycle buffer cache

查看答案

考题单选题You are working as a DBA in an organization. The flash recovery area files are created in ’+disk1’. You want to create new flash recovery area files in the ’+disk2’ location. The new location of the flash recovery area files should be written in the control file and the spfile.Which command will you issue to change the location of the flash recovery area files？（）A ALTER SYSTEM SET DB_RECOVERY_FILE_DEST = ’+disk2’ ；B ALTER SYSTEM SET DB_RECOVER_FILE_DEST = ’+disk2’ SCOPE = BOTH；C ALTER SYSTEM SET DB_CREATE_FILE_DEST = ’+disk2’；D ALTER SYSTEM SET DB_CREATE_ONLINE_LOG_DEST_n = ’+disk2’；

查看答案

考题多选题You set the undo pool resource plan directive for the consumer group named DSS_USERS that is assigned to the DAY_SHIFT plan. The database users， SCOTT and BLAKE， belong to the DSS_USERS resource group. The user， SCOTT， initiates a database session and executes a batch operation that inserts millions of rows into the HISTORY table. Which two options are true if the total undo space allocated to the DSS_USERS group exceeds the value specified in the undo pool resource plan directive？（）AThe batch operation started by the user， SCOTT， terminates with an error.BThe batch operation started by the user， SCOTT， hangs and you are required to increase the undo pool resource plan directive.CThe batch operation started by the user， SCOTT， runs uninterrupted because the database uses the SYSTEM tablespace for the undo operation.DThe user， BLAKE， cannot start a transaction that uses any DML operations until you increase the value of the undo pool resource plan directive.EThe user BLAKE can start a transaction that uses any DML operations after the batch operation started by the user， SCOTT， terminates with an error.

查看答案

考题单选题You need to check the EMP_EAST partition in the EMPLOYEES table for physical corruptions. You also need to verify that the rows belong to the correct partition. Which option could you use？（）A LogMinerB The DBNEWID utilityC The DBVERIFY utilityD The ANALYZE commandE The RMAN REPORT commandF The RMAN CROSSCHECK command.G The RMAN BLOCKRECOVER command.

查看答案

考题单选题Users are performing a large volume of inserts and deletes on the application tables in the APPS tablespace. You observe that there are several warning alerts being generated for the APPS tablespace space usage metrics. Currently， the warning threshold for the tablespace space usage metrics is set to 70%. To make the generated alerts more useful as a problem identification tool， you want to reduce the frequency of alert generation for the tablespace space usage metrics for the APPS tablespace. What should you do？（）A disable SQL tracing for theAPPS tablespaceB disable logging attribute for the APPS tablespaceC modify the tablespace to be a dictionarymanaged tablespaceD increase the critical threshold value for the tablespace space usage metrics for the APPS tablespaceE increase the warning threshold value for the tablespace space usage metrics for the APPS tablespace

查看答案

考题单选题You issued the following statement to monitor the usage of the index： SQL ALTER INDEX SCOTT.EMP_IDX MONITORING USAGE； Which view will you query to ensure that the index is being monitored？（）A INDEX_STATSB DBA_INDEXESC DBA_IND_COLUMNSD V$OBJECT_USAGE

查看答案

考题单选题The DB_BLOCK_CHECKINGinitialization parameter is set to TRUE. What would be the result of this setting on the data blocks being written to the datafiles， every time the DBWn writes？（）A The Oracle database will check all data blocks by going through the data on each block， making sure the data is self-consistent.B The DBWn and the direct loader will calculate a checksum and store it in the cache header of every data block when writing it to disk.C The Oracle database will check data blocks belonging to the SYSTEM tablespace only， by going through the data on each block， making sure the data is self-consistent.D The Oracle database will check data blocks belonging to the SYSAUX tablespace only， by going through the data on each block， making sure the data is self-consistent.E The Oracle database will check data blocks in the SYSTEM and SYSAUX tablespaces only， by going through the data on each block， making sure the data is self-consistent.

查看答案

考题多选题You are using Oracle Database 10g. You performed an incomplete recovery of your database and opened the database with the RESETLOGS option. What is the effect of opening the database with the RESETLOGS option？（）AThis operation resets the SCN for the database.BThis operation creates a new incarnation of the database.CThis operation moves all the redo log files to a different location.DThis operation deletes the old redo log files and creates new redo log files.EThis operation updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp.

查看答案

考题单选题On Tuesday， a junior DBA dropped an important application user account， whose schema has important tables. You are asked to recover all the objects in the schema. On investigation， you find that the user account was dropped at 11：00 a.m. and Sunday’s backup is the most recent backup.Which flashback feature would you use？（）A Flashback DropB Flashback TableC Flashback DatabaseD Flashback Version QueryE Flashback Transaction Query

查看答案

考题单选题From the V$SESSION_LONGOPS view， you find that some of the database users have long-running queries and are consuming a lot of CPU time. This causes problems for you when you try to log on as the system user and perform small maintenance tasks. You would like to ensure that users SYS and SYSTEM get priority over all other users. Which method would you use to achieve this objective？（）A create a plan directive in the SYS_GROUPB create the pending area for the consumer groupC activate the provided SYSTEM_PLAN in Resource ManagerD set the TIMED_STATISTICS parameter to TRUE in the parameter fileE set the execution time limit for all users， except SYS and SYSTEM， in their profiles

查看答案

考题单选题Users are performing a large volume of inserts and deletes on the application tables in the APPS tablespace. You observe that there are several warning alerts being generated for the APPS tablespace space usage metrics. Currently， the warning threshold for the tablespace space usage metrics is set to 70%. To make the generated alerts more useful as a problem identification tool， you want to reduce the frequency of alert generation for the tablespace space usage metrics for the APPS tablespace. What should you do？（）A disable SQL tracing for theAPPS tablespaceB disable logging attribute for the APPS tablespaceC modify the tablespace to be a dictionarymanaged tablespaceD increase the critical threshold value for the tablespace space usage metrics for the APPS tablespaceE increase the warning threshold value for the tablespace space usage metrics for the APPS tablespace

查看答案

考题单选题You enabled block change tracking for faster incremental backups in your database. Which background process writes to the change tracking file？（）A RBALB CKPTC SMOND PMONE MMONF CTWRG DBWR

查看答案

考题单选题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.

查看答案

考题多选题When performing a backup using Recovery Manager （RMAN）， which four types of files can be backed up with the RMAN BACKUP command？（）Adata fileBpassword fileCarchivelog fileDtemporary fileEonline redo log fileFthe current control fileGthe tnsnames.ora fileHcurrent server parameter file

查看答案

考题多选题Users in your production database complain that they are getting the following error message while trying to insert rows into the ORDERS table： ERROR at line 1： ORA/x7f01654： unable to extend index USERS.ORDERS_IND by 8 in tablespace INDEXES While investigating， you find that the INDEXES tablespace has run out of space and there is no more free space on the disk where the data files are available. Which two actions could you perform to overcome this error without affecting the queries that are currently being executed？（）Adrop and recreate the indexBcoalesce the ORDERS_IND indexCcoalesce the INDEXES tablespaceDdrop and recreate the ORDERS tableErebuild the index online and move it to another tablespace

查看答案

考题单选题Manually， you set the consumer group of all of the newly created users to MYDB_GRP. You want the users to be able to change their consumer groups as per the application requirement. What was the first step that was needed in the process to achieve this objective？（）A The user must have been granted the DBA role.B The user must have been granted the switch privilege as a part of a role.C The user must have been granted the Resource Manager administrator privilege.D The user must have been granted the switch privilege by using the DBMS_RESOURCE_MANAGER_PRIVS package.

查看答案

考题单选题In Recovery Manager （RMAN）， you set the retention policy to NONE by executing the following command： CONFIGURE RETENTION POLICY TO NONE; What would be the impact of this setting？（）A The retention policy is cleared.B RMAN does not consider any backup as obsolete.C The retention policy is set to its default setting of redundancy 1.D The retention policy is set to its default setting of recovery window 7.

查看答案

网友您好， 请在下方输入框内输入要搜索的题目：

网友您好，请在下方输入框内输入要搜索的题目：