Certification Exam Prep Questions For Database Administration Fundamentals (98-364)


QuickStart is now offering assessment questions for Database Administration Fundamentals (98-364) . Whether you are deciding which exam to sign up for, or simply want to practice the materials necessary to complete certification for this course, we have provided a practice assessment to better aid in certification. 100% of the questions are real questions; from a recent version of the test you will take for Database Administration Fundamentals (98-364)


Arrow
 

1

The Productlnventory table and the ReorderList table are shown in the exhibit. The ReorderlD column is an identity column. The ReorderList table stores a record for each product that has been ordered. You need to add rows to the ReorderList table that includes the ProductlD, the current date, and a Quantity of 100 for all products that have a Quantity of 0 in the Productlnventory table. Which statement should you use?

2

Which data type can store a whole number between -200 and 200 with the least amount of storage?

A. tinyint
Incorrect.
B. Float
Incorrect.
C. Int
Incorrect.
D. smallint
Correct!
3

Using a relational database allows you to minimize redundant data and index the data so data can be retrieved:

4

You are creating a stored procedure that accepts a UserlD of type int and retrieves a value that is the concatenated FirstName and LastName values for the user. Which parameter list should you use?

5

Which type of constraint is used to enforce referential integrity?

A. Foreign Key constraint
Correct!
B. Unique constraint
Incorrect.
C. Primary key constraint
Incorrect.
D. Check constraint
Incorrect.
6

You are creating a relational database that includes the tables shown in the exhibit. The InStock and OnOrder columns should have a value of 0 if no value is specified. You have already created the Products table and the Stores table, and need to create the Inventory table. Which statement should you issue?

7

Which command can be used with a previously taken fully backup to recover a database?

A. Create Database
Incorrect.
B. Recover Database
Incorrect.
C. Restore Database
Correct!
D. Alter Database
Incorrect.
8

You have a database that uses three read/write filegroups. The database is configured to use the Full recovery model. You are planning the backup strategy for the database. You need to meet the following requirements: • Disk space required to store the backups should be minimized • The number of transaction log backups that need to be replayed during restoration should be minimized What should your backup plan include?

9

How is data about each instance of an entiry stored in a relational database?

A. As A Table
Incorrect.
B. As A Column in a table
Incorrect.
C. As A File
Incorrect.
D. As A Row in a table
Correct!
10

Which DDL statement should you use to create a database object that can store information?

A. Create table
Correct!
B. Alter
Incorrect.
C. Insert
Incorrect.
D. Create type
Incorrect.
11

You are designing a database to track customer and sales information. You want to minimize redundant data that will be stored in the database. Each customer can place one or more orders. For each order, the customer may order one or more products sold by your company. Which tables should your database design include?

12

What data type can store between one and five characters of alphanumeric data and supports multiple languages with minimal storage space requirements?

A. VARCHAR(5)
Incorrect.
B. CHAR(5)
Incorrect.
C. VARCHAR(1,5)
Incorrect.
D. NVARCHAR(5)
Correct!
13

The EmployeeDependents table includes the following columns: EmployeelD Spouse Childl Child2 Child3 Which statement correctly identifies the normalization level of this table?

14

A reason to use a relational database instead of a flat file database would be to:

15

The requirement that each field value in a table is associated with only one row, is an example of normalizing a database to which form?

A. Fourth normal form
Incorrect.
B. Third normal form
Incorrect.
C. First normal form
Incorrect.
D. Second normal form
Correct!
16

You need to create a module that performs the following tasks: • Accepts an order number • Sets the value of the Status column in the Orders table for that order number to Shipped * Retrieves a tracking number from a table ' Logs shipping information to the Shipping table ▪ Returns the number of items shipped and the customer's e-mail address What should you create?

A. CLR function
Incorrect.
B. Stored procedure
Correct!
C. Table-valued function
Incorrect.
D. Scalar function
Incorrect.
17

Which database object should you create to optimize how the underlying data is phycially accessed by queries?

A. A function
Incorrect.
B. A trigger
Correct!
C. A index
Incorrect.
D. A stored Procedure
Incorrect.
18

What is the purpose of including a COLLATE clause in a column definition?

19

Your database includes the tables shown in the exhibit. You need to allow users to query the ProductlD, StorelD, Description, and Price for only products at stores in California. Which statement should you use?

A. ALTER VIEW
Incorrect.
B. CREATE VIEW
Correct!
C. CREATE INDEX
Incorrect.
D. Structured Query Language (SQL)
Incorrect.
20

You have an empty Product table that you created with the following statement: CREATE TABLE Product ProdID int PRIMARY KEY, CategorylD int NOT NULL, Description varchar(35), QtyOnHand int CHECK (QtyOnHand > 0 AND QtyOnHand <= 50)) Which statement will successfully insert data into the Product table?

21

Users in the Market Analysis department require data from the Customers table and the SalesHistory table. They need to be able to issue a SELECT statement that retrieves the data. They should not be able to access the CreditCard or Expiration column of the Customers table. Which statement should you use to create the object?

A. Create Table
Incorrect.
B. CREATE TRIGGER
Incorrect.
C. CREATE Index
Incorrect.
D. Create View
Correct!
22

What data structure physically stores data in a relational database table that has a single nonclustred index?

A. Heap
Correct!
B. B-tree
Incorrect.
C. Queue
Incorrect.
D. Stack
Incorrect.
23

What is one difference between a stored procedure and a function?

24

Which of the following is a server scoped securable?

A. Index
Incorrect.
B. Login
Correct!
C. schema.
Incorrect.
D. Stored procedure
Incorrect.
25

Which data type can store a floating point value between 0 and 200,000 to four decimal places of accuracy with the least amount of required storage?

A. smallmoney
Correct!
B. money
Incorrect.
C. numeric
Incorrect.
D. Decimal
Incorrect.
26

An index that includes all column used by the query is known as a :

A. Clustered index
Incorrect.
B. Nonclustered
Incorrect.
C. Covering index
Correct!
D. Full-text index
Incorrect.
27

What should you do to allow a user specific permissions on a database object and also allow the user to pass along those permissions to others?

28

What is one reason to denormalize a database?

29

Which clause of an UPDATE statement specifies the columns to be updated and the values to which they should be updated?

A. INTO
Incorrect.
B. SET
Correct!
C. Where
Incorrect.
D. Values
Incorrect.
30

A table named Members exists in a SQL Server 2008 database. The table has a column named Mernt that is configured as an Identity column. You need to write a query that creates a row for a member named Renee Smith with a MemberlD of ; Which Transact-SQL should you use?

PDP Url

Sample Question - Database Administration Fundamentals (98-364)


Self-Paced

Learning Style

Beginner

Difficulty

1 Hour

Course Duration

Certificate

See Sample

Buy Individually
About Individual Course:
  • Individual course plan gives you access to this course
$109.00
$109.00
/ Each

Outline

More Information

More Information
Lab Access No
Learning Style Self-Paced Learning
Difficulty Beginner
Course Duration 1 Hour
Language English

Reviews

Write Your Own Review
Only registered users can write reviews. Please Sign in or create an account

Contact A Learning Consultant


click here