mit_262

Comprehensive Exam for Database Management System

Q1: Choose the correct answer

Data is (facts, raw facts, information)

Registration form represents (Data, DBMS, Knowledge)

There is a relationship between math and computer

programming, this fact represents(data, DB, Knowledge)

Statistics represent (information, DBMS, DD)

DB is a collection of (Organized data, information, Rules)

DB is designed to provide(data files, information, Data)

The software the enable user to create DB is called (DB, DBMS, DD)

Data Dictionary is a (program, application, repository) that stores metadata)

DB Application is a set of (user interfaces, reports, facts) that enable users to

access DB via DBMS.

Data Independency is one objective for (DB, DBMS, Application).

General enquiry facility (query language) of the data

(DDL, DML, DCL)

The person who gather the data and check them based on criteria (DBA, DA, Developer)

The first generation of DB systems (Network, relational, object-relation)

Performance is one of problems for(DB, DBMS, Views)

Provide a level of security is one benefit of (DB, DBMS, Views)

Users should not need to know (physical, Logical, conceptual) database storage details.

Users’ view of the database represents (external, conceptual, internal) level for database design.

Entity-Relationship belongs to(Record-Based, Object-Based, Physical) data model.

DB2 was developed by(IBM- Oracle-Microsoft)

Database for Google is a (central, distributed, closed)

is (Central- distributed- Closed).

The tool that is used for converting Data from format to another is

(GML-HTML-XML)

COBOL language implemented (network, relational, file-based) model

SABREE system for airline was developed by (network, deductive logic, File-based) model.

Network model belongs to (object-based, record-based, document-based) Category.

The Relational model is implemented by (SQL, COBOL, XML) model

The Relational model was developed by (IBM, Microsoft, Intel)

Fixed query is one disadvantages of(Hierarchy, document, file-based) model.

Oracle language implements(fil-based, network, relational) model.

DB for Facebook or twiter is represented by(graph, document, object) model

Datalog Language represents (graph, Deductive-logic, Network) model

The external level for DB design represents (user wants, Community of data, DB in computer)

The level for expressing a bout all data attributes for DB is (external, internal, conceptual)

It supposed general frame that determines three levels for DB design (SABREE, SQL, ANSI)

The first person who proposed modeling DB by graphical technologies is (codde, Jetes, Peterchen)

Entity is a set of (attributes, objects, records)

Any object is distinguished about other objects by (one or more attributes, relationships, entities)

The reflexive relationship is among(two entities, two objects, entity with itself).

Graphs represent (entities, objects, relationships) as nodes.

Face book or Twitter’s database is easily represented as a(documents, graph, deductive logic).

They are the most basic type of NoSQL database (document, graph, key-value)

Predicates and arguments form a collection known as a (proposition, statement, rule)

Multi-valued attributes makes somewhat obsolete in (RDBMS, documents, graph) model.

The relationship among customers and Bells is (1: N, N:M, 1:1)

The relationship between customers and receipts entities is (1: N,

N:M, 1:1)

Age attribute is (derived, input, constant)

Ellipse shape expresses a bout (entity, attribute, relationship)

Person Name attribute is (single, composite, derived) features

Telephone_number attribute is (one value, multi-valued, n values).

Date attribute is (one value, multi-valued, n values).

R system was developed based on (relational, ER, Deductive) Model

Table also called (Tuple, relation, relationship)

The row in the table is called (Tuple, relation, column)

Not Null is an constraint of (integrity, private, general)

When the data of view is stored in DB, this view called(Dynamic, Virtual, Materialized)

Cardinality is a number of(columns, rows, constraints)

Business Rules for any organization mean (private, general, integrity) constraints.

Multiplicity of relation is measured by number of (rows, columns, relationships

Maintaining the correctness of data into database means(integrity, independency, security)

The suitable constraint for student level attribute is (unique, not null, check between)

Each cell in the table must have one value, this represents (constraint, property, key) for suitable table.

Lossless-Join is one of (objectives, conditions, constraints) normalization.

In this dependency, each dependent has only one determinate (compound, Full, Partial) dependency.

Each column either is determent or dependent except(name and ID, P.k and F.K, only P.K)

MVD occurs when the second and third columns have(relationship, no relationship, FD)

Q2: Correct the wrong statement

System catalog provides quantity data.(quality data)

Incompatible file formats is one advantages of Databases.(one disadvantages of file-based systems)

In databases, each program maintains its own set of data. X (in file-based system)

Purchases Application represents a Databases. X(represent DB application)

DDL Permits specification of data types, structures and any data constraints. (True)

A view is essentially some subset of the DBMS. X (subset of Database)

In Database, All users should be able to access same data. (true)

External level describes what data is stored in database and relationships among the data. X (internal level)

The user can accesses to DB via system catalog. X(via DBMS)

Data model is a set of data concepts. (True)

File-based system provide a dynamic queries. X (Fixed)

JSON implements document model. (True)

Expert systems are based on deductive-logic model. (True)

Conceptual level expresses a bout the physical representation for DB. X(internal level)

All users able to access data in file-based systems. X(in Database)

The ER model belong to record-based category. X(object-based)

Codde who proposed ER Model. X(proposed Relational model)

Nary relationship connect among n objects. X (n entities)

Entity is a set of similar attributes. (True)

The relationship among Passengers and Rooms entities is N:N. (True)

The reflexive relationship is among object and itself. X (entity with itself)

The name of university is composite attribute. X (single attribute)

Rectangle shape express a bout the entity. (true)

The relationship among students and courses is 1:1. X (N:N)

The receipt number is input value attribute. X (derived attribute)

Candidate key is selected from alternate key. X(oppsite)

The primary key is selected columns from super key. X(selected from candidate key)

R system is a language for relational Model. (True)

Any DBMS supports candidate key. X(supports primary key)

Foreign key has an unique value for each row. X(primary key)

The constraint of Tel_number attribute is null. (true)

The length of value for level attribute is 6. X(the length is 1 byte)

Each object in ERD is converted to table. X (each entity)

Each relationship in ERD for 1:N is converted to middle Table. X (N: N)

In Full dependency, each dependent column has only one determinate column. true

In FD, each value in a column determines multi values in other column. X (in MVD)

In MVD each value in a column has one value in another/other columns.

Always the P.K column for any table is a dependent for the other columns. X (is a detriment).

The 2NF depends on full dependency. X(partial)

Transitive dependency is a rule of 4NF. X(3NF)

In 5NF, If A determines more than values in B, and A determines more th

an values in C, and there is relationship among B and C. (true)

Company name is normalized by 1NF. X (person name)