96.
A table is successfully created by executing the following statement: CREATE TABLE numbers ( double_number double, decimal_number decimal(2,1) ) One row is successfully inserted into the numbers table. At this point, the table contains the following data: +---------------+----------------+ | double_number | decimal_number | +---------------+----------------+ | 1.5 | 2.5 | +---------------+----------------+ The row is updated by executing the following statement: UPDATE numbers SET double_number = double_number + 0.25, decimal_number = decimal_number + 0.01 Which values are now stored in the double_number and decimal_number columns of the updated row? Select the best response.
- A.1.8 and 2.5
- B.1.75 and 2.5
- C.1.8 and 2.51
- D.S1.75 and 2.51.
- Answer
- Report
Answer : [B]
97.
Which of the following statements can be used to list all databases that are accessible to the
current user? Select the best response.
- A.LIST DATABASES
- B.SHOW DATABASES
- C.DISPLAY DATABASES.
- D.VIEW DATABASES
<
- Answer
- Report
Answer : [B]
98.
Which of the following statements will discard the existing database called world? Select the best
response.
- A.DELETE DATABASE world
- B.DROP DATABASE world
- C.REMOVE DATABASE world
- D.TRUNCATE DATABASE world
- Answer
- Report
Answer : [B]
99.
Which statement can be used to list all columns in the City table? Select the best response.
- A.DISPLAY COLUMNS FROM City
- B.SHOW COLUMNS FROM City
- C.SHOW COLUMNS LIKE 'City'
- D.SHOW City COLUMNS
- Answer
- Report
Answer : [B]
100.
The default database contains a table called City. Which of the following statements may be
executed to obtain a statement that could be used to (re-)create the City table? Select the best response.
- A.DESCRIBE City
- B.DESCRIBE TABLE City.
- C.SHOW TABLE City.
- D.SHOW CREATE TABLE City
- Answer
- Report
Answer : [D]
|
|
||||||||||||||||||||||||||||
