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
What does asterisk (*) means in SQL?
a) all columns of table are obtained
b) all records are obtained
c) all records with partial criteria obtained
d) none of these
Which SQL command is used to specify the rows to be selected?
a) EXISTS
b) where
c) From
d) Set
