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 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 10 5 0 9 10 5 0 9 ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL keyword is used to sort the result-set? SORT BY ORDER ORDER BY SORT SORT BY ORDER ORDER BY SORT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is the original purpose of SQL? To specify the syntax and semantics of SQL data definition language To define the data structures All of these To specify the syntax and semantics of SQL manipulation language To specify the syntax and semantics of SQL data definition language To define the data structures All of these To specify the syntax and semantics of SQL manipulation language ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The benefits of a standard relational language include which of the following? Increased dependence on a single vendor Applications are not needed Reduced training costs All of these Increased dependence on a single vendor Applications are not needed Reduced training costs All of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL 'AS' clause is used in SQL for Join operation. Rename operation. Selection operation. Projection operation. Join operation. Rename operation. Selection operation. Projection operation. ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS