问题：单选题You work as a database administrator for Certkiller .com. In your Oracle database10g installation you have set ORACLE_BASE to /u01/app/oracle. Which objective will be achieved by this setting？（）A The Oracle kernel will be placed in this location.B The Oracle software will be placed in this location.C The server parameter file （SPFILE） will be placed in this location.D The database files will be placed in this location， if not specified explicitly.E The location will be considered for the base of Oracle Managed Files （OMF）.F The location will be considered for the base of Optimal Flexible Architecture （OFA）.
查看答案
问题：单选题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
问题：单选题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
问题：多选题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 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.
问题：多选题A user receives the following error while executing a query： ORA/x7f01555：snapshot too old Which two options can be the solutions to avoid such errors in future？（）Aincrease the size of redo log filesBincrease the size of the undo tablespaceCincrease the size of the Database Buffer CacheDincrease the size of the default temporary tablespaceEenable the retention guarantee for the undo tablespace
问题：单选题In your database， the users SYS and SYSTEM have been assigned the profiles， ADMIN_PROF1 and ADMIN_PROF2， respectively. The rest of the database administrators are assigned the profile ADMIN_PROF3. You create a profile， USER_PROF， and assign it to the application user， Adams. After a week you realize that the profile is no longer required and you decide to drop it. What will Adam’s profile be after the USER_PROF profile has been dropped？（）A no profilesB the default profileC same as the profile of SYS userD same as the profile of SYSTEM user
问题：单选题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 execute the following command to audit the database activities： SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL; What is the effect of this command？（）A One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session.B One audit record is created for every session when any user successfully drops a table owned by SCOTT.C One audit record is created for each successful DROP TABLE command executed by any user to drop tables owned by SCOTT.D One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users in his session.E One audit record is created for each successful DROP TABLE command executed in the session of SCOTT.
问题：多选题When you try to start the Database Control by using the emctl start dbconsole command the following error is displayed： TZ set to America/New_york OC4J Configuration issue. /u01/app/oracle/product/10.1.0/db_1/oc4j/j2ee/OC4J_DBConsole_orcl.us.oracle.com not found. Which two environment variables do you need to set appropriately to avoid such errors and start the Database Control successfully？（）ANLS_LANGBORACLE_SIDCORACLE_HOMEDORACLE_BASEELD_LIBRARY_PATH
问题：单选题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 are valid locking levels that are used by transactions in an Oracle database？（）Arow levelBblock levelCobject levelDschema levelEdatabase level
问题：单选题Your alert log file has the following information： Tue May 25 17：43： 38 2004 ORA-00060： Deadlock detected. More info in file /u01/app/oracle/admin/ORCL/udump/orcl_ora_3173.trc. What would you do to ensure that database is still running correctly？（）A examine the trace file and kill the session that caused the deadlockB examine the trace file and kill both the sessions responsible for the deadlockC examine the trace file for details and ask the user who caused the deadlock to rollback the transactionD examine the trace file for details and remember that deadlocks are resolved automatically by Oracle databaseE examine the trace file for details and use the Undo Advisor to rollback the transaction that caused the deadlock
问题：单选题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.
问题：单选题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
问题：单选题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 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.
问题：多选题Which three statements are true about the stages of database startup？（）AData files and redo log files can be renamed at the MOUNT stage.BControl files are read at the OPEN stage for the location of data files.CControl files are required to bring the database to the NOMOUNT stage.DData files and redo log files are made available to users at the OPEN stage.EData files and online redo log files are checked for consistency while opening the database
问题：单选题You work as a database administrator for Supportcenter.cn. You received the following error while working on your database： ORA-01555： snapshot too old ，In which situation would you receive such an error？（）A You performed rollback after commit.B If a log switch occurs in your database.C Thearchiverfails to generate an archived log file.D Instance recovery fails to find one of the redo log files.E A long-running query is unable to get read-consistent image.F If you perform manual undo management operations in auto mode.
问题：多选题You work as a database administrator for Supportcenter.cn. You are working on Oracle Database 10g. To forward client connections to an instance， the listener must know information such as the name of the instance and where the instance’s ORACLE_HOME is located. How does the listener get this information？（）AIt gets it from the parameter file.BThe listener prompts for details on startup.CThe listener gathers information from the control file.DThe instance automatically registers with the default listener.EThe listener gets this information through thelistener.orafile.
