Introduction to SQL In an SQL SELECT statement querying a single table, according to the SQL-92 standard the asterisk (*) means that: all records meeting the full criteria are to be returned. all columns of the table are to be returned. all records with even partial criteria met are to be returned. None of these all records meeting the full criteria are to be returned. all columns of the table are to be returned. all records with even partial criteria met are to be returned. None of these 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 A subquery in an SQL SELECT statement is enclosed in: CAPITAL LETTERS. braces -- {...}. parenthesis -- (...) . brackets -- [...]. CAPITAL LETTERS. braces -- {...}. parenthesis -- (...) . brackets -- [...]. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Data manipulation language (DML) commands are used to define a database, including creating, altering, and dropping tables and establishing constraints. 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 Which of the following SQL commands is used to retrieve data? SELECT JOIN INSERT DELETE SELECT JOIN INSERT DELETE ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS