- SQL (Structured Query Language) A standard language for managing relational databases. - DDL (Data Definition Language) For schema creation and modification (e.g., `CREATE TABLE`, `AL‐ TER TABLE`). - DML (Data Manipulation Language) For querying and modifying data (e.g., `SELECT`, `INSERT`, `UPDATE`, `DELETE`). - DCL (Data Control Language) For access control (e.g., `GRANT`, `REVOKE`). - Query Retrieving data (`SELECT`). - Update Modifying existing data (`INSERT`, `UPDATE`, `DELETE`).
Which set of SQL language commands is used to query and update a database? - (5) Question not attempted
Asked in Programmer Exam 2024 · Topic: Basics of Computers and Information Technology (Database Management Systems (DBMS) Basics: Concepts, Types of Databases)
Show answer
Answer: D. Data Manipulation Language (DML)
Read the notes: Basics of Computers and Information Technology →
More Information and Communication Technology questions
- An ER Model describes which type of schema? - (5) Question not attempted
- Consider a relation with attributes {A, B, C, D} and the following functional dependencies: A → B, B → C and C → D. If A is the primary key, which of the following is true regarding BCNF?
- The number of attribute in a relation is known as -
- Which operation requires two relations as input to form a new relation and these two relations must have a common attribute?
- The complete picture of data stored in database is known as
- Consider the following pairs of name of famous person and name of the company associated with : 1. Elon Musk : Apple 2. Jeff Bezos : Amazon 3. Tim Cook : Tesla Which of the pairs given above is/are correctly matched?
- Which of the following is/are correct with regard to Supercomputing in India ?
- Which one of the following pairs is not matched?
All 1,360 Information and Communication Technology questions →