Introduction to SQL In SQL, which command is used to change a table's storage characteristics? CHANGE TABLE MODIFY TABLE None of these ALTER TABLE CHANGE TABLE MODIFY TABLE None of these ALTER TABLE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL statement is used to delete data FROM a database? DELETE REMOVE ALTER COLLAPSE DELETE REMOVE ALTER COLLAPSE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SELECT statement SELECT 'Hi' FROM DUAL WHERE NULL = NULL; Outputs FLASE Nothing Hi TRUE FLASE Nothing Hi TRUE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL How to select all data from student table starting the name from letter 'r'? SELECT * FROM student WHERE name LIKE 'r%'; SELECT * FROM student WHERE name LIKE '%r%'; SELECT * FROM student WHERE name LIKE '_r%'; SELECT * FROM student WHERE name LIKE '%r'; SELECT * FROM student WHERE name LIKE 'r%'; SELECT * FROM student WHERE name LIKE '%r%'; SELECT * FROM student WHERE name LIKE '_r%'; SELECT * FROM student WHERE name LIKE '%r'; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which one of the following sorts rows in SQL? ALIGN BY GROUP BY ORDER BY SORT BY ALIGN BY GROUP BY ORDER BY SORT BY ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Indexes may be created or dropped at any time. False True False True ANSWER DOWNLOAD EXAMIANS APP