单选题 You work as a database administrator for Certkiller .com. You need to rename a data file of atablespace. How would you perform this？（）
单选题 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？（）
anonymous PL/SQL block
多选题 In your database， the Log Writer （LGWR） process is unable to write to a member of a current redo log group due to read/write failure. Which two effects would you see in your database？（）
The database instance aborts.
The database operation temporarily halts till the member becomes available.
Writing proceeds as normal. LGWR writes to the available members of a group and ignores the unavailable members.
The member would be marked as STALE and an error message would be written to the alert log file and LGWR trace file.
The status of the group changes to INACTIVE and an error message would be written to the alert log file and LGWR trace file.
单选题 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 wait... TNSLSNR for Linux： Version 10.1.0.2.0 - Production System parameter file is /u01/app/oracle/product/10.1.0/db_1/network/admin/listener.ora Log messages written to /u01/app/oracle/product/10.1.0/db_1/network/log/l1.log Error listening on： （ADDRESS=（PROTOCOL=TCP）（HOST=18.104.22.168）（port=8899）） TNS-12542： TNS：address already in use TNS-12560： TNS：protocol adapter error TNS-00512： Address already in use Linux Error： 98： Address already in use Listener failed to start. See the error message（s） above... What action would you take to overcome this error without disrupting any existing database communications？（）
stop and restart the listener process
set the TNS_ADMIN environmental variable
stop all running listener processes and restart the listener process
change the port number to an unused port number and restart the listener process
change the IP address to host machine name in the LISTENER.ORA file and restart the listener process
Indexes and views can be created on temporary tables.
Both the data and the structure of temporary tables can be exported.
Temporary tables are always created in a user’s temporary tablespace.
The data inserted into a temporary table in a session is available to other sessions.
Data manipulation language （DML） locks are never acquired on the data of temporary tables.
单选题 You work as a database administrator for Certkiller .com. While granting a role，SELECT_CATALOG_ROLE， to a user， Certkiller， using Oracle Enterprise Manager 10g Database Control， you have cleared the DEFAULT check box. What will be the result？（）
The user cannot use the role at all.
The role would not be granted to the user.
The user needs to enable the role explicitly.
The user can start using the role immediately.
The user would have the admin option for the role.
单选题 You work as a database administrator for Supportcenter.cn. On a Monday morning， you find the database instance aborted. After inspecting the alert log file， you execute the STARTUP command in SQL*Plus to bring the instance up. What statement is true？（）
PMON coordinates media recovery.
SMON coordinates instance recovery.
PMON coordinates instance recovery.
Undo Advisor would roll back all uncommitted transactions.
SQL*PLUS reports an error with the message asking you to perform instance recovery.
You are working on a database where downtime is not tolerated.
You are working on a database where downtime can be tolerated.
You are working on a database that operates in ARCHIVELOG mode.
You are working on a database that operates in NOARCHIVELOG mode.
You are working on a database where all the tablespaces are locally managed.
You are working on a database where control files and redo log files are multiplexed.
You are working on a database where control files and redo log files are not multiplexed.
单选题 In your Certkiller .com production database， you find that the database users are able to create and read files with unstructured data， available in any location on the host machine from an application. You want to restrict the database users to access files in a specific location on the host machine. What could do to achieve this？（）
Modify the value for the UTL_FILE_DIR parameter in the parameter file
Grant read and write privilege on the operating system path to the database users
Modify the value for the LDAP_DIRECTORY_ACCESS parameter in the parameter file
Modify the value for the PLSQL_NATIVE_LIBRARY_DIR parameter in the parameter file
Create a directory object referring to the operating system path， and grant read and write privilege on the directory object to the database users
单选题 You work as a database administrator for Supportcenter.cn. Users complain that their query is taking a long time to complete. You suspect the database buffer cache size to be the reason， and you define an alert to be generated when the buffer cache hit metric goes below 85%. When you observe the dynamic performance views， you find that the buffer cache hit ratio is 81% but no alerts are being generated. What could be the reason for this problem？（）
The advisory memory has been turned off.
The DB_CACHE_ADVICE parameter has been set to OFF in the parameter file.
The STATISTICS_LEVEL parameter has been set to BASIC in the parameter file.
The TIMED_STATISTICS parameter has been set to FALSE in the parameter file.
The STATISTICS_LEVEL parameter has been set to TYPICAL in the parameter file.