Introduction to SQL The SELECT statement SELECT 'Hi' FROM DUAL WHERE NULL = NULL; Outputs Nothing FLASE Hi TRUE Nothing FLASE Hi TRUE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL is a programming language. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is a SQL aggregate function? LEN AVG JOIN LEFT LEN AVG JOIN LEFT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Scalar aggregate are multiple values returned from an SQL query that includes an aggregate function. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The benefits of a standard relational language include which of the following? Applications are not needed All of these Reduced training costs Increased dependence on a single vendor Applications are not needed All of these Reduced training costs Increased dependence on a single vendor 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 None of these SELECT name FROM staffinfo WHERE salary BETWEEN 10000 AND 25000; SELECT name FROM staffinfo WHERE salary IN (10000, 25000); Both A and B None of these SELECT name FROM staffinfo WHERE salary BETWEEN 10000 AND 25000; ANSWER DOWNLOAD EXAMIANS APP