Introduction to SQL Which SQL keyword is used to retrieve a maximum value? MOST MAX TOP UPPER MOST MAX TOP UPPER ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL can be used to: create database structures only. query database data only. All of these modify database data only. create database structures only. query database data only. All of these modify database data only. 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 SQL provides five built-in functions: COUNT, SUM, AVG, MAX, MIN. False True False True 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 WHERE age<80; None of these SELECT name, course_name FROM student WHERE age>50 and <80; 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; None of these SELECT name, course_name FROM student WHERE age>50 and <80; SELECT name, course_name FROM student WHERE age>50 and age <80; ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS