Sections 1
The
_______ clause can be added to a SELECT statement to return a subset of the
data.
WHICH
WHERE
(*)
ANYWHERE
EVERY
All computers in the world
speak the same languages, so you only need to learn one programming language -
Oracle SQL. True or False?
True
False
(*)
You cannot use computers unless
you completely understand exactly how they work. True or False?
True
False
(*)
What command can be used to
create a new row in a table in the database?
INSERT
(*)
ADD
NEW
CREATE
There is only one kind of
software used by all computers. True or False?
True
False
(*)
What is a NULL value?
An
unknown value (*)
A
perfect zero
A known
value less than zero
A blank
space
In which clause of a SELECT
statement would you specify the name of the table or tables being queried?
The
FROM clause (*)
The
SELECT clause
The
WHERE clause
Any of
the above options; you can list tables wherever you want in a SELECT statement.
Evaluate this SELECT statement:
SELECT (salary * raise_percent) raise
FROM employees;
If the RAISE_PERCENT column only contains null values, what
will the statement return?
A null
value or a numeric value depending on the value of the SALARY column
A null
value or a zero depending on the value of the SALARY column
Only
zeroes
Only
null values (*)
In a SELECT clause, what is the
result of 2 + 3 * 2?
8 (*)
10
13
6
You want to create a list of all
albums that have been produced by the company. The list should include the
title of the album, the artist's name, and the date the album was released. The
ALBUMS table includes the following columns:
ALB_TITLE VARCHAR2(150) NOT NULL
ALB_ARTIST VARCHAR2(150) NOT NULL
ALB_DATE DATE NOT NULL
Which statement can you use to retrieve the necessary
information?
SELECT
alb_title; alb_artist; alb_date
FROM albums;
SELECT
*
FROM albums;
(*)
SELECT
alb_title, alb_artist, alb_dates
FROM albums;
SELECT
alb_title, alb_artist, alb_dates
FROM album;
The basic storage structure in a Relational Database is a
_________:
Table
(*)
Row
Key
Field
Columns in a database table
contain data with the same _________:
Type
(*)
Row
Field
Key
Every row in a relational
database table is unique.
True
(*)
False
A Relational Database generally
contains two or more tables. True or False?
True
(*)
False
In the real world, databases used
by businesses generally have a single table . True or False?
True
False
(*)
No comments:
Post a Comment