Free Pearson VUE INF-201 Exam Questions

Question 1

There are two tables, tblFirst and tblSecond, which only have one column each.SELECT ID as tblFirst retrieves the following IDs:345SELECT IDNumber as tblSecond retrieves the following IDNumbers:123How many rows does the following code retrieve?SELECT ID as tblFirstUNIONSELECT IDNumber as tblSecond

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

Question 2

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

A : bigint

B : tinyint

C : int

D : smallint

Answer: B

Question 3

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?

A : One-to-many

B : One-to-one

C : Many-to-many

Answer: B

Question 4

There are two tables, tblFirst and tblSecond, which only have one column each.SELECT ID as tblFirst retrieves the following IDs:345SELECT IDNumber as tblSecond retrieves the following IDNumbers:123How many rows does the following code retrieve?SELECT ID as tblFirstUNIONSELECT IDNumber as tblSecond

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

Question 5

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?

A : One-to-many

B : One-to-one

C : Many-to-many

Answer: B