Free Pearson VUE INF-201 Exam Questions
Absolute Free INF-201 Exam Practice for Comprehensive Preparation
-
Pearson VUE INF-201 Exam Questions
-
Provided By: Pearson VUE
- Exam: Certified IT Specialist - Databases
- Certification: Pearson VUE Information Technology Specialist
-
Total Questions: 35
-
Updated On: Jan 24, 2026
-
Rated: 4.9 |
-
Online Users: 70
-
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
Answer: C
-
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
-
Question 2
-
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
Answer: C
-
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
-
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?
Answer: B
-
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?
-
Question 4
-
What is the smallest (most efficient) data type to store the following numbers:23100255
Answer: B
-
What is the smallest (most efficient) data type to store the following numbers:23100255
-
Question 5
-
What is the smallest (most efficient) data type to store the following numbers:23100255
Answer: B
-
What is the smallest (most efficient) data type to store the following numbers:23100255