98-364 Exam Questions

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?

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

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

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

Remo works as a Database Designer for Tech Inc. He wants to create a table named Product. He issues the following query to create the Product table: - CREATE Product ( - ProductID...

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

Mark works as a Database Administrator for DataWorld Inc. The company has a SQL Server database. Management instructs him to ensure that no inconsistent data is entered in the data...

You work as a Database Designer for Netwell Inc. The database has a table named Project, which is depicted below: - ProjectID - ProjectName - TaskID - TaskName - A - Macwell - Desi...

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

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

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

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

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

Which of the following statements is true about referential integrity?

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

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.

Smith works as a Database Administrator for DWorlds Inc. The management instructs him to plan a database where identifying the key objects or entities for database management is im...

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

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?

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?

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

Which of the following are the types of prototyping strategies? Each correct answer represents a complete solution. Choose two.

A table named Emp is given below that contains data of an organization. How many records will be displayed if the following SQL query is executed? - SELECT * - FROM Emp - WHERE Nam...

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

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

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

You work as a 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 co...

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

Two tables, namely, OrderItem and Item are depicted below in which all attributes mentioned therein respectively, refer to column heading labels. If the ItemName attribute is moved...

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

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?

You work as a Database Designer for Hitech Inc. You are designing a database named Project. The company takes projects from outside and divides them into tasks (design, coding, etc...

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

You are designing a database for a sports hostel. In the hostel, a player can be enrolled for multiple games. You are working on a relation shown in the image below: Which of the f...

You are designing a database for a sports hostel. There are three types of buildings for which a fixed fee is charged on per room basis. No player can take two accommodations. You...

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

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

Examine the following table: What is the degree of this table?

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

You work as the 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...

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

Which of the following are the characteristics of application design? Each correct answer represents a complete solution. Choose three.

Consider the conceptual database design, depicting the relationship between two entities. The relationship among Author, Title, and Order is represented by the ER-diagram given bel...

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

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

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

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

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

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

Which of the following is NOT a valid DDL command?