Download Microsoft.98-364.BrainDumps.2019-03-20.80q.vcex

Download Exam

File Info

Exam Database Fundamentals
Number 98-364
File Name Microsoft.98-364.BrainDumps.2019-03-20.80q.vcex
Size 872 KB
Posted Mar 20, 2019
Download Microsoft.98-364.BrainDumps.2019-03-20.80q.vcex

How to open VCEX & EXAM Files?

Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.

Download
ProfExam Simulator

Purchase

Coupon: MASTEREXAM
With discount: 20%





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

Which key uniquely identifies a row in a table?


  1. foreiqn
  2. primary
  3. local
  4. superkey
Correct answer: B



Question 5

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 6

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 7

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



Question 8

Which keyword can be used in a create table statement?


  1. ORDER BY
  2. DISTINCT
  3. GROUP BY
  4. UNIQUE
Correct answer: D



Question 9

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?


  1. an error stating that NULL values are not allowed
  2. a new row in the table
  3. an error stating that duplicate IDs are not allowed
  4. a syntax error
Correct answer: B



Question 10

One reason to create a stored procedure is to:


  1. Improve performance.
  2. Minimize storage space.
  3. Bypass case sensitivity requirements.
  4. Give the user control of the query logic.
Correct answer: A









CONNECT US

Facebook

Twitter

PROFEXAM WITH A 20% DISCOUNT

You can buy ProfExam with a 20% discount!

Get Now!


HOW TO OPEN VCEX FILES

Use ProfExam Simulator to open VCEX files