Names, Domains, and Parameter File Settings - Quiz Explanation

The answers you selected are indicated below, along with text that explains the correct answers.

 
1. What does Oracle suggest using as the basis for the database domain name?
Please select the best answer.
  A. The default value of “world”
  B. Your Internet domain name
  C. The DBA's surname
  D. The database name
  The correct answer is B. Presumably, the Internet domain name of any company is unique worldwide. Oracle suggests capitalizing on that by using it as a basis for your database domain name,. For example, the production payroll database for XYZ Corp might have a domain of payroll.xyz.com.

2. If your database name is PROD, what should you name the instance?
Please select the best answer.
  A. PRODSID
  B. PROD
  C. PRDI
  D. PROD_INSTANCE
  The correct answer is B. In this case, PROD, would be the best choice for an instance name. While you certainly don't have make your database and instance names the same, it's a lot easier to keep things straight if you do.

3. Which initialization parameter setting enables Oracle to use the cost-based optimizer?
Please select the best answer.
  A. optimizer_mode = cost
  B. optimizer_mode = choose
  C. optimizer = choose
  D. optimizer = cost
  The correct answer is B. The optimizer_mode parameter is the one that controls the optimizer to be used. A value of “choose” enables Oracle to used the cost-based optimizer. You might wonder why “choose” instead of “cost.” Certainly “cost” seems easier to remember, but someone at Oracle picked the term “choose” instead. I can only offer this insight as to why: Oracle can only use the cost-based optimizer when the DBA has gathered statistics for the table involved in a query, so the optimizer chooses the cost-based optimizer when statistics are present. Someone probably thought that the word “cost” would only make sense if it forced the cost-based optimizer to be used all the time, and that can't happen yet.

4. What does the compatible setting do?
Please select the best answer.
  A. It forces the Oracle software to run in a way that is compatible with Microsoft SQL Server.
  B. It enables you to provide a list of applications that are compatible with a particular database.
  C. It forces the Oracle software to run in a way that is compatible with a previous release.
  D. It enables you to provide a list of Oracle instances that must interoperate with each other.
  The correct answer is C. The compatible parameter lets you upgrade your Oracle software to a new release without affecting existing applications. You simply set the compatible parameter to match the release of Oracle for which the application has been tested.


Oracle 13C Cloud Manager