Introduction to SQL The SQL statementSELECT SUBSTR('123456789', INSTR('abcabcabc', 'b'), 4) FROM DUAL; 6789 1234 2345 456789 6789 1234 2345 456789 ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which operator performs pattern matching? BETWEEN operator LIKE operator None of these EXISTS operator BETWEEN operator LIKE operator None of these EXISTS operator ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL statement is used to delete data FROM a database? COLLAPSE ALTER REMOVE DELETE COLLAPSE ALTER REMOVE DELETE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is a SQL aggregate function? LEN LEFT AVG JOIN LEN LEFT AVG JOIN 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 Which of the following is the original purpose of SQL? To specify the syntax and semantics of SQL data definition language To specify the syntax and semantics of SQL manipulation language All of these To define the data structures To specify the syntax and semantics of SQL data definition language To specify the syntax and semantics of SQL manipulation language All of these To define the data structures ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS