QUESTION 101
You are modifying a database that is used as a backend for a web site. The web site developers want to include positional data that can be used by the web site users to determine store locations information that is stored in the Stores table of the database. You are asked to add a column to the Stores table. What data type should you use?
A. varchar
B. nvarchar
C. geography
D. GPS
Correct Answer: C
QUESTION 102
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.
A. They can only be recovered from the dump files.
B. They are automatically recovered at the server startup.
C. They are recovered only after restarting the server with the innodb_force_recovery option configured.
D. The innodb_force_recovery option opens the InnoDB tables in the read-only mode.
Correct Answer: BD
QUESTION 103
Which of the following ensures referential integrity between tables?
A. Foreign key
B. CHECK constraint
C. Index
D. Primary key
Correct Answer: A
QUESTION 104
John works as a Database Administrator for www.company.com Inc. The company has a SQL server 2008 database. John wants to define a valid data while adding or updating an entry in a table of a relational database. Which of the following should he use to accomplish the task?
A. Locking hints
B. Check constraint
C. Stored procedure
D. View
Correct Answer: B
QUESTION 105
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?
A. Native auditing
B. Two-phase commit
C. Encryption
D. Concurrency control
Correct Answer: B
QUESTION 106
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?
A. The query will fail, as the id and name attributes are created in lowercase.
B. The query will execute partially, as it will create the table but will fail to create the attributes.
C. The query will fail because the id and name attributes must be separated by a comma.
D. The query will create a table named Emp.
Correct Answer: C
QUESTION 107
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
B. Object modeling
C. Object identification
D. Identifying the relationships between objects
Correct Answer: A
QUESTION 108
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 model
B. Generic Data Model
C. Relational model
D. Entity-Relationship Model
Correct Answer: A
QUESTION 109
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
EmployeeIdentityNumber
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
B. Three tables, Employee, Manager, and a table to link both these entities
C. Two tables, Employee and Manager
D. Either two or three tables
Correct Answer: A
QUESTION 110
You work as a Database Administrator for Softech Inc. The company has a database that contains a table named Emp. The Emp table has the EmpId, Name, Department, and Designation attributes. Recently, the table was modified by adding the Phone attribute. Some employees have more than one phone number.
Which of the following statements is true about the Emp table?
A. It violates 1NF.
B. It violates 2NF.
C. It violates 3NF.
D. It does not violate any normal form.
Correct Answer: A
Free VCE & PDF File for Microsoft 98-364 Real Exam
Instant Access to Free VCE Files: MCSE|MCSA|MCITP…
Instant Access to Free PDF Files: MCSE|MCSA|MCITP…
100-105 Dumps VCE PDF
200-105 Dumps VCE PDF
300-101 Dumps VCE PDF
300-115 Dumps VCE PDF
300-135 Dumps VCE PDF
300-320 Dumps VCE PDF
400-101 Dumps VCE PDF
640-911 Dumps VCE PDF
640-916 Dumps VCE PDF
70-410 Dumps VCE PDF
70-411 Dumps VCE PDF
70-412 Dumps VCE PDF
70-413 Dumps VCE PDF
70-414 Dumps VCE PDF
70-417 Dumps VCE PDF
70-461 Dumps VCE PDF
70-462 Dumps VCE PDF
70-463 Dumps VCE PDF
70-464 Dumps VCE PDF
70-465 Dumps VCE PDF
70-480 Dumps VCE PDF
70-483 Dumps VCE PDF
70-486 Dumps VCE PDF
70-487 Dumps VCE PDF
220-901 Dumps VCE PDF
220-902 Dumps VCE PDF
N10-006 Dumps VCE PDF
SY0-401 Dumps VCE PDF