• 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

Card Range To Study

through

image

Play button

image

Play button

image

Progress

1/66

Click to flip

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;

66 Cards in this Set

  • Front
  • Back
What are 2 items that make up the Oracle Architecture?
-Relational Database Management System (RDBMS)

-System Global Area
What do table spaces contain?
Data files
What 2 database instances does the ORASVR have?
-AODB
-EMRDB
What does OEM stand for?
Oracle Enterprise Manager
Under OEM what type of interface is used?
Graphical User Interface (GUI) tool.
Describe the 3 Tier Architecture?
The 3 Tier Architecture is defined as an extension of the client-server model. In a 3 Tier Architecture, the applications processing requirements are moved from the client to the application server tier.
What are the 3 Tiers under the 3 Tier Architecture?
-Client Tier (1)
-Middle Tier (2)
-Database Tier (3)
What is the name of the Oracle listener?
5x6t203Ks4. The Oracle listener must NEVER change, the system will not function correctly afterwards.
What does DBAdmS stand for?
Database Administrator Server.
What does DBAmR stand for?
Database Administrator Runtime.
What are 2 items that make up the Oracle Architecture?
-Relational Database Management System (RDBMS)

-System Global Area
What do table spaces contain?
Data files
What 2 database instances does the ORASVR have?
-AODB
-EMRDB
What does OEM stand for?
Oracle Enterprise Manager
Under OEM what type of interface is used?
Graphical User Interface (GUI) tool.
What are some DBADMIN Responsibilities?
-AODB Reset
-SITEINFO
-ABP Purge
-Database Backups
-Restoring Oracle Database
What are important items to know about Oracle Database Backups?
-Off-line backups require the Oracle database be brought down and all files that make up the database be copied into one single compressed file.
IRT Oracle Database Backups the make off-line Backup Script creates what two files in the /h/TBMDBA/data/site directory?
backup_<service_name>.csh, which contains the commands

files_>service name>.lis, which contains the list of files to backup.
What must be done after any database is completely restored?
That database must be immiediately backedup using the off-line backup procedures.
What version of Oracle does TBMCS 1.1.3 use?
Oracle 9i.
What are the 2 segments that makes up the Database Administrator Group?
-DBAmR and DBAmS.
What login must a user have in order to have access to the following DBAMIN software?
dbadmin1
The standard off-line backup script uses ____ with the file specifications relative to the root directory (/)?
tar, when using tar this means the restored database files go back to the same locations they came from if the user is in root when restoring.
What is the equivalent server for TBMCS 1.1.3 ORASVR build?
Netra 20, V440
What does Intel Database Tools provide?
IDBTLS provides GUI for most tasks to be performed by the SYBASE DBA.
What is Bulk Copy Data?
-One file for each table in the selected database.
-The file names are the same as the table names.
-files with a length greater than 0 are compressed with the UNIX compress utility.
-File extensions are .bcp for files that are not compressed, and .bcp.Z for compressed files.
What are some items associated with DMPI statistics?
-TBMCS dictates that DMPI's follow certain business rules:

DMPI's received from external sources do not always adhere to the rules.

The DMPI statistics application reports the rule and the number of DMPI's that do not adhere to the rule.
What is Tie Table Maintenance?
The number of records in the facility tie table tied to the target list should equal the number of records in the target list tie table that are tied to a facility.
What are some details associated with Update Database Statistics IRT when they should be completed?
-Scheduled to be performed at least once a week.

-Updating database statistics during off-peak hours is recommended.
What are some items related to Backing Up and Restoring Data using the Sybase bcp utility?
-transfers data and only data at high speeds between a table and an operating system file.

-bcp can be used to transfer data from other database vendors, spreadsheet applications, and other Sysbase servers.

-BCP out/in can either be performed using IDBTLS, or can be performed from the command line.
What does AIIM stand for?
Automated Image Import Module.
What are some functions of AAIM?
-Mission is to provide automated services for importing imagery from local and remote file systems into the ITS Server, and to provide management of the ITS Server Search Profiles and standing queries.

Provides ability to configure and manage the trieval of imagery from remote servers such as IPL (Image Product Library) by providing setup tools for ITS Server data search profiles and standing queries.
What are some Image formats that are used with AIIM?
1. National Imagery Transmission Format (NITF) 1.1, NITF 2.0

2. Graphic Interface Format (GIF)

3. Joint Photographic Experts Group (JPEG)

4. Tagged Image Format File (TIFF)

5. Sun Raster

6. Vitec

7. XWindows Dump Utility (XWD)
What does ITSAPP stand for?
Image Transformation Services Applications.
What are some items that ITSAPP provide?
-Client applications
-Image Transformation Services Server (ITSSVR) administration
-Image data transformations (rotations and scaling)
-Image data format translations.
What 2 functions does ITSAPP provide?
-ITS Transform
-ITS Admin
What is the new name for Delay Postscript (DPS)?
ITS
What does ITSSVR stand for?
Image Transformation Services Server
What are some functions that ITSSVR provide?
-Provides cataloging, linking, management, selective archiving, and retrieval of digital imagery.

-Provides data integration with Global Command and Control System (GCCS) by:

Maintaining the imagery catalog within the MIDB GMI server
What are some functions associated with a being a SYBADM Sybase Administration?
-Provides DBA functions and capabilities by maintaining and managing the ISDS.
-Backup Intel SDS
-Restore Intel SDS
-Database Statistics Manager for Updating Statistics
What does TISUP stand for?
TBMCS Intel Support.
What are some functions that TISUP provides?
-Creates databases and database objects to support TBMCS Intel Applications.

-Creates ADIDB, EOBSVCDB, TWMDB, TISUPDB, IRISDB, DAADB, TGTSVCDB, and TGTDCCDB
What does SYBC stand for?
Sybase Client.
What are some functions that SYBC provides?
Copies the Runtime Portion of the Sybase Open Client / C Developer's Kit COTS to the hard disk.

-Ver 11.9.2.6
What does SYBS stand for?
Sybase SQL Server Segment
What are some functions that SYBS provides?
-Adaptive Server Enterprise Ver 11.9.2.6
-Sybase SQL Server segment is installed on a machine to provide database maintenance capabilities for DII databases and Applications.
-It provides the functionality to Retrieve data through SQL, to interface with the databases on disk, and to control access to individual databases.
What does DBADMR stand for?
Database Administration Runtime.
What are some functions that DBADMR provides?
-Provides DBA with a set of GUI's that allow some basic system setup in preparation of database segment installation.

Supplies the following tools:

Identify Storage: Identifies disk devices on a COE Database Server and allows the DBA to allocate and de-allocate physical storage on those disks.
-Server Control: starts and stops the database management server.
-Set Password: Prompts for and sets the DBA Password.
-Error Log
What does DBADMS stand for?
Database Administration Server.
What are some functions that DBADMS provides?
-Provides DBA Server process to support DBAdmR GUI tools.
-Provides the API's used by segments to create/drop data stores.
What does GDUS stand for?
GMIDB Data for US Only.
What are some functions that GDUS provides?
Loads data into select tables in the GMI, constraints, and Support Databases.
What does GMIDB stand for?
General Military Intelligence Database.
What are some functions that GMIDB provides?
-Creates 4 databases:
1. GMI: provides data on equipment, Fac, Unit, Order of Battle, Tracks, Observations.
2.Alerts: holds query information.
3.Constraints: holds constraints for certain GMI fields.
4. Support: Supports the software, contains stored procedures, and contains data lookup values.
What does IMOM stand for?
Improved Many on Many.
What are some functions that IMOM provides?
-Two Dimensional, Graphically oriented analyst aid for simulation of an Electronic Combat (EC) environment conditioned by the effects of Electronics Countermeasures (ECM).

-Shows effects of terrain masking on ground based radar systems and accounts for weapon systems capabilities.
What does IDBTLS stand for?
Intel Database Tools
What are some functions of IDBTLS?
It is a collection of tools each with a GUI that enables a DBA to monitor, copy, and maintain the data on a Sybase Data Server.
What does IDBUSR stand for?
Intel Database Users.
What are some functions of IDBUSR?
-Executes SQL to create applications users.
-Consists of users only; no tables are created by this segment.
-Multiple users are created and specific roles are granted to each.
-If this segment is de-installed / re-installed, the passwords will have to be reset on the weblogic server.
What does ISHOPD stand for?
Intelligence Shop Data Store.
What are some functions ISHOPD provides?
-Contains Structures to hold persistent I3 business objects supporting the Intelligence Shop Middle Tier Components (ISHOPM)
What does ITS stand for?
Image Transformation Services.
What are some functions that ITS provides?
-Provides archiving, catalog, and retrieval of digital products and related data.
-Provide client interface to other segments which allow data entry/catalog, query, selection, and data retrieval.
-Additional functions provided by ITS include: file format translations, image scaling, and backup/restore.
-The transformation functions are also available to the client.
What are rules?
Enforce the domain of values permitted for a column within a database. This rule would be enforced during every insert or update to a table for the column, once the rule is bound to the column.
What are check constraints?
They also enforce the domain of values.