To form a projection with SQL…….
a) name the relation to be projected
b) keyword SELECT & FROM are optional
c) columns to be listed before keyword
d) tables to be listed before keyword
Which of the following keyword is used to remove duplication of rows?
a) ONLY
b) UNIQUE
c) DISTINCT
d) SINGLE
Which SQL keyword is used to name a new table?
a) set
b) create
c) alter
d) modify
Which SQL keyword is used to change the structure of a table?
a) set
b) create
c) alter
d) modify
Which SQL keyword is used to update the values of a table?
a) set
b) create
c) alter
d) modify
If a table has a column price with data type numeric (8,2), it stores value.
a) 8 digits and 2 decimal points
b) 6 digits and 2 decimal point
c) 10 digits and 2 decimal points
d) 8 digits with no stored decimal points
