Passing 98-364 exam is a first step for you to get the MTA certification. With studying all of Microsoft Database Fundamentals 98-364 exam prep questions dumps, you can test your skills to check if you have a good understanding of the exam topics or not. All the Microsoft 98-364 exam prep questions are collected from the real test by our certified experts, who update the 98-364 questions frequently according to the changes at the testing center.
You execute the following statement: SELECT EmployeeID, FirstName, DepartmentName FROM Employee, Department This type of operation is called a/an:A . intersection.B . outer join.C . equi-join.D . Cartesian product.View AnswerAnswer: D
You have a Customer table and an Order table. You join the Customer table with the Order table by using the CusromerID column. The results include: - All customers and their orders - Customers who...
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. You execute the following statement: SELECT Name FROM Product WHERE Quantity...
Which keyword can be used in a create table statement?A . ORDER BYB . DISTINCTC . GROUP BYD . UNIQUEView AnswerAnswer: D
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?A . INTEGERB . DOUBLEC . COUNTD . FLOATView AnswerAnswer: A
You have a table named Product that contains the following data. The PrcducrID column is the primary key. The CategoryID column is a foreign key to a separate table named Category. You execute the following...
You need to remove a view named EmployeeView from your database. Which statement should you use?A . DELETE VIEW EmployeeViewB . DELETE EmployeeViewC . DROP EmployeeViewD . DROP VIEW EmployeeViewView AnswerAnswer: D
You need to establish a set of permissions that you can routinely assign to new users. What should you create?A . resourceB . groupC . listD . roleView AnswerAnswer: D
A database contains two tables named Customer and Order. You execute the following statement: DELETE FROM Order WHERE CustomerID = 209 What is the result?A . The first order for CustomerID 209 is deleted from...
Which keyword would you use in a select statement to return rows that meet a specific condition?A . WHEREB . UNIONC . ORDER BYD . FROMView AnswerAnswer: A
