Final answer:
So, the correct answer is: C. DDL
Employees with administrative and programming responsibilities should have limited access to DML and DDL. DML manipulates data, while DDL defines and modifies database structures, both of which can cause harm if misused.
Step-by-step explanation:
The question is asking which types of database operations should have limited access for employees with administrative and programming responsibilities. The options are related to different types of SQL (Structured Query Language) commands:
- A. DML (Data Manipulation Language): This includes commands such as INSERT, UPDATE, DELETE, etc., which are used to manipulate data inside the database.
- B. DQL (Data Query Language): People use these commands, like SELECT, to query and retrieve data from the database.
- C. DDL (Data Definition Language): These commands, such as CREATE, ALTER, and DROP, are used to define and modify database structure.
The correct answer is D. A and C, meaning that there should be limited access to both DML and DDL for these employees. Data Manipulation and Data Definition are the areas where destructive or disruptive actions could occur if not properly managed.
The subject of this question is Computers and Technology. The question is asking about limited access for employees with administrative and programming responsibilities. The correct answer is option D, which is DDL (Data Definition Language) and DML (Data Manipulation Language).
DDL is used to define and manage the structure of a database, while DML is used to retrieve, insert, update, and delete data in a database. Both of them are crucial for managing and manipulating data.
Therefore, limiting access to employees with administrative and programming responsibilities for DDL and DML is essential to ensure data security and integrity.