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 is the name given to the set of rules that define a programming language's structures, symbols, and semantics?

    a. Projection

    b. Restriction

    c. Syntax

    d. If..then

  2. In which of these statements is case preserved?

    a. SElect * from employee;

    b. select first_name "My Name" from employee;

    c. SELECT BLOG_ID FROM BLOG;

    d. SelECt diSTINCT branch_ID, BRANCH_name from branch;

  3. Which of these symbols is a valid statement terminator in Oracle SQL?

    a. !

    b. *

    c. ;

    d. &

  4. Which of these is not a valid SQL statement?

    a. select first_name from employee;

    b. select * from message;

    c. select from award_date award;

    d. select website_url from website;

  5. The process of displaying one or more columns from a table is known as:

    a. Projection

    b. DISTINCT

    c. Restriction

    d. Selection ...

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