Reading...
Play button
Play button
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;
80 Cards in this Set
- Front
- Back
|
What is the difference between Database Control and Grid Control?
|
The Database Control manages only one database. The Grid Control manages multiple databases, both local and remote.
|
|
|
List the 9 key components that come with Oracle 10g
|
1. Oracle 10g Database
2. Oracle Net Services 3. Java/Web 4. Oracle Enterprise Manager (OEM) 5. OEM Wizards 6. SQL*Plus 7. Utilities 8. Pre-compilers 9. Add-ons |
|
|
What types of Utilities are included in Oracle 10g? Give some examples.
|
backup, recovery and transport utilities.
- Recovery Manager - Data Pump Export and Import - Migration tools, allowing loading from flat files and transferring from one character set to another |
|
|
What engines are included in the Oracle 10g database?
|
PL/SQL engine
JVM (Java Virtual Machine) engine |
|
|
What key component of Oracle 10g is "the gateway into the database" for other components and also for non-Oracle products?
|
Oracle Net Services
|
|
|
What function does Oracle Net Services serve?
|
Provides the network link between the Oracle 10g database and most applications that communicate with the database.
|
|
|
Which Oracle 10g component integrates many utilities and monitoring tools into a GUI interface for administrating Oracle 10g?
|
Oracle Enterprise Manager (OEM)
|
|
|
What types of tools are included in the Standard Pack of OEM Wizards?
|
management tools for creating users, tables and objects and administering storage space
|
|
|
Describe the functionality of SQL*Plus.
|
-Accepts standard SQL with Oracle enhancements
-Allows: - the creation and execution of queries - adding rows - modifying data - writing reports |
|
|
What do pre-compilers do?
Name 2 examples of pre-compilers. |
-support embedded commands within external programming languages, such as COBOL, C and C++.
- Examples: Pro*COBOL, Pro*C |
|
|
Name 9 add-ons that require additional licensing
|
- Oracle Partitioning
- Oracle Clusterware - Oracle Spatial - Oracle Data Mining - Oracle COM Automation Feature - Oracle Database Expansions for .NET - Oracle Advanced Security - Oracle Label Security - Oracle OLAP Services |
|
|
What is Oracle Clusterware?
How does it speed up processing time? |
-management tools that support database clusters and computer grids.
-Allows long-running tasks to be spread among several databases |
|
|
What function does Oracle Partitioning serve?
What types of tables may benefit from partitioning? |
-Builds the capability to partition tables across multiple tablespaces
Beneficiaries: - High-volume tables, such as historical records in data warehouses - Online Transaction Processing (OLTP) database tables can also benefit from the use of partitioning |
|
|
What types of objects are handled by Oracle Spatial?
|
spatial objects, which store data related to time and space, allowing calculation of distance or time between objects, and to draw lines, polygons, points on a map and similar functions
|
|
|
What support does Oracle Data Mining provide?
|
supports setting up algorithms and functions that search and retrieve data warehouse information
|
|
|
Who might use the Oracle COM Automation Feature?
|
PL/SQL developers use it to manipulate COM components
|
|
|
What are some uses for Oracle Advanced Security?
|
- outgoing data encryption
- special methods of user authentication, such as those used with ATMs, requiring a physical bank card and entering a PIN |
|
|
What unique feature does Oracle Label Security provide?
|
ability to designate row-level security profiles which can be assigned to a user's security profile, thereby restricting the access to rows within a table or view
|
|
|
How do datafiles look and function with and without OLAP Services?
|
- with OLAP Services, datafiles look like normal files in a standard file directory, and when opened, are extracted by Oracle and display actual readable data.
- without OLAP services, datafiles are seen in the standard directory, but are unreadable when opened through the operating system |
|
|
Define database
|
the collection of operating system files that store your data
|
|
|
Databases are made up of what 3 types of files?
|
-control files
-database files -redo log files |
|
|
What are the 2 main components of a database instance?
|
-memory (System Global Area-SGA)
-background processes |
|
|
Generally speaking, what do the background processes manage?
|
-user interaction with the database
-memory -integrity -I/O (input/output) |
|
|
Name 3 different configurations used to implement a database server.
|
-Single-instance server
-Multiple-instance server -Clustered servers (Real Application Clusters-RAC) |
|
|
Describe the configuration of a single-instance server
|
One computer with one set of database files and one instance that accesses the files
|
|
|
Describe the configuration of a multiple-instance server
|
One computer with multiple instances, each with their own database files, each running independently of one another.
|
|
|
What server configuration would be useful for one powerful computer supporting two independent development teams
|
Multiple-instance server
|
|
|
Describe the configuration of a clustered server.
|
a clustered configuration of several computers (database nodes) each containing one database instance. Another computer (file server), or a specialized storage device, houses the database files, which are shared by all the instances. The cluster manager, residing on a separate computer or on one of the nodes, coordinates all the instances and the tasks that each one handles.
|
|
|
What server configuration would be useful for applications requiring speed for processing massive amounts of data or complex calculations?
|
Clustered servers, using Oracle Real Application Clusters (RAC)
|
|
|
What is a user process?
|
created by the user's application to control the connection to the database process.
|
|
|
What is a server process?
|
the process on the database side that interacts with the user process
|
|
|
Name 2 basic methods used to connect the user process to the server process.
|
-Dedicated server
-Shared servers |
|
|
Describe the Dedicated Server connection method
|
one user process with one server process
|
|
|
Describe the Shared Servers connection method
|
multiple user processes share a minimal number of server processes
|
|
|
Which server connection method is better for systems with fewer users?
|
Dedicated Server
|
|
|
Which server connection method is better for user processes that require a great deal of processing time on the database?
|
Dedicated Server
|
|
|
Which server connection method is better for serving a large number of users at once, as a web server or application server would do?
|
Shared Servers
|
|
|
A predefined database created on installation is configured in which server connection mode?
|
Dedicated Server
|
|
|
What is the biggest advantage of installing Oracle 10g R2.03 versus keeping Oracle 10g R2.01?
|
Daylight Savings Time-the recent changes to which dates DST starts and stops are implemented in 10.2.03. In 10.2.01 the database does not function during the weeks where DST is still in effect when it would not have been under the old DST rules.
|
|
|
What are the advantages of an n-tier system?
|
- processing power
- isolation of changes to a specific tier (changes in one tier should not affect the other tiers) |
|
|
What are the major options for Server-Side installation?
|
- Enterprise Edition
- Standard Edition - Personal Edition |
|
|
What are the options for Client-Side installation?
|
-Administrator
-Runtime -client software -custom |
|
|
What types of requirements should lead a business to choose Enterprise Edition over Standard Edition?
|
-Multiple concurrent users
-Applications connecting to db -High data volume -Multiple db instances support the business and may be networked -db replication is necessary for duplicating data across multiple sites |
|
|
What types of requirements would be sufficient for Standard Edition?
|
-small number of users, such as those in a single department within a company
-no need for future upgrading of additional features, such as partitioning or clustering |
|
|
What are some uses of the Personal Edition?
|
-A single user accessing the database instance
-Programming of applications which can then be migrated to Enterprise Edition -Deployment of single-user applications |
|
|
Does Enterprise Edition have more system requirements than Personal Edition?
|
No. Personal Edition can be installed on all platforms available to the Enterprise and Standard editions.
|
|
|
What features are included in the Administrator installation option?
|
-Enterprise manager
-many of the same features on the client as Enterprise Edition provides on the server side, except that there is no database installed |
|
|
Who are the intended users of the Runtime option?
|
programmers who are developing applications on their own client machines while using a remote database as the connection to the database.
|
|
|
Who are the recommended users of the Administrator runtime option?
|
Only DBAs and Jr. DBAs
|
|
|
What is the name of the directory tree under which Oracle executable files are stored?
|
ORACLE_HOME
|
|
|
What is the path to all Oracle software?
|
ORACLE_HOME
|
|
|
In what 2 ways does Optimal Flexible Architecture (OFA) improve performance through its physical placement of files?
|
-spreads I/O functions across separate devices by separating data from software
-Improves performance by separating products into distinct directories that can be located on separate devices to reduce bottlenecks |
|
|
In what 2 ways does Optimal Flexible Architecture (OFA) improve performance through its naming standards?
|
-Speeds up administrative tasks, such as backups, by using naming standards for file types
-Improves detection and prevention of fragmentation in datafiles by using naming standards that quickly identify which tablespace and datafile are associated with one another |
|
|
What is the path to all Oracle files and database storage?
|
ORACLE_BASE
|
|
|
What directories are found under ORACLE_BASE?
|
- Admin/<database name>
- db_1 - client_1 - oradata/<database name> - flash_recovery_area |
|
|
Using OFA, in which directory are the database's datafiles, control files and redo logs found?
|
ORACLE_BASE/oradata/<database name>
|
|
|
Using OFA, in which directory are the initialization files and high-level log files stored?
|
ORACLE_BASE/Admin/<database name>
|
|
|
Using OFA, which directory contains the Oracle database server installation, the database engine and Oracle Net Services software?
|
ORACLE_BASE/db_1
|
|
|
Using OFA, which directory contains the client installation?
|
ORACLE_BASE/client_1
|
|
|
Using OFA, which directory contains backup and recovery files, including archive log files?
|
ORACLE_BASE/flash_recovery_area
|
|
|
Can ORACLE_HOME contain multiple installations?
|
No
|
|
|
Can ORACLE_BASE contain multiple installations?
|
Yes
|
|
|
Using OFA, which directory contains most of the executables?
|
ORACLE_HOME/bin
|
|
|
Define control file.
|
Administrative file containing up-to-date info on db structure, log files, checkpoints. It is a critical file for opening the database.
|
|
|
Define redo log file.
|
set of files that record changes to db data.
|
|
|
Which type of file records changes immediately?
|
Online redo log files
|
|
|
Which type of file contains copies of current and past redo logs for recovery if needed?
|
Archive redo log files
|
|
|
What is the filename extension for control files?
|
ctl
|
|
|
What is the filename extension for redo log files?
|
log
|
|
|
What is the filename extension for datafiles?
|
dbf
|
|
|
Define datafile.
|
A physical file on the computer disk containing data, such as tables and indexes.
|
|
|
To how many tablespaces may a single datafile belong?
|
One
|
|
|
May a tablespace have more than one datafile?
|
Yes
|
|
|
What is a grid?
|
a group of many computers linked together over a network, acting as a single computer or hardware resource
|
|
|
What is the most complete, robust installation option for the server side?
|
Enterprise Edition
|
|
|
What is the name of the user-friendly interface which installs or uninstalls all Oracle products?
|
Oracle Universal Installer
|
|
|
Can the Oracle Universal Installer install non-Oracle applications?
|
Yes, using the Oracle Software Packager, custom applications can be packaged into components which can be installed by the OUI
|
|
|
What are the new and improved versions of the Export and Import Utilities?
|
Data Pump Export and Import utilities
|
|
|
Your database server uses shared server processes. You have 50 user sessions. What is the least number of server sessions you can have?
|
One
|
|
|
Your database server uses dedicated server processes. You have 50 user sessions. What is the least number of server sessions you can have?
|
50
|
