Introduction to SQL The condition in a WHERE clause can refer to only one value. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following query is correct for using comparison operators in SQL? 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; SELECT name, course_name FROM student WHERE age>50 and WHERE age<80; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which operator performs pattern matching? EXISTS operator None of these LIKE operator BETWEEN operator EXISTS operator None of these LIKE operator BETWEEN operator ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables? None Data Definition Language(DDL) Data Manipulation Language(DML) Both of above None Data Definition Language(DDL) Data Manipulation Language(DML) Both of above ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statementSELECT SUBSTR('abcdefghij', INSTR('123321234', '2', 3, 2), 2) FROM DUAL;prints 23 gh ab bc 23 gh ab bc ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL What is the full form of SQL? Structured Query List None of these Simple Query Language Structured Query Language Structured Query List None of these Simple Query Language Structured Query Language ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS