Which two elements are required to define a column? (Choose two.)
Answer : AD
What defines the amount of storage space that is allocated to a value in a column?
Answer : C
You are creating a table to store customer data. The AccountNumber column uses values that always consist of one letter and four digits. Which data type should you use for the AccountNumber column?
Answer : A
What is one difference between an update statement and a delete statement?
Answer : C
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?
Answer : C
You need to store the first name, last name, and student ID for 100 students.
This information will be stored in a table as:
Answer : B
What are three valid data manipulation language (DML) commands? (Choose three.)
Answer : ACE
Explanation:
Data manipulation languages have their functional capability organized by the initial word in a statement, which is almost always a verb. In the case of SQL, these verbs are:
✑ SELECT ... FROM ... WHERE ...
✑ INSERT INTO ... VALUES ...
✑ UPDATE ... SET ... WHERE ...
✑ DELETE FROM ... WHERE ...
References:
http://en.wikipedia.org/wiki/Data_manipulation_language
You assign User1 a set of permissions that include the WITH GRANT OPTION.
The WITH GRANT OPTION enables User1 to:
Answer : C
Which type of index changes the order in which the data is stored in a table?
Answer : A
Which statement should you use to remove a foreign key?
Answer : A
First normal form requires that a database excludes:
Answer : D
You execute a statement inside a transaction to delete 100 rows from a table. The transaction fails after only 40 rows are deleted.
What is the result in the database?
Answer : D
You have a table that contains product IDs and product names.
You need to write an UPDATE statement to change the name of a specific product to glass.
What should you include in the update statement?
Answer : A
Your database contains a table named Customer.
You need to delete the record from the Customer table that has a CusromerID of 12345.
Which statement should you use?
Answer : D