问题：单选题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
查看答案
问题：单选题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.
问题：单选题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
问题：单选题You work as a database administrator for Certkiller .com. Because of space constraints， you decided to manually shrink the table. You executed the ALTER TABLE ....SHRINK SPACE statement to shrink the space and you receive an error as follows： ERROR at Line 1： ORA-10635： Invalid segment ortablespacetype What could be the reason？（）A The table is partitionedB The table name is wrong.C It is an index-Organized table （IOT）D The table is stored in locally managedtablespace.E The table is stored in atablespacewhere segment space is managed manually.
问题：单选题You work as a database administrator for Certkiller .com. In your production database， the size of Database Buffer Cache needs to be increased immediately for the current as well as future instances of the database. The Oracle instance has been configured to accommodate any changes in the size of the memory structures. At this is production database， you want to accomplish this task with no impact on the user’s connections. Which activity must you have completed before accomplishing this task？（）A You must have started the database instance in restricted mode.B You must have started the database instance inNORMALmode.C You must have started the database instance with server parameter file.D You must have started the database instance but must not have mounted.E You must have started the database instance but must not have opened.
问题：单选题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
问题：单选题You work as a database administrator for Supportcenter.cn. You have been asked to use a centralized administrative tool to administer your database servers and application servers. In order to achieve the objective， which component would you configure on each database server？（）A Database ControlB Management ServerC Management RepositoryD Application Server ControlE Oracle Management Agent
问题：单选题You work as a database administrator for Supportcenter.cn. Client connection requests are failing because the listener is not responding. You want to forward client connect requests to another listener if one listener is not responding. How do you achieve this？（）A Enable instance failoverB Configure shared serverC Enable database failoverD Enable connect-time failoverE Enable Transparent Application Failover （TAF）
问题：单选题You executed the following command in the lsnrctl utility to stop the listener： lsnrctl> STOP L1 What is the effect of this command if L1 is the only listener configured for your database？（）A It terminates all user sessions.B It prevents users from logging in to the database remotely.C It halts the server until all user transactions are completed.D The server hangs， so users will receive an error asking them to login again.E Connected users would get an error with the message End of communication channel.
问题：多选题While setting up the database for your production environment， you want to create a user with following requirements. 1.The objects created by the user must be stored in a tablespace， TBS1， if the TABLESPACE option is not defined during the object creation. 2.The user should be able to use 10MB of space in the tablespace TBS1. 3.The user must change the password immediately after logging in for the first time. Which three options of the CREATE USER command would you use to achieve this objective？（）AprofileBaccount lockCaccount unlockDpassword expireEquota 10MB on TBS1Fpassword never expireGdefault tablespace TBS1Hquota unlimited on TBS1Itemporary tablespace TEMPJtemporary tablespace SYSTEM
问题：单选题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 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
问题：单选题Where do you find information about a missing redo log file？（）A trace fileB audit trailC control fileD alert log fileE event viewer
问题：多选题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 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 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.
问题：多选题You plan to use static database registration for a new listener when you create it.What could be the two reasons for this？（）AMore than one database is to be registered with the listener.BThe users will connect the database by using the host naming method.CThe Oracle Enterprise Manager is to be used to monitor an Oracle9i database.DThe database that is to be registered with the listener is configured in shared server mode.EThe listener is not configured on the default port of 1521 and the instance is not configured to register with a nondefault port.
问题：多选题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.
问题：单选题Examine the following commands executed in your database： SQL> ALTER SESSION RECYCLEBIN=ON； Session altered SQL > CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees； Table created. Further， you executed the following command to drop the table： SQL> DROP TABLE emp；Table dropped. What happens in this scenario？（）A The table is moved to the SYSAUX tablespace.B The table is moved to the SYSTEM tablespace.C The table is removed from the database permanently.D The table is renamed and remains in the TBSFD tablespace.
问题：多选题You work as a database administrator for Certkiller .com. You decided to manage client and server connections using Local Naming method in Certkiller .com. When you try to connect to the database you get the following error： ERROR： ORA-12154：TNS：couldnot resolve service name Which network configuration files would you look into to resolve this error？（）Asnmp.oraBnames.oraCspfile.oraDsqlnet.oraElistener.oraFtnsnames.ora
