Introduction to SQL Which of the following command makes the updates performed by the transaction permanent in the database? DELETE ROLLBACK COMMIT TRUNCATE DELETE ROLLBACK COMMIT TRUNCATE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL To establish a range of values, < and > can be used. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL What is a view? A view is a database diagram. A view is a special stored procedure executed when certain event occurs. None of these 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. A view is a special stored procedure executed when certain event occurs. None of these 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 The keyword BETWEEN can be used in a WHERE clause to refer to a range of values. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL In SQL, which command is used to change a table's storage characteristics? MODIFY TABLE None of these ALTER TABLE CHANGE TABLE MODIFY TABLE None of these ALTER TABLE CHANGE TABLE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The wildcard in a WHERE clause is useful when? An exact match is necessary in a SELECT statement. An exact match is necessary in a CREATE statement. An exact match is not possible in a CREATE statement. An exact match is not possible in a SELECT statement. An exact match is necessary in a SELECT statement. An exact match is necessary in a CREATE statement. An exact match is not possible in a CREATE statement. An exact match is not possible in a SELECT statement. ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS