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) >=
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) >=
