Introduction to SQL Which of the following do you need to consider when you make a table in SQL? Default values Data types Primary keys All of these Default values Data types Primary keys All of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which operator performs pattern matching? None of these LIKE operator BETWEEN operator EXISTS operator None of these LIKE operator BETWEEN operator EXISTS operator ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following SQL query is correct for selecting the name of staffs from 'staffinfo' table where salary is 10,000 or 25,000? SELECT name FROM staffinfo WHERE salary IN (10000, 25000); Both A and B SELECT name FROM staffinfo WHERE salary BETWEEN 10000 AND 25000; None of these SELECT name FROM staffinfo WHERE salary IN (10000, 25000); Both A and B SELECT name FROM staffinfo WHERE salary BETWEEN 10000 AND 25000; None of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL NULL is the same as blank for character the same as 0 for integer and blank for character the same as 0 for integer not a value the same as blank for character the same as 0 for integer and blank for character the same as 0 for integer not a value 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. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statementSELECT ROUND(45.926, -1) FROM DUAL; prints 50 is illegal prints garbage prints 045.926 prints 50 is illegal prints garbage prints 045.926 ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS