Database Quiz Questions

File processing systems have important limitations Data is separated and isolated Data is often duplicated Application programs are dependent on file format All of the above None of the above

All of the above

The property / properties of a database is / are : It is an integrated collection of logically related records. It consolidates separate files into a common pool of data records. Data stored in a database is independent of the application programs using it All of the above

All of the above

Which of the following is Database Language? Data Definition Language Data Manipulation Language Data Query Language All of the above

All of the above

Which of the following is a function of the DBMS? 1. Storing data 2. Providing multi-users access control 3. Data Integrity 4. All of the above

All of the above

To allow users to manipulate the information, the system has a number of Application programs Application files Manipulation program Manipulation files

Application programs

A characteristic of an entity. Relation Attribute Parameter Constraint

Attribute

DBMS helps achieve Data independence Centralized control of data Neither A nor B Both A and B

Both A and B

Let R1(A, B, C, D) and R2(P, Q, R, S) be two relations in which A is the foreign key of R1 that refers to the primary key of R2. Which of the following operations causes the referential integrity constraint violation? a) insert into R1 b) Delete from R1 c) Insert into R2 d) Delete from R2 e) Both (a) and (d)

Both a and d

Statement 1: A tuple is a row in a relation Statement 2: Existence of multiple foreign keys in a same relation is possible ---------------------- Both the statements are true Statement 1 is correct but Statement 2 is false Statement 1 is false but Statement 2 is correct Both the statements are false

Both the statements are true

Database processing programs: Call the DBMS to access the stored data Cannot be used more than on process Require at least one dedicated workstation Present problems with storage space

Call the DBMS to access the stored data

In relational database minimal superkeys is known as: Reference keys Candidate keys Foreign Keys Primary keys None of the above

Candidate Keys

A(n) ____ model is independent of both hardware and software. conceptual external developmental Physical

Conceptual

Which stage of data modeling focuses on creating a high-level representation of data requirements? Logical Data Modeling Physical Data Modeling Conceptual Data Modeling Database Implementation

Conceptual Data Modeling

The restrictions placed on the data. Relation Attribute Parameter Constraint

Constraint

Data Manipulation Language (DML) is not to Insertion of new information into the Database Modification of information in the Database Create information table in the Database Deletion of information in the Database

Create information table in the database

Which of the following is not a level of data abstraction? View Level Physical Level Logical Level Critical Level

Critical Level

Data independence means A) Data is defined separately and not included in programs B) Programs are not dependent on the physical attributes of data. C) Programs are not dependent on the logical attributes of data D) Both (B) and (C)

D

They design and implement the DBMS modules and interfaces as a software package Real - time and active database technology Data warehouses and online analytical processing (0LAP) DBMS system designers and implementers System protection

DBMS system designers and implementers

Which of the following is generally used for performing tasks like creating the structure of the relations, deleting relation?

DDL (Data Definition Language)

Which of the following provides the ability to query information from the database and insert tuples, delete tuples from, and modify tuples in the database?

DML (Data Manipulation Language)

A type of data abstraction that is used to provide a conceptual representation Big data Data model Transaction Casual end users

Data model

Snapshot of the data in the database at a given instant of time is called Database Instance All of the options Database Schema Database Snapshot

Database Instance

Logical design of database is called All of the options Database Schema Database Instance Database Snapshot

Database Schema

___________ are considered database architects. Database administrators Systems administrators Database designers Systems analysts and programmers

Database designers

Which of the following is FALSE about the properties of relations? There is no significance to attribute domains Duplicate values are present in the tuple Tuples can be ordered in any order None of the above

Duplicate values are present in the tuple

DBMS manages the interaction between __________ and database. System Analysts Compilers End Users Stake Holders

End Users

Which would most likely NOT be an entity on an ERM? Student Professor Class Enroll

Enroll

Which of the following in true regarding Referential Integrity? Every primary-key value must match a primary-key value in an associated table Every primary-key value must match a foreign-key value in an associated table Every foreign-key value must match a primary-key value in an associated table Every foreign-key value must match a foreign-key value in an associated table

Every foreign-key value must match a primary-key value in an associated table

ERM is an acronym for Enterprise Reliability Model. True or false

False

The relationship among the instances of three entity types is called a unary relationship. True or False

False

True or False At most 2 distinct entity sets can be associated with any relationship set R.

False

With the traditional file processing approach, each application shares data files, thus enabling much data sharing. True or False

False

What can store and analyze maps, weather data, and satellite images?

Geographic information systems (G I S)

The actual content in the database at a particular point. Schema Attribute Parameter Instance

Instance

Which of the following in not a function of DBA? Network Maintenance Schema Definition Authorization for data access Routine Maintenance

Network Maintenance

Which of the following is a navigational data model model? Network Model Object oriented model E-R Model None of these

Network Model

The subset of a super key is a candidate key under what condition? No proper subset is a super key All subsets are super keys Subset is a super key Each subset is a super key

No proper subset is a super key

The subset of super key is a candidate key under what condition? No proper subset is a super key All subsets are super keys Subset is a super key Each subset is a super key

No proper subset is a super key

An entity in A is associated with at most one entity in B, and an entity in B is associated with at most one entity in A.This is called as One-to-many One-to-one Many-to-many Many-to-one

One-to-one

Which data modeling stage involves transforming the logical data model into a database-specific schema? Conceptual Data Modeling Logical Data Modeling Physical Data Modeling Database Implementation

Physical Data Modeling

DBMS is a set of __________ to access the data. Codes Programs Information Metadata

Programs

Relationships among entities of the same type are called_______? IS-A relationships Recursive relationships HAS-A relationships None

Recursive relationships

The three major parts of an ERM diagram are: Process, data flow, data store Attribute, modularity, cardinality Relationship, data flow, entity Relationship, attribute, entity Process, entity and relationship

Relationship, attribute, entity

It is better to use files than a DBMS when there are Stringent real-time requirements Multiple users wish to access the data Complex relationships among data All of the above

Stringent real-time requirements

A completeness constraint may specify that each entity of the supertype must be a member of some subtype in the relationship. True or false

True

A data model is a graphical system used to capture the nature and relationships among data. True or False

True

An entity instance of a subtype represents the same entity instance of the supertype. True or false

True

A Database System is: Meta Data Collection of programs to access data Collection of interrelated data All of the above

all of the above

Data Manipulation Language enables users to Retrieval of information stored in database Insertion of new information into the database Deletion of information from the database All the above

all of the above

____ command can be used to modify a column in a table alter update set create

alter

relationships modeled as an entity type

associative entity

property of an entity

attribute

The property by which subtype entities possess the values of all attributes of a supertype is called: hierarchy reception. class management. multiple inheritance. attribute inheritance.

attribute inheritance

specifies maximum and minimum number of instances.

cardinality constraint

A(n) ________ constraint is a type of constraint that addresses whether an instance of a supertype must also be an instance of at least one subtype. disjoint overlap completeness weak

completeness

An attribute that can be broken down into smaller parts is called a(n) ________ attribute. associative simple composite complex

composite

facts, text, graphics, images, etc

data

An advantage of the database management approach is....

data is integrated and can be accessed by multiple programs

A ____ focuses primarily on storing data used to generate information required to make tactical or strategic decisions.

data warehouse

The DBMS acts as an interface between ____________ and ___________ of an enterprise-class system

database application database

A collection of interrelated data and a set of programs to access those programs is known as....

database system

The number of entity types that participate in a relationship is called the: number. identifying characteristic. degree. counter.

degree

An attribute of an entity that is computed is a(n): optional attribute. composite attribute. derived attribute. fuzzy attribute.

derived attribute.

Customers, cars, and parts are examples of: entities. attributes. cardinals. relationships.

entities

person, place, object, concept, event.

entity

In entity-relationship models, a member of a subtype does NOT necessarily have to be a member of the supertype. True or false

false

Data redundancy and Data Inconsistency is one of the major drawbacks of File processing system File retrieval system File storage system File updating system

file processing system

Which of the following is not involved in DBMS? End Users Data Application Request HTML

html

uniquely identifies entity instances.

identifier

A(n) ________ is the relationship between a weak entity type and its owner. member chain identifying relationship jump path chain link

identifying relationship

Which type of data can be stored in the database?

image oriented data, text, files containing data, data in the form of audio or video

A level that describes data stored in a database and the relationships among the data. physical logical user view

logical

An entity in A is associated with at most one entity in B. An entity in B, however, can be associated with any number (zero or more) of entities in A. One-to-many One-to-one Many-to-many Many-to-one

many to one

Which of the following statements are true: 1. Each superkey is a superset of some candidate key, 2. Each primary key is also a candidate key, but there may be candidate keys that are not primary keys). ---------------------------- only 1 is true only 2 is true both 1 and 2 are true neither 1 nor 2 are true

neither 1 nor two are true

A strong entity depends on the following: weak entity attribute owner associative entity none of the above

none of the above

In a supertype/subtype hierarchy, each subtype has: only one supertype. many supertypes. at most two supertypes. at least one subtype.

only one supertype

an entity belongs to two subtypes.

overlap rule

The ________ rule specifies that an entity instance of a supertype is allowed not to belong to any subtype. semi-specialization total specialization partial specialization disjointness

partial specialization

The rule specifies that an entity instance of a supertype is allowed not to belong to any subtype. overlap total specialization partial specialization disjointness

partial specialization

Which of the following can be a multivalued attribute? Phone_number Name Date_of_birth All of the mentioned

phone_number

A level that describes how a record is stored is......

physical level

Data ____ exists when the same data are stored unnecessarily at different places. dependency redundancy inconsistency fragmentation

redundancy

Which data modeling concept ensures that every relationship is supported by accurate and existing data? Entity integrity Referential integrity Data integrity Domain integrity

referential integrity

association between entity types.

relationship type

A ......... is used to define overall design of the database schema application program data definition language code

schema

A logical structure of the database

schema

Thus a _______ of course data gives the values of all attributes, such as title and department, of all courses at a particular point in time. Instance Snapshot Both Instance and Snapshot All of the mentioned

snapshot

creating subtypes for an entity type

specialization

The most common types of entities are: strong entities. weak entities. associative entities. smush entities.

strong entities

An attribute of the supertype that determines the target subtype(s) is called the: determinant. subtype decision. disjoint indicator. subtype discriminator.

subtype discriminator

generalized entity type.

supertype

In a supertype/subtype hierarchy, subtypes that are lower in the hierarchy inherit attributes from not only their immediate supertype but from all ________ in the hierarchy. subtypes supertypes constraints dimensions

supertypes

Before use of the DBMS, information was stored using....

the file management system

Subtypes should be used when: there are attributes that apply to some but not all instances of an entity type. supertypes relate to objects outside the business. the instances of a subtype do not participate in a relationship that is unique to that subtype. a recursive relationship is needed.

there are attributes that apply to some but not all instances of an entity type.

The architecture of the database can be viewed as how many levels?

three levels

The hierarchical database model is based on a ____. tree structure lack of a parent segment lack of a child segment matrix

tree structure

Which of the following isn't a level of abstraction? physical logical user view

user

The ______level helps application programs hide the details of data types. physical logical user view

view

An entity type whose existence depends on another entity type is called a ________ entity. strong weak codependent variant

weak