CFD module 6

studied byStudied by 0 people
0.0(0)
Get a hint
Hint

This is the standard language of DBMS in storing, updating and retrieving data in the database.

1 / 11

12 Terms

1

This is the standard language of DBMS in storing, updating and retrieving data in the database.

SQL

New cards
2

What are the 3 common clauses for SQL?

Select, From, Where

New cards
3

This clause identifies the columns or fields to be displayed.

Select

New cards
4

This clause identifies the table or relation where the data is to be retrieved.

From

New cards
5

This clause identifies some criteria in retrieving data in the database.

Where

New cards
6

What does DML stand for?

Data Manipulation Language

New cards
7

What does DDL stand for?

Data Definition Language

New cards
8

This command ensures that transactions are either completed or rolled back.

Transaction controls

New cards
9

These are used to control access to the database and concerns about the creation of user permissions.

Security statements

New cards
10

Used to add, access and process data stored in the computer database

Database management system

New cards
11

This is an Open Source SQL database management system developed, distributed and supported by Oracle Corporation.

MySQL

New cards
12

This stores data into tables consisting of rows and columns. It is govern by the rules in relationship such as one-to-one, one-to-many and many-to-many

Relational database

New cards

Explore top notes

note Note
studied byStudied by 23 people
... ago
5.0(1)
note Note
studied byStudied by 73 people
... ago
5.0(2)
note Note
studied byStudied by 7454 people
... ago
4.6(5)
note Note
studied byStudied by 9 people
... ago
5.0(1)
note Note
studied byStudied by 20 people
... ago
5.0(1)
note Note
studied byStudied by 20 people
... ago
5.0(1)
note Note
studied byStudied by 9 people
... ago
5.0(1)
note Note
studied byStudied by 125764 people
... ago
4.8(564)

Explore top flashcards

flashcards Flashcard (28)
studied byStudied by 8 people
... ago
5.0(1)
flashcards Flashcard (20)
studied byStudied by 4 people
... ago
5.0(1)
flashcards Flashcard (56)
studied byStudied by 11 people
... ago
5.0(1)
flashcards Flashcard (47)
studied byStudied by 23 people
... ago
5.0(2)
flashcards Flashcard (58)
studied byStudied by 17 people
... ago
5.0(1)
flashcards Flashcard (246)
studied byStudied by 3 people
... ago
5.0(1)
flashcards Flashcard (38)
studied byStudied by 3 people
... ago
5.0(1)
flashcards Flashcard (84)
studied byStudied by 34 people
... ago
5.0(2)
robot