98-364 Exam Questions

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

Mark works as a Database Administrator for DataOneWorld Inc. The company has a SQL Server database. Mark has to change the properties of an object inside the database. Which of the...

Mark works as the Database Administrator for DataWorld Inc. The company has a SQL server 2008 database. Mark wants to protect the database from unintended activities made by author...

Examine the following table: In the table, you deleted the record of Mark Smith. Which of the following will change as a result?

You manage a SQL Server 2008 server that hosts a database named Sales. Unauthorized odifications to some tables within the Sales database have resulted in some views no longer work...

Which of the following are considered limitations of the legacy LOB implementation?

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

You work as a Database Designer for Allen Inc. You are designing the database of a company that has several divisions (e.g. Spare Parts division). Each division has several departm...

Roger is the HR Manager of Neon Inc. He wants to generate a report of all the employees working in Department ID 30 from the Emp table on the following attributes: - Fname - Lname...

Merlyn works as a Database Administrator for DOW Inc. She is currently designing a database. She wants to break down the preliminary specifications into smaller components so that...

John works as a Database Administrator for Bluewell Inc. The company has a SQL Server database. A table in the database has a candidate key and an attribute that is not a constitue...

You want to recover one or more tablespaces to a point in time older than the rest of the database. Which of the following are the recovery situations in which tablespace Point-in-...

Linda works as a Database Designer for Lion Inc. She has been given an assignment to design the database of a publishing company. The database has a table named Author, which has a...

Which of the following is a management activity that allows the stages of the database application to be realized as efficiently and effectively as possible?

Which keyword can be used in a create table statement?

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?

Which statement will result in the creation of an index?

You have the following table definition: - CREATE TABLE Road - (RoadID INTEGER NOT NULL, - Distance INTEGER NOT NULL) The Road table contains the following data: You execute the fo...

You need to store product names that vary from three to 30 characters. You also need to minimize the amount of storage space that is used. Which data type should you use?

The component that holds information for a single entry in a table is called a:

You execute the following statement: - SELECT EmployeeID, FirstName, DepartmentName - FROM Employee, Department This type of operation is called a/an:

Which command should you use to add a column to an existing table?

You have the following table definition: - CREATE TABLE Product - (ID INTEGER PRIMARY KEY, - Name VARCHAR(20), - Quantity INTEGER) The Product table contains the following data. Yo...

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?

A database contains two tables named Customer and Order. You execute the following statement: - DELETE FROM Order - WHERE CustomerID = 209 What is the result?

You have a table named Product. The Product table has columns for ProductDescription and ProductCategory. You need to change the ProductCategory value for all the spoons in the Pro...

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?

You need to populate a table named EmployeeCopy with data from an existing table named Employee. Which statement should you use?

You execute the following statement: This statement is an example of a/an:

Which keyword would you use in a select statement to return rows that meet a specific condition?

You have a table named Employee that includes the following columns: - EmployeeID - Smp1oyeeName Which statement should you use to return the number of rows in the table?

The Product table contains the following data. You execute the following statement: - SELECT COUNT(*) - FROM Product WHERE Quantity > 18 What is the value returned by this statemen...

Which command should you use to remove a table from a database?

You need to store the contact information for each student in your school database. You should store each student's information in a:

Which two keys establish a relationship between two tables? (Choose two.)

One difference between a function and a stored procedure is that a function:

You have a table named Customer. You need to add a new column named District. Which statement should you use?

Which keyword must be included in a create view statement?

You need to remove a view named EmployeeView from your database. Which statement should you use?

A named group of SQL statements that can be executed in a database is called a:

A view can be used to:

On which database structure does an update statement operate?

Which statement should you use to remove a foreign key?

First normal form requires that a database excludes:

You execute a statement inside a transaction to delete 100 rows from a table. The transaction fails after only 40 rows are deleted. What is the result in the database?

You have a table that contains product IDs and product names. You need to write an UPDATE statement to change the name of a specific product to glass. What should you include in th...

Your database contains a table named Customer. You need to delete the record from the Customer table that has a CusromerID of 12345. Which statement should you use?

On which database structure does an insert statement operate?

You have a table of products with fields for ProductID, Name, and Price. You need to write an UPDATE statement that sets the value in the InStock field to Yes for a specific Produc...

You have the following table definition: - CREATE TABLE Product - (ProductID INTEGER, - Name VARCHAR(20)) You need to insert a new product. The product's name is Plate and the prod...