Introduction to SQL Which of the following command makes the updates performed by the transaction permanent in the database? TRUNCATE ROLLBACK DELETE COMMIT TRUNCATE ROLLBACK DELETE COMMIT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL data definition commands make up a(n) ________ . DML XML DDL HTML DML XML DDL HTML ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SELECT statement SELECT 'Hi' FROM DUAL WHERE NULL = NULL; Outputs TRUE Nothing Hi FLASE TRUE Nothing Hi FLASE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is the original purpose of SQL? All of these To specify the syntax and semantics of SQL data definition language To define the data structures To specify the syntax and semantics of SQL manipulation language All of these To specify the syntax and semantics of SQL data definition language To define the data structures To specify the syntax and semantics of SQL manipulation language ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following SQL commands can be used to add data to a database table? INSERT UPDATE ADD APPEND INSERT UPDATE ADD APPEND ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The HAVING clause acts like a WHERE clause, but it identifies groups that meet a criterion, rather than rows. False True False True ANSWER DOWNLOAD EXAMIANS APP