Oracle 10G Chapter 2 Part I

Front 1

Describe Managed Targets interms of Oracle Management Framework?

Back 1

Entities which can be monitor and managed using oracle management framework.
These entities include:
1-Databases
2-Application Servers
3-Web Servers
4-Applications
5-Oracle Agents(Net Listener, Connection Manager)

Front 2

Describe Oracle Enterprise Manager 10g Grid Control?

Back 2

This is a web based user interface that communicates with all the components within the Oracle enterprise.

Front 3

Describe Oracle Enterprise Manager 10g Database Control?

Back 3

This is a web based component of the Enterprise Management Framework wich allows to monitor and administer a single Oracle database instance or a real application cluster (RAC)

Front 4

Describe Application Server Control?

Back 4

This is a web based component of the Enterprise Management Framework wich monitors the Oracle Application Server 10g(9.0.4)

Front 5

What is Oracle Management Agent?

Back 5

Its a background process that runs on each managed target server.

Front 6

What command line utility should be used to start AND stop Oracle Management Agent?

Back 6

/bin>emctl start agent
/bin>emctl stop agent

Front 7

What command line utility should be used to start AND stop EM Database Control?

Back 7

/bin>emctl start dbconsole
/bin>emctl stop dbconsole

Front 8

What is the difference between EM Grid Control and EM Database Control

Back 8

EM Grid Control is used for multiple database instances, while EM Database Control is used to manage a single instance of database.

Front 9

What command line utility should be used to start AND stop isqlplus?

Back 9

/bin>isqlplusctl start
/bin>isqlplusctl stop

Front 10

What is the URL for accesing the Database Control from web?>

Back 10

http://hostname:portnumber/em
where the default portnumber is 5500

Front 11

What file contains the summary of all the ports used by Oracle components?

Back 11

%ORACLE_HOME/install dir/portlilst.ini

Front 12

What are the DBCA Database Management Options?

Back 12

1-Create a database
2-Configure database options
3-Delete a database
4-Manage Templates

Front 13

What are the sections included in Template Definitions?

Back 13

1-Common Options
2-Innitialization Parameters
3-Character Sets
4-Control Files
5-Tablespaces
6-Data Files
7-Redo Log Groups

Front 14

Describe Oracle SID(System Identification)name?

Back 14

It is the name of the instance associated with the database. It can be max 8 characters long and has to be unique.

Front 15

What are the 4 preconfigured accounts at the time of a database setup?

Back 15

1-SYS: The SYS user owns all the internal Oracle tables including DD.
2-SYSTEM: It is an additional support user which contains additional table and views.
3-DBSNMP: This is a login used by the Enterprise Manager facility to monitor and gather performance statistics about the database.
4- SYSMAN: It is the equivalent of the SYS user for the Enterprise Manager.

Front 16

What is ASM?

Back 16

ASM stands for Automated Storage Management; Oracle manages the storage definitions of the database within a second database used exclusively by ASM to keep track of the disk group allocations.

Front 17

What is the default size of flash recovery area?

Back 17

2048 MB

Front 18

What tabs are preseneted to update the innitialization parameters at the time of installation?

Back 18

1-Memory
2-Sizing
3-Character Sets
4-Connection Mode

Front 19

How does oracle searches for the parameter file?

Back 19

The search hierarchy is:
1-spfile$ORACLE_SID.ora
2-spfile.ora
3-pfile (init$ORACLE_SID.ora)

Front 20

What are the modes of startup?

Back 20

1-No Mount
2-Mount
3-Open

Front 21

What are the commands for Oracle DB Startup?

Back 21

1-STARTUP NOMOUNT
2-STARTUP MOUNT
3-STARTUP OPEN
4-STARTUP FORCE
5-STARTUP RESTRICT

Front 22

Describe Startup NOMOUNT?

Back 22

1-Parameter file is read
2-Memory Structure and background processes are initiated.

Front 23

Describe Startup MOUNT?

Back 23

1-Parameter file is read
2-Memory Structure and background processes are initiated.
3-Starts communicating with the db structures.

Front 24

Descrive Startup OPEN?

Back 24

1-Parameter file is read
2-Memory Structure and background processes are initiated.
3-Starts communicating with the db structures.
4-The database is available for the users.

Front 25

Descrive Startup FORCE?

Back 25

Used in abnormal situations.
It does Shutdown abort and then restart the database.

Front 26

Descrive Startup RESTRICT?

Back 26

It places the db in open mode but gives access to only those users which have RESTRICTED SESSION Privilege.

Front 27

What SQL command is used for starting the DATABASE?

Back 27

sql> STARTUP [MOUNT|NOMOUNT|OPEN] [PFILE|SPFILE=] [RESTRICT]

Front 28

What are the optios available for shutting down the database?

Back 28

1-Shutdown NORMAL
2-Shutdown TRANSACTIONAL
3-Shutdown IMMEDIATE
4-Shutdown ABORT

Front 29

Describe Shutdown NORMAL?

Back 29

1- No new connections with the database are allowed from the time the Shutdown NORMAL command is issued.
2-Database will wait untill all the users are disconnected

Front 30

Describe Shutdown TRANSACTIONAL?

Back 30

1- No new connections with the database are allowed from the time the Shutdown TRANSACTIONAL command is issued.
2-No new transactions are allowed to start from the time the Shutdown TRANSACTIONAL command is issued.
3-Once all the active transactions on the database have completed all the clients are disconnected.

Front 31

Describe Shutdown IMMEDIATE?

Back 31

1- No new connections with the database are allowed from the time the Shutdown IMMEDIATE command is issued.
2-Any uncommitted transactions are rolled back, thus a user in the middle of a transaction will lose the uncommitted work.
3-Oracle doesnot wait for clients to disconnect.
4-Any unfinished transactions are rolled back and their database connections are terminated.

Front 32

Describe Shutdown ABORT?

Back 32

1- No new connections with the database are allowed from the time the Shutdown ABORT command is issued.
2-Any SQL Statements currently in progress are terminated regardless of their state.
3-Uncommitted work is not rolled back.
4-Oracle disconnect all client connections immediately upon the instance of SHUTDOWN ABORT.

Front 33

What is the SQL Command used for shutting down the oracle instance?

Back 33

SQL> SHUTDOWN [NORMAL|IMMEDIATE|RESTRICT|ABORT]

Front 34

What parameter governs the location of the alert log?

Back 34

BACKGROUND_DUMP_DEST

Front 35

Where does Oracle stores information about managed targets?

Back 35

Oracle Management Repository

Front 36

What is Oracle Management Repository composed of?

Back 36

The repository is composed of two tablespaces.
It contains information about administrators, targets, applications that are managed within Enterprise Manager.

Front 37

What is the term for fully qualified database name?

Back 37

Global Database Name

Front 38

Describe Raw devices?

Back 38

These are disk partitions setup as special devices managed by Oracle.

Front 39

What new Oracle 10g feature provides a centralized location to maintain and manage all the files related to database backups?

Back 39

Flash Recovery

Front 40

What does a seed template contain?

Back 40

Seed template contains template definitions including
1-Database information
2-Actual Data files
3-Redo log files.

Front 41

What does a non-seed template contains?

Back 41

Non Seed templates only contain
Database information.

Front 42

What does .dbc extension files contain?

Back 42

These are the seed template files.

Front 43

What does .djf extension files contain?

Back 43

These are the associated predefined redo logs and data files.

Front 44

what does .dbt extension files contain?

Back 44

These are the non-seed template files.

Front 45

What does Oracle Alert log contain?

Back 45

It only contains a chronological history of administrative events and actions not user related actions.