Introduction to SQL The SQL statementSELECT ROUND(45.926, -1) FROM DUAL; prints garbage prints 045.926 prints 50 is illegal prints garbage prints 045.926 prints 50 is illegal ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL To sort the results of a query use: SORT BY. ORDER BY. None of these GROUP BY. SORT BY. ORDER BY. None of these GROUP BY. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is valid SQL for an Index? CREATE INDEX ID; REMOVE INDEX ID; ADD INDEX ID; CHANGE INDEX ID; CREATE INDEX ID; REMOVE INDEX ID; ADD INDEX ID; CHANGE INDEX ID; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL You can add a row using SQL in a database with which of the following? MAKE CREATE ADD INSERT MAKE CREATE ADD INSERT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Count function in SQL returns the number of groups. columns. values. distinct values. groups. columns. values. distinct values. 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