Introduction to SQL Which command undo all the updates performed by the SQL in the transaction? DELETE TRUNCATE ROLLBACK COMMIT DELETE TRUNCATE ROLLBACK COMMIT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL can be used to: create database structures only. modify database data only. query database data only. All of these create database structures only. modify database data only. query database data only. All of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The benefits of a standard relational language include which of the following? Reduced training costs All of these Increased dependence on a single vendor Applications are not needed Reduced training costs All of these Increased dependence on a single vendor Applications are not needed ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SELECT statement SELECT 'Hi' FROM DUAL WHERE NULL = NULL; Outputs TRUE Nothing FLASE Hi TRUE Nothing FLASE Hi ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following group functions ignore NULL values? All of these COUNT SUM MAX All of these COUNT SUM MAX ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is a valid SQL type? NUMERIC FLOAT CHARACTER All of these NUMERIC FLOAT CHARACTER All of these ANSWER DOWNLOAD EXAMIANS APP