Want to pass your Database Fundamentals 98-364 exam in the very first attempt? Try Pass2lead! It is equally effective for both starters and IT professionals.
VCE
HOTSPOT
Instructions: For each of the following statements, select Yes if the statement is true. Otherwise, select No. Each correct selection is worth one point.
Hot Area:
You need to enable a new employee to authenticate to your database. Which command should you use?
A. ALLOW USER
B. CREATE USER
C. ADD USER
D. INSERT USER
E. ALTER USER
You have a table named Student that contains 100 rows. Some of the rows have a NULL value in the FirstName column. You execute the following statement:
DELETE FROM Student
What is the result?
A. All rows in the table will be deleted.
B. All rows containing a NULL value in the FirstName column will be deleted.
C. You will receive an error message.
D. All rows and the table definition will be deleted.