BT 0066 Database Management System

BT 0066 Database Management System

ABBSOFT COMPUTERS

BT 0066 Database Management System

One Marks Each

1)A database is a collection of ______stored s that it is available to may users for different purposes.

  1. related information
  2. contents
  3. words
  4. information summary

Ans a.

2)Data is known ______that can be recorded and have an implicit meaning.

  1. storage
  2. fact
  3. architecture
  4. symbol

Ans b.

3)DBMS is a software package/system to facilitate the ______of a computerized database.

  1. creation and management
  2. design and store
  3. store and retrieve
  4. storage and management

Ans a.

4)Data independence is usually considered from two points of view: physical and ______

  1. conceptual
  2. external
  3. internal
  4. logical

Ans d.

5)Which is true__

  1. Physical data independence allows changes in the physical storage device.
  2. Logical data independence indicates that conceptual schema can’t be changed without affecting the existing external schema.
  3. The concept of data independence is not similar in many respects to the concept of abstract data type in modern programming language like C++.
  4. None of the above

Ans a.

6)The data model is one part of the ______design process.

  1. proportional
  2. logical
  3. conceptual
  4. functional

Ans c.

7)E-R data model is one of several ______data models.

  1. semantic
  2. static
  3. dynamic
  4. restricted

Ans a.

8)Entities are basic data______.

  1. relation
  2. dependence
  3. objects
  4. attributes

Ans c.

9)Attribute are characteristics of ______.

  1. Entities
  2. Identifiers
  3. Descriptors
  4. Keys

Ans a.

10)Two types of attributes are identifiers and _____

  1. nonkey
  2. descriptors
  3. entities
  4. instance

Ans b.

11)Relationship represents real-world ______among one or more entities.

  1. association
  2. combination
  3. notation
  4. description

Ans a.

12)A role is the name of one end of ______, when each end needs a distinct name.

  1. database
  2. relation
  3. definition
  4. entity

Ans b.

13)A database allows the sharing of data under its control by any number of______.

  1. domain
  2. application
  3. solution
  4. entity

Ans b.

14)Each external view is described by means of a schema called an ______

  1. internal schema
  2. external schema
  3. conceptual schema
  4. traditional schema

15)The external schema consists of the definition of the ______in the external view.

  1. logical records and relationships
  2. conceptual view
  3. logical view
  4. physical relations

Ans a.

16)One conceptual view represents the entire ______.

  1. Schema
  2. Logic
  3. Database
  4. Record

Ans c.

17)Which of the following is true?

  1. The recovery manager is not a part of MySQL.
  2. MySQL is based on tiered architecture.
  3. The structure of MySQL consists of 12 subsystems.
  4. All are true.

Ans b.

18)The Query Engine consists of three interrelate components Syntax Parser, Query Optimizer and ______-

  1. Query Processor
  2. Execution components
  3. Query Analyzer
  4. Execution Storage

Ans b.

19)The function of transaction manager is to facilitate ______in data access.

  1. concurrency
  2. locality
  3. permission
  4. concept

Ans a.

20)The recovery manager’s job is to keep copies of data for ______later.

  1. access
  2. traverse
  3. delete
  4. retrieve

Ans d.

21)OLTP stands for

  1. Over Line Transaction Power
  2. Off Line Transaction Process
  3. Online Transaction Processing
  4. None of the above

Ans c.

22)Which is true?

  1. The oracle server consists of physical files and memory components.
  2. The oracle instance consists of centralized repository and databases.
  3. The oracle database is the centralized repository where the data is stored.
  4. All are true.

Ans a.

23)Two main type of facilities provided with DBMS are ______

  1. DSL and DDL
  2. VDL and VDU
  3. DDL and DML
  4. VSL and DDL

Ans c.

24)DML is a language that enables users to ______as organized by data model.

  1. maintain
  2. access or manipulate
  3. access or store
  4. store

Ans b.

25)DML provides commands to select and ______

  1. retrieve
  2. display
  3. manage
  4. delete

Ans a.

26)A______is a statement in the DML that requests the retrieval of data from the database.

  1. SQL
  2. PL/SQL
  3. Query
  4. Language

Ans c.

27)The data manipulation function provided by DBMS can be invoked in application programs directly by______

  1. procedure calls
  2. system calls
  3. locations
  4. RAM

Ans a.

28)Two types of DML are ______

  1. Sequential and Non Sequential
  2. Procedural and Non Procedural
  3. Hierarchical and Sequential
  4. SQL and PL/SQL

Ans b.

29)DML ______converts DML statements embedded in an application program to normal procedure calls in the host language.

  1. compilers
  2. compilers and precompilers
  3. precompilers
  4. variants

Ans c.

30)A data dictionary provides ______of data items.

  1. character
  2. definition
  3. facilities
  4. value

Ans b.

31)A ______uses the data dictionary in every phase of a database life cycle.

  1. professional
  2. manager
  3. DBA
  4. Client

Ans c.

32)The hierarchical data model organizes data in ______structure.

  1. tree
  2. point
  3. graph
  4. network

Ans a.

33)The CODASYL network model is based on mathematical ______.

  1. calculations
  2. set theory
  3. operation
  4. logic

Ans b.

34)Object DBMS add database functionality to object ______language.

  1. structure
  2. analysis
  3. programming
  4. numerical

Ans c.

35)A tuple is a ______of an entity or the relation represents relationship or whatever.

  1. object
  2. instance
  3. example
  4. arrangement

Ans b.

36)Duplicate ______are not permitted in RDBMS.

  1. records
  2. instances
  3. database
  4. tuple

Ans d.

37)An ______is a “thing” or object in the real world that is distinguishable from all other object.

  1. entity
  2. element
  3. address
  4. attribute

Ans a.

38)An attribute of an entity type for which each entity must have a unique value, is called a ______.

  1. additional key
  2. composite key
  3. key attribute
  4. access control

Ans c.

39)A ______is an abstract form of any system or process that hides the unnecessary details.

  1. sample
  2. model
  3. data
  4. key

Ans b.

40)How many basics are there in E-R data model

  1. Three
  2. Four
  3. Five
  4. Six

Ans a.

Two Marks Each

41)An associative database is comprised of a number of ______and a user’s view of the contents of database is controlled by his or her ______.

  1. chapters, profile
  2. chapter, record
  3. data, records
  4. fields, records

Ans a.

42)Which of the following are true

  1. The associative model differentiates between what it calls entities and association.
  2. A profile is list of DBA
  3. The relational model is based on a collection of tables
  4. A table is also called a record

i)a, c, d

ii)b, c

iii)a, c

iv)none

Ans iii)

43)A ______is a list of chapters. The combination of chapters and profiles can simply the ______of the database to particular user.

  1. record, database
  2. profile, tailoring
  3. record, profile
  4. database, tailoring

Ans b.

44)The ______is the fastest and most costly form of ______.

  1. cache, storage
  2. cache, processor
  3. processor, storage
  4. cache, hardware

Ans a.

45)______memory is also known as ______

  1. main, PROM
  2. flash, EEPROM
  3. cache, EPROM
  4. flash, ROM

Ans b.

46)Volatile storage loses its ______when the power to the device is ______

  1. memory, established
  2. contents, connected
  3. contents, removed
  4. process, located

Ans c.

47)The disk surface is logically divided into ______, which are subdivided into ______.

  1. segment, groups
  2. sectors, tracks
  3. tracks, sectors
  4. parts, tracks

Ans c.

48)A ______is the smallest unit of information that can be read from or ______to the disk.

  1. sector, written
  2. sector, segmented
  3. memory, restored
  4. track, exposed

Ans a.

49)Which of the following are not true?

  1. A fixed head disk has a separate head for each track.
  2. A disk controller interfaces between the computer and the actual hardware of the disk drive.
  3. Disk controller never attaches checksum to each sector that is written.
  4. In the storage area network architecture, large numbers of disks are disconnected by a high speed network.

i)a, b, c

ii)a, b

iii)a, d

iv)a, c, d

Ans ii)

50)Which of the following are true?

  1. Access time is the time from when a read or write request is issued to when data transfer begins.
  2. Smaller disks tend to have higher seek time.
  3. The average seek time is the average of seek time, measured over a sequence of random request.
  4. A block is a contiguous sequence of sectors from a single track of one platter.

i)a, b

ii)a ,c

iii)a, c, d

iv)b, d

Ans iii)

51)A ______is a contiguous sequence of sectors from a single track of one ______.

  1. block, platter
  2. block, segment
  3. platter, block
  4. memory, block

Ans a.

52)Disk Arm Scheduling ______attempt to order accesses to tracks in a fashion that increases the number of accesses that can be ______.

  1. technique, organized
  2. algorithm, processed
  3. technique, processed
  4. process, organized

Ans b.

53)The ______is the fastest and most ______form of storage.

  1. cache, costly
  2. RAM, cheap
  3. EPROM, durable
  4. Cache, powerful

Ans a.

54)The CD and DVD come under ______memory storage and tape storage is referred as ______access storage.

  1. temporary, random
  2. permanent, sequential
  3. temporary, sequential
  4. optical, sequential

Ans d.

55)A ______is organized logically as a sequence of ______

  1. file, records
  2. file, segments
  3. group, sectors
  4. sector, file

Ans a.

56)Any ______can be placed anywhere in the file where there is space for the record in ______file organization.

  1. record, heap
  2. record, sequential
  3. track, random
  4. record, random

Ans a.

57)In ______file organization records are stored in sequential order according to the value of a ______of each record.

  1. Sequential, search key
  2. Sequence, composite key
  3. Order, key
  4. Key, sequence

Ans a.

58)A ______file is designed for efficient processing of records in sorted order based on some ______

  1. sequential , search key
  2. random, ideas
  3. network, keys
  4. sequential, rules

Ans a.

59)Which of the following are true?

  1. A foreign key is a column or set of columns that refers to a primary key in the same table or another table.
  2. An RDBMS is very difficult to access.
  3. An RDBMS provides full data independence
  4. A primary key is a multiple identifier.

i)a, b

ii)a, d

iii)a, b, c

iv)a, c

Ans iv)

60)A relational DBMS maintains information about every ______and ______that it contains.

  1. relation, index
  2. data, tuple
  3. relation, tuple
  4. data, index

Ans a.

Four Marks Each

61)Match the following.

a. The number of tuples NTuples(R) for each relation R. i) Size

b. The number of pages NPages(R) for each relation. ii) Cardinality

c. The number of nonleaf levels IHeight(I) for each tree iii) Index Size

index I.

d. The number of pages INPages(I) for each index I. iv) Index Height

a.)a-iii, b-iv, c-i, d-ii

b.)a-ii, b-iii, c-i, d-iv

c.)a-ii, b-i, c-iv, d-iii

d.)a-i, b-ii, c-iv, d-iii

Ans c.

62)Data ______in ______is via the ______

  1. definition, SQL, create, statement
  2. manipulation, DBMS, DDL, statement
  3. storage, PL/SQL, DML, Query
  4. rhythm, RDBMS, DDL, statement

Ans a.

63)Which of the following are true?

  1. Data manipulation capabilities allow one to retrieve and modify contents of the database.
  2. Condition is a single predicate or a collection of predicates combined using Boolean operators AND, OR and NOT.
  3. Subqueries can’t appear when using the comparison predicate.
  4. COUNT(*) has a special meaning in that it counts the number of rows in a relation.
  5. If the function is followed by the word distinct then duplicate values are shown.
  6. The GROUP BY feature allows one to partition the result into a number of groups such that all the rows of the group have the same value in some specified column.

i)a, b, e, f

ii)a, b, c

iii)a, b, d, f

iv)a, e, f

Ans iii)

64)The ______of a database can be ______by ______a new ______.

  1. contents, modified, inserting, tuple
  2. tools, generated, deleting, value
  3. tools, modified, deleting, value
  4. contents, modified, deleting, tuple

Ans a.

65)A very important aspect of ______definition is the ability to ______alternative ______of ______.

  1. column, demonstrate, aspect, data
  2. data, define, view, data
  3. tuple, demonstrate, aspect, data
  4. column, define, view, data

Ans b.

66)Once the ______informs the user that a ______has been successfully completed, its effect should persist even if the system ______before all its changes are reflected on ______

  1. DBMS, transaction, crashes, disk
  2. RDBMS, queries, restart, disk
  3. DBMS, queries, restart, screen
  4. DBA, process, crashes, screen

Ans a.

67)The acronym ACID is sometimes used to refer to the four properties of

transaction : ______, ______, ______and ______.

  1. Atomicity, Consistency, Isolation and Durability
  2. Analyzed, Continuous, Integrated and Defined
  3. Atomicity, Concurrent, Isolated and Durable
  4. Atomicity, Consistency, Integrated, Defined

Ans a.

68)Each ______run by itself with no ______execution of other transactions, must preserve the ______of the ______.

a. transaction, proper, consistency, database

b. transaction, concurrent, consistency, database

c. option, current, regularity, data

d. query, proper, consistency, RDBMS

Ans b.

69)Which are not true?

  1. The projection of a relation is defined as a projection of all its tuples over some set of attributes.
  2. The projection operation yields a vertical subset of a relation.
  3. The join operator never joins two relations.
  4. The selection operation is sometimes known as the restriction operation.
  5. Relational Algebra defines a set of algebraic operations that operate on tables and output tables as their result.
  6. A tuple variable is a variable that takes on tuples of a particular relation schema as value.

i.)a, c, f

ii.)c

iii.)a, d, f

iv.)none

Ans c.

70) Instead of describing a ______by how to ______the output relation, a ______query describes the tuples in the output relation.

  1. query, compute, relational, calculus
  2. data, consider, relational, algebra
  3. query, consider, relational, calculus
  4. data, compute, multiple, segment

Ans a.

71) The aim of the ______system is to reduce ______meaning that ______is to be ______only once.

  1. database, redundancy, information, stored
  2. management, information, data, read
  3. database, information, data, stored
  4. management, redundancy, information, stored

Ans a.

72) Match the following—

  1. Decomposition i. insertion, updating, deletion
  2. Anomalies ii. Simplification
  3. Redundancy iii. Dependency
  4. First Normal From iv. Flat files
  5. a-I, b-iii, c-iv, d-ii
  6. a-iv, b-ii, c-iii, d-I
  7. a-ii, b-I, c-iii, d-iv
  8. a-iii, b-iv, c-ii, d-I

Ans 3.

73) The system maintains the several identical ______of the ______. Each replica is ______in a different _____.

  1. replicas, relation, stored, site
  2. copies, tuple, manipulated, location
  3. replicas, relation, manipulation, site
  4. copies, tuple, stored, site

Ans a.

74) In the process of ______the relation is ______into several ______. Each fragment is stored in a different ______.

a. segmentation, partitioned, fragments, memory

b. fragmentation, partitioned, fragments, site

c. fragmentation, partitioned, data, memory

d. replication, partitioned, fragments, memory

Ans b.

75) Which of the following is true?

  1. A distribute database system consists of collection of sites.
  2. A database can’t be organized according to data models.
  3. Artificial intelligence and expert systems represent the information as fact and rule that can be said to be knowledge based database
  4. An object means combination of data and program
  5. Each program in a program part is called method

i.)a, b, e

ii.)a, c, e

iii.)c, d

iv.)All of the above

Ans iv)

1

Top View