98-364 Exam Questions
238 real 98-364 exam questions with expert-verified answers and explanations. Page 1 of 5.
- Question #1
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?
- Question #2
Which of the following is a building working model of a database system?
- Question #3
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...
- Question #4
Which of the following steps in database planning is used to record an object so that it is represented visually in the system?
- Question #5
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...
- Question #6
What is the relationship between the foreign key and primary key? Each correct answer represents a complete solution. Choose all that apply.
- Question #7
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...
- Question #8
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...
- Question #9
Which of the following statements about rebuilding an index is true?
- Question #10
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...
- Question #12
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...
- Question #13
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...
- Question #14
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...
- Question #15
Which of the following statements is true about referential integrity?
- Question #16
Which of the following are DML commands? Each correct answer represents a complete solution. Choose all that apply.
- Question #18
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.
- Question #19
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...
- Question #20
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...
- Question #21
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?
- Question #22
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?
- Question #23
Which of the following DML SQL statements support usage of correlated sub-queries? Each correct answer represents a complete solution. Choose all that apply.
- Question #24
Which of the following are the types of prototyping strategies? Each correct answer represents a complete solution. Choose two.
- Question #25
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...
- Question #26
Which of the following commands cannot be rolled back? Each correct answer represents a complete solution. Choose two.
- Question #27
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...
- Question #28
What is the ideal time to back up dynamic log files?
- Question #29
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...
- Question #30
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...
- Question #31
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...
- Question #32
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...
- Question #33
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?
- Question #34
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...
- Question #35
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...
- Question #37
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...
- Question #38
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...
- Question #39
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...
- Question #40
Which of the following is an ANSI approved language for communicating and managing data in a relational database management system (RDBMS)?
- Question #41
Examine the following table: What is the degree of this table?
- Question #42
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...
- Question #43
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...
- Question #44
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...
- Question #45
Which of the following are the characteristics of application design? Each correct answer represents a complete solution. Choose three.
- Question #46
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...
- Question #47
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...
- Question #48
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...
- Question #49
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...
- Question #50
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....
- Question #51
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...
- Question #52
Which of the following statements are true regarding DML? Each correct answer represents a complete solution. Choose all that apply.
- Question #53
Which of the following is NOT a valid DDL command?