98-364 - Database Fundamentals
Go back to Microsoft
How much does the 98-364 exam cost?
The 98-364 exam is $127. The exam provider is Pearson Vue and you can register for the exam on their website.
What is the best way to study for the 98-364 exam?
The best way to study for the 98-364 exam is to practice at Exam.com.
Which database term is used to describe the process of applying a backup to a damaged or corrupt database?
Which of the following is a design of the user interface and the application programs that use and process the database?
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?
Which permission does a user need in order to run a stored procedure?
Which key uniquely identifies a row in a table?
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 more efficiently. You are sure that the table structure and its contents have no problems. Which of the following steps will you take to accomplish the task? Each correct answer represents a part of the solution. Choose two.
Perform a table analysis operation.
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.
They can only be recovered from the dump files.
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 regional center has allotted more than one study center in its region. Each regional center has a region code, which is unique and specifies a region. Each study center also has a study center code, which is also unique. What is the relationship between regional center and study center?
Which of the following properties of the database transaction has been defined in the given statement: "Either all the changes or no changes have been made in the database."
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?
What is the relationship between the foreign key and primary key? Each correct answer represents a complete solution. Choose all that apply.
A foreign key constraint works in conjunction with a primary key constraint to enforce referential integrity among related entities.
One reason to add an index is to:
Improve performance of select statements.
A database contains two tables named Customer and Order. You execute the following statement: DELETE FROM Order WHERE CustomerID = 209 What is the result?
All orders for CustomerID 209 are deleted from the Order table.
Which of the following are the types of prototyping strategies? Each correct answer represents a complete solution. Choose two.
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 that some of the InnoDB tables need to be repaired. You restart the server and discover that auto-recover has failed. Which of the following steps will you take to recover the corrupted InnoDB tables?
Restart the server with the innodb_force_recovery option.
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?
Binary log files
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 and objectives. Which of the following will you use to accomplish the task?
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. You notice that the DML statement has not executed. What will you do to resolve the issue? Each correct answer represents a complete solution. Choose two.
Clean up all the uncommitted transactions on the Sales table.
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.
UPDATE DATABASE CONFIGURATION
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 not have access?
Which command should you use to give a user permission to read the data in a table?
You have created a database for employee management. The database has a table named Employees. The table has the following attributes: Name Address Contact Number Designation You want to store the salary information for each employee. The database should also store salary history. How will you design the database so that you can query the last increment given to a particular employee?
Create a new table that includes the EmployeeID, EmployeeSalary, and DateOfIncrement columns. Create a one-to-many relationship with the Employees table.
John works as a Database Administrator in www.company.com Inc. 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 has to ensure that the lastname column does not allow null values. Which of the following queries will he use to accomplish the task?
CREATE TABLE employees (id INTEGER PRIMARY KEY, firstname CHAR(50)NULL, lastname CHAR (75)NOT NULL, dateofbirth DATE NULL);
You are writing an SQL statement to retrieve rows from a table. Which data manipulation language (DML) command should you use?
Which of the following commands are used to terminate a transaction? Each correct answer represents a complete solution. Choose all that apply.
Fill in the blank with the appropriate word. The model for database management is a database model based on first-order predicate logic.
At 3:00 P.M. (1500 hours), you create a backup of your database. At 4:00 P.M. (1600 hours), you create a table named Customer and import data into the table. At 5:00 P.M. (1700 hours), your server fails. You run a script to apply only the 3:00 P.M. backup to your database. What is the result of the script?
The Customer table no longer exists.
You need to establish a set of permissions that you can routinely assign to new users. What should you create?
Which category of SQL statements is used to add, remove, and modify database structures?
Data control language (DCL)
The component that holds information for a single entry in a table is called a:
Data in a database is stored in:
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 '24342' What will be the output of the query?
A database will be created.
You have a table named Student that contains 100 rows. Some of the rows have a NULL value in the FirstName column. You execute the following statement: DELETE FROM Student What is the result?
All rows in the table will be deleted.
You have a table that contains information about all students in your school. Which SQL keyword should you use to change a student's first name in the table?
Which command should you use to add a column to an existing table?
The terms "bitmap," "b-tree," and "hash" refer to which type of database structure?
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 implement to accomplish the task?
Physical database design
You need to store product quantities, and you want to minimize the amount of storage space that is used. Which data type should you use?
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 contents are in a proper state?
Perform a table check operation.
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?
Requirements collection and analysis
Which of the following values cannot be stored in a character column defined as the primary key of a table?
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.
CREATE TABLE AS SELECT AS OF
You work as a database developer for www.company.com.com. The company has a database named www.company.com that is hosted on a SQL Server 2008 server. The database includes a table named Employees, which contains the details of the employees. You want to ensure that anytime any data in the Employees table is modified with an UPDATE statement, they are recorded in a table named EmployeeChanges. The EmployeeChanges table includes columns to record what the change was, who made the change, and when they made the change. What should you create to meet this need?
A DML trigger that queries the inserted table
You need to enable a new employee to authenticate to your database. Which command should you use?
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?
The query will fail because the id and name attributes must be separated by a comma.
Which command should you use to remove a table from a database?
You have two tables. Each table has three rows. How many rows will be included in the Cartesian product of these two tables?
In SQL, an insert statement is used to add a:
Row of data to a table.
You are writing a select statement to find every product whose name contains a specific character. Which keyword should you use in your where clause?
In which situation do you need to perform a restore on a database?
when data becomes corrupted in the database