Best Microsoft 98-364 dumps exam study materials are written according to the latest real IT exams. All the Microsoft 98-364 dumps exam practice questions and answers are revised by the skillful experts. https://www.passitdump.com/98-364.html 100% success and guarantee to pass Microsoft 98-364 exam test quickly and easily at first attempt.
QUESTION 1
The terms “bitmap,” “b-tree,” and “hash” refer to which type of database structure?
A. View
B. Function
C. Index
D. Stored procedure
E. Trigger
Correct Answer: C
QUESTION 2
One reason to add an index is to:
A. Decrease storage space.
B. Increase database security.
C. Improve performance of select statements.
D. Improve performance of insert statements.
Correct Answer: C
QUESTION 3
You have a table that contains the following data.
This process is referred to as:
A. defragmentation
B. normalization
C. fragmentation
D. denormalization
Correct Answer: B
QUESTION 4
You have a table that contains the following data.
Which database term is used to describe the relationship between ProductID and ProductCategory?
A. Cohort
B. Relationally dependent
C. Deterministic
D. Functionally dependent
E. Compositional
Correct Answer: D
QUESTION 5
Which key uniquely identifies a row in a table?
A. foreiqn
B. primary
C. local
D. superkey
Correct Answer: B
QUESTION 6
Which statement creates a composite key?
A. Option A
B. Option B
C. Option C
D. Option D
Correct Answer: D
QUESTION 7
At 3:00 P.M. (1500 hours), you create a backup of your database. At 4:00 P.M. (1600 hours), you create a table named Customer and import data into the table. At 5:00 P.M. (1700 hours), your server fails. You run a script to apply only the
3:00 P.M. backup to your database. What is the result of the script?
A. The Customer table no longer exists.B. The Customer table is unaffected.
C. The Customer table exists but has no data.
D. The script fails.
Correct Answer: A
QUESTION 8
In which situation do you need to perform a restore on a database?
A. when data becomes corrupted in the database
B. when you need to roll back a transaction
C. when you encounter an error in your application
D. when data needs to be deleted from the database
Correct Answer: A
QUESTION 9
Which command should you use to give a user permission to read the data in a table?
A. ALLOW SELECT
B. LET READ
C. PERMIT READ
D. GRANT SELECT
Correct Answer: D
QUESTION 10
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
Correct Answer: B
QUESTION 11
Which keyword can be used in a create table statement?
A. ORDER BY
B. DISTINCT
C. GROUP BY
D. UNIQUE
Correct Answer: D
QUESTION 12
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
Correct Answer: A
QUESTION 13
Which statement will result in the creation of an index?
A. Option A
B. Option B
C. Option C
D. Option D
Correct Answer: A
QUESTION 14
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
Correct Answer: B
QUESTION 15
You need to store product names that vary from three to 30 characters. You also need to minimize the amount of storage space that is used.
Which data type should you use?
A. VARCHAR (3, 30)
B. CHAR (3, 30)
C. VARCHAR (30)
D. CHAR (30)
Correct Answer: C
QUESTION 16
One reason to create a stored procedure is to:A. Improve performance.
B. Minimize storage space.
C. Bypass case sensitivity requirements.
D. Give the user control of the query logic.
Correct Answer: A
QUESTION 17
Which permission does a user need in order to run a stored procedure?
A. EXECUTE
B. ALLOW
C. CALL
D. RUN
Correct Answer: A
QUESTION 18
You have a table named Product. You create a view that includes all the products from the Product table that are in the Furniture category.
You execute a statement on the Product table that deletes all the products in the Furniture category.
After you execute the statement, the result set of the view is:
A. Empty
B. Deleted
C. Unchanged
D. Archived
Correct Answer: A
QUESTION 19
In SQL, an insert statement is used to add a:
A. User to a database.
B. Row of data to a table.
C. Table to a database.
D. Column to a table definition.
Correct Answer: B
QUESTION 20
You have two tables. Each table has three rows.
How many rows will be included in the Cartesian product of these two tables?
A. 0
B. 3
C. 6
D. 9
Correct Answer: D
QUESTION 21
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.
A. No change is needed
B. 1433 and 1434
C. 411 and 412
D. 67 and 68
Correct Answer: B
QUESTION 22
You ate creating a database object named Student to store the following data:
A. Option A
B. Option B
C. Option C
D. Option D
Correct Answer: A
QUESTION 23
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?
A. View
B. Table
C. Function
D. Stored procedure
Correct Answer: D
QUESTION 24
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.
A. No change is needed.B. Composite keys
C. Duplicate rows
D. Foreign keys
Correct Answer: A
QUESTION 25
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?
A. Non-null constraint
B. Default constraint
C. Index
D. Foreign key
Correct Answer: D
QUESTION 26
Instructions: For each of the following statements, select Yes if the statement is true. Otherwise, select No.
Each correct selection is worth one point.
QUESTION 27
The following graphic shows the components of a SQL Server application. You access the SQL Server application through Internet Explorer.
QUESTION 28
The following illustration shows the structure of a clustered index in a single partition:
Instructions: Use the drop-down menus to select the answer choice that completes each statement Each correct selection is worth one point.
Read more: https://www.passitdump.com/98-364.html Microsoft 98-364 MTA is the industry leader in information technology, and getting certified by them is a guaranteed way to succeed with IT careers. We help you do exactly that with our high quality Microsoft 98-364 dumps exam Microsoft Database Fundamentals training materials. Microsoft MTA exam training material in PDF format, which is a very common format found in all computers and gadgets. Regardless of whichever computer you have, you just need to download one of the many PDF readers that are available for free.