Introduction to SQL The SELECT command, with its various clauses, allows users to query the data contained in the tables and ask many different questions or ad hoc queries. False True False 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 The command to remove rows from a table 'CUSTOMER' is: DROP FROM CUSTOMER ... REMOVE FROM CUSTOMER ... UPDATE FROM CUSTOMER ... DELETE FROM CUSTOMER WHERE ... DROP FROM CUSTOMER ... REMOVE FROM CUSTOMER ... UPDATE FROM CUSTOMER ... DELETE FROM CUSTOMER WHERE ... ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Table employee has 10 records. It has a non-NULL SALARY column which is also UNIQUE.The SQL statementSELECT COUNT(*) FROM employee WHERE SALARY > ALL (SELECT SALARY FROM EMPLOYEE);prints 9 0 10 5 9 0 10 5 ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL 'AS' clause is used in SQL for Selection operation. Projection operation. Join operation. Rename operation. Selection operation. Projection operation. Join operation. Rename operation. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following query is correct for using comparison operators in SQL? SELECT name, course_name FROM student WHERE age>50 and age <80; SELECT name, course_name FROM student WHERE age>50 and WHERE age<80; SELECT name, course_name FROM student WHERE age>50 and <80; None of these SELECT name, course_name FROM student WHERE age>50 and age <80; SELECT name, course_name FROM student WHERE age>50 and WHERE age<80; SELECT name, course_name FROM student WHERE age>50 and <80; None of these ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS