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 Scalar aggregate are multiple values returned from an SQL query that includes an aggregate function. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL A view is which of the following? A virtual table that cannot be accessed via SQL commands A virtual table that can be accessed via SQL commands A base table that cannot be accessed via SQL commands A base table that can be accessed via SQL commands A virtual table that cannot be accessed via SQL commands A virtual table that can be accessed via SQL commands A base table that cannot be accessed via SQL commands A base table that can be accessed via SQL commands ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is a SQL aggregate function? LEFT JOIN LEN AVG LEFT JOIN LEN AVG ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL statement is used to update data in a database? SAVE AS MODIFY SAVE UPDATE SAVE AS MODIFY SAVE UPDATE 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
EXAMIANS