1Z0-042 题目列表
多选题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.
单选题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？ （）AUndo data is retained until the next full database backup.BNo committed undo data will be overwritten for 10 minutes.CCommitted undo data will be kept forever if not overwritten within 600 seconds.DGuarantees that requested undo information are available until the instance is shut down.
单选题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？（）AfunctionsBpackagesCproceduresDdatabase triggersEanonymous PL/SQL block
单选题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？（）Acannot be used in RMANBby starting up the database againCby using the CATALOG command of RMANDby using the RECOVER CATALOG command in RMANEby re-creating the target control file to rebuild the RMAN repository
单选题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？（）AB-treeBbitmapCreverse keyDfunction based
单选题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？（）Aimplementing valuebased auditing by using triggersBimplementing finegrained auditing with audit condition and event handlerCperforming standard database auditing to audit object privileges by setting the AUDIT_TRAIL parameter to EXTENDEDDperforming standard database auditing to audit SQL statements with granularity level set to ACCESS
多选题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？（）AConfigure Java Pool to cache the java objects.BConfigure Streams Pool to enable parallel processing.CIncrease Shared Pool size to cache more PL/SQL objects.DIncrease Database Buffer Cache size to increase cache hits.EConfigure Large Pool to be used by RMAN and shared server.FIncrease the total System Global Area （SGA） size to increase memory hits.
单选题Where do you find information about a missing redo log file？（）Atrace fileBaudit trailCcontrol fileDalert log fileEevent viewer
单选题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？（）AThe modified blocks would be written to the data files.BThe modified blocks would be written to the temp files.CThe modified blocks would be written to the control file.DThe modified blocks would be written to the redo log files.EThe modified blocks would be written to the archived redo log files.FThe modified blocks would be retained in the database buffer cache.
单选题You work as a database administrator for Supportcenter.cn. You enabled tracing while creating a listener to your database. What additional information is available to you when you enable tracing？（）AInformation about each Oracle Net connection.BInformation about each entry in theLinstener.orafileCInformation about the changed done in the databaseDInformation about the different listeners in your systemEInformation about all thenondatabasefiles required to operate the database
多选题You work as a database administrator for Supportcenter.cn. Your database is in the MOUNT state and you execute the following command to open it ALTER DATABASE OPEN； What two actions are performed as a result of this command？（）AAll control files are openedBAll redo files are openedCThe password file is openedDThe parameter file is openedEAll online data files are opened
单选题You are connecting to an Oracle database server from a client by using the following connect string： SQL CONNECT hr/hr@pdserver.us.oracle.com：1521/proddb Which naming method is being used in this case？（）ALocal NamingBEasy ConnectCExternal NamingDDirectory Naming
多选题You work as a database administrator for Certkiller .com. Your database is in the MOUNT state and you execute the following command to open it ALTER DATABASE OPEN； What two actions are performed as a result of this command？（）AAll control files are openedBAll redo files are openedCThe password file is openedDThe parameter file is openedEAll online data files are opened
单选题You work as a database administrator for Supportcenter.cn. When you tried to connect to the database， you received the following error： ERROR： ORA-12541：TNS：no_listener You found that the listener is not running on the server， so you issued the following command in the Listener Control utility to start the listener. lsnrctlSTART What statement is true？（）AIt would attempt to start the default listenerBIt would start the most recently created listener.CIt would display an error with a message asking for the listener name to be specified.DIt would show you a list of listeners and prompts for the listener name that you want to start.