Which statement deletes the rows where the employee's phone number is not entered?
Correct Answer:A
On which database structure does an insert statement operate?
Correct Answer:E
You have a database table that contains the following columns:
You must insert the following record into the table:
Which two Structured Query Language (SQL) statements can you use? (Choose two.)
Correct Answer:BC
You have two tables. Each table has three rows.
How many rows will be included in the Cartesian product of these two tables?
Correct Answer:D
You ate creating a database object named Student to store the following data:
Which syntax should you use to create the object?
Correct Answer:A
This question requires that you evaluate the underlined text to determine if it is correct.
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 corrector.
Correct Answer:D