Individuals

Learn how you can get certified, advance your career, and get promoted with our self-paced subscription of over 900 self-paced courses.

Learn More

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

Name: Sample Question - Database Administration Fundamentals (98-364)
SKU: Database Administration Fundamentals (98-364)
Price: 109 USD
Availability: InStock

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)

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.

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.

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:

A. using a data definition language (DDL) trigger.: Incorrect.

B. quickly and easily.: Correct!

C. without writing queries.: Incorrect.

D. as long as no filter is specified: Incorrect.

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.

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?

A. Database backups and differential backups: Incorrect.

B. Database backups and partial backups: Incorrect.

C. Database backups, partial differential backups; and transaction log backups: Incorrect.

D. Database backups, differential backups, and transaction log backups: Correct!

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.

A. @UserlD int: Incorrect.

B. @UserlD int, @FullName varchar(40) OUTPUT: Correct!

C. UserlD int: Incorrect.

D. UserlD int, FullName varchar(40) OUTPUT: Incorrect.

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.

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.

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.

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.

A. The table is normalized to the third normal form.: Incorrect.

B. The table is not normalized.: Correct!

C. The table is normalized to the first normal form: Incorrect.

D. The table is normalized to the second normal form.: Incorrect.

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

A. ensure that only specific users can access certain data.: Incorrect.

B. ensure that aggregate information can be tracked.: Incorrect.

C. allow all information to be stored in a single database table.: Incorrect.

D. minimize the amount of redundant data stored in the database.: Correct!

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!

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.

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

A. To ensure that all values entered in the column fall within a specific range: Incorrect.

B. To specify sorting rules that are different than those used for the other columns in the table: Correct!

C. To create a relationship with a column in a different table: Incorrect.

D. To create a computed column that can be included in an index: Incorrect.

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?

A. INSERT INTO Product (Description, QtyOnHand) VALUES ('Oval Wall Mirror', 15): Incorrect.

B. INSERT INTO Product (ProdID, CategorylD, Description, QtyOnHand) VALUES (101, 2, 'Oval Wall Mirror', 65): Incorrect.

C. INSERT INTO Product VALUES (101, 1, 'Outdoor Extension Cord', 25): Correct!

D. INSERT INTO Product VALUES (101, NULL, 'Outdoor Extension Cord', 25): Incorrect.

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.

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.

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

A. Stored procedures can only perform DML processing.: Incorrect.

B. Functions return only a single scalar or table value.: Correct!

C. Stored procedures must include a RETURNS clause: Incorrect.

D. Functions can accept input values, but stored procedures cannot.: Incorrect.

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

A. Stored procedure: Incorrect.

B. Login: Correct!

C. Index: Incorrect.

D. schema.: Incorrect.

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.

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?

A. Issue an ALTER USER statement specifying the desired permissions: Incorrect.

B. Create a database role and assign the user to the role.: Incorrect.

C. Create an application role.: Incorrect.

D. Grant the user the permissions including the WITH GRANT OPTION clause.: Correct!

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

A. To eliminate redundant data: Incorrect.

B. To provide privacy protection for confidential data: Incorrect.

C. To improve data modification performance: Incorrect.

D. • To improve data retrieval performance: Correct!

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?