Introduction to SQL 'AS' clause is used in SQL for Selection operation. Join operation. Projection operation. Rename operation. Selection operation. Join operation. Projection operation. Rename operation. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL provides the AS keyword, which can be used to assign meaningful column names to the results of queries using the SQL built-in functions. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included. DISTINCT UNIQUE ONLY SINGLE DISTINCT UNIQUE ONLY SINGLE 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 > ANY (SELECT SALARY FROM EMPLOYEE);prints 9 5 10 0 9 5 10 0 ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The ADD command is used to enter one row of data or to add multiple rows as a result of a query. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Each index consumes extra storage space and also requires overhead maintenance time whenever indexed data change value. False True False True ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS