You company has four DBAs. You need to know which DBA added a column to the JOB_HISTORY table. The database cannot be offline during work hours. Which LogMiner command can you use to find out which user made the table change？（）

You work as a database administrator for Certkiller .com. You need to rename a data file of atablespace.  How would you perform this？（）

单选题查看答案

You created a database by using the Database Configuration Assistant. What must you do to access a user account in the sample schemas？（）

单选题查看答案

View the Exhibits. You performed operations on the DEPT4 table as shown in the Exhibit. When you perform the FlashbackVersions Query， you find that the first two updates are not listed. What could be the reason？（） 

单选题查看答案

You work as a database administrator for Certkiller .com. You want to configure database backups to be run automatically.  Which tool or utility would you use to achieve this？ （）

单选题查看答案

You work as a database administrator for Certkiller .com. Your database is opened in NOARCHIVEKLOG mode. You decide to place the database in ARCHIVELOG mode.  How would you do this？（）

多选题查看答案

You are managing an Oracle Database 11g database. You want to ensure the recovery of thedatabase to the point of failure.  Which configuration will you do to accomplish the task（）

单选题查看答案

During recovery， you need to know if log sequence 11 is in the online redo logs， and if so， you need to know the names of the online redo logs so you can apply them during recovery.  Which view or views would you use to determine this information？（） 

多选题查看答案

You made changes to the COMPUTE_TAX function inside the EMP_ADMIN package body.  Whichstatement is true after you recompile the EMP_ADMIN package body（）

单选题查看答案

You are configuring the data source for an Oracle database. You will need to specify a test table for WebLogic to test the status of the database. Which option should you choose?（）

单选题查看答案

You are designing an application for a telecom company and you have been asked to design a database table to facilitate monthly bill generation. The bill would include details of customer calls， listed in chronological order.  Which method would you follow to achieve this objective without increasing the overhead of sorting the rows？（）

单选题查看答案