98-364 Exam Questions

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

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

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

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

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

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

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

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

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

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

Which of the following ensures referential integrity between tables?

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

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

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

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

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

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

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

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

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

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.

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

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

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

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

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

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

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

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

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

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

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

Which of the following statements about external tables is true?

You work as a Database Designer for SoftTech Inc. You have developed the conceptual design of the database of an organization. Following is the ER-diagram, which you have designed....

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

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

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

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

Suzanne works as a Database Designer for DataOneWorld Inc. She is assigned the task of ecomposing the components of a database, but she has to ensure that all the components are de...

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

Server 2000, and all client computers run Windows XP rofessional and Windows Vista. named COMPANY-DB111, which you administer at a regular interval of time. COMPANY-DB111 contains...

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

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?

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

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?

You work as a Database Designer for Tritech Inc. You are designing a table named Info. The table contains the following attributes: - Login and Password - Name - ContactNumber - Ad...

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

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?

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

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'?