In a new installation of Oracle Database 11g， you perform these activities： 1. Organize software and data on different subdirectories to avoid poor performance. 2. Use consistent naming conventions for database files. 3. Separate administrative information pertaining to the database in different directories.  Which optioncorresponds to the type of activities you performed（）

You completed the development of a new application and want to create a new domain in a new environment for functional testing. You want to have the same settings for your new domain as your old domain, with the option of changing the configuration in the new target environment. Which two actions should you execute?（）

单选题查看答案

Youre performing tablespace point-in-time recovery on a tablespace called USERS. If an object in that tablespace has a foreign key constraint owned by another object in the INDEX_TBS  which statement is true？（）  

单选题查看答案

Exhibit You work as a database administrator for Supportcenter.cn. While creating a new user or changing the password for existing users， the password must adhere to the restrictions specified in the exhibit. Which option would you use to achieve this objective？（）

单选题查看答案

A team of programmers is reviewing a proposed API for a new utility class. After some discussion， theyrealize that they can reduce the number of methods in the API without losing any functionality. If theyimplement the new design，which two OO principles will they be promoting？（）

多选题查看答案

You are performing a block media recovery on the tools01.dbf data file in the SALES database by using RMAN.   Which two statements are correct in this scenario？（）

多选题查看答案

You want to access employee details contained in flat files as part of the EMPLOYEE table. You planto add a new column to the EMPLOYEE table to achieve this.  Which data type would you use for the new column（）

单选题查看答案

ou have a large amount of historical data in a flat file. Some analysts in your organization need to query thisdata in the file. The file is too large to load the data in it into your current database.  Which is the most effectivemethod to access this data in your database（）

单选题查看答案

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？（）

单选题查看答案

Click the Exhibit button. What is the output of the program shown in the exhibit？（）

单选题查看答案

Which statement is true about a whole consistent database backup on a database running in ARCHIVELOGmode（）

单选题查看答案