A table with no repeating groups, with a single field primary key , and with a transitive dependency
violates which normal form ?
A -
Second normal form
B -
Third normal form
C -
First normal form
D -
Second normal form and third normal form
2-
Going from first to second normal form removes
A -
Transitive dependencies
B -
Data redundancy
C -
Full functional dependencies
D -
Functional dependencies
3-
A given relation is known to be in third normal form. Select the statement which can be inferred
from this:
A -
All attributes contribute to the primary key
B -
Each non-key attribute is determined by the primary key
C -
Every determinant is a candidate key
D -
The relation is not in fourth normal form.
4-
A relation is in Boyce-Codd normal form if it is in 3NF and .
A -
every determinant is a candidate key
B -
every determinant is a primary key
C -
every attribute is a candidate key
D -
there is more than one candidate key
5-
A relation scheme is
A -
A relation name and a set of attibute.
B -
A set of data values
C -
A set of tuples
D -
An entity relationship diagram.
6-
If a relation schema has 5 attributes and 3 of those attributes make up the only key, then how many
different superkeys does the relation have?
A -
2
B -
3
C -
4
D -
5
7-
Given the table STUDENT(StudentID, Name, Advisor), which of the following SQL statements would be
used to change the value of the Advisor field to 'Smith' for all rows in the STUDENT table?
A -
UPDATE STUDENT SET Advisor = 'Smith';
B -
MODIFY STUDENT SET Advisor = 'Smith';
C -
MODIFY Advisor SET STUDENT = 'Smith';
D -
UPDATE Advisor = 'Smith';
8-
Which of the following SQL commands would be used to remove both the data and the table structure of a
table named STUDENT?
A -
REMOVE TABLE STUDENT;
B -
DELETE TABLE STUDENT;
C -
DROP TABLE STUDENT;
D -
DELETE FROM STUDENT;
9-
Given the table CUSTOMER(CustID, Name, PhoneNum, AcctBalance), what is the standard SQL query
phrase to retrieve data for customers with an account balance greater than 50?
A -
WHERE CUSTOMER-AcctBalance > 50
B -
WHERE AcctBalance > 50
C -
HAVING AcctBalance > 50
D -
WHERE (Customer-AcctBalance > 50)
10-
Given the tables STUDENT(StudentID, StudentName, AdvisorID) and ADVISOR(AdvisorID,
AdvisorName, Office, Phone), which of the following SQL statements would be used to implant a join
between the two tables?
A -
WHERE STUDENT MATCH ADVISOR
B -
WHERE STUDENT.AdvisorID MATCH ADVISOR.AdvisorID
C -
WHERE STUDENT JOIN ADVISOR ON STUDENT.AdvisorID = ADVISOR.AdvisorID
