Tag - 98-364 exam

Which command should you use to remove a table from a database?A . REMOVE TABLEB . UPDATE TABLEC . DROP TABLED . DELETE TABLEView AnswerAnswer: C

The component that holds information for a single entry in a table is called a:A . data type.B . row.C . column.D . view.View AnswerAnswer: B

At 3:00 P.M. (1500 hours), you create a backup of your database. At 4:00 P.M. (1600 hours), you create a table named Customer and import data into the table. At 5:00 P.M. (1700 hours), your server fails. You run a script to apply only the 3:00 P.M. backup to your...

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

You are writing an SQL statement to retrieve rows from a table. Which data manipulation language (DML) command should you use?A . READB . SELECTC . OUTPUTD . GETView AnswerAnswer: B

Which statement creates a composite key? A . Option AB . Option BC . Option CD . Option DView AnswerAnswer: D

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 BC . Option CD . Option DView AnswerAnswer: D

In which situation do you need to perform a restore on a database?A . when data becomes corrupted in the databaseB . when you need to roll back a transactionC . when you encounter an error in your applicationD . when data needs to be deleted from the databaseView AnswerAnswer:...

You have a table that contains the following data. Which database term is used to describe the relationship between ProductID and ProductCategory?A . cohortB . relationally dependentC . deterministicD . functionally dependentE . compositionalView AnswerAnswer: D

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