Introduction to SQL 'AS' clause is used in SQL for Selection operation. Rename operation. Projection operation. Join operation. Selection operation. Rename operation. Projection operation. Join operation. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL A dynamic view is one whose contents materialize when referenced. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statementSELECT ROUND(45.926, -1) FROM DUAL; prints 045.926 is illegal prints 50 prints garbage prints 045.926 is illegal prints 50 prints garbage ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is the original purpose of SQL? To define the data structures All of these To specify the syntax and semantics of SQL data definition language To specify the syntax and semantics of SQL manipulation language To define the data structures All of these To specify the syntax and semantics of SQL data definition language To specify the syntax and semantics of SQL manipulation language ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL COUNT(field_name) tallies only those rows that contain a value; it ignores all null values. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statementSELECT SUBSTR('abcdefghij', INSTR('123321234', '2', 3, 2), 2) FROM DUAL;prints bc ab gh 23 bc ab gh 23 ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS