CFD module 6

0.0(0)
studied byStudied by 0 people
0.0(0)
full-widthCall with Kai
GameKnowt Play
New
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
Card Sorting

1/11

Study Analytics
Name
Mastery
Learn
Test
Matching
Spaced

No study sessions yet.

12 Terms

1
New cards

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

SQL

2
New cards

What are the 3 common clauses for SQL?

Select, From, Where

3
New cards

This clause identifies the columns or fields to be displayed.

Select

4
New cards

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

From

5
New cards

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

Where

6
New cards

What does DML stand for?

Data Manipulation Language

7
New cards

What does DDL stand for?

Data Definition Language

8
New cards

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

Transaction controls

9
New cards

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

Security statements

10
New cards

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

Database management system

11
New cards

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

MySQL

12
New cards

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

Explore top flashcards

biopsychology
Updated 513d ago
flashcards Flashcards (26)
Philosophy Test #4
Updated 1065d ago
flashcards Flashcards (48)
13-14
Updated 583d ago
flashcards Flashcards (30)
Enzymes
Updated 1043d ago
flashcards Flashcards (42)
Cultural Study Guide
Updated 447d ago
flashcards Flashcards (163)
biopsychology
Updated 513d ago
flashcards Flashcards (26)
Philosophy Test #4
Updated 1065d ago
flashcards Flashcards (48)
13-14
Updated 583d ago
flashcards Flashcards (30)
Enzymes
Updated 1043d ago
flashcards Flashcards (42)
Cultural Study Guide
Updated 447d ago
flashcards Flashcards (163)