364-668c6d89c3816d115f18c97b

You accept an IT internship at a local charity. The charity wants you to help them with compliance and auditing requirements. You need to ensure that a column or combination of columns uniquely identifies each row of a table. Which constraint should you define?

• Primary key

• Secondary key

• Foreign key

• Default key

• Public key

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?

• Foreign key

• Index key

• Link key

• Default key

You have two tables named Cars and Color as defined below. The two tables are related by ColorId.
You run the following SQL statement:
SELECT *

FROM Cars

LEFT OUTER JOIN Colors

ON Cars.ColorId = Colors.ColorID

How many rows does the SQL statement return?

• 0

• 2

• 3

• 6

You have a Department table and an Employee table in your database. You need to ensure that an employee can be assigned to only an existing department. What should you apply to the Employee table?

• A primary key

• An index

• A foreign key

• A unique constraint

• A data type

You need to combine the results of two queries into a single result that contains all of the rows from both queries. Which Structured Query Language (SQL) statement should you use?

• TRUNCATE

• JOIN

• EXCEPT

• UNION

• WHERE

You have a table named Employee that includes four columns. You execute the following statement:
SELECT *

FROM Employee

Which columns are returned?

• All columns

• Only the last column

• Only the first column

• Only the first and last columns

What is one difference between an update statement and a delete statement?

• An update statement can change only one row.

• A delete statement cannot use a where clause.

• An update statement does not remove rows from a table.

• A delete statement works only within a stored procedure.

Truncate is a database term used to describe the process of applying a backup to a damaged or corrupt database.

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.

• Change is needed

• Commit

• Attach

• Restore

You combine data from three tables into one table. The new table includes redundancy to optimize read performance.

The data in the new table has been denormalized.

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.

• No change is needed

• Normalized

• Truncated

• Indexed

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.

• No change is needed

• GRANT SELECT

• LET HEAD

• PERMIT READ