Q1. While attending college, you accept an IT internship at a local charity. The charity needs to report on data that is related and exists in two tables.
You need to establish a relationship between the data that is in the two tables.
Which constraint should you define?
A. Foreign key
B. Index key
C. Link key
D. Default key
Answer: B
Q2. This question requires that you evaluate the underlined text to determine if it is correct.
Ports 20 and 21 are the default ports to secure a SQL Server.
Instructions: Review the underlined text. If it makes the statement correct, select "No change is needed." If the statement is incorrect, select the answer choice that makes the statement correct.
A. No change is needed
B. 1433 and 1434
C. 411 and 412
D. 67 and 68
Answer: B
Q3. Which statement deletes the rows where the employee's phone number is not entered?
A. Option A
B. Option B
C. Option C
D. Option D
Answer: A
Q4. You have the following table definition:
CREATE TABLE Product
(ID INTEGER PRIMARY KEY,
Name VARCHAR(20),
Quantity INTEGER)
The Product table contains the following data.
You execute the following statement:
SELECT Name FROM Product WHERE Quantity IS NOT NULL
How many rows are returned?
A. 0
B. 1
C. 2
D. 3
E. 4
Answer: D
Q5. You have a table named Customer. You need to add a new column named District.
Which statement should you use?
A. Option A
B. Option B
C. Option C
D. Option D
Answer: D
Q6. You have a table that contains the following data.
You break the table into the following two tables.
This process is referred to as:
A. defragmentation
B. normalization
C. fragmentation
D. denormalization
Answer: B
Q7. You need to enable a new employee to authenticate to your database.
Which command should you use?
A. ALLOW USER
B. CREATE USER
C. ADD USER
D. INSERT USER
E. ALTER USER
Answer: B
Q8. This question requires that you evaluate the underlined text to determine if it is correct.
Use the ALLOW SELECT command to give a user permission to read the data in a table.
Instructions: Review the underlined text. If it makes the statement correct, select "No change is needed." If the statement is incorrect, select the answer choice that makes the statement correct
A. No change is needed
B. GRANT SELECT
C. LET HEAD
D. PERMIT READ
Answer: B
Q9. This question requires that you evaluate the underlined text to determine if it is correct.
A view can be used to ensure referential integrity.
Instructions: Review the underlined text. If it makes the statement correct, select "No change is needed." If the statement is incorrect, select the answer choice that makes the statement correct
A. No change is needed.
B. Save an extra copy of data stored in a separate table.
C. Limit access to specific rows or columns of data in a table.
D. Save historical data before deleting it from the base table.
Answer: C
Q10. You have a table named Employee that includes four columns.
You execute the following statement:
SELECT *
FROM Employee
Which columns are returned?
A. all columns
B. only the last column
C. only the first column
D. only the first and last columns
Answer: A