[Free] 2017(Oct) EnsurePass Passguide Microsoft 98-364 Dumps with VCE and PDF 71-80

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

Database Fundamentals

Question No: 71

You have a table named Product that contains the following data.

Ensurepass 2017 PDF and VCE

The PrcducrID column is the primary key. The CategoryID column is a foreign key to a separate table named Category.

You execute the following statement: INSERT INTO Product

VALUES (3296, #39;Table#39;, 4444)

What is the result?

  1. a foreign key constraint violation

  2. a syntax error

  3. a new row in the Product table

  4. a primary key constraint violation

  5. a new row in the Category table

Answer: D

Question No: 72 HOTSPOT

Instructions: For each of the following statements, select Yes if the statement is true. Otherwise, select No. Each correct selection is worth one point.

Ensurepass 2017 PDF and VCE

Answer:

Ensurepass 2017 PDF and VCE

Explanation:

Ensurepass 2017 PDF and VCE

C:\Users\Kamran\Desktop\image – Copy.jpg

Question No: 73

You have a table named Employee that includes the following columns:

EmployeeID Smp1oyeeName

Which statement should you use to return the number of rows in the table?

Ensurepass 2017 PDF and VCE

  1. Option A

  2. Option B

  3. Option C

  4. Option D

Answer: D

Question No: 74

Which keyword must be included in a create view statement?

  1. WHERE

  2. ORDER BY

  3. UPDATE

  4. SELECT

Answer: D

Question No: 75

You need to delete a database table.

Which data definition language (DDL) keyword should you use?

  1. ALTER

  2. DELETE

  3. DROP

  4. TRUNCATE

Answer: C

Question No: 76

Which key uniquely identifies a row in a table?

  1. foreiqn

  2. primary

  3. local

  4. superkey

Answer: B

Question No: 77 HOTSPOT

You have a user that has server roles as defined below:

Ensurepass 2017 PDF and VCE

Instructions: Use the drop-down menus to select the answer choice that completes each statement. Each correct selection is worth one point.

Ensurepass 2017 PDF and VCE

Answer:

Ensurepass 2017 PDF and VCE

Ensurepass 2017 PDF and VCE

Explanation:

C:\Users\Kamran\Desktop\image – Copy.jpg

Question No: 78

One difference between a function and a stored procedure is that a function:

  1. Must be called from a trigger.

  2. Must return a value.

  3. Cannot contain a transaction.

  4. Cannot accept parameters.

Answer: B

Question No: 79

This question requires that you evaluate the underlined text to determine if it is correct. You have two tables. Each table has three rows.

Nine rows will be included in the Cartesian product of these two tables.

Instructions: Review the underlined text. If it makes the statement correct, select quot;No change is needed.quot; If the statement is incorrect, select the answer choice that makes the statement corrector.

  1. No change is needed

  2. Zero

  3. Three

  4. Six

Answer: A

Question No: 80

You execute the following statement:

Ensurepass 2017 PDF and VCE

This statement is an example of a/an:

  1. Subquery

  2. Union

  3. Outer join

  4. Cartesian product

Answer: A

100% Free Download!
Download Free Demo:98-364 Demo PDF
100% Pass Guaranteed!
Download 2017 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

2017 EnsurePass IT Certification PDF and VCE

[Free] 2017(Oct) EnsurePass Passguide Microsoft 98-364 Dumps with VCE and PDF 61-70

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

Database Fundamentals

Question No: 61

You have a table named Product that contains one million rows.

You need to search for product information in the Product table by using the product#39;s unique ID.

What will make this type of search more efficient?

  1. A cursor

  2. A subquery

  3. A trigger

  4. An index

Answer: D

Question No: 62

You need to rename a column in a database table.

Which data definition language (DDL) statement should you use?

  1. ALTER

  2. INSERT

  3. CREATE

  4. UPDATE

Answer: A

Question No: 63 HOTSPOT

Instructions: For each of the following statements, select Yes if the statement is true. Otherwise, select No. Each correct selection is worth one point.

Ensurepass 2017 PDF and VCE

Answer:

Ensurepass 2017 PDF and VCE

Explanation:

Ensurepass 2017 PDF and VCE

C:\Users\Kamran\Desktop\image – Copy.jpg

Question No: 64 HOTSPOT

Instructions: For each of the following statements, select Yes if the statement is true. Otherwise, select No. Each correct selection is worth one point.

Ensurepass 2017 PDF and VCE

Answer:

Ensurepass 2017 PDF and VCE

Ensurepass 2017 PDF and VCE

Explanation:

C:\Users\Kamran\Desktop\image – Copy.jpg

Question No: 65

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?

  1. View

  2. Table

  3. Function

  4. Stored procedure

Answer: D

Question No: 66

You assign User1 a set of permissions that include the WITH GRANT OPTION. The WITH GRANT OPTION enables User1 to:

  1. request a log of permission use.

  2. delegate permissions to other users.

  3. create new database users.

  4. view other users#39; permissions.

Answer: C

Question No: 67

You are writing an SQL statement to retrieve rows from a table. Which data manipulation language (DML) command should you use?

  1. READ

  2. SELECT

  3. OUTPUT

  4. GET

Answer: B

Question No: 68

Which database term is used to describe the process of applying a backup to a damaged or corrupt database?

  1. Recover

  2. Restore

  3. Commit

  4. Attach

Answer: B

Question No: 69

This question requires that you evaluate the underlined text to determine if it is correct. Use the ALLOW SELECT command to give a user permission to read the data in a table.

Instructions: Review the underlined text. If it makes the statement correct, select quot;No change is needed.quot; If the statement is incorrect, select the answer choice that makes the statement correct

  1. No change is needed

  2. GRANT SELECT

  3. LET HEAD

  4. PERMIT READ

Answer: B

Question No: 70

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?

  1. INTEGER

  2. DOUBLE

  3. COUNT

  4. FLOAT

Answer: A

100% Free Download!
Download Free Demo:98-364 Demo PDF
100% Pass Guaranteed!
Download 2017 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

2017 EnsurePass IT Certification PDF and VCE

[Free] 2017(Oct) EnsurePass Passguide Microsoft 98-364 Dumps with VCE and PDF 51-60

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

Database Fundamentals

Question No: 51

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:

  1. Empty

  2. Deleted

  3. Unchanged

  4. Archived

Answer: A

Question No: 52

You have two tables named Salesperson and Sales.

You need to ensure that each record in the Sales table has a valid associated salesperson record in the Salesperson table.

Which database object should you add to the Sales table?

  1. Nonclustered index

  2. Primary key

  3. Foreign key

  4. Clustered index

Answer: B

Question No: 53

This question requires that you evaluate the underlined text to determine if it is correct. Create a query that returns a set of table data by using the UPDATE statement.

Instructions: Review the underlined text. If it makes the statement correct, select quot;No change is needed.quot; If the statement is incorrect, select the answer choice that makes the statement correct.

  1. No change is needed

  2. INSERT

  3. REPLACE

  4. SELECT

Answer: D

Question No: 54

A view can be used to:

  1. Save an extra copy of data stored in a separate table.

  2. Limit access to specific rows or columns of data in a table.

  3. Ensure referential integrity.

  4. Save historical data before deleting it from the base table.

Answer: B

Question No: 55

Which keyword would you use in a select statement to return rows that meet a specific condition?

  1. WHERE

  2. UNION

  3. ORDER BY

  4. FROM

Answer: A

Question No: 56

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?

  1. VARCHAR (3, 30)

  2. CHAR (3, 30)

  3. VARCHAR (30)

  4. CHAR (30)

Answer: C

Question No: 57

You have a table that contains the following data.

Ensurepass 2017 PDF and VCE

You break the table into the following two tables.

Ensurepass 2017 PDF and VCE

This process is referred to as:

  1. defragmentation

  2. normalization

  3. fragmentation

  4. denormalization

Answer: B

Question No: 58

This question requires that you evaluate the underlined text to determine if it is correct.

Use the FROM keyword in a SELECT statement to return rows that meet a specific condition.

Instructions: Review the underlined text. If it makes the statement correct, select quot;No change is needed.quot; If the statement is incorrect, select the answer choice that makes the statement correct

  1. No change is needed

  2. ORDER BY

  3. UNION

  4. WHERE

Answer: D

Question No: 59

This question requires that you evaluate the underlined text to determine if it is correct. Views are database objects that contain all of the data in a database.

Instructions: Review the underlined text. If it makes the statement correct, select quot;No change is needed.quot; If the statement is incorrect, select the answer choice that makes the statement correct

  1. No change is needed

  2. Queries

  3. Stored procedures

  4. Tables

Answer: D

Question No: 60

You need to list the name and price of each product, sorted by price from highest to lowest. Which statement should you use?

Ensurepass 2017 PDF and VCE

  1. Option A

  2. Option B

  3. Option C

  4. Option D

Answer: A

100% Free Download!
Download Free Demo:98-364 Demo PDF
100% Pass Guaranteed!
Download 2017 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

2017 EnsurePass IT Certification PDF and VCE

[Free] 2017(Oct) EnsurePass Passguide Microsoft 98-364 Dumps with VCE and PDF 41-50

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

Database Fundamentals

Question No: 41

You execute the following statement:

SELECT EmployeeID, FirstName, DepartmentName FROM Employee, Department

This type of operation is called a/an:

  1. Intersection

  2. Outer join

  3. Equi-join

  4. Cartesian product

Answer: D

Question No: 42

You have a table named Customer. You need to add a new column named District. Which statement should you use?

Ensurepass 2017 PDF and VCE

  1. Option A

  2. Option B

  3. Option C

  4. Option D

Answer: D

Question No: 43 HOTSPOT

Instructions: For each of the following statements, select Yes if the statement is true. Otherwise, select No. Each correct selection is worth one point.

Ensurepass 2017 PDF and VCE

Answer:

Ensurepass 2017 PDF and VCE

Explanation:

Ensurepass 2017 PDF and VCE

C:\Users\Kamran\Desktop\image – Copy.jpg

Question No: 44

The terms quot;bitmap,quot; quot;b-tree,quot; and quot;hashquot; refer to which type of database structure?

  1. View

  2. Function

  3. Index

  4. Stored procedure

  5. Trigger

Answer: C

Question No: 45

Which two elements are required to define a column? (Choose two.)

  1. A name

  2. A key

  3. An index

  4. A data type

Answer: A,D

Question No: 46

What defines the amount of storage space that is allocated to a value in a column?

  1. format

  2. key

  3. data type

  4. validator

Answer: C

Question No: 47

Which command should you use to remove a table from a database?

  1. REMOVE TABLE

  2. UPDATE TABLE

  3. DROP TABLE

  4. DELETE TABLE

Answer: C

Question No: 48

You have the following table definition: CREATE TABLE Product

(ID INTEGER PRIMARY KEY, Name VARCHAR(20),

Quantity INTEGER)

The Product table contains the following data.

Ensurepass 2017 PDF and VCE

You execute the following statement:

SELECT Name FROM Product WHERE Quantity IS NOT NULL How many rows are returned?

  1. 0

  2. 1

  3. 2

  4. 3

  5. 4

Answer: D

Question No: 49

This question requires that you evaluate the underlined text to determine if it is correct.

The UNION keyword combines the results of two queries and returns only rows that appear in both result sets.

Instructions: Review the underlined text. If it makes the statement correct, select quot;No change is needed.quot; If the statement is incorrect, select the answer choice that makes the

statement correct

  1. No change is needed

  2. INTERSECT

  3. ALL

  4. UOIN

Answer: B

Question No: 50

You have the database table named Cars as defined below:

Ensurepass 2017 PDF and VCE

You have the following Structured Query Language (SQL) statement:

Ensurepass 2017 PDF and VCE

How many rows are returned by the SQL statement?

  1. 4

  2. 5

  3. 6

  4. 7

Answer: A

100% Free Download!
Download Free Demo:98-364 Demo PDF
100% Pass Guaranteed!
Download 2017 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

2017 EnsurePass IT Certification PDF and VCE

[Free] 2017(Oct) EnsurePass Passguide Microsoft 98-364 Dumps with VCE and PDF 31-40

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

Database Fundamentals

Question No: 31

This question requires that you evaluate the underlined text to determine if it is correct. Use the ALTER statement to add a new table in a database.

Instructions: Review the underlined text. If it makes the statement correct, select quot;No change is needed.quot; If the statement is incorrect, select the answer choice that makes the statement correct.

  1. No change is needed

  2. UPDATE

  3. INSERT

  4. CREATE

Answer: D

Question No: 32

You ate creating a database object named Student to store the following data:

Ensurepass 2017 PDF and VCE

Which syntax should you use to create the object?

Ensurepass 2017 PDF and VCE

  1. Option A

  2. Option B

  3. Option C

  4. Option D

Answer: A

Question No: 33 DRAG DROP

You have a database table that stores information about school attendance. You have a data set that is defined as follows:

Ensurepass 2017 PDF and VCE

You have the following requirements:

->StudentName must consist of a string of characters.

->GradeLevel must be only a whole number.

->DaysAbsent can have one number after the decimal.

Match the data types to the column names.

Instructions: To answer, drag the appropriate data type from the column on the left to its column name on the right Each data type may be used once, more than once, or not at all. Each correct match is worth one point.

Ensurepass 2017 PDF and VCE

Answer:

Ensurepass 2017 PDF and VCE

Explanation:

Ensurepass 2017 PDF and VCE

C:\Users\Kamran\Desktop\image – Copy.jpg

Question No: 34

You are creating a table to store customer data. The AccountNumber column uses values that always consist of one letter and four digits. Which data type should you use for the AccountNumber column?

  1. CHAR

  2. BYTE

  3. DOUBLE

  4. SMALLINT

Answer: A

Question No: 35

You accept an IT internship at a local charity. The charity asks you to keep a record of its volunteers by using a database table named Volunteer.

The table has the following columns and rows:

Ensurepass 2017 PDF and VCE

When volunteer information changes, you must update the table. You need to change Tia#39;s name to Kimberly.

Which statement should you choose?

Ensurepass 2017 PDF and VCE

  1. Option A

  2. Option B

  3. Option C

  4. Option D

Answer: A

Question No: 36

You accept an IT internship at a local charity. The charity has two tables in their data model named Chapter and Language, as defined below:

Ensurepass 2017 PDF and VCE

You create a third table named ChapterLanguage to relate the Chapter table and the Language table.

You need to select columns from the Chapter and Language tables to create a composite primary key for the ChapterLanguage table.

Which two columns should you select? (Choose two.)

  1. ChapterId

  2. LanguageId

  3. Country

  4. Region

  5. City

  6. LanguageName

Answer: A,E

Question No: 37

You are writing a select statement to find every product whose name contains a specific character.

Which keyword should you use in your where clause?

  1. FIND

  2. BETWEEN

  3. INCLUDES

  4. LIKE

Answer: D

Question No: 38

This question requires that you evaluate the underlined text to determine if it is correct. In a database table, each column represents a unique record.

Instructions: Review the underlined text. If it makes the statement correct, select quot;No change is needed.quot; If the statement is incorrect, select the answer choice that makes the statement correct

  1. No change is needed

  2. Table

  3. Index

  4. Row

Answer: D

Question No: 39 HOTSPOT

The following graphic shows the components of a SQL Server application. You access the SQL Server application through Internet Explorer.

Ensurepass 2017 PDF and VCE

Instructions: Use the drop-down menus to select the answer choice that completes each statement. Each correct selection is worth one point.

Ensurepass 2017 PDF and VCE

Answer:

Ensurepass 2017 PDF and VCE

Explanation:

Ensurepass 2017 PDF and VCE

C:\Users\Kamran\Desktop\image – Copy.jpg

Question No: 40

The component that holds information for a single entry in a table is called a:

  1. Data type

  2. Row

  3. Column

  4. View

Answer: B

100% Free Download!
Download Free Demo:98-364 Demo PDF
100% Pass Guaranteed!
Download 2017 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

2017 EnsurePass IT Certification PDF and VCE

[Free] 2017(Oct) EnsurePass Passguide Microsoft 98-364 Dumps with VCE and PDF 21-30

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

Database Fundamentals

Question No: 21

You have a table of products with fields for ProductID, Name, and Price.

You need to write an UPDATE statement that sets the value in the InStock field to Yes for a specific ProductID.

Which clause should you use in your update statement?

  1. THAT

  2. WHERE

  3. GROUP BY

  4. HAVING

Answer: B

Question No: 22

What are three valid data manipulation language (DML) commands? (Choose three.)

  1. INSERT

  2. COMMIT

  3. DELETE

  4. OUTPUT

  5. UPDATE

Answer: A,C,E

Explanation: http://en.wikipedia.org/wiki/Data_manipulation_language

Data manipulation languages have their functional capability organized by the initial word in a statement, which is almost always a verb. In the case of SQL, these verbs are:

SELECT … FROM … WHERE … INSERT INTO … VALUES …

UPDATE … SET … WHERE … DELETE FROM … WHERE …

Question No: 23 DRAG DROP

You need to set up a database to provide a view of North American mammals. Match the Structured Query Language (SQL) statements to the SQL query.

Instructions: To answer, drag the appropriate SQL statement from the column on the left to its place in the SQL query on the right Each SQL statement may be used once, more than once, or not at all. Each correct match is worth one point.

Ensurepass 2017 PDF and VCE

Answer:

Ensurepass 2017 PDF and VCE

Ensurepass 2017 PDF and VCE

Explanation:

C:\Users\Kamran\Desktop\image – Copy.jpg

Question No: 24

This question requires that you evaluate the underlined text to determine if it is correct. Use indexing to create, remove, or change database objects.

Instructions: Review the underlined text. If it makes the statement correct, select quot;No change is needed.quot; If the statement is incorrect, select the answer choice that makes the statement correct.

  1. No change is needed.

  2. Data manipulation language (DML) statements

  3. Data definition language (DDL) statements

  4. A unique constraint

Answer: C

Question No: 25 HOTSPOT

You have two database tables as defined below. The StateID column is unique in the State table. The AddressID column is unique in the Address table. The two tables are related by the StateID column.

Ensurepass 2017 PDF and VCE

Instructions: Use the drop-down menus to select the answer choice that completes each statement. Each correct selection is worth one point.

Ensurepass 2017 PDF and VCE

Answer:

Ensurepass 2017 PDF and VCE

Explanation:

Ensurepass 2017 PDF and VCE

C:\Users\Kamran\Desktop\image – Copy.jpg

Question No: 26

You need to store the contact information for each student in your school database.

You should store each student#39;s information in a:

  1. Stored procedure

  2. Function

  3. Row

  4. Variable

Answer: C

Question No: 27

You need to disable User1#39;s access to view the data in the Customer table. Which statement should you use?

Ensurepass 2017 PDF and VCE

  1. Option A

  2. Option B

  3. Option C

  4. Option D

Answer: C

Question No: 28

You need to store the first name, last name, and student ID for 100 students. This information will be stored in a table as:

  1. 100 items and three cells.

  2. 100 rows and three columns.

  3. three rows and 100 columns.

  4. three items and 100 cells.

Answer: B

Question No: 29

Which statement creates a composite key?

Ensurepass 2017 PDF and VCE

  1. Option A

  2. Option B

  3. Option C

  4. Option D

Answer: D

Question No: 30 DRAG DROP

Your class project requires that you help a charity set up a website.

The website collects information about volunteers. Each volunteer record must be uniquely identified.

The following information is stored for each volunteer:

->Given name

->Surname

->Date of birth

->Phone number

->Photo

You need to create a table to meet the requirements.

Match the Structured Query Language SQL statements to the SQL query.

Instructions: To answer, drag the appropriate SQL statement from the column on the left to its place in the SQL query on the right. Each SQL statement may be used once, more than once, or not at all. Each correct match is worth one point.

Ensurepass 2017 PDF and VCE

Answer:

Ensurepass 2017 PDF and VCE

Ensurepass 2017 PDF and VCE

Explanation:

C:\Users\Kamran\Desktop\image – Copy.jpg

100% Free Download!
Download Free Demo:98-364 Demo PDF
100% Pass Guaranteed!
Download 2017 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

2017 EnsurePass IT Certification PDF and VCE

[Free] 2017(Oct) EnsurePass Passguide Microsoft 98-364 Dumps with VCE and PDF 11-20

EnsurePass
2017 Oct 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 2017 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 2017 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 2017 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 2017 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 2017 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

2017 EnsurePass IT Certification PDF and VCE

[Free] 2017(Oct) EnsurePass Passguide Microsoft 98-364 Dumps with VCE and PDF 1-10

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

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 2017 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 2017 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 2017 PDF and VCE

You must insert the following record into the table:

Ensurepass 2017 PDF and VCE

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

Ensurepass 2017 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% Free Download!
Download Free Demo:98-364 Demo PDF
100% Pass Guaranteed!
Download 2017 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

2017 EnsurePass IT Certification PDF and VCE