MTA: Database Fundamentals

MTA: Database Fundamentals

Contents
 Understanding core database concepts
 Create database objects
 Manipulate data
 Understand data storage
 Administer a database

MTA certifications are a great place to start if you would like to get into the
technology field. MTA certifications address a wide spectrum of fundamental
technical concepts, assess and validate core technical knowledge, and enhance
technical credibility. Note: MTA exams do not qualify for MCP certification, nor are
they a prerequisite for MCSA or MCSD certification.

Job role: Developer

Required exams: 98-364
Important: See details
Go to Certification Dashboard
 MTA: Database Fundamentals

Question #1
The terms "bitmap," "b-tree," and "hash" refer to which type of database structure?

 C. Index

Question #2
One reason to add an index is to:

 C. Improve performance of select statements.

Question #3
You have a table that contains the following data.

You break the table into the following two tables.

This process is referred to as:

 B. normalization
 MTA: Database Fundamentals

Question #4
You have a table that contains the following data.

Which database term is used to describe the relationship between ProductID and
ProductCategory?

 D. Functionally dependent

Question #5
Which key uniquely identifies a row in a table?

 B. primary
 MTA: Database Fundamentals

Question #6
Which statement creates a composite key?

 D. Option D

Question #7
At 3:00 P.M. (1500 hours), you create a backup of your database. At 4:00 P.M.
(1600 hours), you create a table named Customer and import data into the table.
At 5:00 P.M. (1700 hours), your server fails.
You run a script to apply only the 3:00 P.M. backup to your database. What is the
result of the script?

 A. The Customer table no longer exists.

Question #8
In which situation do you need to perform a restore on a database?

 A. when data becomes corrupted in the database

 MTA: Database Fundamentals

Question #9
Which command should you use to give a user permission to read the data in a
table?

 D. GRANT SELECT

Question #10
You need to enable a new employee to authenticate to your database.
Which command should you use?

 B. CREATE USER

Question #11
Which keyword can be used in a create table statement?

 D. UNIQUE

Question #12
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?

 A. INTEGER

Question #13
Which statement will result in the creation of an index?

 A. Option A
 MTA: Database Fundamentals

Question #14
You have the following table definition:

CREATE TABLE Road -

(RoadID INTEGER NOT NULL,
Distance INTEGER NOT NULL)
The Road table contains the following data:

You execute the following statement:

INSERT INTO Road VALUES (1234, 36)
What is the result?

 B. a new row in the table

Question #15
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?

 C. VARCHAR (30)

Question #16
One reason to create a stored procedure is to:

 A. Improve performance.

Question #17
Which permission does a user need in order to run a stored procedure?

 A. EXECUTE
 MTA: Database Fundamentals

Question #18
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:

 A. Empty

Question #19
In SQL, an insert statement is used to add a:

 B. Row of data to a table.

Question #20
You have two tables. Each table has three rows.
How many rows will be included in the Cartesian product of these two tables?

 D. 9

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

 B. SELECT

Question #22
Which constraint ensures a unique value in the ID column for each customer?

 D. PRIMARY KEY

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

 B. Row
 MTA: Database Fundamentals

Question #24
You execute the following statement:
SELECT EmployeeID, FirstName, DepartmentName

FROM Employee, Department -

This type of operation is called a/an:

 D. Cartesian product

Question #25
Which command should you use to add a column to an existing table?

 B. ALTER

Question #26
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.

You execute the following statement:

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

 D. 3

Question #27
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?

 D. LIKE
 MTA: Database Fundamentals

Question #28
A database contains two tables named Customer and Order.
You execute the following statement:

DELETE FROM Order -

WHERE CustomerID = 209 -

What is the result?

 C. All orders for CustomerID 209 are deleted from the Order table.

Question #29
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?

 A. Option A

Question #30
You have a table that contains information about all students in your school.
Which SQL keyword should you use to change a student's first name in the table?

 A. UPDATE
 MTA: Database Fundamentals

Question #31
You need to populate a table named EmployeeCopy with data from an existing
table named Employee.
Which statement should you use?

 D. Option D

Question #32
You execute the following statement:

This statement is an example of a/an:

 A. Subquery
 MTA: Database Fundamentals

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

 A. WHERE

Question #34
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?

 D. Option D
 MTA: Database Fundamentals

Question #35
The Product table contains the following data.

You execute the following statement:

SELECT COUNT(*)
FROM Product WHERE Quantity > 18
What is the value returned by this statement?

 C. 3

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

 C. DROP TABLE

Question #37
You need to store the contact information for each student in your school
database.
You should store each student's information in a:

 C. Row

Question #38
Which category of SQL statements is used to add, remove, and modify database
structures?

 D. Data definition language (DDL)

 MTA: Database Fundamentals

Question #39
You have a Customer table and an Order table. You join the Customer table with
the Order table by using the CusromerID column.
The results include:

All customers and their orders -

✑ Customers who have no orders

Which type of join do these results represent?

 D. Outer join

Question #40
Data in a database is stored in:

 A. Tables

Question #41
You have a table named Student that contains 100 rows. Some of the rows have a
NULL value in the FirstName column.
You execute the following statement:

DELETE FROM Student -

What is the result?

 A. All rows in the table will be deleted.

Question #42
You need to establish a set of permissions that you can routinely assign to new
users.
What should you create?

 D. Role

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

 B. Restore
 MTA: Database Fundamentals

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

 C. Option C

Question #45
Denormalization is performed in order to:

 D. Improve query performance.

Question #46
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's unique ID.
What will make this type of search more efficient?

 D. An index
 MTA: Database Fundamentals

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

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, 'Table', 4444)
What is the result?

 D. a primary key constraint violation

Question #48
Which two keys establish a relationship between two tables? (Choose two.)

 B. foreign
 E. primary

Question #49
One difference between a function and a stored procedure is that a function:

 B. Must return a value.

Question #50
Which keyword must be included in a create view statement?

 D. SELECT
 MTA: Database Fundamentals

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

 D. Option D

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

 D. DROP VIEW EmployeeView

Question #53
A named group of SQL statements that can be executed in a database is called a:

 C. Stored procedure

Question #54
A view can be used to:

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

 MTA: Database Fundamentals

Question #55
On which database structure does an update statement operate?

 A. Table

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

 A. Option A

Question #57
You delete rows in a table named Order. The corresponding rows in the OrderItem
table are automatically deleted. This process is an example of a/an:

 B. Cascade delete
 MTA: Database Fundamentals

Question #58
Which statement deletes the rows where the employee's phone number is not
entered?

 A. Option A

Question #59
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?

 B. Option B
 MTA: Database Fundamentals

Question #60
You have a table named Employee that includes four columns.
You execute the following statement:
SELECT *

FROM Employee -
Which columns are returned?

 A. all columns

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

 A. A name
 D. A data type

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

 C. data type

Question #63
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?

 A. CHAR

Question #64
What is one difference between an update statement and a delete statement?

 C. An update statement does not remove rows from a table.

Question #65
You have a Department table and an Employee table in your database.
You need to ensure that an employee can be assigned to only an existing
department.
What should you apply to the Employee table?

 C. A foreign key
 MTA: Database Fundamentals

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

 B. 100 rows and three columns.

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

 A. INSERT
 C. DELETE
 E. UPDATE

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

 C. create new database users.

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

 A. non-sequential

Question #70
Which statement should you use to remove a foreign key?

 A. ALTER TABLE

Question #71
First normal form requires that a database excludes:

 D. Repeating groups
 MTA: Database Fundamentals

Question #72
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?

 D. No rows will be deleted from the table.

Question #73
You have a table that contains product IDs and product names.
You need to write an UPDATE statement to change the name of a specific product
to glass.
What should you include in the update statement?

 A. SET ProduetName = 'glass'

Question #74
Your database contains a table named Customer.
You need to delete the record from the Customer table that has a CusromerID of
12345.
Which statement should you use?

 D. Option D
 MTA: Database Fundamentals

Question #75
On which database structure does an insert statement operate?

 E. Table

Question #76
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?

 B. WHERE

Question #77
You have the following table definition:

CREATE TABLE Product -

(ProductID INTEGER,
Name VARCHAR(20))
You need to insert a new product. The product's name is Plate and the product's ID
is 12345.
Which statement should you use?

 D. Option D
 MTA: Database Fundamentals

Question #78
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.
Hot Area:

Question #79
HOTSPOT -
The following graphic shows the components of a SQL Server application. You
access the SQL Server application through Internet Explorer.

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

Hot Area:

Question #80
You have the database table named Cars as defined below:

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

How many rows are returned by the SQL statement?

 A. 4
 MTA: Database Fundamentals

Question #81
You have a database table named SongInformation as defined below:

You need to create a Structured Query Language (SQL) query to retrieve only the
names of songs that sold more than 1000 compact discs (CDs).
Which query should you use?

 A. Option A

Question #82
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:

When volunteer information changes, you must update the table.

You need to change Tia's name to Kimberly.
Which statement should you choose?
 MTA: Database Fundamentals

 A. Option A

Question #83
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
"No change is needed." If the statement is incorrect, select the answer choice that
makes the statement correct

 D. WHERE

Question #84
You need to combine the results of two queries into a single result that contains all
of the rows from both queries.
Which Structured Query Language (SQL) statement should you use?

 D. UNION

Question #85
This question requires that you evaluate the underlined text to determine if it is
correct.
The CREATE TABLE command removes one or more table definitions and all
data, indexes, triggers, constraints, and permission specifications for those tables.
Instructions: Review the underlined text. If it makes the statement correct, select
"No change is needed." If the statement is incorrect, select the answer choice that
makes the statement correct

 B. DROP TABLE

Question #86
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?

 C. Foreign key
 MTA: Database Fundamentals

Question #87
HOTSPOT -
The following illustration shows the structure of a clustered index in a single
partition:

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

Question #88
HOTSPOT -
You have the following table:

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

Question #89
While attending college, you accept an IT internship at a local charity. The charity
needs to report on data that is related and exists in two tables.
You need to establish a relationship between the data that is in the two tables.
Which constraint should you define?

 B. Index key

Question #90
This question requires that you evaluate the underlined text to determine if it is
correct.
A view can be used to ensure referential integrity.
Instructions: Review the underlined text. If it makes the statement correct, select
"No change is needed." If the statement is incorrect, select the answer choice that
makes the statement correct

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

 MTA: Database Fundamentals

Question #91
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.
Select and Place:

Question #92
DRAG DROP -
You have a database table that stores information about school attendance.
You have a data set that is defined as follows:

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.
 MTA: Database Fundamentals

Select and Place:

Question #93
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.
Hot Area:
 MTA: Database Fundamentals

Question #94
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
"No change is needed." If the statement is incorrect, select the answer choice that
makes the statement correct

 D. Row

Question #95
This question requires that you evaluate the underlined text to determine if it is
correct.
You have two tables. Each table has three rows. You create a SQL query that uses
a cross join. The query does not include a WHERE clause.
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
"No change is needed." If the statement is incorrect, select the answer choice that
makes the statement corrector.

 A. No change is needed

Question #96
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?

 B. Primary key
 MTA: Database Fundamentals

Question #97
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.
Select and Place:

Question #98
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
"No change is needed." If the statement is incorrect, select the answer choice that
makes the statement correct.

 D. CREATE
 MTA: Database Fundamentals

Question #99
You need to rename a column in a database table.
Which data definition language (DDL) statement should you use?

 A. ALTER

Question #100
DRAG DROP -
You have two database tables as defined below. The first table contains
information about students. The second table contains information about courses.
The two tables are related by CourseID.

Match the CourseName to the StudentName.

Instructions: To answer, drag the appropriate CourseName from the column on the
left to its StudentName on the right. Each CourseName may be used once, more
than once, or not at all. Each correct match is worth one point.
Select and Place:
 MTA: Database Fundamentals

Question #101
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
"No change is needed." If the statement is incorrect, select the answer choice that
makes the statement correct.

 C. Data definition language (DDL) statements

Question #102
You need to add rows to a database table.
Which Structured Query Language (SQL) keyword should you use?

 A. JOIN

Question #103
You need to retrieve data from two related database tables based on a column that
exists in both tables.
Which command should you use in a query?

 B. UNION

Question #104
You have a database table that contains the following columns:

You must insert the following record into the table:

Which two Structured Query Language (SQL) statements can you use? (Choose
 MTA: Database Fundamentals

two.)

 B. Option B
 C. Option C

Question #105
This question requires that you evaluate the underlined text to determine if it is
correct.
The JOIN 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
"No change is needed." If the statement is incorrect, select the answer choice that
makes the statement correct

 B. INTERSECT

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

You need to normalize the data to third normal form.

How many tables should you create?

 C. 3
 MTA: Database Fundamentals

Question #107
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:

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

 A. ChapterId
 E. City
 MTA: Database Fundamentals

Question #108
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.
Hot Area:

Question #109
This question requires that you evaluate the underlined text to determine if it is
correct.
You combine data from three tables into one table. The new table includes
redundancy to optimize read performance.
The data in the new table has been denormalized.
Instructions: Review the underlined text. If it makes the statement correct, select
"No change is needed." If the statement is incorrect, select the answer choice that
makes the statement correct.

 A. No change is needed

Question #110
You need to delete a database table.
Which data definition language (DDL) keyword should you use?

 C. DROP
 MTA: Database Fundamentals

Question #111
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
"No change is needed." If the statement is incorrect, select the answer choice that
makes the statement correct.

 D. SELECT

Question #112
Your class project requires that you help a charity to create a website that registers
volunteers.
The website must store the following data about the volunteers:
✑ Given name
✑ Surname
✑ Telephone number
✑ Email address
You need to recommend a correct way to store the data.
What do you recommend?

 A. Create a table that contains columns that are named given name, surname,
phone number, and email.

Question #113
This question requires that you evaluate the underlined text to determine if it is
correct.
Truncate is a database term used to describe the process of applying a backup to
a damaged or corrupt database.
Instructions: Review the underlined text. If it makes the statement correct, select
"No change is needed." If the statement is incorrect, select the answer choice that
makes the statement corrector.

 D. Restore
 MTA: Database Fundamentals

Question #114
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
"No change is needed." If the statement is incorrect, select the answer choice that
makes the statement correct

 B. GRANT SELECT

Question #115
HOTSPOT -
You have a user that has server roles as defined below:

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

Question #115

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

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

Question #116

HOTSPOT -
The following illustration shows backup strategies that use the simple recovery
model and the full recovery model:

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

Question #117
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.
Hot Area:

Question #118
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
"No change is needed." If the statement is incorrect, select the answer choice that
makes the statement correct

 D. Tables

Question #119
You have two tables named Cars and Color as defined below. The two tables are
related by ColorId.

You run the following SQL statement: select:

 MTA: Database Fundamentals

How many rows does the SQL statement return?

 C. 3

Question #120
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.
When volunteers ask to be removed from mailing lists, the table must be updated.
You need to use a transaction to ensure that the database has data integrity and
referential integrity.
Which statement should you use?

 A. Option A

Question #121
This question requires that you evaluate the underlined text to determine if it is
correct.
ALTER TABLE removes all rows from a table without logging the individual row
deletions.
Instructions: Review the underlined text. If it makes the statement correct, select
"No change is needed." If the statement is incorrect, select the answer choice that
makes the statement correct.

 C. TRUNCATE TABLE
 MTA: Database Fundamentals

Question #122
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?

 A. Money

Question #123
This question requires that you evaluate the underlined text to determine if it is
correct.
A row holds information for a single record in a table.
Instructions: Review the underlined text. If it makes the statement correct, select
"No change is needed." If the statement is incorrect, select the answer choice that
makes the statement correct

 A. No change is needed

Question #124
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.
Hot Area:
 MTA: Database Fundamentals

Question #125
This question requires that you evaluate the underlined text to determine if it is
correct.
Ports 20 and 21 are the default ports to secure a SQL Server.
Instructions: Review the underlined text. If it makes the statement correct, select
"No change is needed." If the statement is incorrect, select the answer choice that
makes the statement correct.

 B. 1433 and 1434

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

Which syntax should you use to create the object?

 A. Option A
 MTA: Database Fundamentals

Question #127
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?

 D. Stored procedure

Question #128
This question requires that you evaluate the underlined text to determine if it is
correct.
First normal form requires that a database excludes repeating groups.
Instructions: Review the underlined text. If it makes the statement correct, select
"No change is needed." If the statement is incorrect, select the answer choice that
makes the statement correct.

 A. No change is needed.

Question #129
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.

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

Question #130
You have the following SQL query
SELECT * FROM dbo.ProAthlete WHERE Salary > 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?

 D. Foreign key

Question #131
You work for a small auto trading company. You need to remove a car from the
company database.
Information about the car is stored in the following tables.

All of the car's parts are custom made, so they each have a row in every table.
Cascading deletes are not enabled but referential integrity is.
From which table must you first make your deletion?

 A. Make
 MTA: Database Fundamentals

Question #132
This question requires that you evaluate the underlined text to determine if it is
correct.
You have a table that contains information about all students in your school.
You use the INSERT SQL keyword to change a student's given name in the table.
Instructions: Review the underlined text. If it makes the statement correct, select
`No change is needed.` If the statement is incorrect, select the answer choice that
makes the statement correct.

 B. UPDATE

Question #133
You create the following table, which lists how many books you have on loan to
your friends.

Harry in San Francisco returns your books.

Which statement will update your table correctly?

 A. UPDATE LoanedBooks SET Books = 0 WHERE (Name = 'Harry' AND City =

'San Francisco')

Question #134
You are developing a SQL query.
Which two SQL constructs represent data manipulation language (DML)
statements? Choose two.

 A. SELECT EmployeeName FROM Employee WHERE EmployeeName = 'Jack

Smith';
 B. INSERT INTO Employee VALUES ('Jack Smith')
 MTA: Database Fundamentals

Question #135
You need to create a view to filter rows of data from an underling table.
Which type of clause must be included in the CREATE VIEW statement?

 B. WHERE

Question #136
This question requires that you evaluate the underlined text to determine if it is
correct.
A key defines the amount of storage space that is allocated to a value in a column.
Instructions: Review the underlined text. If it makes the statement correct, select
"No change is needed." If the statement is incorrect, select the answer choice that
makes the statement correct

 C. data type

Question #137
This question requires that you evaluate the underlined text to determine if it is
correct.
A relational database management system employs the concept of an attribute to
ensure that data entered into a field in a column is valid.
Instructions: Review the underlined text. If it makes the statement correct, select
"No change is needed." If the statement is incorrect, select the answer choice that
makes the statement correct.

 C. a constraint

Question #138
HOTSPOT -
You are structuring a table in a relational database.
Instructions: For each of the following statement, select Yes if the statement is true.
Otherwise, select No. Each correct selection is worth one point.
 MTA: Database Fundamentals

Hot Area:

Question #139
You have a database that contains 10 terabytes of data. You need to back up the
database every two hours.
Which type of backup should you use?

 C. partial

Question #140
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
"No change is needed." If the statement is incorrect, select the answer choice that
makes the statement correct

 B. INTERSECT

Question #141
Mark works as a Database Administrator for ExamTopics Inc.
The company has a SQL Server database.
Management instructs him to ensure that no inconsistent data is entered in the
database.
Which of the following will help him to accomplish the task?

 A. Referential integrity
 MTA: Database Fundamentals

Question #142
Which of the following statements about rebuilding an index is true?

 C. Without the ONLINE keyword the index is locked for any DML operation.

Question #143
You work as a database developer for www.company.com.com.
The company has a database named www.company.com that is hosted on a SQL
Server 2008 server. The database includes a table named Employees, which
contains the details of the employees.
You want to ensure that anytime any data in the Employees table is modified with
an UPDATE statement, they are recorded in a table named EmployeeChanges.
The EmployeeChanges table includes columns to record what the change was,
who made the change, and when they made the change.
What should you create to meet this need?

 B. A DML trigger that queries the inserted table

Question #144
You want to recover one or more tablespaces to a point in time older than the rest
of the database.
Which of the following are the recovery situations in which tablespace Point-in-
Time Recovery (TSPITR) should be used? Each correct answer represents a part
of the solution. (Choose all that apply.)

 A. To recover a tablespace that contains rollback segments

 B. To recover a table that has become logically corrupted
 C. To recover a DML statement that has affected only a subset of the database

Question #145
Linda works as a Database Designer for Lion Inc.
She has been given an assignment to design the database of a publishing
company.
The database has a table named Author, which has a composite key, AuthorID and
TitleID. Royalty and LiteraryAgent are the other attributes.
The functional dependencies are such that AuthorID + TitleID-> Royalty (i.e.
Royalty is functionally dependent on AuthorID and TitleID) and AuthorID->
LiteraryAgent (i.e. LiteraryAgent is functionally dependent on AuthorID).
Which of the following is true about this table?

 B. It violates 2 NF.
 MTA: Database Fundamentals

Question #146
Which of the following is a management activity that allows the stages of the
database application to be realized as efficiently and effectively as possible?

 A. Database planning

Question #147
You work as a Database Administrator for Bell Ceramics Inc.
An employee of the company has fired a query, including a DML statement, such
as INSERT, against a table named Sales.
You notice that the DML statement has not executed.
What will you do to resolve the issue? Each correct answer represents a complete
solution. (Choose two.)

 B. Add more space to the tablespace and increase the users quota on the

 D. Provide an appropriate privilege or create views on the Sales table, and grant
privileges on the view.

Question #148
Which of the following is the process of extracting trails on a regular basis so that
they can be transferred to a designated security system where the database
administrators do not have access?

 A. Native auditing

Question #149
You manage a large database named Sales.
The Sales database contains a table named OrderDetails, which is a heavily
transacted table with frequent inserts.
Indexes in the table often become fragmented due to excessive page splitting.
You want to minimize the amount of fragmentation due to page splits. What should
you do?

 B. Change the fillfactor for the indexes to 60.

 MTA: Database Fundamentals

Question #150
You are the database administrator of a MySQL server that runs on a Windows
server.
All clients are local clients.
For security, you want to disable connections from the remote clients.
Which of the following steps will you take to accomplish the task?

 C. Start the server with the --skip-networking option.

Question #151
Which of the following statements is true about referential integrity?

 D. It checks that no record in a child table can exist if its corresponding record is
not available in the parent table.

Question #152
Which of the following are DML commands? Each correct answer represents a
complete solution. (Choose all that apply.)

 A. SELECT INTO
 B. DELETE
 C. UPDATE
 F. INSERT

Question #153
Which of the following commands can be used to change the authorization type in
DB2 9? Each correct answer represents a complete solution. (Choose all that
apply.)

 A. UPDATE DATABASE CONFIGURATION

 D. UPDATE DBM CFG

Question #154
Smith works as a Database Administrator for ExamTopics Inc.
The management instructs him to plan a database where identifying the key
objects or entities for database management is important.
Which of the following database planning steps will help him to accomplish the
task?

 A. Object identification
 MTA: Database Fundamentals

Question #155
You are a database developer for a database named Customers hosted on a SQL
Server 2008 server.
Recently, several customers were deleted from the Customers database.
To ensure this is not repeated in future, you have decided to create a DML trigger
to prevent it.
What code will create the trigger to meet your goals? Each correct answer
represents a complete solution. (Choose all that apply.)

 B. CREATE TRIGGER trgDeleteCustomer ON dbo.Customers AFTER DELETE

AS RAISERROR('Customers cannot be deleted. An error has been logged', 16,
10) WITH LOG ROLLBACK TRANSACTION
 D. CREATE TRIGGER trgDeleteCustomer ON dbo.Customers AFTER DELETE
AS IF (SELECT COUNT(*) FROM DELETED) > 0 BEGIN
RAISERROR('Customers cannot be deleted. An error has been logged', 16, 10)
WITH LOG ROLLBACK TRANSACTION END

Question #156
JDBC API 2.0 defines five levels of transaction isolation for database concurrency
control.
Which of the following is the lowest level of transaction isolation?

 B. TRANSACTION_NONE

Question #157
Which of the following provides reliable units of work that allow correct recovery
from failures and keeps a database consistent even in cases of system failure?

 D. Database transaction

Question #158
John works as a Database Administrator for Bluewell Inc.
The company has a SQL Server database.
A table in the database has a candidate key and an attribute that is not a
constituent of the candidate key. The non-key attribute depends upon the whole of
the candidate key rather than just a part of it.
Which of the following normal forms is represented in the scenario?

 B. 2 NF
 MTA: Database Fundamentals

Question #159
You work as a Database Designer for DataOneWorld Inc.
The company has a SQL Server database.
You are assigned the task of creating a data model of an enterprise based on a
specific data model. The model to be created should be independent of a particular
DBMS.
Which of the following database designs will help you accomplish the task?

 A. Logical database design

Question #160
Which of the following steps in database planning helps to determine the
requirements of the database through interviewing?

 A. Gathering information

Question #161
Consider the case of a fruit juice company.
The company manufactures fruit juices and supplies them to wholesalers.
The Database Designer creates a table named Production.
The code is given below:

Which of the above-mentioned lines has an error?

 B. Line 2

Question #162
John works as a Database Administrator for DataOneWorld Inc.
The company has a SQL Server database.
John wants to insert records in a table where the database is structured in a fixed
format.
Which of the following data models will he use to accomplish the task?

 D. Relational model
 MTA: Database Fundamentals

Question #163
You manage a database named Customers, which includes a table named Orders.
The Orders table is frequently queried, but only orders with a sales total of more
than $1000.00 are required in the query.
You want to create an index to speed up these types of queries at the same time,
ensuring the index is as small as possible.
What type of index should you use?

 B. Filtered

Question #164
Which of the following database terms is described in the statement below?
It prevents the current database operation from reading or writing a data item while
the data item is being accessed by another operation.

 A. Lock

Question #165
Your Company is designing and developing a number of databases for a stock
exchange.
One of the databases will contain highly sensitive data for which high level of
security will be required. Although high processing speed is one of the prime
requirements of the customer, for this database, security of the data will take
priority over the processing speed. It needs to be ensured that even if unauthorized
access to the database is obtained, the rogue user is unable to read the data.
Which of the following protection techniques will you suggest for this database?

 B. Encryption

Question #166
Which of the following are the main approaches in the database design? Each
correct answer represents a complete solution. (Choose three.)

 A. Top-down approach
 B. Bottom-up approach
 D. Inside-out approach
 MTA: Database Fundamentals

Question #167
You are a Database Administrator of MySQL database.
Few days back, your server crashed. Now, it is up and online.
You need to check the integrity of various tables used in the database.
You need to issue the CHECK TABLE command.
For which of the following tables will this command work? Each correct answer
represents a complete solution. (Choose two.)

 B. MyISAM
 D. InnoDB

Question #168
Which of the following can be used to populate a table? Each correct answer
represents a complete solution. (Choose all that apply.)

 A. Data Pump
 B. SQL*Loader
 C. INSERT statement
 D. MERGE statement

Question #169
Which of the following statements about external tables is true?

 B. They cannot be written to with DML commands.

Question #170
Which of the following values cannot be stored in a character column defined as
the primary key of a table?

 A. null

Question #171
Mark works as a Database Administrator for DataOneWorld Inc.
Management instructs him to provide an additional security layer to the database to
prevent unauthorized viewing of data with the help of an algorithm called cipher.
Which of the following will help him to accomplish the task?

 C. Encryption
 MTA: Database Fundamentals

Question #172
Which of the following is a design of the user interface and the application
programs that use and process the database?

 A. Application Design

Question #173
Which of the following is used to give a default value to a column if the value for
that column is unknown?

 B. DEFAULT constraint

Question #174
Suzanne works as a Database Designer for DataOneWorld Inc.
She is assigned the task of decomposing the components of a database, but she
has to ensure that all the components are decomposed to only some extent.
Which of the following approaches will she use to accomplish the task?

 A. Mixed approach

Question #175
Consider the case of a distance education university.
The university has many regional centers across the country.
Each regional center has a head known as regional manager.
Each regional center has allotted more than one study center in its region.
Each regional center has a region code, which is unique and specifies a region.
Each study center also has a study center code, which is also unique.
What is the relationship between regional center and study center?

 B. One-to-many

Question #177
You work as a Database Administrator for DataOneWorld Inc.
Management instructs you to remove an object from the relational database
management system.
Which of the following statements will you use to accomplish the task?

 A. DROP
 MTA: Database Fundamentals

Question #178
Which of the following enables a user to use generic methods to access a
database and to focus on the coding rather than the syntax for a specific database
API?

 A. Abstraction

Question #179
You work as a Database Administrator for InfoTech Inc.
The company has a database and they want you to create a design for a database
that will support the enterprise's operations and objectives.
Which of the following will you use to accomplish the task?

 B. Database design

Question #180
Which of the following scripts is used to convert Unix-type zone files into SQL
statements, and loads the time zone tables in a mysql database?

 A. mysql_tzinfo_to_sql

Question #182
In addition to taking backups of your databases, you should also backup up files
stated below.
Which of these files store updates that have been made after the backup was
made?

 A. Binary log files

Question #183
Which of the following is a building working model of a database system?

 A. Prototyping
 MTA: Database Fundamentals

Question #184
You are the database administrator for a MySQL database server.
The network contains new and old (pre-4.1) clients.
You configure another database server on the network.
You allow the network clients to connect to the new server.
Some users complain that when they try to connect to the server, they receive the
following error:
ERROR 1251: The client does not support authentication protocol requested by the
server; consider upgrading MySQL client
You do not want to upgrade any client or server right now, and want to enable all
clients to connect to the new server successfully.
Which of the following steps will you take to resolve the issue?

 B. Run the server with the --old-password option.

Question #185
Which of the following steps in database planning is used to record an object so
that it is represented visually in the system?

 D. Object modeling

Question #187
What is the relationship between the foreign key and primary key? Each correct
answer represents a complete solution. (Choose all that apply.)

 A. A foreign key constraint works in conjunction with a primary key constraint to

enforce referential integrity among related entities.
 B. A foreign key ties attribute(s) of an entity to the primary key of another entity, for
the purpose of creating a dependency.

Question #188
Which of the following DML SQL statements support usage of correlated sub-
queries? Each correct answer represents a complete solution. (Choose all that
apply.)

 B. UPDATE
 D. SELECT
 MTA: Database Fundamentals

Question #189
Which of the following are the types of prototyping strategies? Each correct answer
represents a complete solution. (Choose two.)

 A. Requirements prototyping
 D. Evolutionary prototyping

Question #190
Which of the following commands cannot be rolled back? Each correct answer
represents a complete solution. (Choose two.)

 B. TRUNCATE
 D. COMMIT

Question #191
Mark works as a Database Designer for Reon Inc.
He is assigned the task to create a database for the company.
He issues the following query to create the database:
CREATE DATABASE '24342'
What will be the output of the query?

 A. A database will be created.

Question #192
What is the ideal time to back up dynamic log files?

 C. When the server is stopped.

Question #193
You work as a ExamTopics MySQL Database Administrator.
Your server crashed and it was recovered and made online within half an hour.
What will you do to ensure that the table structure and contents are in a proper
state?

 D. Perform a table check operation.

 MTA: Database Fundamentals

Question #194
James works as an Administrator for Softech Inc.
The company has a SQL Server 2005 computer named SQL1.
The company has six departments; Accounting, Sales, Marketing, Manufacturing,
Production, and Research. The user accounts of each department are located in a
domain group named after the department. James wants to create a separate
database on SQL1 for each department which will store the department related
information. Users in each department must be able to read and update data in the
database belonging to their respective departments.
No user must be able to access the database belonging to another department.
James wants to configure access to the database to meet these requirements.
What should James do to accomplish the task?

 B. James should create a Windows Authentication login for each domain group
and configure the logins as database users for the appropriate database. Add each
database user to the db_datareader and db_datawriter database roles.

Question #195
You are the database administrator for a MySQL database.
The database server is installed on a Unix system.
The time zone files for the system are located at /usr/share/zoneinfo.
You need to ensure that the system and MySQL time zones are based on the
same information.
Which of the following statements will you use to accomplish the task?

 D. shell> mysql_tzinfo_to_sql /ust/share/zoneinfo | mysql -u root mysql

Question #196
Which of the following is the process of creating a design for the database that will
support the enterprise's operations and objectives for the required database
system?

 B. Database design
 MTA: Database Fundamentals

Question #197
You manage a database named Exams accessed via a website.
The website is regularly accessed by users in different countries.
You are redesigning a table named History that records when users have
purchased and taken online exams.
You need one of the columns in the History table to record what time of day that a
user has taken an exam.
Additionally, you need this column to have time zone awareness.
What data type should you use?

 A. datetimeoffset

Question #198
Fill in the blank with the appropriate word.
The _______________ model for database management is a database model
based on first-order predicate logic.

 A. relational

Question #199
You work as a Database Administrator for Dowtech Inc.
A table named StudentInformation exists in a database.
The table has columns named student_names, student_marks, and
student_courses.
Some students who have opted for various courses have got different marks in
them.
This implies that the table has two many-to-many relationships.
You have to ensure that these two relationships are not represented in a single
table and that the student_name column exists in both tables.
Which of the following normal forms will you use to represent these relationships in
the tables?

 A. 4 NF ( 4th form normal)

Question #200
Which of the following are the steps of database planning life cycle? Each correct
answer represents a part of the solution. (Choose three.)

 A. Application Design
 B. Data conversion and loading
 D. Operational Maintenance
 MTA: Database Fundamentals

Question #201
You manage a SQL Server 2008 server that hosts a database named Sales.
Unauthorized modifications to some tables within the Sales database have resulted
in some views no longer working.
You need to implement a method that will ensure that all modifications to any
objects with the Sales database are logged.
What should you do?

 A. Create a DDL trigger with database scope.

Question #202
Which of the following is an ANSI approved language for communicating and
managing data in a relational database management system (RDBMS)?

 A. SQL

Question #203
A company named Rel Inc. has many authorized dealers across the country who
sell their products.
The Sales Manager of the company wants to see the details of the authorized
dealers, including the name, region, and total sales in ascending order of sales.
Which of the following queries should be issued to get the desired output?

 D. SELECT Name, Region, Totalsales FROM Dealer ORDER BY Totalsales

Question #204
You work as ExamTopics Database Administrator for a MySQL database server.
In an hour or so, you are able to bring a corrupted server online.
You execute the CHECK TABLE command and find that some of the InnoDB
tables need to be repaired.
You restart the server and discover that auto-recover has failed.
Which of the following steps will you take to recover the corrupted InnoDB tables?

 D. Run the OPTIMIZE TABLE command.

 MTA: Database Fundamentals

Question #205
Mark works as a Database Administrator for DataOneWorld Inc.
The company has a SQL Server database.
Management instructs him to verify the identity of a user or software that is
connecting to the database.
Which of the following will help him to accomplish the task?

 D. Authentication

Question #206
Which of the following are the characteristics of application design? Each correct
answer represents a complete solution. (Choose three.)

 A. Output of the transaction

 C. Data can be used from the transaction
 D. Expected rate of usage

Question #207
John works as a database designer in ABC Tech.
He wants to produce a description of a database implemented on secondary
storage media.
Which of the following designs will he implement to accomplish the task?

 D. Physical database design

Question #208
You have developed a stored procedure named usp_GetEmp that accepts an
employee number as a parameter and retrieves the details about the employee
from the CurrentEmp table of a database named Employees.
You have tested it, and it works exactly as you expected.
Later, another employee tries to use the stored procedure and receives the
following error:
The SELECT permission was denied on the object 'CurrentEmp', database
'Employees.schema 'dbo'
What should you do to resolve the problem?

 A. Modify usp_GetEmp to include the With Execute As Owner clause

 MTA: Database Fundamentals

Question #209
Peter works as a Database Administrator for DataOneWorld Inc.
The company has a SQL Server database. Peter has to construct an Entity-
Relationship schema design for the data he will use in the database.
Which of the following database designs will he use to accomplish the task?

 B. Conceptual database design

Question #210
You are taking back up of your MySQL database server.
You need to take a back up of the file that has been created by the replication
slave server and contains information needed for connecting to the master server.
Which of the following files will you copy?

 A. Master.info

Question #211
Which of the following is the process of collecting and analyzing information about
the part of the organization that is to be supported by the database application?

 B. Requirements collection and analysis

Question #212
Which of the following statements is true regarding a composite key in a table?

 B. It is a primary or foreign key that consists of two or more attributes of the table.

Question #213
Which of the following approaches begins with the identification of only a few
important concepts and, based on these, the design proceeds, spreading outward
`˜radially'?

 A. Inside-out approach
 MTA: Database Fundamentals

Question #214
You have created a database for employee management. The database has a
table named Employees. The table has the following attributes:

Name -

Address -

Contact Number -

Designation -
You want to store the salary information for each employee. The database should
also store salary history. How will you design the database so that you can query
the last increment given to a particular employee?

 B. Create a new table that includes the EmployeeID, EmployeeSalary, and

DateOfIncrement columns. Create a one-to-many relationship with the Employees
table.

Question #215
Philandrio Inc. is one of the largest drug manufacturing companies in the world.
It has many offices worldwide. Each office has a manpower of approximately
14,000.
The managers themselves are employees in the company.
You are building a database for the company's Human Resources Department
(HRD).
You want to track the following attributes for each employee, and at the same time,
eliminate duplicate entries and minimize data storage wherever possible.

FirstName -
MiddleName -
LastName -
EmployeeldentityNumber -
Address -
Date_of_Hire -
Department -
Salary -

ManagerIdentityNumber -
Which of the following is the appropriate table detail sufficient to track the above
attributes, correctly and efficiently?

 A. Only one table, Employee

 MTA: Database Fundamentals

Question #216
Mark works as the Database Administrator for DataWorld Inc.
The company has a SQL server 2008 database.
Mark wants to protect the database from unintended activities made by authorized
individuals or processes such as authenticated misuse, malicious attacks, or
inadvertent mistakes.
Which of the following should he use to accomplish the task?

 D. Database security

Question #217
Which of the following files contain configuration information that must be restored
after a MySQL database server has crashed? Each correct answer represents a
complete solution. (Choose two.)

 A. My.ini
 B. My.cnf

Question #218
John works as a Database Administrator in www.company.com Inc.
The company has a SQL Server database.
John wants to create a table named employees in the database.
The table will have the id, firstname, lastname, and dateofbirth columns.
John has to ensure that the lastname column does not allow null values.
Which of the following queries will he use to accomplish the task?

 A. CREATE TABLE employees (id INTEGER PRIMARY KEY, firstname

CHAR(50)NULL, lastname CHAR (75)NOT NULL, dateofbirth DATE NULL);

Question #219
Which of the following statements are true regarding DML? Each correct answer
represents a complete solution. (Choose all that apply.)

 A. It enables users to access/manipulate data in a database.

 D. It can be procedural or declarative.
 MTA: Database Fundamentals

Question #220
You work as a Database Designer for Realtech Inc.
You want to create two tables, Product and Order, such that a row in the Order
table does not exist without a corresponding row in the Product table.
The structure of the Product and Order tables with their respective columns is
given below:

Product -
ProductID -
ProductNumber -
Date_of_ manufacturing -
SupplierID -
ProductPrice -
ProductQty -
Order -
OrderID -
OrderDate -
OrderQuantity -
OrderPrice -
Based on this information, while maintaining the integrity of this rule, what will you
do to accomplish the task?

 D. Create the Product table, and then create the Order table that has a foreign key
constraint that references the primary key in the Product table.

Question #221
Peter works as a Database Administrator for UnrealTech Inc.
Management instructs him to create a schema that is gradually expanded from one
level to another through appropriate modifications.
Which of the following approaches will he use to accomplish the task?

 A. Top down approach

 MTA: Database Fundamentals

Question #222
You are a database developer for a database named Sales hosted on a SQL
Server 2008 server.
The Sales database includes the Exams and ExamQuestions tables.
If any questions are modified for an exam, you need to ensure that the
ExamModifiedDate in the Exams table is updated with the date and time of the
update. The
ExamQuestions table includes an INSTEAD OF trigger that records when and who
last modified each question.
Therefore, you decide to create a trigger.
You only want the trigger to fire if a constraint violation has not occurred.
Which of the following code will create the trigger to meet your goals?

 B. CREATE TRIGGER trgExamQuestionsModified ON dbo.ExamQuestions

AFTER UPDATE NOT FOR REPLICATION AS UPDATE Exams SET
ExamModifiedDate = GetDate() FROM inserted WHERE inserted.ExamID =
Exams.ExamID

Question #223
You are the database administrator of a MySQL database server.
Your network contains a combination of new and old (pre-4.1) MySQL clients.
You are configuring a new server for testing purposes.
You want to allow connections only by the clients that have new-format passwords.
Which of the following steps will you take to accomplish the task?

 B. Start the server with the --secure-auth option.

Question #224
Which of the following commands are used to terminate a transaction? Each
correct answer represents a complete solution. (Choose all that apply.)

 A. TRUNCATE
 C. ROLLBACK
 D. COMMIT

Question #225
Which of the following refers to the system, processes, and procedures that protect
a database from unintended activities, such as authenticated misuse, malicious
attacks, or inadvertent mistakes made by authorized individuals or processes?

 A. Database security
 MTA: Database Fundamentals

Question #226
Which of the following is undertaken at any time prior to the logical design,
provided that sufficient information is available regarding system requirements?

 C. DBMS selection

Question #227
Mark works as a Database Administrator for Techworld Inc.
He wants to remove the columns from a table that are not dependent on the
primary key.
Which of the following normal forms will help him accomplish the task?

 D. 3 NF

Question #228
You are a Database Administrator for MySQL database.
Users are complaining of slow query execution in a few tables.
You need to ensure that contents of those tables are accessed more efficiently.
You are sure that the table structure and its contents have no problems.
Which of the following steps will you take to accomplish the task? Each correct
answer represents a part of the solution. (Choose two.)

 A. Perform a table analysis operation.

 C. Perform a table optimization operation.

Question #229
Which of the following are the correct statements of using the Flashback Query
feature in Oracle? Each correct answer represents a complete solution. (Choose
all that apply.)

 A. CREATE TABLE AS SELECT AS OF

 B. SELECT AS OF

Question #230
Which of the following statements are correct regarding recovery of the InnoDB
tables after a server crash? Each correct answer represents a complete solution.
(Choose all that apply.)

 B. They are automatically recovered at the server startup.

 D. The innodb_force_recovery option opens the InnoDB tables in the read-only
mode.
 MTA: Database Fundamentals

Question #231
Adam works as a Database Designer for DataOne Inc.
The company has a SQL Server database. Adam has to ensure that either all the
databases are updated or none of them are updated, so that the databases remain
synchronized.
Which of the following will he use to accomplish the task?

 B. Two-phase commit

Question #232
Meryl works as a Database Designer for Klone Inc.
She wants to create a table named Emp.
She issues the following query:

CREATE Table Emp (id Int -

UNSIGNED NOT NULL AUTO_INCREMENT
PRIMARY KEY name Char(10))
What will happen after executing this query?

 C. The query will fail because the id and name attributes must be separated by a
comma.

Question #233
James works as a Database Administrator for DataOneWorld Inc.
The company has a SQL Server database.
James has been assigned the task to store information for each object in the
database.
Which of the following steps will help him accomplish the task?

 A. Identifying the information for objects

Question #234
Which of the following terms is described in statement below?
It is a collection of conceptual tools for describing data, data relationship, data
semantics, and consistency constraints.

 A. Data mode
 MTA: Database Fundamentals

Question #235
You work as an Application Developer for Nero Inc.
You want to instruct the DBMS to set the transaction isolation level so that when a
user updates a table in the database, other users cannot read the value at the
same time.
Which of the following methods will you use to define the transaction level?

 A. setTransactionIsolation()