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

December 8, 2020Pdfprep98-36498-364 exam questions, 98-364 practice exam, MTA

Which two keys establish a relationship between two tables? (Choose two.)A . candidateB . foreignC . superkeyD . localE . primaryView AnswerAnswer: BE

Read more +

Which keyword must be included in a create view statement?

December 8, 2020Pdfprep98-36498-364 exam questions, 98-364 practice exam, MTA

Which keyword must be included in a create view statement?A . WHEREB . ORDER BYC . UPDATED . SELECTView AnswerAnswer: D

Read more +

Which database term is used to describe the process of applying a backup to a damaged or corrupt database?

December 7, 2020Pdfprep98-36498-364 exam questions, 98-364 practice exam, MTA

Which database term is used to describe the process of applying a backup to a damaged or corrupt database?A . recoverB . restoreC . commitD . attachView AnswerAnswer: B

Read more +

Which statement should you use?

December 6, 2020Pdfprep98-36498-364 exam questions, 98-364 practice exam, MTA

You need to disable User1's access to view the data in the Customer table. Which statement should you use? A . Option AB . Option BC . Option CD . Option DView AnswerAnswer: C

Read more +

You need to store the contact information for each student in your school database.

December 1, 2020Pdfprep98-36498-364 exam questions, 98-364 practice exam, MTA

You need to store the contact information for each student in your school database. You should store each student's information in a:A . stored procedure.B . function.C . row.D . variable.View AnswerAnswer: C

Read more +

Which key uniquely identifies a row in a table?

November 30, 2020Pdfprep98-36498-364 exam questions, 98-364 practice exam, MTA

Which key uniquely identifies a row in a table?A . foreiqnB . primaryC . localD . superkeyView AnswerAnswer: B

Read more +

Which data type should you use?

November 27, 2020Pdfprep98-36498-364 exam questions, 98-364 practice exam, MTA

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?A . VARCHAR (3,...

Read more +

You execute the following statement:

November 27, 2020Pdfprep98-36498-364 exam questions, 98-364 practice exam, MTA

You execute the following statement: This statement is an example of a/an:A . subquery.B . union.C . outer join.D . Cartesian product.View AnswerAnswer: A

Read more +

One reason to add an index is to:

November 27, 2020Pdfprep98-36498-364 exam questions, 98-364 practice exam, MTA

One reason to add an index is to:A . decrease storage space.B . increase database security.C . improve performance of select statements.D . improve performance of insert statements.View AnswerAnswer: C

Read more +

Which statement should you use to return the number of rows in the table?

November 22, 2020Pdfprep98-36498-364 exam questions, 98-364 practice exam, MTA

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? A . Option AB . Option...

Read more +