Microsoft.98-364.v2018-12-19.q77

Exam Code:98-364
Exam Name:Microsoft Database Fundamentals
Certification Provider:Microsoft
Free Question Number:77
Version:v2018-12-19
Rating:
# of views:156
# of Questions views:1410
Start Practice Test

LEAVE A REPLY

Your email address will not be published. Required fields are marked *

Other Version
306 viewsMicrosoft.98-364.v2018-05-01.q78
Exam Question List
Question 1: This question requires that you evaluate the underlined text...
Question 2: You are writing an SQL statement to retrieve rows from a tab...
Question 3: In SQL, an insert statement is used to add a:...
Question 4: You have a table named Product. You create a view that inclu...
Question 5: A named group of SQL statements that can be executed in a da...
Question 6: You need to store product names that vary from three to 30 c...
Question 7: This question requires that you evaluate the underlined text...
Question 8: Which two keys establish a relationship between two tables? ...
Question 9: Data in a database is stored in:...
Question 10: You need to combine the results of two queries into a single...
Question 11: A database contains two tables named Customer and Order. You...
Question 12: You need to remove a view named EmployeeView from your datab...
Question 13: You need to add rows to a database table. Which Structured Q...
Question 14: You have a database table named SongInformation as defined b...
Question 15: The Product table contains the following data. (Exhibit) You...
Question 16: You have the database table named Cars as defined below: (Ex...
Question 17: A view can be used to:
Question 18: Your database contains a table named Customer. You need to d...
Question 19: This question requires that you evaluate the underlined text...
Question 20: You execute the following statement: (Exhibit) This statemen...
Question 21: This question requires that you evaluate the underlined text...
Question 22: While attending college, you accept an IT internship at a lo...
Question 23: Which command should you use to add a column to an existing ...
Question 24: On which database structure does an insert statement operate...
Question 25: You have the following table definition: CREATE TABLE Road (...
Question 26: You have the following table definition: CREATE TABLE Produc...
Question 27: You have a table named Product that contains one million row...
Question 28: You need to store the contact information for each student i...
Question 29: You work at a restaurant and they ask you to help them with ...
Question 30: You need to disable User1's access to view the data in the C...
Question 31: This question requires that you evaluate the underlined text...
Question 32: You have two tables named Salesperson and Sales. You need to...
Question 33: You need to establish a set of permissions that you can rout...
Question 34: Which constraint ensures a unique value in the ID column for...
Question 35: Which category of SQL statements is used to add, remove, and...
Question 36: You have the following table definition: CREATE TABLE Produc...
Question 37: You need to retrieve data from two related database tables b...
Question 38: You execute the following statement: SELECT EmployeeID, Firs...
Question 39: Which command should you use to remove a table from a databa...
Question 40: You need to delete a database table. Which data definition l...
Question 41: You have a table named Customer. You need to add a new colum...
Question 42: This question requires that you evaluate the underlined text...
Question 43: The component that holds information for a single entry in a...
Question 44: One difference between a function and a stored procedure is ...
Question 45: You need to rename a column in a database table. Which data ...
Question 46: Your class project requires that you help a charity to creat...
Question 47: You accept an IT internship at a local charity. The charity ...
Question 48: You have a table that contains product IDs and product names...
Question 49: This question requires that you evaluate the underlined text...
Question 50: Which statement should you use to remove a foreign key?...
Question 51: Which database term is used to describe the process of apply...
Question 52: You have a table named Student that contains 100 rows. Some ...
Question 53: You have a table named Employee that includes the following ...
Question 54: You have a table named Product that contains the following d...
Question 55: This question requires that you evaluate the underlined text...
Question 56: Denormalization is performed in order to:...
Question 57: You have a table of products with fields for ProductID, Name...
Question 58: First normal form requires that a database excludes:...
Question 59: You execute a statement inside a transaction to delete 100 r...
Question 60: On which database structure does an update statement operate...
Question 61: You have a table that contains information about all student...
Question 62: Which keyword would you use in a select statement to return ...
Question 63: This question requires that you evaluate the underlined text...
Question 64: Which keyword must be included in a create view statement?...
Question 65: You have a table named Product. The Product table has column...
Question 66: One reason to create a stored procedure is to:...
Question 67: You accept an IT internship at a local charity. The charity ...
Question 68: You have a Customer table and an Order table. You join the C...
Question 69: This question requires that you evaluate the underlined text...
Question 70: You need to populate a table named EmployeeCopy with data fr...
Question 71: This question requires that you evaluate the underlined text...
Question 72: You have a database table that contains the following column...
Question 73: You are writing a select statement to find every product who...
Question 74: You have two tables. Each table has three rows. How many row...
Question 75: Which permission does a user need in order to run a stored p...
Question 76: This question requires that you evaluate the underlined text...
Question 77: You accept an IT internship at a local charity. The charity ...