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