RelationalDBDesignRelationalDBDesign


Create Database   «Prev  Next»
 

Create Oracle Database - Quiz

Each question is worth one point. Select the best answer or answers for each question.

1. One of your users gets this error message when they try to run an application:
ORA-06553: PLS-213: package STANDARD not accessible
.
Which script should you consider executing to fix the problem?
Please select the best answer.
  A. CATALOG.SQL
  B. STANDARD.SQL
  C. DBMS_STANDARD.SQL
  D. CATPROC.SQL

2. What is wrong with the following statement?
CREATE ROLLBACK SEGMENT rbs01

TABLESPACE rbs

    STORAGE (INITIAL 256K, NEXT 128K, MINEXTENTS 1);


Please select the best answer.
  A. The next extent size should not be less than 256k.
  B. A rollback segment must have a minimum of two extents.
  C. The initial and next extent sizes must match.
  D. Rollback segments should be created in the system tablespace.

3. You issue a select against user_tables in order to see a list of tables that you own, and instead you receive the following message:
table or view does not exist
. Which script should you consider executing to fix this problem?
Please select the best answer.
  A. CATPROC.SQL
  B. USER_CATALOG.SQL
  C. DATA_DICTIONARY.SQL
  D. CATALOG.SQL

4. Several database users have received messages warning them about a missing product user profile. Which script should you run in order to resolve the problem?
Please select the best answer.
  A. PUPBLD.SQL
  B. CATPROC.SQL
  C. CATALOG.SQL
  D. DBMS_PROFILE.SQL

5. Which four tablespaces are recommended by the OFA guidelines?
Please select all the correct answers.
  A. USERS
  B. REPORTS
  C. TOOLS
  D. QUERIES
  E. VIEWS
  F. REDO_LOGS
  G. RBS
  H. TEMP