An outstanding functionality of SQL is its support for automatic ………… to the target data.

Related MCQs

• 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?
• Which of the following data types does the SQL standard not support?
•                  dump, writes out SQL DDL statements and SQL insert statements to a file, which can then be reexecuted to re- create the database.
• Which SQL function is used to count the number of rows in a SQL query?
• Which of the following SQL standard support triggers?
•                        combines the data manipulating power of SQL with the data processing power of Procedural languages.
• 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 command can be used to modify existing data in a database table?
• Which of the following is a valid SQL data type?