Database Programming with SQL-Section 16 Quiz

Test: Quiz: Anatomy of a SQL Statement

1. The order of operator precedence is

/ + – *
* – + /
* / + – –
None of the above

2. If you want to see all columns of data in a table, you use what symbol?

&
%
$
* –

3. SELECT * FROM departments; is a:

Keyword
Statement (*)
Declaration
Strategy

4. The SQL SELECT statement is capable of:

Selection and protection
Selection and projection
Projection and updating
None of the above

5. If you want to see just a subset of the columns in a table, you use what symbol?

&
%
*
None of the above, instead of using a symbol you name the columns you want to see the data for.

6. What is a NULL value?

A perfect zero
A known value less than zero
A blank space
An unknown value

Test: Quiz: Relational Database Technology

1. The following table creation statement is valid. True or False?

CREATE TABLE country (
ID NUMBER(6) NOT NULL,
NAME VARCHAR2(30) NOT NULL,
LOC VARCHAR2(40),
REG_ID NUMBER,
NAME VARCHAR2(25))

True
False

2. The following statements are true regarding tables in a RDBMS: (Choose Two)

A table is a logical object only. They cannot be created in a RDBMS.
A table holds all the data necessary about something in the real world, such as employees, invoices or customers.
Tables contain fields, which can be found at the intersection of a row and a column.
It is not possible to relate multiple tables within an RDBMS.

3. Once data has been created in a RDBMS, the ony way of getting it out again is by writing a Java or C program. No other languages can be used to access that data. True or False?

True
False

4. RDBMS stands for

Relational database manipulation system.
Relational database management system.
Relational database mutilation system.
Relational database management style

Section 16 – Quiz answers

Posted November 12, 2009 by blogulblogurilor in Oracle Design. Comments Offon Section 16 – Quiz answers

Test: Quiz: Anatomy of a SQL Statement

1. The order of operator precedence is

/ + – *
* – + /
* / + – –
None of the above

2. If you want to see all columns of data in a table, you use what symbol?

&
%
$
* –

3. SELECT * FROM departments; is a:

Keyword
Statement (*)
Declaration
Strategy

4. The SQL SELECT statement is capable of:

Selection and protection
Selection and projection
Projection and updating
None of the above

5. If you want to see just a subset of the columns in a table, you use what symbol?

&
%
*
None of the above, instead of using a symbol you name the columns you want to see the data for.

6. What is a NULL value?

A perfect zero
A known value less than zero
A blank space
An unknown value

Test: Quiz: Relational Database Technology

1. The following table creation statement is valid. True or False?

CREATE TABLE country (
ID NUMBER(6) NOT NULL,
NAME VARCHAR2(30) NOT NULL,
LOC VARCHAR2(40),
REG_ID NUMBER,
NAME VARCHAR2(25))

True
False

2. The following statements are true regarding tables in a RDBMS: (Choose Two)

A table is a logical object only. They cannot be created in a RDBMS.
A table holds all the data necessary about something in the real world, such as employees, invoices or customers.
Tables contain fields, which can be found at the intersection of a row and a column.
It is not possible to relate multiple tables within an RDBMS.

3. Once data has been created in a RDBMS, the ony way of getting it out again is by writing a Java or C program. No other languages can be used to access that data. True or False?

True
False

4. RDBMS stands for

Relational database manipulation system.
Relational database management system.
Relational database mutilation system.
Relational database management style