• 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/50

Click to flip

50 Cards in this Set

  • Front
  • Back
What commands Are part of the Data Definition Language(DDL)?
CREATE, ALTER, DROP
What Commands are part of the Data Control Language(DCL)?
GRANT, REVOKE
What commands are a part of the Data Manipulation Language(DML)?
INSERT, UPDATE, DELETE
What are the three types of Data Dictionary Views?
DBA_, ALL_, USER_
What are the five types of restraints and what is their purpose?
NOT NULL - Must have a value
UNIQUE KEY - If a value is supplied, it must be unique
PRIMARY KEY - Must be unique and not null
FOREIGN KEY -Must match value in this or another table
CHECK - Must match specified value for column
In what Data Dictionary View is the constraint information held?
DBA_CONSTRAINTS, DBA_CONS_COMLUMNS
What are the four types of segments?
Table - stores data
Index - improves access to data
Rollback - for read consistency during transactions
Partition - Divides table into smaller piece
What is a Segment?
A segment is where the actual database information is stored. Segements exist in the logical tablespace structure.
What are the five types of PL/SQL objects and what are they used for?
ANONYMOUS BLOCK - Block of pl/sql code embedded in a form, webpage, or sql script outside of the database.
PROCEDURE - A Block(in database) that performs a specific action
FUNCTION - A block(in database) that performs as action and returns a value
PACKAGE - Collection of procedures and functions that perform related actions
TRIGGER - pl/sql code that runs when INSERT, UPDATE, OR DELETE occurs. Can also run for database events
Name the components of the System Global Area(SGA).
SHARED POOL, DATABASE BUFFER CACHE, REDO LOG, JAVAPOOL, STREAMS POOL, LARGE POOL
What is the shared pool for?
Caches the most recent SQL statements that users have issued.
What is the Database Buffer Cache?
Caches the data most recently accessed by the database.
What is the Redo Log Buffer?
Store transactions for recovery.
What is the Java Pool?
Caches most recently used Java objects and code when JVM options is used.
What is the Large Pool?
Caches data for large operations, such as backup, restore, and shared server.
What is the Streams Pool?
Caches data associated with queued message requests when Oracle Advanced Queuing is being used.
How does Oracle age items out of the Shared Pool and Database Buffer Cache?
Using the Least Recently Useds algorithm(LRU).
What is a PFILE?
A text file containing startup parameters. In order for changes to take affect, database must be restarted.
What is an SPFILE?
A binary file containing startup parameters. Most options can be applied without a restart.
What are the five required Oracle Background Processes?
SYSTEM MONITOR, PROCESS MONITOR, DATABASE WRITER, LOG WRITER, CHECKPOINT
What is SMON?
System Monitor. It performs instance recovery after an instance crash. It alsocoalesces free space and manages sorting space.
What is PMON?
Process Monitor. Cleans up failed user connections.
What is DBWn?
Database Writer. Writes modified blocks from Database Buffer Cache to datafiles.
What is LGWR?
Log Writer. Write transaction recovery info from Redo Log Buffer to Redo Log files.
What is CKPT?
Checkpoint. Updates database files following a checkpoint event.
What is the Archiver process?
ARCn. Archiver copies recovery information from the Redo Logs to the Archive logs.
What is in a Control File?
Locations of physical files, database name, block size, character set, and recovery info.
What is in a Datafile?
All data and internal metadata.
What is in a Redo log file?
All changes made to database for recovery purposes.
What is in a parameter file?
SPFILE or PFILE. Configuration parameters for the SGA, optional Oracle features, and background processes.
What is in an Archive Log?
Copies of previous online redo logs for recovery purposes.
What are the three required tablespaces in Oracle 10g?
SYSTEM, SYSAUX, TEMP
What are the five things that cause the Log Writer to write to the Redo Logs?
Every three Seconds.
A transaction Commits.
Redo log buffer is 1/3 full.
Redo log buffer contains 1MB of info.
When a checkpoint event occurs.
What are the minimum system requirements for Oracle Database 10g?
Memory: 512MB
Swap: 1GB or two times RAM
Temp: 400MB
Free Space: 1.5GB
What is the Grid Control Console?
The EM Web-base user interface for centrally managing entire environment. From the Grid control console, you can monitor and administer entire environment from one location on the network.
What is the Management Agent(MA) and to what technology does it pertain?
Grid Control. MA is a process running on all managed hosts. It collects information about its' targets and reports them to the Management Service(MS).
What is the Management Service(MS) and to what technology does it pertain?
Grid Control. The MS renders the user interface for Grid Control Console. It all collects data from all the Management Agents(MA) and communicates them to the Management Repositiory(MR).
What is the Management Repository and to which technology does it pertain?
Grid Control. The MR is two tablespaces in an Oracle Database that contain all available information about administrators, targets, and application managed within Enterprise Manager.
What are the five startup options that can be used?
NOMOUNT, MOUNT, OPEN, FORCE, RESTRICT
Describe STARTUP NOMOUNT.
The parameter file is read and the memory structures are put in place, but they are not communicating with the physical files on disk. At this point the database is unavailable. This is good for recovery or database creation.
Describe STARTUP MOUNT.
The memory structures created during the NOMOUNT phase, plus the instance is now communicating with the physical files. The control files are accessed. This stage is good for general maintenance.
Describe STARTUP OPEN.
The default mode if nothing is explicitly typed. At this stage database is available to all users.
Describe STARTUP FORCE.
This is used when the database won't start by normal means. It performs at SHUTDOWN ABORT and then restarts the database.
Describe STARTUP RESTRICT.
Places database in OPEN mode, but only allows access to users granted with RESTRICTED privledges. Good for maintenance. After maintenance is complete you should perform a ALTER SYSTEM DISABLE RESTRICTED SESSION;
What parameter shows you where the alert log file is being stored?
BACKGROUND_DUMP_DEST
Define the difference between a seed template and a non-seed template.
Seed Templates include the database definition plus datafiles and redo log files. Non-seed templates only include the database definition.
What are the four functional parts of the Oracle Enterprise Management Framework?
Management Services, Database Control, Oracle Management Repository, Manged targets.
What do you expect the contents on a .DJF file to be?
The predefined redo log files and datafiles for a seed template.
What parameter do you set to enable Oracle Managed Files(OMF)?
DB_CREATE_FILES_DEST

You can also enable OMF by omitting the filename what using CREATE TABLESPACE
What are the two types of Extent Management and how do they differ?
Local Extent Management and Dictionary Extent Managemt. Local mangement uses bitmaps to track extents and comes in UNIFORM and AUTOALLOCATE. Dictionary is an old way that stores info in the data dictionary and uses recursive sql to manage extents.