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

Following are four different types of constraints in database. You want to enforce referential integrity. Can you identify which of these constraints will you use for that purpose?

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

Can you identify from the options below, the data type that has the ability to store a whole number between -200 and 200 with the least amount of storage?

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

Complete the sentence by choosing one of the options. With a relational database you can minimize data that is redundant and index the data in order to retrieve data:

4

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.
5

You company is operating a database that uses three read/write filegroups. The configuration of database allows the use of Full recovery model. The database needs to have a backup strategy and you decide to prepare it. Following are some requirements that are a must: -Storing backups requires disk space. That disk space must be minimized. -Transaction log backups are required to be replayed while restoration. The number of transaction log backups must be minimized What should your backup plan include?

6

You create a stored procedure. A UserlD of type int is accepted by the procedure and reflects a concatenated value of FirstName and LastName of the user. Identify the parameter list you should use given the situation above.

7

Can you identify the form how a relational database stores data about each instance of an entry?

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

You want to create a database object in which information can be stored. Identify the correct DDL statement for this purpose.

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

Identify the type of data that can store alphanumeric data between one and five characters. This data type also supports multiple languages. Keep in mind the data type needs minimal storage space for this. Which data type is it?

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

Following are the columns in the table EmployeeDependents: EmployeelD Spouse Childl Child2 Child3 You want to identify the normalization level of this table. Choose a statement that correctly does that.

11

You will use a relational database in place of a flat file database because it will:

12

There is a requirement that says each field value in a table is associated with only one row. Can you identify which form of database normalizing can this be?

A. third normal form
Incorrect.
B. first normal form
Incorrect.
C. Fourth normal form
Incorrect.
D. Second normal form
Correct!
13

You want to optimize how the underlying data is accessed by queries physically. Identify the database object you must create.

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

A COLLATE clause is included in a column definition. What could be the purpose of that?

15

Following is the statement you used to create an empty Product Table: CREATE TABLE Product ProdID int PRIMARY KEY, CategorylD int NOT NULL, Description varchar(35), QtyOnHand int CHECK (QtyOnHand > 0 AND QtyOnHand <= 50)) Can you identify the statement with which you can insert data into the Product table successfully?

16

You have employees working in the Market Analysis department. These users need data from the Customers table and the SalesHistory table. They have to retrieve data by issuing a SELECT statement. They must be prevented from accessing the data in CreditCard or Expiration column of the Customers table. Identify the statement you would use to create the object.

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

There is a relational database table with a single nonclustered index. Can you identify the data structure that can physically store data in that type of relational database table?

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

Can you identify one valid difference between a function and a stored procedure?

19

From the options below, can you identify a server scoped securable?

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

There is a data type that can store a floating-point value between 0 and 200,000 to four decimal places of accuracy with the least amount of required storage. Can you identify which of the following is that type?

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

You want to provide a user specific permission on a database object. You also want that user to be able to pass along permissions to other users when needed. What would be your step of action?

22

You want to denormalize a database. Can you identify one reason of doing that?

23

From the following options, choose the right clause of an UPDATE statement that specifies the columns to be updated and also specifies the values to which they should be updated?

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

You need to identify the index that includes all columns a query has used.

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

Sample Question - Database Administration Fundamentals (98-364)

$99.00

More Information:

  • Learning Style: On Demand
  • Learning Style: Practice Exam
  • Difficulty: Beginner
  • Course Duration: 1 Hour
  • Course Info: Download PDF
  • Certificate: See Sample

Need Training for 5 or More People?

Customized to your team's need:

  • Annual Subscriptions
  • Private Training
  • Flexible Pricing
  • Enterprise LMS
  • Dedicated Customer Success Manager

Outline

Reviews

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

Hit button to validate captcha