Data & Information
Raw facts that have no meaning on their own
What is data?
This feature reduces repetition of data
What is data redundancy reduction?
DDL stands for...?
What is Data Definition Language?
DML stands for...?
What is Data Manipulation Language?
SQL command to take back user privileges
What is REVOKE?
Processed data that is meaningful
What is information?
DBMS ensures this by allowing only authorized access
What is data security?
SQL command to create a new table
What is CREATE?
SQL command to add new data into a table
What is INSERT?
SQL command to retrieve data from a table
What is SELECT?
Example: "92" is data, "Student scored 92 marks" is...?
What is information?
DBMS allows multiple users to access data at once
What is multi-user access or concurrency control?
SQL command to change structure of a table
What is ALTER?
SQL command to modify existing records
What is UPDATE?
DCL stands for...?
What is Data Control Language?
Type of data that includes names and words
What is textual data?
DBMS makes sure data is the same across the system
What is data consistency?
SQL command to delete a table permanently
What is DROP?
SQL command to remove data from a table
What is DELETE?
DQL stands for...?
What is Data Query Language?
When data is accurate, complete, and timely, it becomes this
What is useful information?
DBMS manages how data is stored and retrieved efficiently
What is data management?
The command that removes all records but not the structure
What is TRUNCATE?
The type of operations DML handles
What are Insert, Update, Delete?
SQL command to give privileges to users
What is GRANT?