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 The command to remove rows from a table 'CUSTOMER' is: DROP FROM CUSTOMER ... DELETE FROM CUSTOMER WHERE ... UPDATE FROM CUSTOMER ... REMOVE FROM CUSTOMER ... DROP FROM CUSTOMER ... DELETE FROM CUSTOMER WHERE ... UPDATE FROM CUSTOMER ... REMOVE FROM CUSTOMER ... ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL is: a programming language. a data sublanguage. an operating system. a DBMS. a programming language. a data sublanguage. an operating system. a DBMS. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL In SQL, which command is used to change a table's storage characteristics? ALTER TABLE None of these CHANGE TABLE MODIFY TABLE ALTER TABLE None of these CHANGE TABLE MODIFY TABLE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is illegal? SELECT SYSDATE - (SYSDATE + 2) FROM DUAL; SELECT SYSDATE - SYSDATE FROM DUAL; None of these SELECT SYSDATE - (SYSDATE - 2) FROM DUAL; SELECT SYSDATE - (SYSDATE + 2) FROM DUAL; SELECT SYSDATE - SYSDATE FROM DUAL; None of these SELECT SYSDATE - (SYSDATE - 2) FROM DUAL; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL keyword GROUP BY instructs the DBMS to group together those rows that have the same value in a column. False True False True ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS