Basics Of Data Types And Database Objects

5 Questions | Attempts: 318
Share

SettingsSettingsSettings
Data Type Quizzes & Trivia

The quiz checks if trainee has understood basic concepts of table creation and database objects


Questions and Answers
  • 1. 
    Which of these statements will fail because the table name is not legal? (Choose two answers.)
    • A. 

      Create table "SELECT" (col1 date);

    • B. 

      Create table "lower case" (col1 date);

    • C. 

      Create table number1 (col1 date);

    • D. 

      Create table update(col1 date);

    • E. 

      Create table 1number(col1 date);

  • 2. 
    Several object types share the same namespace and therefore cannot have the same name in the same schema. Which of the following object types is not in the same namespace as the others? (Choose the best answer.)
    • A. 

      Index

    • B. 

      PL/SQL stored procedure

    • C. 

      Synonym

    • D. 

      Table

    • E. 

      View

  • 3. 
    Which of the following is not supported by Oracle as an internal datatype? (Choose the best answer.)
    • A. 

      CHAR

    • B. 

      FLOAT

    • C. 

      INTEGER

    • D. 

      STRING

  • 4. 
    You need to record date/time values, with a precision of one second. What would be a suitable datatype for a single column to store this information? (Choose One that is most appropriate)
    • A. 

      DATE

    • B. 

      TIMESTAMP

    • C. 

      DATE or TIMESTAMP

    • D. 

      User Defined Data Type

  • 5. 
    Which of the following constraints require an index? (Choose Two)
    • A. 

      NOT NULL

    • B. 

      PRIMARY KEY

    • C. 

      CHECK

    • D. 

      UNIQUE

Back to Top Back to top
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.