O'Reilly logo

OCA Oracle Database 11g: SQL Fundamentals I: A Real-World Certification Guide by Steve Ries

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Test your knowledge

  1. Which of the following statements about SQL sub-languages is true?

    a. Data Definition Language (DDL) is a sub-language of Data Manipulation Language (DML)

    b. DML is a sub-language of DDL

    c. Both DML and DDL are sub-languages of SQL

    d. Neither DML nor DDL are related to SQL

  2. Which of the following terms describes a way to classify the types of data that are possible in a particular column?

    a. Formula

    b. Sub-query

    c. Function

    d. Datatype

  3. Which of the following datatypes stores alphanumeric data in a fixed length format?

    a. CHAR

    b. VARCHAR

    c. VARCHAR2

    d. DATE

  4. Which of the following datatypes stores alphanumeric data in a variable length format?

    a. CHAR

    b. NUMBER

    c. VARCHAR2

    d. DATE

  5. Which of the following datatypes could store the value "Model Airplane" ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required