CS6400-EXAM1 NEWEST ACTUAL QUESTIONS WITH

CS6400-EXAM1 NEWEST ACTUAL / QUESTIONS WITH

CORRECT ANSWERS VERIFIED/GRADED A+)

DDL (Data Definition Language) - ----Answers----is used by the DBA and by database designers to define both schemas

Storage Definition Language (SDL) - ----Answers----Used to specify the internal schema

View Definition Language (VDL) - ----Answers----Specifies user views/mappings to conceptual schema

Data Manipulation Language (DML) - ----Answers----DBMS language that changes database content, including data element creations, updates, insertions, and deletions

Two main types of DMLs - ----Answers----1) A high-level or nonprocedural DML can be used on its own to specify complex database operations concisely.called set-at-a-time or set-oriented DMLs.2) A low-level or procedural DML, retrieves individual records or objects from the database and processes each separately.also called record-at-a-time DML

It is more difficult to provide logical data independence than to provide physical data independence - ----Answers----TRUE 1 / 3

Buffer Management Module - ----Answers----schedule disk read/write, because management of buffer storage has a considerable effect on performance. Reducing disk read/write improves performance considerably.

Stored Data Manager Module - ----Answers----controls access to DBMS information that is stored on disk, whether it is part of the database or the catalog.

interactive query - ----Answers----Used by casual users and persons with occasional need for information from the database

query optimizer - ----Answers----A DBMS process that analyzes SQL queries and finds the most efficient way to access the data. The query optimizer generates the access or execution plan for the query.

precompiler - ----Answers----extracts DML commands from an application program written in a host programming language

Runtime Database Processor - ----Answers----executes (1) the privileged commands, (2) the executable query plans, and (3) the canned transactions with runtime parameters

• / 3

Stored Data Manager - ----Answers----uses basic operating system services for carrying out low-level input/output (read/write) operations between the disk and main memory

Database System Utilities - ----Answers-----Loading -Backup -Database storage reorganization -Performance monitoring

data dictionary - ----Answers----compiles all of the metadata about the data elements in the data model

Information Repository - ----Answers----A component that stores metadata that describe an organization's data and data processing resources, manages the total information processing environment, and combines information about an organization's business information and its application portfolio.

communications software - ----Answers----allows users at locations remote from the database system site to access the database through computer terminals, workstations, or personal computers

Centralized DBMS - ----Answers----- Combines everything into single system including DBMS software, hardware, application programs, and user interface processing software.

• / 3