ORACLE Flashcards

1
Q

ORACLE design

A

MEMORY STRUCTURES
<=> PROCESS STRUCTUES <=>
STORAGE STRUCTURES

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

INSTANCE

A

SGA
PROCESS STRUCTURES

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

DDL

A

DATA DEFINITION LANGUAGE => CREATE TABLE / DROP TABLE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

DML

A

DATA MANIPULATION LANGUAGE => INSERT / UPDATE / DELETE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

SQL is divided

A

DDL
MML

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q
A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly