Introduction to SQL Which of the following is a valid SQL type? CHARACTER All of these FLOAT NUMERIC CHARACTER All of these FLOAT NUMERIC ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statementSELECT ROUND(45.926, -1) FROM DUAL; prints garbage is illegal prints 045.926 prints 50 prints garbage is illegal prints 045.926 prints 50 ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Scalar aggregate are multiple values returned from an SQL query that includes an aggregate function. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which command undo all the updates performed by the SQL in the transaction? TRUNCATE DELETE ROLLBACK COMMIT TRUNCATE DELETE ROLLBACK COMMIT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statement that queries or reads data from a table is ________ . READ SELECT None of these QUERY READ SELECT None of these QUERY ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Each index consumes extra storage space and also requires overhead maintenance time whenever indexed data change value. True False True False ANSWER DOWNLOAD EXAMIANS APP