Introduction to SQL In SQL, which command(s) is(are) used to change a table's storage characteristics? MODIFY TABLE ALTER TABLE All of these CHANGE TABLE MODIFY TABLE ALTER TABLE All of these CHANGE TABLE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is the original purpose of SQL? All of these To define the data structures To specify the syntax and semantics of SQL data definition language To specify the syntax and semantics of SQL manipulation language All of these To define the data structures 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 Which of the following SQL query is correct for selecting the name of staffs from 'staffinfo' table where salary is 10,000 or 25,000? None of these Both A and B SELECT name FROM staffinfo WHERE salary BETWEEN 10000 AND 25000; SELECT name FROM staffinfo WHERE salary IN (10000, 25000); None of these Both A and B SELECT name FROM staffinfo WHERE salary BETWEEN 10000 AND 25000; SELECT name FROM staffinfo WHERE salary IN (10000, 25000); ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statementSELECT SUBSTR('123456789', INSTR('abcabcabc', 'b'), 4) FROM DUAL; 6789 2345 1234 456789 6789 2345 1234 456789 ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL keyword is used to sort the result-set? SORT BY SORT ORDER BY ORDER SORT BY SORT ORDER BY ORDER ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL In SQL, which command is used to change a table's storage characteristics? None of these ALTER TABLE CHANGE TABLE MODIFY TABLE None of these ALTER TABLE CHANGE TABLE MODIFY TABLE ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS