Which keyword can be used in a create table statement?
D
Which of the following are the main approaches in the database design? Each correct answer represents a complete
solution. (Choose three.)
A B D
What is the relationship between the foreign key and primary key? Each correct answer represents a complete solution.
(Choose all that apply.)
A B
Which database term is used to describe the process of applying a backup to a damaged or corrupt database?
B
Which of the following statements is true about referential integrity?
D
You have a table named Product that contains one million rows.
You need to search for product information in the Product table by using the product's unique ID.
What will make this type of search more efficient?
D
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.
B
Which of the following DML SQL statements support usage of correlated sub-queries? Each correct answer represents a
complete solution. (Choose all that apply.)
B D
You execute the following statement:
This statement is an example of a/an:
A
You have two tables named Salesperson and Sales.
You need to ensure that each record in the Sales table has a valid associated salesperson record in the Salesperson table.
Which database object should you add to the Sales table?
B