Introduction to SQL The keyword BETWEEN can be used in a WHERE clause to refer to a range of values. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL You can add a row using SQL in a database with which of the following? CREATE MAKE INSERT ADD CREATE MAKE INSERT ADD ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statementSELECT ROUND(45.926, -1) FROM DUAL; is illegal prints 045.926 prints garbage prints 50 is illegal prints 045.926 prints garbage prints 50 ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL A view is which of the following? A base table that cannot be accessed via SQL commands A virtual table that cannot be accessed via SQL commands A virtual table that can be accessed via SQL commands A base table that can be accessed via SQL commands A base table that cannot be accessed via SQL commands A virtual table that cannot be accessed via SQL commands A virtual table that can be accessed via SQL commands A base table that can be accessed via SQL commands ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL What is a view? None of these A view is a database diagram. 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. None of these A view is a database diagram. 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
Introduction to SQL Select the right statement to insert values to the student table. INSERT INTO student VALUES ( INSERT VALUES ( INSERT VALUES INTO student ( INSERT student VALUES ( INSERT INTO student VALUES ( INSERT VALUES ( INSERT VALUES INTO student ( INSERT student VALUES ( ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS