1Z0-042單項(xiàng)選擇題每日一練(2019.01.17)

單項(xiàng)選擇題
Your database is having two control files， three redo log file groups with two members in each group. Failure of which file would cause an instance to shut down？（）
A.any control file
B.any archive log file
C.one of the redo log members
D.loss of the initialization parameter file
E.any data file belonging to the default permanent tablespac
單項(xiàng)選擇題
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 deadlock
B.examine the trace file and kill both the sessions responsible for the deadlock
C.examine the trace file for details and ask the user who caused the deadlock to roll back the transaction
D.examine the trace file for details and remember that deadlocks are resolved automatically by Oracle database
E.examine the trace file for details and use the Undo Advisor to rollback the transaction that caused the deadlock
單項(xiàng)選擇題
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.functions
B.packages
C.procedures
D.database triggers
E.anonymous PL/SQL block
單項(xiàng)選擇題
Your database is in NOARCHIVELOG mode and a logswitch happens every 20 minutes. On Thursday morning， media failure resulted in corruption of a data file belonging to the TOOLS tablespace. Backups are taken on every Sunday. What would you do in this situation？（）
A.recover using Oracle Flashback Database technology
B.restore the data files from backup and perform a complete recovery
C.restore only the corrupted data file and perform tablespace recovery
D.restore the data files from backup and perform cancel-based recovery
E.restore the entire database from the most recent backup and start the instance and open the database
單項(xiàng)選擇題
You work as a database administrator for Certkiller .com. After being hired， you find that there is only one database that is functional and that is being access by the applications. You want to create a replicate of the database， to be used for testing purposes. What is the best method to create a replica？（）
A.A
B.B
C.C
D.D