问题:单选题You are using the backup scheduler in Enterprise Manager (EM) to schedule a backup of your database. Which type of script does the backup scheduler generate? ()A SQL scriptB PL/SQL scriptC Operating System (OS) scriptD Enterprise Manager (EM) scriptE Recovery Manager (RMAN) script
查看答案
问题:单选题Your Supportcenter.cn database is in ARCHIVELOG mode. The data file that belongs to the SYSTEM tablespace has become corrupted. Up to what point can you recover the database?()A Until last commitB Until the time you perform recoveryC Until the time the date file got corruptedD Until the point where the last transaction begunE You cannot recover the SYSTEMtablespaceand must re-create the database.
问题:单选题It is a holiday and no transactions are being performed on the database. You took a consistent backup of your database without using Recovery Manager (RMAN). How would you make use of this consistent backup in RMAN?()A cannot be used in RMANB by starting up the database againC by using the CATALOG command of RMAND by using the RECOVER CATALOG command in RMANE by re-creating the target control file to rebuild the RMAN repository
问题:单选题In your database, UNDO_RETENTION has been set to 600 sec and UNDO tablespace is configured for RETENTION GUARANTEE. Which statement regarding RETENTION GUARANTEE is true? ()A Undo data is retained until the next full database backup.B No committed undo data will be overwritten for 10 minutes.C Committed undo data will be kept forever if not overwritten within 600 seconds.D Guarantees that requested undo information are available until the instance is shut down.
问题:多选题Which two statements about bigfile tablespaces are true? ()AThe bigfile tablespace have only one data file.BThe segment space management is automatic.CThe extent management is dictionary managed.DThe database can have only one bigfile tablespace.EThe bigfile tablespace can be converted to a smallfile tablespace.
问题:单选题You want to be notified when the space usage of an existing critical tablespace has reached 75% of the allocated space. Which option would you use to achieve this?()A run a procedure to check the tablespace space usageB define the warning threshold for the tablespace at 75% in Database ControlC create a trigger to be executed when tablespace space usage reaches 75%D submit a job by using DBMS_JOB package to check the free space in the tablespace at regular intervalsE define the warning threshold to be 75% for the tablespace by ALTER TABLESPACE .. ADD THRESHOLD command
问题:单选题In the instance of the PROD database, the checkpoint (CKPT) process runs after every minute. A database user updates the rows of the ORDERS table. Because of the configuration, the CKPT process gets initiated before the user commits the transaction. What would happen to the modified blocks when the CKPT process is started?()A The modified blocks would be written to the data files.B The modified blocks would be written to the temp files.C The modified blocks would be written to the control file.D The modified blocks would be written to the redo log files.E The modified blocks would be written to the archived redo log files.F The modified blocks would be retained in the database buffer cache.
问题:单选题You find that the database performance degrades while you backup the PROD database using Recovery Manager (RMAN). The PROD database is running in shared server mode. The database instance is currently using 60% of total operating system memory. You suspect the shared pool fragmentation to be the reason. Which action would you consider to overcome the performance degradation?()A Configure Java Pool to cache the java objects.B Configure Streams Pool to enable parallel processing.C Increase Shared Pool size to cache more PL/SQL objects.D Increase Database Buffer Cache size to increase cache hits.E Configure Large Pool to be used by RMAN and shared server.F Increase the total System Global Area (SGA) size to increase memory hits.
问题:多选题In which two cases would you perform only consistent backup?()AYou are working on a database where downtime is not tolerated.BYou are working on a database where downtime can be tolerated.CYou are working on a database that operates in ARCHIVELOG mode.DYou are working on a database that operates in NOARCHIVELOG mode.EYou are working on a database where all the tablespaces are locally managed.FYou are working on a database where control files and redo log files are multiplexed.GYou are working on a database where control files and redo log files are not multiplexed.
问题:单选题You work as a database administrator for Certkiller .com. Your database is functional. One of the disks containing a mirrored redo log member has bad sectors in it. You are unable to fix the damaged file. How does the loss of a redo log member affect the instance of the database that is currently running?()A The instance would normally abort.B The instance would not be affected.C The instance would be invalid, so would have to be aborted.D The instance would remain open, but the LGWR process would fail.E The instance would remain open and would automatically create the missing file
问题:单选题Where do you find information about a missing redo log file?()A trace fileB audit trailC control fileD alert log fileE event viewer
问题:多选题Which two statements about Recovery Manager (RMAN) backups are true? ()AOnline redo log files can be backed up.BArchived redo log files are backed up.COnly used data blocks can be backed up as backup sets.DOnly consistent database backups can be performed.ERMAN backup can be taken only if the database is configured in ARCHIVELOG mode.
问题:单选题You observe that in your PROD database, customer information is being modified by some unauthorized users. You want to keep track of all of the transactions happening on the table using PL/SQL. Which type of PL/SQL subprogram or construct would you use to accomplish this task?()A functionsB packagesC proceduresD database triggersE anonymous PL/SQL block
问题:单选题As a result of performance analysis, you created an index on the prod_name column of the prod_det table, which contains about ten thousand rows. Later, you updated a product name in the table. How does this change affect the index?()A A leaf will be marked as invalid.B An update in a leaf row takes place.C The index will be updated automatically at commit.D A leaf row in the index will be deleted and inserted.E The index becomes invalid when you make any updates.
问题:多选题Which three pieces of information are considered while deciding the size of the undo tablespace in your database?()Athe size of an undo blockBthe size of the redo log filesCundo blocks generated per secondDthe size of the database buffer cacheEthe value of the UNDO_RETENTION parameter
问题:单选题The SAVE_AMT column in the ACCOUNTS table contains the balance details of customers in a bank. As part of the year/x7fend tax and interest calculation process, all the rows in the table need to be accessed. The bank authorities want to track access to the rows containing balance amounts exceeding $200,000, and then send an alert message to the administrator. Which method would you suggest to the bank for achieving this task?()A implementing valuebased auditing by using triggersB implementing finegrained auditing with audit condition and event handlerC performing standard database auditing to audit object privileges by setting the AUDIT_TRAIL parameter to EXTENDEDD performing standard database auditing to audit SQL statements with granularity level set to ACCESS
问题:单选题You have two databases, FINDB and PAYDB, on single operating system and using Optimal Flexible architecture (OFA). FINDB is functional and is currently being accessed by the users. While starting up the instance for the PAYDB database you get the following error: ORA-01081: cannot start - already running ORACLE - shut it down first Which environmental variable would you set before starting up the PAYDB database to overcome this error?()A ORA_PATHB ORACLE_SIDC ORACLE_BASED ORACLE_HOMEE LD_LIBRARY_PATH
问题:单选题You work as a database administrator for Certkiller .com. You determine that archiving was not successful in one of thedestinators. You want to check the alert log file for more information on this. Which initialization parameter gives you the location of the alert log file?()A USER_DUMP_DESTB CORE_DUMP_DESTC ALERT_LOG_DESTD ALERT_DUMP_DESTE TRACE_DUMP_DESTF BACKGROUND_DUMP_DEST
问题:多选题You work as a database administrator for Certkiller .com. Your listener process, L1,is currently listening to three databases:CertK INDB04,Certkiller DB05 and Certkiller DB06. Using Database Configuration Assistant (DBCA) you create one more database,Certkiller DB07,and enable dynamic registration. Which two commands of Listener Control Utility (lsnrct1) would you use to determine whether the dynamic registration occurred for the database, Certkiller DB07, with the L1 listener process?()ASHOW L1BSPAWN L1CSTATUS L1DSERVICES L1ESTATUS LISTENERFSERVICES LISTENERGSHOWcurrent_listener
问题:单选题The ST_INFO master table has millions of rows that are updated very rarely. It has a STATE_CODE column that contains the value for 25 states. The table is frequently queried on the STATE_CODE column. Which type of index would you suggest to improve the query performance?()A B-treeB bitmapC reverse keyD function based