Introduction to SQL Which command undo all the updates performed by the SQL in the transaction? TRUNCATE ROLLBACK DELETE COMMIT TRUNCATE ROLLBACK DELETE COMMIT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables? None Both of above Data Manipulation Language(DML) Data Definition Language(DDL) None Both of above Data Manipulation Language(DML) Data Definition Language(DDL) ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL provides five built-in functions: COUNT, SUM, AVG, MAX, MIN. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL ON UPDATE CASCADE ensures which of the following? Data Integrity Materialized Views All of these Normalization Data Integrity Materialized Views All of these Normalization ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SELECT DISTINCT is used if a user wishes to see duplicate columns in a query. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statementSELECT ROUND(45.926, -1) FROM DUAL; prints 50 prints garbage is illegal prints 045.926 prints 50 prints garbage is illegal prints 045.926 ANSWER DOWNLOAD EXAMIANS APP