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
If a table has a column price with data type numeric (8,2), the values 12345 will be displayed by DBMS as…..
a) 123.45
b) 12345
c) 12345.00
d) 123450.00
Which SQL keyword is used to delete a table structure?
a) delete
b) drop
c) update
d) alter
When is the correct SQL command used to delete table structure?
a) if deleted table was parent
b) if deleted table was child
c) the data in table also deleted
d) nothing because no data in table
Which SQL command is used to specify the tables to be used?
a) EXISTS
b) update
c) From
d) Set
