Tag - 98-364 exam

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, 30)B . CHAR (3, 30)C . VARCHAR (30)D . CHAR (30)View AnswerAnswer: C

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

Which command should you use to give a user permission to read the data in a table?A . ALLOW SELECTB . LET READC . PERMIT READD . GRANT SELECTView AnswerAnswer: D

You have two tables. Each table has three rows. How many rows will be included in the Cartesian product of these two tables?A . 0B . 3C . 6D . 9View AnswerAnswer: D

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 statement: INSERT INTO Product VALUES (3296, 'Table', 4444) What is the result?A . a foreign...

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

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

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

Data in a database is stored in:A . tables.B . queries.C . data types.D . stored procedures.View AnswerAnswer: A