Study your flashcards anywhere!

Download the official Cram app for free >

  • Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
Front

How to study your flashcards.

Right/Left arrow keys: Navigate between flashcards.right arrow keyleft arrow key

Up/Down arrow keys: Flip the card between the front and back.down keyup key

H key: Show hint (3rd side).h key

A key: Read text to speech.a key

image

Play button

image

Play button

image

Progress

1/45

Click to flip

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.