[Free] 2018(Aug) Ensurepass Microsoft 98-364 Dumps with VCE and PDF 1-10

Ensurepass.com : Ensure you pass the IT Exams
2018 Aug Microsoft Official New Released 98-364
100% Free Download! 100% Pass Guaranteed!

Database Fundamentals

Question No: 1

Which category of SQL statements is used to add, remove, and modify database structures?

  1. Data access language (DAL)

  2. Data manipulation language (DML)

  3. Data control language (DCL)

  4. Data definition language (DDL)

Answer: D

Question No: 2

What is one difference between an update statement and a delete statement?

  1. An update statement can change only one row.

  2. A delete statement cannot use a where clause.

  3. An update statement does not remove rows from a table.

  4. A delete statement works only within a stored procedure.

Answer: C

Question No: 3

You execute a statement inside a transaction to delete 100 rows from a table. The transaction fails after only 40 rows are deleted.

What is the result in the database?

  1. The table will be corrupted.

  2. Forty (40) rows will be deleted from the table.

  3. The transaction will restart.

  4. No rows will be deleted from the table.

Answer: D

Question No: 4

You have the following SQL query

SELECT * FROM dbo.ProAthlete WHERE Salary gt; 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?

  1. Non-null constraint

  2. Default constraint

  3. Index

  4. Foreign key

Answer: D

Question No: 5

You need to insert two new products into the Product table. The first product is named Book and has an ID of 125. The second product is named Movie and has an ID of 126.

Which statement should you use?

Ensurepass 2018 PDF and VCE

  1. Option A

  2. Option B

  3. Option C

  4. Option D

Answer: B

Question No: 6

You have the following table definition:

CREATE TABLE Road (RoadID INTEGER NOT NULL,

Distance INTEGER NOT NULL)

The Road table contains the following data:

Ensurepass 2018 PDF and VCE

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

Answer: B

Question No: 7

First normal form requires that a database excludes:

  1. Foreign keys

  2. Composite keys

  3. Duplicate rows

  4. Repeating groups

Answer: D

Question No: 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

Answer: A

Question No: 9

You have a database table that contains the following columns:

Ensurepass 2018 PDF and VCE

You must insert the following record into the table:

Ensurepass 2018 PDF and VCE

Which two Structured Query Language (SQL) statements can you use? (Choose two.)

Ensurepass 2018 PDF and VCE

  1. Option A

  2. Option B

  3. Option C

  4. Option D

Answer: A,C

Question No: 10

A database contains two tables named Customer and Order. You execute the following statement:

DELETE FROM Order

WHERE CustomerID = 209 What is the result?

  1. The first order for CustomerID 209 is deleted from the Order table.

  2. All orders for CustomerID 209 are deleted from the Order table, and CustomerID 209 is deleted from the Customer table.

  3. All orders for CustomerID 209 are deleted from the Order table.

  4. CustomerID 209 is deleted from the Customer table.

Answer: C

100% Ensurepass Free Download!
98-364 PDF
100% Ensurepass Free Guaranteed!
98-364 Dumps

EnsurePass ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.