Introduction to SQL Which of the following is the original purpose of SQL? 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 To specify the syntax and semantics of SQL data definition language To define the data structures ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL A subquery in an SQL SELECT statement: can always be duplicated by a join. cannot have its results sorted using ORDER BY. has a distinct form that cannot be duplicated by a join. can only be used with two tables. can always be duplicated by a join. cannot have its results sorted using ORDER BY. has a distinct form that cannot be duplicated by a join. can only be used with two tables. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Each index consumes extra storage space and also requires overhead maintenance time whenever indexed data change value. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Find all the tuples having temperature greater than 'Paris'. SELECT * FROM weather WHERE temperature > (SELECT city FROM weather WHERE city = 'Paris') SELECT * FROM weather WHERE temperature > 'Paris' temperature SELECT * FROM weather WHERE temperature > (SELECT * FROM weather WHERE city = 'Paris') SELECT * FROM weather WHERE temperature > (SELECT temperature FROM weather WHERE city = 'Paris') SELECT * FROM weather WHERE temperature > (SELECT city FROM weather WHERE city = 'Paris') SELECT * FROM weather WHERE temperature > 'Paris' temperature SELECT * FROM weather WHERE temperature > (SELECT * FROM weather WHERE city = 'Paris') SELECT * FROM weather WHERE temperature > (SELECT temperature FROM weather WHERE city = 'Paris') ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The HAVING clause acts like a WHERE clause, but it identifies groups that meet a criterion, rather than rows. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL What is a view? A view is a database diagram. None of these A view is a special stored procedure executed when certain event occurs. A view is a virtual table which results of executing a pre-compiled query. A view is not part of the physical database schema, while the regular tables are. A view is a database diagram. None of these A view is a special stored procedure executed when certain event occurs. A view is a virtual table which results of executing a pre-compiled query. A view is not part of the physical database schema, while the regular tables are. ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS