If it makes the statement correct, select "No change is needed." If the statement is incorrect, sele
This question requires that you evaluate the underlined text to determine if it is correct.
ALTER TABLE removes all rows from a table without logging the individual row deletions.
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.
Which data type should you recommend?
You work at a coffee shop. They ask you to set up a website that stores charges on purchases.
You need to recommend a data type in a database table to run financial functions against the
charged amounts.
Which data type should you recommend?
If it makes the statement correct, select "No change is needed." If the statement is incorrect, sele
This question requires that you evaluate the underlined text to determine if it is correct.
A row holds information for a single record 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
Which syntax should you use to create the object?
For each of the following statements, select Yes if the statement is true.
This question requires that you evaluate the underlined text to determine if it is correct.
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.
Which database object should you use to store the data?
You develop a database to store data about textbooks. The data must be stored to process at a later
time.
Which database object should you use to store the data?
If it makes the statement correct, select "No change is needed." If the statement is incorrect, sele
This question requires that you evaluate the underlined text to determine if it is correct.
First normal form requires that a database excludes repeating groups.
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.
Use the drop-down menus to select the answer choice that completes each statement.
HOTSPOT
You have two database tables as defined below. The StateID column is unique in the State table. The
AddressID column is unique in the Address table. The two tables are related by the StateID column.
Instructions: Use the drop-down menus to select the answer choice that completes each statement.
Each correct selection is worth one point.
Which item should you add to the Salary column?
You have the following SQL query SELECT * FROM dbo.ProAthlete WHERE Salary > 500000 The query
takes too much time to return data. You need to improve the performance of the query. Which item
should you add to the Salary column?