Question 1 Using the TAL company tables: How do you retrieve the customer num an

Question

Question 1

Using the TAL company tables: How do you retrieve the customer num and customer name of all the customers who buy from repnum 30 ?                      

Question 2          

A column which is specified as the ________ enforces a constraint that the only allowed values in it are either null or the values in another tables primary key.       

Question 3

Using the TAL company tables, which is the correct SQL statement to create a view for all the items in storehouse 3 and are categorized as toys.                       

Question 4

Using the Colonial tables, which is the correct SQL statement to List the trip season and average gmax group size per season, sorted by season in descending order                    

Question 5

Which SQL structure would create if you had to speed up a select query             

Question 6

This type of statement removes the records specified, but leave the table structure unmodified (choose one).                  

Question 7

To implement an insert database trigger on a table, we must use the following header. (choose one)                  

Question 8

The ______ integrity rule , is implemented by the primary key and says that a primary key column may not be null.          

Question 9

he following SQL scripts, represents the implementation of a _________ (choose one)..

add constriant MyConstraint check (season in ('summer','fall','spring')                        

Question 10

To find out information (metadata) on the table structures in a database, you would use the ________ (choose one).                     

Explanation / Answer

1) select customernum , customername from customers where repnum = 30 ;

2) Foreign key -  A foreign key is a column (or columns) that references a column (most often the primary key) of another table.

3) create view items as select * from storehouse 3 where category = "toys";

5) Transaction

6) delete statement

7)  CREATE TRIGGER trigger_name ON table AFTER INSERT

8) Entity integrity rule

9) table level constraint

10) describe table name

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.