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. What relational term is used to denote any person, place, or thing?

    a. Attribute

    b. Entity

    c. Flat file

    d. Repeating group

  2. What is the name of the process used to transform non-relational data into relational data?

    a. Normalization

    b. Transformation

    c. Repudiation

    d. Object-oriented

  3. A ___________ uniquely identifies any single row of data.

    a. Foreign key

    b. Attribute

    c. Primary key

    d. Column

  4. Which of these is NOT a form of entity relationship?

    a. One-to-many

    b. One-to-one

    c. Variant-to-one

    d. Many-to-many

  5. What is the visual representation of a data model called?

    a. A table

    b. An entity

    c. Normalization

    d. An entity relationship diagram

  6. Which of these is NOT required to make a database connection?

    a. Port number

    b. Table name

    Database name

    c. Hostname/IP ...

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