chapter 9 Flashcards

1
Q

it is a Java-based tool used to create Oracle Databases.

A

Oracle Database Configuration Assistant

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

Using this, Oracle manages the file placement and naming automatically

A

Configure Automatic Storage Mangement

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q
  • research and marketing data
  • state or federal tax payments
  • professional licensing
A

Data Warehouse

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q
  • Store checkout register system

- Automatic teller machine transaction

A

Transaction processing

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

Retail billing system

A

General Purpose

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

this user owns all base tables and user-accessible view of the data distionary

A

SYS

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

this user is used to create additional tables and views that display administrative information, and internal tables and views used by various Oracle option and tools

A

System

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

this user represents the Enterprise Manager super admin account. This EM admin can create and modify other EM admin accounts as well as admin the database instance itself

A

Sysman

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

this user is used by EM to monitor the databse

A

DBSNMP

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

are admin privileges to perform high-level admin

A

SYSOPER

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

can do SYSOPER plus can look at user data.

A

SYSDBA

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

5 operations only can be performed by SYSDBA

A
  • startup a database
  • shutdown a database
  • backup a database
  • recover a database
  • create a database
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

it is the most common type of storage configuration for many Oracle databases

A

File system storage

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

are disks that are not managed by the underlying OS

A

Raw Devices

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

It is the foundation of the new automated disk-based recovery feature

A

Oracle flash recovery

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

Performs a shutdown abort then restart

A

startup force

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

open to only restricted session privilege

A

startup restrict

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

increase the database availability state

A

alter database[mount|open]

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

wait till all users are disconnected

A

shutdown

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

wait till all active transactions are completed

A

shutdown transactional

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q
  • roll back uncommitted transactions

- disconnect all clients immediately

A

shutdown immediate

22
Q
  • terminate current sql statement statements, no roll back
  • disconnect all clients immediately
  • requires instance recovery in next startup
A

shutdown abort

23
Q

it contains chronological summary of startup. shutdown, alter activities

24
Q

how to find location of alert log diags trace and alert

A

sql> select name, value from v$diag_info

25
- initialization parameter files that reads and writes by instance
spfile (spfileSID.ora or spfile.ora)
26
- reads only by instance | - can be created from an spfile
pfile (initSID.ora)
27
how many initializaiton parameters
285
28
to change parameter
sql> alter system set
29
to view parameter
sql> show parameter
30
initialization parameters view are located in?
oracle_home/dbs
31
how many data dictionary views about the database and its objects
1600
32
how many dynamic performance views
480
33
- data dictionary views that shows information on all tables
DBA_
34
an user's own tables and tables with granted access
ALL_
35
tables owned by individual user
User_
36
it shows information about the initialization parameters that are currently in effect
V$PARAMETER
37
it shows the contents of the spfile used to start the instance
V$SPPARAMETER
38
-this starts the instance without mounting the database
startup nomount
39
this performs all the work of the startup nomount option but also attaches and interacts with the database structures.
startup mount
40
this is the default startup mode if no mode is specified on the startup comman line.
startup open
41
you can use this when you are experiencing trouble starting the database in normal fashion
startup force
42
this option starts up the database and places it in open mode but gives access only to users who have the restricted sessions privilege
startup restrict
43
note1:
Database_block_size cannot be changed from 8K
44
global database name
ORACLE SID
45
Initialization parameter
- memory - size - character set - connection mode
46
contain database definition information, actual datafile and redo log file
seed template
47
custom defined database definition
nonseed template
48
database metadata
data dictionary views and dynamic performance views
49
provide information about database and its object
data dictionary views
50
- virtual tables that record the current database activity and status - fixed views - v_$ or v$
dynamic performance views
51
hierarchy parameter files
- spfile$ORACLE_SID.ora - spfile.ora - init$ORALCE_SID.ora