98-364 Exam
Improve 98-364: Examcollection real bootcamp from 71 to 78
Want to know Exambible 98-364 Exam practice test features? Want to lear more about Microsoft Microsoft Database Fundamentals certification experience? Study Downloadable Microsoft 98-364 answers to Improved 98-364 questions at Exambible. Gat a success with an absolute guarantee to pass Microsoft 98-364 (Microsoft Database Fundamentals) test on your first attempt.
Q71. 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?
A. CHAR
B. BYTE
C. DOUBLE
D. SMALLINT
Answer: A
Q72. 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
A. No change is needed
B. Queries
C. Stored procedures
D. Tables
Answer: D
Q73. On which database structure does an insert statement operate?
A. Role
B. Trigger
C. User
D. Stored procedure
E. Table
Answer: E
Q74. 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.
A. Change is needed
B. Commit
C. Attach
D. Restore
Answer: D
Q75. You need to disable User1's access to view the data in the Customer table. Which statement should you use?
A. Option A
B. Option B
C. Option C
D. Option D
Answer: C
Q76. You have the following table definition:
CREATE TABLE Road
(RoadID INTEGER NOT NULL,
Distance INTEGER NOT NULL)
The Road table contains the following data:
You execute the following statement:
INSERT INTO Road VALUES (1234, 36)
What is the result?
A. an error stating that NULL values are not allowed
B. a new row in the table
C. an error stating that duplicate IDs are not allowed
D. a syntax error
Answer: B
Q77. You need to store product quantities, and you want to minimize the amount of storage space that is used. Which data type should you use?
A. INTEGER
B. DOUBLE
C. COUNT
D. FLOAT
Answer: A
Q78. You have a table that contains the following data.
You break the table into the following two tables.
This process is referred to as:
A. defragmentation
B. normalization
C. fragmentation
D. denormalization
Answer: B