Question 1

A SELECT statement has a join from a PRIMARY KEY in one table to a FOREIGN KEY in another table.

Which of the following types of relationships could result from this JOIN?

Options :

A : One-to-many

B : One-to-one

C : Many-to-many

Answer: B

Question 2

What is the smallest (most efficient) data type to store the following numbers:

23

100

255

Options :

A : bigint

B : tinyint

C : int

D : smallint

Answer: B

Question 3

There are two tables, tblFirst and tblSecond, which only have one column each.

SELECT ID as tblFirst retrieves the following IDs:

3

4

5

SELECT IDNumber as tblSecond retrieves the following IDNumbers:

1

2

3

How many rows does the following code retrieve?

SELECT ID as tblFirst

UNION

SELECT IDNumber as tblSecond

Options :

A : 6

B : 4

C : 5

D : SQL Server returns as error, as the column names (ID and IDNumber) are not identical, and SQL Server doesn't know which one to use.

E : 3

Answer: C