当前分类： 1Z0-042
问题：单选题Your database is in the NOARCHIVELOG mode. Since last night’s offline backup， the logs in group 1 have been written to twice. This morning， the SYSTEM data file has become corrupted. Up to what point can it be recovered？（）A until the last commitB canno...
查看答案
问题：单选题In your Certkiller .com database server the parameter PLSQL_CODE_TYPE has been set to NATIVE. Which object would be achieved by the setting？（）A The source PL/SQL code will be stored in native machine code.B The source PL/SQL code will be stored in inte...
问题：多选题You require the Oracle server to manage the undo segments and space among various active sessions automatically. You created an undo tablespace， UNDO_TBS1， in your database. Which two additional steps would you perform to achieve this？（）ASet the UNDO_R...
问题：单选题You work as a database administrator for Certkiller .com. You find that users with DBA role are using more CPU resources than what is allocated in their profiles. Which action would you take to ensure that resources limits are imposed on these users？ （...
问题：多选题Which two statements about Automatic Storage Management （ASM） are true？（）AASM provides mirroring on file by file basis.BASM provides automatic load balancing across all ASM disks.CASM supports the Oracle database and operating system files.DASM can be ...
问题：单选题Your Certkiller .com database is in ARCHIVELOG mode. The data file that belongs to the SYSTEMtablespacehas 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 da...
问题：单选题Which step do you need to perform to enable a user with the SYSDBA privilege to log in as SYSDBA in iSQL*Plus？（）A The user must be granted the database administrator （DBA） privilege.B The user must be listed in the password file for the authentication....
问题：单选题You manually create an additional listener process，L1，for databases PROD， PAYDB and FINDB. While starting up the listener process，you get the following error message： LSNRCTL start l1 Starting /u01/app/oracle/product/10.1.0/db_1/bin/tnslsnr： please w...
问题：单选题The database users are connecting to the PROD database from different applications， thereby degrading the database performance. The senior database administrator suspects the large number of concurrent connections to be the reason for low performance ...
问题：单选题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 ...
问题：单选题In your database， you discovered that a tempfile in a locally managed temporary tablespace has been deleted at the operating system level. How would you recover the tablespace？（）A flash back the databaseB perform point-in-time recoveryC perform a full ...
问题：多选题What are the consequences of executing the SHUTDOWN ABORT command？ （）AThe database files are synchronized.BUncommitted changes are not rolled back.CThe database is closed， but the instance is still started.DDatabase buffers and redo buffers are not wri...
问题：单选题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 follo...
问题：多选题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 b...
问题：单选题You are using flat files as the data source for one of your data warehousing applications. You plan to move the data from the flat file structures to an Oracle database to optimize the application performance. In your database you have clustered tables...
问题：单选题You work as a database administrator for Supportcenter.cn. In your Oracle database 10g 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 Th...
问题：多选题You work as a database administrator for Supportcenter.cn. Users in the SupportCenter PROD database complain about the slow response when accessing the database. In the Active Session Waiting： Configuration page you find that the majority of the wait t...
问题：多选题You work as a database administrator for Certkiller .com. You are using Recovery Manager （RMAN） to perform backups in your databases. Which four backup operations can be performed using RMAN？（）AA backup of the target database when it is mountedBA back...
问题：单选题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 ma...
问题：单选题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 sus...
