Download Database Fundamentals.98-364.PracticeTest.2017-12-15.130q.vcex

Vendor: Microsoft
Exam Code: 98-364
Exam Name: Database Fundamentals
Date: Dec 15, 2017
File Size: 3 MB
Download Exam

How to open VCEX files?

Files with VCEX extension can be opened by ProfExam Simulator.

Download
ProfExam Simulator

Purchase
Coupon: EXAM_HUB

Discount: 20%

ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator

Demo Questions

Question 1
The terms "bitmap," "b-tree," and "hash" refer to which type of database structure?
  1. View
  2. Function
  3. Index
  4. Stored procedure
  5. Trigger
Correct answer: C
Question 2
One reason to add an index is to:
  1. Decrease storage space.
  2. Increase database security.
  3. Improve performance of select statements.
  4. Improve performance of insert statements.
Correct answer: C
Question 3
You have a table that contains the following data. 
  
You break the table into the following two tables. 
  
This process is referred to as:
  1. defragmentation
  2. normalization
  3. fragmentation
  4. 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?
  1. Cohort
  2. Relationally dependent
  3. Deterministic
  4. Functionally dependent
  5. Compositional
Correct answer: D
Question 5
Which key uniquely identifies a row in a table?
  1. foreiqn
  2. primary
  3. local
  4. superkey
Correct answer: B
Question 6
Which statement creates a composite key? 
  
  1. Option A
  2. Option B
  3. Option C
  4. 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?
  1. The Customer table no longer exists.
  2. The Customer table is unaffected.
  3. The Customer table exists but has no data.
  4. The script fails.
Correct answer: A
Question 8
In which situation do you need to perform a restore on a database?
  1. when data becomes corrupted in the database
  2. when you need to roll back a transaction
  3. when you encounter an error in your application
  4. 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?
  1. ALLOW  SELECT
  2. LET  READ
  3. PERMIT  READ
  4. GRANT  SELECT
Correct answer: D
Question 10
You need to enable a new employee to authenticate to your database.  
Which command should you use?
  1. ALLOW USER
  2. CREATE USER
  3. ADD USER
  4. INSERT USER
  5. ALTER USER
Correct answer: B
CONNECT US
HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset

HOW TO OPEN VCEX AND EXAM FILES

Use ProfExam Simulator to open VCEX and EXAM files
ProfExam Screen

ProfExam
ProfExam at a 20% markdown

You have the opportunity to purchase ProfExam at a 20% reduced price

Get Now!