Which of the following SQL command can be used to modify existing data in a database table?

Related MCQs

• Consider a hash table of size seven, with starting index zero, and a hash function (3x + 4)mod7. Assuming the hash table is initially empty, which of the following is the contents of the table when the sequence 1, 3, 8, 10 is inserted into the table using closed hashing? Note that ‘_’ denotes an empty location in the table.
• Database __________ which is the logical design of the database, and the database _______ which is a snapshot of the data in the database at a given instant in time.
• Database __________ , which is the logical design of the database, and the database _______,which is a snapshot of the data in the database at a given instant in time.
•                  dump, writes out SQL DDL statements and SQL insert statements to a file, which can then be reexecuted to re- create the database.
• Which one of the following provides the ability to query information from the database and to insert tuples into, delete tuples from, and modify tuples in the database?
• Which SQL Query is use to remove a table and all its data from the database?
• Which SQL Query is use to remove a table and all its data from the database?
• Which of the following SQL clauses is used to DELETE tuples from a database table?
• In SQL, which command is used to issue multiple CREATE TABLE, CREATE VIEW and GRANT statements in a single transaction?
• View the Exhibit and examine the data in the EMPLOYEES tables. Evaluate the following SQL statement: SELECT employee_id, department_id FROM employees WHERE department_id= 50 ORDER BY department_id UNION SELECT employee_id, department_id FROM employees WHERE department_id= 90 UNION SELECT employee_id, department_id FROM employees WHERE department_id= 10; What would be the outcome of the above SQL statement?