当前分类： 1Z0-042
问题：多选题Which three statements are true regarding the fine/x7fgrained auditing （FGA）？（）AFGA is possible on SELECT statements only.BThe audit trail for FGA is stored in the FGA_LOG$ table.CThe audit trail for FGA is stored in the AUD_LOG$ table.DFGA enables a S...
查看答案
问题：单选题You define an alert to be raised when the USERS tablespace usage has reached 80%of the total space. Which area would you refer to， in order to confirm that the alert has been raised due the event？（）A the alert.log fileB the DBA_ALERTS viewC the Databas...
问题：多选题In your Oracle 10g database ， you have scheduled a job to update the optimizer statistics at 05：00 pm every Friday. The job has successfully completed. Which three pieces of information would you check to confirm that the statistics have been collected...
问题：单选题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...
问题：单选题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...
问题：单选题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 starti...
问题：单选题You work as a database administrator for Supportcenter.cn. One of the user sessions was terminated abnormally in the middle of a transaction. What does Oracle database do to recover it？（）A Uses undo data for roll forwardB Uses Flashback Log for recover...
问题：单选题Your database is running in the ARCHIVELOG mode. You placed a tablespace， tbs_1， offline with the immediate option. Which statement is correct in this scenario？ （）A The operation would fail if tbs_1 were a read-only tablespace.B The operation would fai...
问题：多选题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...
问题：单选题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 ...
问题：多选题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....
问题：单选题Where do you find information about a missing redo log file？（）A trace fileB audit trailC control fileD alert log fileE event viewer...
问题：单选题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 ...
问题：单选题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...
问题：单选题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...
问题：单选题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...
问题：多选题Which two operations require undo data？（）Acommitting a transactionBrolling back a transactionCrecovering from failed transactionsDrecording a transaction to redo log filesErolling forward during instance recovery...
问题：单选题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. Wh...
问题：单选题You work as a database administrator for Certkiller .com. You are using three database， Certkiller DB01， Certkiller DB02， and Certkiller DB03， on different host machines in your development environment. The database serverconfiguration， such as IP addr...
问题：单选题You want to migrate your application from the development environment to the production environment. While doing the task， you want the database objects owned by the user DEVUSER in the development environment to be moved to the user APPS in the produc...
