Introduction to SQL Which command undo all the updates performed by the SQL in the transaction? TRUNCATE COMMIT DELETE ROLLBACK TRUNCATE COMMIT DELETE ROLLBACK ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following are the five built-in functions provided by SQL? SUM, AVG, MIN, MAX, NAME SUM, AVG, MIN, MAX, MULT COUNT, SUM, AVG, MAX, MIN SUM, AVG, MULT, DIV, MIN SUM, AVG, MIN, MAX, NAME SUM, AVG, MIN, MAX, MULT COUNT, SUM, AVG, MAX, MIN SUM, AVG, MULT, DIV, MIN ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following must be enclosed in double quotes? Strings All of these Column Alias Dates Strings All of these Column Alias Dates ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SELECT statement SELECT 'Hi' FROM DUAL WHERE NULL = NULL; Outputs TRUE FLASE Hi Nothing TRUE FLASE Hi Nothing ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Scalar aggregate are multiple values returned from an SQL query that includes an aggregate function. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following command makes the updates performed by the transaction permanent in the database? DELETE TRUNCATE ROLLBACK COMMIT DELETE TRUNCATE ROLLBACK COMMIT ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS