Microsoft 98-364 Database Fundamentals Exam Practice Test Questions
98-364 Exam Features
In Just $59 You can Access
- Includes All Official Question Types
- Practice Tests on a Web-Based Software (no downloads needed)
- No Need To Install Any Software
- Customize Your Practice Sessions (Free Demo Available)
- Customer Support Available 24/7
-
Your class project requires that you help a charity set up a website.The website collects information about volunteers. Each volunteer record must be uniquely identified.The following information is stored for each volunteer:Given nameSurnameDate of birthPhone numberPhotoYou need to create a table to meet the requirements.Match the Structured Query Language SQL statements to the SQL query.Instructions: To answer, drag the appropriate SQL statement from the column on the left to its place in the SQL query on the right. Each SQL statement may be used once, more than once, or not at all. Each correct match is worth one point.
Answer:Next
-
This question requires that you evaluate the underlined text to determine if it is correct.Views are database objects that contain all of the data in a 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 correct
Answer: 4 Next -
Instructions: For each of the following statements, select Yes if the statement is true. Otherwise, select No. Each correct selection is worth one point.
Answer:Next
-
You have the following table definition:CREATE TABLE Product(ID INTEGER PRIMARY KEY,Name VARCHAR(20),Quantity INTEGER)The Product table contains the following data.You execute the following statement:SELECT Name FROM Product WHERE Quantity IS NOT NULLHow many rows are returned?
Answer: 4 Next -
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: 4 Next