Introduction to SQL Which of the following command makes the updates performed by the transaction permanent in the database? TRUNCATE COMMIT ROLLBACK DELETE TRUNCATE COMMIT ROLLBACK DELETE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statement that queries or reads data from a table is ________ . READ None of these QUERY SELECT READ None of these QUERY SELECT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The result of a SQL SELECT statement is a ________ . report file form table report file form table ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL statement is used to update data in a database? UPDATE MODIFY SAVE AS SAVE UPDATE MODIFY SAVE AS SAVE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following query is correct for using comparison operators in SQL? SELECT name, course_name FROM student WHERE age>50 and WHERE age<80; None of these SELECT name, course_name FROM student WHERE age>50 and age <80; SELECT name, course_name FROM student WHERE age>50 and <80; SELECT name, course_name FROM student WHERE age>50 and WHERE age<80; None of these SELECT name, course_name FROM student WHERE age>50 and age <80; SELECT name, course_name FROM student WHERE age>50 and <80; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is valid SQL for an Index? CHANGE INDEX ID; REMOVE INDEX ID; CREATE INDEX ID; ADD INDEX ID; CHANGE INDEX ID; REMOVE INDEX ID; CREATE INDEX ID; ADD INDEX ID; ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS