Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
45 Cards in this Set
- Front
- Back
Describe Managed Targets interms of Oracle Management Framework?
|
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) |
|
Describe Oracle Enterprise Manager 10g Grid Control?
|
This is a web based user interface that communicates with all the components within the Oracle enterprise.
|
|
Describe Oracle Enterprise Manager 10g Database Control?
|
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)
|
|
Describe Application Server Control?
|
This is a web based component of the Enterprise Management Framework wich monitors the Oracle Application Server 10g(9.0.4)
|
|
What is Oracle Management Agent?
|
Its a background process that runs on each managed target server.
|
|
What command line utility should be used to start AND stop Oracle Management Agent?
|
/bin>emctl start agent
/bin>emctl stop agent |
|
What command line utility should be used to start AND stop EM Database Control?
|
/bin>emctl start dbconsole
/bin>emctl stop dbconsole |
|
What is the difference between EM Grid Control and EM Database Control
|
EM Grid Control is used for multiple database instances, while EM Database Control is used to manage a single instance of database.
|
|
What command line utility should be used to start AND stop isqlplus?
|
/bin>isqlplusctl start
/bin>isqlplusctl stop |
|
What is the URL for accesing the Database Control from web?>
|
http://hostname:portnumber/em
where the default portnumber is 5500 |
|
What file contains the summary of all the ports used by Oracle components?
|
%ORACLE_HOME/install dir/portlilst.ini
|
|
What are the DBCA Database Management Options?
|
1-Create a database
2-Configure database options 3-Delete a database 4-Manage Templates |
|
What are the sections included in Template Definitions?
|
1-Common Options
2-Innitialization Parameters 3-Character Sets 4-Control Files 5-Tablespaces 6-Data Files 7-Redo Log Groups |
|
Describe Oracle SID(System Identification)name?
|
It is the name of the instance associated with the database. It can be max 8 characters long and has to be unique.
|
|
What are the 4 preconfigured accounts at the time of a database setup?
|
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. |
|
What is ASM?
|
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.
|
|
What is the default size of flash recovery area?
|
2048 MB
|
|
What tabs are preseneted to update the innitialization parameters at the time of installation?
|
1-Memory
2-Sizing 3-Character Sets 4-Connection Mode |
|
How does oracle searches for the parameter file?
|
The search hierarchy is:
1-spfile$ORACLE_SID.ora 2-spfile.ora 3-pfile (init$ORACLE_SID.ora) |
|
What are the modes of startup?
|
1-No Mount
2-Mount 3-Open |
|
What are the commands for Oracle DB Startup?
|
1-STARTUP NOMOUNT
2-STARTUP MOUNT 3-STARTUP OPEN 4-STARTUP FORCE 5-STARTUP RESTRICT |
|
Describe Startup NOMOUNT?
|
1-Parameter file is read
2-Memory Structure and background processes are initiated. |
|
Describe Startup MOUNT?
|
1-Parameter file is read
2-Memory Structure and background processes are initiated. 3-Starts communicating with the db structures. |
|
Descrive Startup OPEN?
|
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. |
|
Descrive Startup FORCE?
|
Used in abnormal situations.
It does Shutdown abort and then restart the database. |
|
Descrive Startup RESTRICT?
|
It places the db in open mode but gives access to only those users which have RESTRICTED SESSION Privilege.
|
|
What SQL command is used for starting the DATABASE?
|
sql> STARTUP [MOUNT|NOMOUNT|OPEN] [PFILE|SPFILE=] [RESTRICT]
|
|
What are the optios available for shutting down the database?
|
1-Shutdown NORMAL
2-Shutdown TRANSACTIONAL 3-Shutdown IMMEDIATE 4-Shutdown ABORT |
|
Describe Shutdown NORMAL?
|
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 |
|
Describe Shutdown TRANSACTIONAL?
|
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. |
|
Describe Shutdown IMMEDIATE?
|
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. |
|
Describe Shutdown ABORT?
|
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. |
|
What is the SQL Command used for shutting down the oracle instance?
|
SQL> SHUTDOWN [NORMAL|IMMEDIATE|RESTRICT|ABORT]
|
|
What parameter governs the location of the alert log?
|
BACKGROUND_DUMP_DEST
|
|
Where does Oracle stores information about managed targets?
|
Oracle Management Repository
|
|
What is Oracle Management Repository composed of?
|
The repository is composed of two tablespaces.
It contains information about administrators, targets, applications that are managed within Enterprise Manager. |
|
What is the term for fully qualified database name?
|
Global Database Name
|
|
Describe Raw devices?
|
These are disk partitions setup as special devices managed by Oracle.
|
|
What new Oracle 10g feature provides a centralized location to maintain and manage all the files related to database backups?
|
Flash Recovery
|
|
What does a seed template contain?
|
Seed template contains template definitions including
1-Database information 2-Actual Data files 3-Redo log files. |
|
What does a non-seed template contains?
|
Non Seed templates only contain
Database information. |
|
What does .dbc extension files contain?
|
These are the seed template files.
|
|
What does .djf extension files contain?
|
These are the associated predefined redo logs and data files.
|
|
what does .dbt extension files contain?
|
These are the non-seed template files.
|
|
What does Oracle Alert log contain?
|
It only contains a chronological history of administrative events and actions not user related actions.
|