EnsurePass
2018 Jan Microsoft Official New Released 98-364
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/98-364.html

Database Fundamentals

Question No: 11

You work at a coffee shop. They ask you to set up a website that stores charges on purchases.

You need to recommend a data type in a database table to run financial functions against the charged amounts.

Which data type should you recommend?

  1. Money

  2. Bit

  3. Varchar

  4. Binary

Answer: C

Question No: 12

You need to remove a view named EmployeeView from your database. Which statement should you use?

  1. DELETE VIEW EmployeeView

  2. DELETE EmployeeView

  3. DROP EmployeeView

  4. DROP VIEW EmployeeView

Answer: D

Question No: 13

You have the following table definition:

CREATE TABLE Product (ProductID INTEGER, Name VARCHAR(20))

You need to insert a new product. The product#39;s name is Plate and the product#39;s ID is 12345.

Which statement should you use?

Ensurepass 2018 PDF and VCE

  1. Option A

  2. Option B

  3. Option C

  4. Option D

Answer: D

Question No: 14

You work at a restaurant and they ask you to help them with a data issue. They provide you with the following recipe data:

Ensurepass 2018 PDF and VCE

You need to normalize the data to third normal form.

How many tables should you create?

  1. 1

  2. 2

  3. 3

  4. 4

Answer: C

Question No: 15

You have a table named Product. The Product table has columns for ProductDescription and ProductCategory.

You need to change the ProductCategory value for all the spoons in the Product table to 43.

Which statement should you use?

Ensurepass 2018 PDF and VCE

  1. Option A

  2. Option B

  3. Option C

  4. Option D

Answer: A

Question No: 16

Which type of index changes the order in which the data is stored in a table?

  1. non-sequential

  2. sequential

  3. non-clustered

  4. clustered

Answer: A

Question No: 17

You need to populate a table named EmployeeCopy with data from an existing table named Employee.

Which statement should you use?

Ensurepass 2018 PDF and VCE

  1. Option A

  2. Option B

  3. Option C

  4. Option D

Answer: D

Question No: 18

You accept an IT internship at a local charity. The charity wants you to help them with compliance and auditing requirements.

You need to ensure that a column or combination of columns uniquely identifies each row of a table.

Which constraint should you define?

  1. Primary key

  2. Secondary key

  3. Foreign key

  4. Default key

Answer: C

Question No: 19

You have a table named Employee that includes four columns. You execute the following statement:

SELECT *

FROM Employee

Which columns are returned?

  1. all columns

  2. only the last column

  3. only the first column

  4. only the first and last columns

Answer: A

Question No: 20

You need to add rows to a database table.

Which Structured Query Language (SQL) keyword should you use?

  1. JOIN

  2. INSERT

  3. CREATE

  4. UPDATE

Answer: A

100% Free Download!
Download Free Demo:98-364 Demo PDF
100% Pass Guaranteed!
Download 2018 EnsurePass 98-364 Full Exam PDF and VCE

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

2018 EnsurePass IT Certification PDF and VCE