SQL practice questions help

SQL practice questions help

What can you use to generate a series of integer values that can be used by more than one table? 1) a batch 2) a sequence 3) a constraint 4) a cascading update Question 2 (1 point) The first character of an identifier must be 1) a letter as defined by the Unicode Standard 2.0 2) an underscore O 3) an at sign (@) 4) any of the above Question 3 (1 point) The basic code structure for many SQL statements and objects can be found in which section of the SQL Server Management Studio? O 1) DDL 2) Query Editor 3) Transact-SQL snippets 4) Code Warchouse Question 4 (1 point) When you define a foreign key constraint, you can specify all but one of the following. Which one is it? 1) that no action should be taken and an error should be returned when a related row in a related table is deleted or updated the rows in the foreign key table matched in the primary key table should be cascaded up to the primary key table the rows in the foreign key table 2) that the deletion of a related row in a primary key table should be cascaded down to 3) that the insertion of a row in a foreign key table that has a foreign key that isn't 4) that the updating of a primary key in a primary key table should be cascaded down to t 1 Diag...jpg Assignment 1 Dia..hG What kind of constraint limits the values that can be stored in a column? 1) size constraint 2) values constraint 3) check constraint 4) integrity constraint Question 6 (1 point) When you create a script for creating a database, which keyword do you use to signal of a batch and cause all the statements in the batch to be executed? 1) START l 2 END 3) EXECUTE 4) Go Question 7 (1 point) When coding a definition for a column that will contain a high percentage of null values attribute can you use to optimize the storage? 1) the NULL attribute 2) the NOT NULL attribute 3) the SPARSE attribute 4) the UNIQUE attribute Question 8 (1 point) When you create a script for creating a database. 1) you can create the tables in whatever sequence you prefer 2) you need to create the refered to tables before you create the tables that refer to a) you need to create the Indoxes before you create the lables that they ap them 4) you need to code the gimary key column first in each table