SQL Flashcards Preview

OCA Summary > SQL > Flashcards

Flashcards in SQL Deck (8)
Loading 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