Ch. 1

Question 1

Which of the following Oracle tools can be used to execute SQL statements against a database?
- SQL Developer
- SQL*Plus command line
- SQL Language Reference Manual
- SQL Live

Answer 1

• SQL Developer
• SQL*Plus command line
• SQL Live

Question 2

The relational model consists of which of the following. Choose all that are true:

• Primary and foreign keys
• Collection of tables
• Data integrity for accuracy and consistency
• Set of operators to act on the relations, called the relational algebra

Answer 2

All are true

Question 3

What are a primary key’s identifying characteristics? (select all that apply)
- it uniquely identifies each row
- it consists of only one column
- it cannot be null
- it must be numeric

Answer 3

• it uniquely identifies each row
• it cannot be null

Question 4

Which of the following is not required to form a syntactically correct SELECT statement?
- SELECT
- a valid table name
- FROM
- a valid column name

Answer 4

• a valid column name

Question 5

Which of the following are not part of SQL? select all that apply

• if..then..else selection
• COMMIT
• ROLLBACK
• DO..WHILE loop
• FOR..NEXT loop

Answer 5

• if..then..else selection
• DO..WHILE loop
• FOR..NEXT loop

Question 6

Which component(s) of the following query is/are a literal (select all that apply):
SELECT order_id || ‘-‘ || line_item_id || ‘ ‘ || quantity “Purchase”
FROM line_item;
- “Purchase”
- ‘ ‘
-‘-‘
- ||

Answer 6

• ’ ‘
• ’-‘

Question 7

The SHIPS table has two columns: SHIP_ID and SHIP_NAME
Which of the following SELECT statements will produce a syntax error? (Choose two.)

• SELECT ship_id, ship_id FROM SHIPS;
• SELECT FROM ships;
• SELECT (ship_id, ship_name) FROM ships;
• SELECT 1 + 2 FROM ships;

Answer 7

• SELECT FROM ships;
• SELECT (ship_id, ship_name) FROM ships;

Question 8

Which of the following are valid datatypes in Oracle SQL? select all that apply

• VARCHAR2
• CHAR
• VARCHAR2(50)
• CHAR(12)

Answer 8

• CHAR
• VARCHAR2(50)
• CHAR(12)

Question 9

Which of the following are string literals? select all that apply
- ‘Hogwarts School of Witchcraft and Wizardry’
- ‘975 *==+’
- NULL
- Harry Potter

Answer 9

• ‘Hogwarts School of Witchcraft and Wizardry’
• ‘975 *==+’

Question 10

SQL is case sensitive, so you must capitalize all keywords, such as SELECT and FROM.
- True
- False

Answer 10

False

Question 11

What is the dummy table called in Oracle

Answer 11

DUAL

Question 12

A table consists of ..

• Rows and columns, primary key, and possibly foreign keys
• Names and statements
• many-to-many relationship
• relationships such as one-to-many

Answer 12

• Rows and columns, primary key, and possibly foreign keys

Question 13

For the datatype NUMBER(5,2) which of the following numbers would NOT work?

• 3344.56
• 176
• 95.78
• 8.7

Answer 13

• 3344.56

Question 14

Which of the folllowing would you use to concatenate two strings together?
- &
- |
- ||
- +

Answer 14

• ||

Question 15

What keyword is used to eliminate duplicate rows in query’s output?
- UNIQUE
- DISTINCT
- DIFFERENT
- DUPLICATE

Answer 15

• DISTINCT

Question 16

Explain the difference between a Database and SQL

Answer 16

• Database is a persistent store of data
• SQL is the industry standard language for creating and interacting with a relational database

Question 17

Which is used to build data objects and define structures of the database?

Answer 17

Data Definiton Language (DDL)

Question 18

Consider the following rows in a table called CUSTOMERS:

CUST_ID FIRST_NAME MIDDLE LAST_NAME
1 Bianca M. Canales
2 Chua A. Nguyen
3 Bianca M. Jackson
4 Maya R. Canales
5 Bianca S. Canales

How many rows of data will be displayed as the result of executing the following statement: (one answer)

SELECT DISTINCT LAST_NAME, FIRST_NAME FROM CUSTOMERS;

Answer 18

4

Question 19

You are tasked with creating a SELECT statement to retrieve data from a database table named PORTS. The PORTS table has two columns: PORT_ID, and PORT_NAME. Which of the following is a valid SELECT statement? (Choose all that apply.)

• SELECT PORT_ID FROM PORTS:
• SELECT * FROM PORTS;
• SELECT PORT_NAME, PORT_ID FROM PORTS;
• SELECT ‘Name of the port ‘ || PORT_NAME FROM PORTS;

Answer 19

• SELECT * FROM PORTS;
• SELECT PORT_NAME, PORT_ID FROM PORTS;
• SELECT ‘Name of the port ‘ || PORT_NAME FROM PORTS;