MTA 98-364 RESUME

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?

• 4 NF

• 3 NF

• 2 NF

• 1 NF

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?

• Logical database design

• Conceptual database design

• Physical database design

• Application design

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:

1.CREATE Table Production

2.(Fruit_type VarChar,

3.Fruit_name Char(20),

4.Quantity Int(3))

Which of the above-mentioned lines has an error?

• Line 1

• Line 2

• Line 3

• Line 4

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?

• Object relational data model

• Entity-Relationship Model

• Network data model

• Relational model

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?

• Non-clustered

• Filtered

• clustered

• XML

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?

• Authentication

• Encryption

• Native auditing

• Integrity controls

Raj has the cycle database setup for his dad’s cycle shop in India. The next step is to work with his dad to learn what operations he will need to perform with the database. These are called user requirements.

His dad needs the new application to perform these initial tasks (other requirements will be defi ned later):

• Create various inventory reports

• Produce sales reports (by cycle model, price, and so on)

• Add new inventory to the system when it arrives

• Change the cost of cycles and parts as necessary

• Remove cycles from the database when they are sold

What DML (data manipulation language) command must be used to indicate that a cycle was sold and should be removed from the Cycle table?

• DELETE FROM Cycle WHERE cycle _ id = T1234

• REMOVE FROM Cycle WHERE cycle _ id = T1234

• ERASE FROM Cycle WHERE cycle _ id = T1234

SCENARIO: Raj has the cycle database setup for his dad’s cycle shop in India. The next step is to work with his dad to learn what operations he will need to perform with the database. These are called user requirements.

His dad needs the new application to perform these initial tasks (other requirements will be defi ned later):

• Create various inventory reports

• Produce sales reports (by cycle model, price, and so on)

• Add new inventory to the system when it arrives

• Change the cost of cycles and parts as necessary

• Remove cycles from the database when they are sold

What command is used to report on the current on-hand quantities of red cycles?

• SELECT cycle _ model WHERE cycle _ color = ‘red’

• SELECT * FROM Cycle WHERE cycle _ color = ‘red’

• FIND * FROM Cycle WHERE cycle _ color = ‘red’

SCENARIO: Raj has the cycle database setup for his dad’s cycle shop in India. The next step is to work with his dad to learn what operations he will need to perform with the database. These are called user requirements.

His dad needs the new application to perform these initial tasks (other requirements will be defi ned later):

• Create various inventory reports

• Produce sales reports (by cycle model, price, and so on)

• Add new inventory to the system when it arrives

• Change the cost of cycles and parts as necessary

• Remove cycles from the database when they are sold

How is a new cycle added to the Cycle table in the database?

• INSERT INTO Cycle (C3425, ‘Rockrider, ‘red’, 9999.00)

• ADD INTO Cycle VALUES (C3425, ‘Rockrider’, ‘red’, 9999.00)

• INSERT INTO Cycle VALUES (C3425, ‘Rockrider’, ‘red’, 9999.00)

SCENARIO: Raj is making excellent progress automating his dad’s cycle shop. He has reduced the amount of paperwork and provided more accurate information for his dad to maintain the current inventory. As a result of the automation, his dad has decided that he wants to use a website to advertise and sell cycles. Raj is in charge of the next phase of this exciting change to the cycle shop business. Raj immediately realizes that the current database schema needs to be changed. If they are going to allow users to buy from the internet, he needs to have photos of all their products, including cycles, accessories, and parts.

Which DDL command can Raj use to add a new field to the Cycle table to store the filename of the photo?

• ALTER TABLE Cycle ADD photo _ file _ name CHAR (30) NULL

• ADD photo _ file _ name TO TABLE Cycle

• ALTER Cycle TABLE USING photo _ file _ name CHAR(30) NULL