SQL Flashcards
1
Q
what does RDBMS
A
Relation Data Bases Management System
2
Q
How are RDBMS structure
A
Relational Data Bases Management System stores the data in form of a collection of tables and relations can be defined between the common fields of these tables.
3
Q
What is a database?
A
A database is an organized collection of data, that can be stored and retrieved from a remote or local computer system.
4
Q
What are the four basic operations supported by any relational database?
A
CRUD
Create
Read / Retrieve
Update
Delete
5
Q
What does each CRUD operation mean?
A
Create = create or add new data Read = retrieve or access data into memory Update = update Delete = delete
6
Q
define SQL
A
Structure Query Language
7
Q
What is a primary key?
A
A primary key is a column in a table that uniquely identifies every row.
8
Q
What are the SQL methods?
A
CREATE / INSERT
SELECT
UPDATE
DELETE
