Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Oracle DBA > Oracle DBA > Flashcards

Oracle DBA Flashcards

1
Q

What does PDB stand for?

A

Pluggable Database

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

What does CDB stand for?

A

Multitenant Container Database

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

What does OUI stand for?

A

Oracle Universal Installer

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

What does DBCA stand for?

A

Oracle Database Configuration Assistant

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

What does DBUA stand for?

A

Oracle Database Upgrade Assistant

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

What does EM Express stand for?

A

Oracle Enterprise Manager Database Express

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

What does OLTP stand for?

A

High Security Online Transaction Processing

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

What does SME stand for?

A

Small and Medium Sized Enterprises

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

What does Oracle ASM stand for?

A

Oracle Automatic Storage Management

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

What does SID stand for?

A

System Identifier

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

What does OSDBA stand for?

A

Operating System Database Administrator Group

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

What does OMF stand for?

A

Oracle Managed Files

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

What does LGWR stand for?

A

Log Writer Process

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

What is the Archive Log also known as?

A

The Archive Redo Log

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

What is the Archive Redo Log also known as?

A

The Archive Log

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

What is Archiving?

A

The process of turning online redo log files into archived log files.

17
Q

What does SGA stand for?

A

System Global Area

18
Q

What is SGA (System Global Area)?

A

A group of shared memory dedicated to an oracle instance.

19
Q

What does PGA stand for?

A

Program Global Area

20
Q

What is PGA (Program Global Area)?

A

A memory region that contains data and control information for a server process.

21
Q

Is PGA (Program Global Area) memory shared or unshared?

A

Unshared

22
Q

When is PGA (Program Global Area) memory created?

A

It is created by Oracle Database when a server process in started.

23
Q

To what process in PGA (Program Global Area) memory exclusive to?

A

The server process.

24
Q

What two types of processes allocate their own PGA (Program Global Area) memory?

A

Server processes, and background processes

25
Q

What is a .dfb file?

A

A PDB Datafile Backup

26
Q

What does ASH stand for?

A

Active Session History

27
Q

What does ADDM stand for?

A

Automatic Database Diagnostics Monitor

28
Q

What does AWR stand for?

A

Automatic Workload Repository

29
Q

What does lsnrctl stand for?

A

Net Listener Control (Command Line)

30
Q

What does DBCS stand for?

A

Oracle Database Cloud Services

31
Q

What does SQL stand for?

A

Structured Query Language

Oracle DBA (1 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions