Brainscape's Knowledge GenomeTM

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


See full index

Database > chapter 9 > Flashcards

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

A

alert log

24
Q

how to find location of alert log diags trace and alert

A

sql> select name, value from v$diag_info

25
Q
  • initialization parameter files that reads and writes by instance
A

spfile (spfileSID.ora or spfile.ora)

26
Q
  • reads only by instance

- can be created from an spfile

A

pfile (initSID.ora)

27
Q

how many initializaiton parameters

A

285

28
Q

to change parameter

A

sql> alter system set

29
Q

to view parameter

A

sql> show parameter

30
Q

initialization parameters view are located in?

A

oracle_home/dbs

31
Q

how many data dictionary views about the database and its objects

A

1600

32
Q

how many dynamic performance views

A

480

33
Q
  • data dictionary views that shows information on all tables
A

DBA_

34
Q

an user’s own tables and tables with granted access

A

ALL_

35
Q

tables owned by individual user

A

User_

36
Q

it shows information about the initialization parameters that are currently in effect

A

V$PARAMETER

37
Q

it shows the contents of the spfile used to start the instance

A

V$SPPARAMETER

38
Q

-this starts the instance without mounting the database

A

startup nomount

39
Q

this performs all the work of the startup nomount option but also attaches and interacts with the database structures.

A

startup mount

40
Q

this is the default startup mode if no mode is specified on the startup comman line.

A

startup open

41
Q

you can use this when you are experiencing trouble starting the database in normal fashion

A

startup force

42
Q

this option starts up the database and places it in open mode but gives access only to users who have the restricted sessions privilege

A

startup restrict

43
Q

note1:

A

Database_block_size cannot be changed from 8K

44
Q

global database name

A

ORACLE SID

45
Q

Initialization parameter

A
  • memory
  • size
  • character set
  • connection mode
46
Q

contain database definition information, actual datafile and redo log file

A

seed template

47
Q

custom defined database definition

A

nonseed template

48
Q

database metadata

A

data dictionary views and dynamic performance views

49
Q

provide information about database and its object

A

data dictionary views

50
Q
  • virtual tables that record the current database activity and status
  • fixed views
  • v_$ or v$
A

dynamic performance views

51
Q

hierarchy parameter files

A
  • spfile$ORACLE_SID.ora
  • spfile.ora
  • init$ORALCE_SID.ora

Database (6 decks)

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