Tag - 98-364 exam

You have a table named Customer. You need to add a new column named District. Which statement should you use? A . Option AB . Option BC . Option CD . Option DView AnswerAnswer: D

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 following statement: INSERT INTO Road VALUES (1234, 36) What is the result?A . an error stating that NULL values are not allowedB ....

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

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?A . UPDATEB . CHANGEC . SELECTD . INSERTView AnswerAnswer: A

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 table named Product. The Product table has columns for Product Description and Product Category. You need to change the Product Category value for all the spoons in the Product table to 43. Which statement should you use? A . Option AB . Option BC . Option CD...

You have a table named Student that contains 100 rows. Some of the rows have a NULL value in the FirstName column. You execute the following statement: DELETE FROM Student What is the result?A . All rows in the table will be deleted.B . All rows containing a NULL value...

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 statement?A . 1B . 2C . 3D . 4View AnswerAnswer: C

Which permission does a user need in order to run a stored procedure?A . EXECUTEB . ALLOWC . CALLD . RUNView AnswerAnswer: A

Which command should you use to add a column to an existing table?A . MODIFYB . ALTERC . UPDATED . INSERTE . CHANGEView AnswerAnswer: B