Confidently Practice Online with Free INF-201 Exam Cram

Practice your Certified IT Specialist - Databases certification test with free INF-201 exam cram and take control of your certification preparation. At FreeExamCram, you can practice online for free using real INF-201 exam dumps, verified questions, and expert-designed free online practice tests. Moreover our Pearson VUE INF-201 exam cram backed by our confidence-boosting refund guarantee.

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:

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:

SELECT IDNumber as tblSecond retrieves the following IDNumbers:

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