NEW
Font size
WorksheetsPRACTICE SET FOR INTERMEDIATE 2
Total questions: 10
Worksheet time: 5mins
•The ................... value will be added to all new records, if no other value is specified.
Syntax
NOT NULL
DEFAULT
CHECK
The table with the .............key is called the child table,
FOREIGN
PRIMARY
The table with the primary key is called the referenced or ............ table.
PARENT
CHILD
HYBRID
•If you define a ......... constraint on a column it will allow only certain values for this column.
CHECK
DEFAULT
CONDITION
• The ................. constraint uniquely identifies each record in a table.
PRIMARY KEY
FOREIGN KEY
•The ................. constraint ensures that all values in a column are different.
UNIQUE
PRIMARY
•The ................... constraint enforces a column to NOT accept NULL values.
NOT DULL
NOT NULL
NOT SPECIFIED
SQL ....................... are used to specify rules for the data in a table
RULES
T-SQL
CONSTRAINTS
SUB QUERY IS ALSO KNOWN AS ................
NESTED QUERY
INNER QUERY
BOTH
NONE
The .......... select query is usually used to determine the result of the outer query.
INNER
OUTER
