Introduction to SQL Which of the following is a valid SQL type? FLOAT NUMERIC All of these CHARACTER FLOAT NUMERIC All of these CHARACTER ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Table employee has 10 records. It has a non-NULL SALARY column which is also UNIQUE.The SQL statementSELECT COUNT(*) FROM employee WHERE SALARY > ALL (SELECT SALARY FROM EMPLOYEE);prints 5 9 0 10 5 9 0 10 ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL is: an operating system. a programming language. a DBMS. a data sublanguage. an operating system. a programming language. a DBMS. a data sublanguage. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Count function in SQL returns the number of groups. columns. distinct values. values. groups. columns. distinct values. values. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL What operator tests column for the absence of data? NOT operator EXISTS operator IS NULL operator None of these NOT operator EXISTS operator IS NULL operator None of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL can be used to: query database data only. create database structures only. All of these modify database data only. query database data only. create database structures only. All of these modify database data only. ANSWER DOWNLOAD EXAMIANS APP