Oracle Final Exam Semester 1 sql

Oracle Final Exam Semester 1

The text below is an example of what constraint type:
The value in the manager_id column of the EMPLOYEES table must match a value in the
employee_id column in the EMPLOYEES table.
(4) Referential integrity

A table must have at least one candidate key, as well as its primary key. True or False?
(2) False

A table must have a primary key. True or False?
(2) False

If a primary key is a set of columns then one column must be null. True or False?
(2) False

Attributes become tables in a database. True or False?
(2) False

In a physical data model, an attribute becomes a _____________.
(4) Column

The transformation from an ER diagram to a physical design involves changing terminology.
Primary Unique Identifiers in the ER diagram become __________ and relationships become
____________.
(2) Primary keys, Foreign keys

The Oracle Database can implement a many to many relationship. You simply create two
foreign keys between the two tables. True or False?
(2) False

Many to many relationships are implemented via a structure called a: ________________
(2) Intersection Table

An "Arc Implementation" can be done just like any other Relationship - you simply add the
required Foreign Keys. True or False?
(2) False

What command will return data from the database to you?
(3) SELECT

The DESCRIBE command returns all rows from a table. True or False?
(2) False

What command can be used to create a new row in a table in the database?
(4) INSERT

The f_customers table contains the following data:
ID Name Address City State Zip
1 Cole Bee 123 Main Street Orlando FL 32838

, 2 Zoe Twee 1009 Oliver Avenue Boston MA 02116
3 Sandra Lee 22 Main Street Tampa FL 32444
If you run the following statement:
DELETE FROM F_CUSTOMERS WHERE ID <= 2;
How many rows will be left in the table?
(3) 1

The SQL statement ALTER TABLE EMPLOYEES DELETE COLUMN SALARY is a valid
statement. True or False?
(2) False

Systems are always just rolled out as soon as the programming phase is finished. No further
work is required once the development is finished. True or False?
(2) False

System Documentation is developed right at the end once the system has gone live and users
have been using it for a little while. You are more likely to get it correct that way. True or
False?
(2) False

Which SQL statement will return an error?
(1) SEL * FR sky;

When you use the SELECT clause to list one or two columns only from a table and no
WHERE clause, which SQL capability is used?
(3) Projection only

Which statement best describes how arithmetic expressions are handled?
(4) Division and multiplication operations are handled before subtraction and addition
operations.

In a SELECT clause, what is the result of 2 + 3 * 2?
(2) 8

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?
(2) Only null values

Which SQL keyword specifies that an alias will be substituted for a column name in the
output of a SQL query?
(1) AS

You need to display employees with salaries that are at least 30000 or higher. Which
comparison operator should you use?
(3) >=