Learning Ashram

FUNDAMENTALS OF DBMS/ ADVANCE DBMS WITH ORACLE 9i

FUNDAMENTALS OF DBMS/ ADVANCE DBMS WITH ORACLE 9i
(1-MARK questions)

1. Database Systems evolved in _________.

a. 1950
b. 1960
c. 1970
d. 1980

2. The advantages of database systems are-

1. Minimal data redundancy
2. Data inconsistency
3. Data integration
4. Data sharing
5. Data dependence

a. 1, 2, 3, 4, 5
b. 1, 2, 3
c. 2, 3, 4, 5
d. 1, 2, 3

3. The different types of uses for a DBMS are-

1. End user
2. The application programmer
3. Database Administrator
4. System programmer

a. 1, 2, 3
b. 1, 2, 3, 4
c. 2, 3, 4
d. 1, 3, 4

4. __________ is the user who actually puts the data in the system into use in business.

a. End-user
b. System programmer
c. Application programmer
d. None of the above

5. _________ is known as Super-user of the system.
a. System programmer
b. Database administrator
c. Application programmer
d. None of the above

6. _________ contains the structure of the data in the application.

a. Schema
b. Log files
c. Dictionary
d. All of the above

7. In ________ model, different records are inter-related through tree like structures.

a. Network model
b. Hierarchical
c. Relational Model
d. Object Model

8. In ________ model, a parent can have several children and a child can have many parent records.

a. Hierarchical model
b. Relational model
c. Network model
d. None of the above

9. _________ level deals with the physical storage of data.

a. External level
b. Conceptual level
c. Internal level
d. None of the above

10. In _________ clustered records belong to the same file (task).

a. Inter-file clustering
b. Intra file clustering
c. Both a & b
d. None of the above

11. ________ is a common method for making retrievals faster.

a. Clustering
b. Hashing
c. Indexing
d. All of the above

12. _________ method provides direct access to records on the basis of the value of a specific field called hash fields.

a. Indexing
b. Hashing
c. Sequencing
d. None of these

13. The properties of relations are-

1. No duplicate tuples
2. Tuples are ordered
3. Attributes are ordered
4. Attributes values are atomic

a. 1, 2, 3, 4
b. 2, 3, 4
c. 1, 4
d. 1, 3, 4

14. _________ is used to retrieve specific tuples / rows from a relation.

a. Project
b. select
c. Union
d. Intersect

15. __________ is used to obtain an possible consignation of tuples from two relations.

a. Project
b. Product
c. Select
d. None of the above

16. __________ is used to retrieve tuples appearing in the first relation participating in the difference but not the second.

a. Union
b. Difference
c. Join
d. None of the above

17. Application logic consists of-

a. Presentation logic
b. Processing logic
c. Storage logic
d. All of the above

18. In ___________ architecture the client / server model expands to include a middle tier, which is an application server that houses the business logic.

a. One-tier architecture
b. Two tier
c. N-tier
d. Four tier

19. ________ occurs when the structure of the database can change without requiring programs that access the database to change.

a. Data dependence
b. Data independence
c. Data integrity
d. Data consistency

20. ANSI stands for-

a. American National Standards Institute
b. Australian National Standards Institute
c. American Network Standard Institute
d. American Network System Institute

21. The three levels of database architecture are-

1. External view
2. Conceptual view
3. Internal view
4. System view

a. 1, 2, 3, 4
b. 1, 2, 3
c. 1, 2, 3
d. 2, 3, 4

22. The _________ is the view that the individual user of the database has-

a. Internal level
b. Conceptual level
c. External level
d. None of the above

23. ________ is the information model of the enterprise and contains the view of whole enterprise without any concern for physical limitation.

a. Conceptual view
b. Internal view
c. External view
d. None of the above

24. In _________ situation, A cannot proceed until B has completed and B cannot proceed until A has completed the transaction.

a. Locking
b. Deadlock
c. Shared lock
d. All of the above

25. __________ is a column or a collection of columns in a task whose values should match with the primary key of some specific task.

a. Foreign key
b. Unique key
c. Not null
d. Check

26. A __________ is considered to be a two-dimensional object having two components one corresponds to vertical and other to horizontal.

a. Tuple
b. Attribute
c. Relation
d. All of the above

27. SQL stands for-

a. Structured Query Library
b. Structured Query Language
c. Simantic Query Language
d. None of the above

28. Method of accessing data from more than one task is known as _________.

a. Describing
b. Selection
c. Joining
d. Projection

29. _________ is the process of determining the content and arrangement of data and is a two step process.

a. Describing
b. Joining
c. Database design
d. Hashing

30. A relation is said to be in __________ if it is in 2NF and if only determinants it has are candidate keys.

a. 4NF
b. 5NF
c. 3NF
d. 6NF

31. ________ is the principal data object about which information is to be collected.

a. Attributes
b. Entities
c. Tuples
d. None of the above

32. __________ entities are entities used to associate two or more entities in order to reconcile a many-to-many relationship.

a. Dissociative
b. Associative
c. Attribute
d. None of the above

33. __________ represents an association an association between two or more entities.

a. Attributes
b. Relationships
c. Associative attributes
d. Dissociative attributes

34. _________ of a relationship is the number of entities associated with the relationship.

a. Degree
b. Cardinality
c. Connectivity
d. None of the above

35. _________ describes the mapping of associated entity instances in the relationship.

a. Connectivity
b. Cardinality
c. Degree
d. Association

36. __________ relationship is when instance of entity A, there are zero, one, or many instance of entity B, but for one instance of entity B, there is only one instance of entity A.

a. One-to-one
b. One-to-many
c. Many-to-many
d. None of the above

37. _________ denotes is dependent upon the existence of related, entity instance.

a. Direction
b. Type
c. Connectivity
d. Existence

38. _________ occurs when two or more entities represent categories of the some real-world object.

a. Direction
b. Association
c. Generalization
d. Specification

39. ________ is a design technique that is widely used as a guide in designing relational databases.

a. E-R Notation
b. Normalization
c. Direction
d. Generalization

40. Relations without repeating groups are said to be in ________.
a. Second normal form
b. BCNF
c. First normal form
d. HNF

(2-MARKS questions)

41. A _______________is a collection of ________________data and a 1.database management system is a set of _________________to use and / or _________ this data.
Ans: database, interrelated , Program, modify.

42. The DBMS is a ________________ which provides a common interface between the ___________ and the various ______________in the application.
Ans: central system, data front-end program data.

43. _________________ means after a system failure and concurrent access of ____________________ by multiple users are handled by the ________.
Ans: Recovery, records, DBMS.

44. The ___________ defines the ________ which contains the __________ of the data in the ___________, what data needs to be present in the system and how this data has to be represented and organized.
Ans: DBA, sehema , structure ,application.

45. The DBMS views the database as a collection of ________ . The _________ of the underlying views it as a set of pages and the _________Disk Manager views it as a collection of physical locations on the disk.
Ans: Records, File Manager, Operating System,.

46. _________ is a method used for making ________. This method provides _________ to record on the basis of the value of a specific field called the _________.
Ans: Hashing, retrievals faster, direct access, hash_field.

47. The ________ partitioned _________ index entries are hashed to different partitions based on partitioning key and the ___________.
Ans: hash, global indexes ,number of partitions.

48. The ________ is the _________ as well as the foundation for the leading DBMS products, which include ________ family, Informix________ _________ and SQL Server.
Ans: relational model , dominant data model , IBM’s DB2, Oracle , Sybase,.

49. _________ represent close to a ___________ industry alone.
Ans: RDBMS , multibillion-dollar .

50. The _____________ goal of a computer system is to ____________________ into information.
Ans: Primary ,tune data,.

51. The _______________ to function properly there must be a peson or group in change of the _________ . This group is called _____________________.
Ans: Database approach ,database, Database Administration(DBA).

52. __________ means from the control or elimination of _______________.
Ans: Consistency Redundancy.

53. ______________ occurs when the structure of the database can change without requiring programs that access the_____________ to change.
Ans: Data Independence ,database,.

54. The ___________is the information model of the ______and contains the view of the whole enterprise without any concern for the ____________.
Ans: conceptual view, Physicial implementation.

55. The size and ___________of DBMS, more ________________ may be required than would be necessary without ___________.
Ans: Complexity ,hardware resources ,DBMS.

56. To detect ___________________, the system must keep track of the__________ take place.
Ans: Deadlock, actually, .

57. A ________________ is considered to be a ____________________ object having two components one corresponds to ____________ and other to _____________.
Ans: Relational, two-dimensional, Vertical , Horizontal.

58. The ______________ of a relation is the _________ or, which uniquely identifies a given.
Ans: Primary Key, attribute (column), collection of attributes, tuple (row).

59. This command in _____________ takes a _________________of a relation.
Ans: relational algebra, Vertical Subset.

60. When we divide ____________ by _________________ , we obtain a new relation, with a single column _____________.
Ans: SOFTWARE , PACKAGE, Tagnumbers .

(4-MARKS questions)

61. A ___________________ hierarchy is a form of abstraction that specifices that two or more entities that_________ attributes can be generalized into a higher level entity type called a ___________ entity.
Ans: Generalization, share common, supertype or generic.

62. _______________ is a design technique that is widely used as a guide in designing _____________.
Ans: Normalization, Relational database.

63. The _________ who uses the _________. This is the user who actually puts the data in the system into use in business. This _______ need actually, puts the________ in the system into use in business.,need not know anything about the __________ in the _____________.
(End User, application, user, data, organization of data, physical level)

64. The ______________, defines the _________ which contains the ________ of the _________data in the __________. The __________ determines what does needs to be present in the system and how this data to be represented and___________.
(DBA, schema, structure, application, DBA, organized.)

65. The ________ also defines __________ for ______ and recovery. Defining ___________ includes specifying what___________ is to backed up, the ___________ of taking backups and also the medium and __________ place for the backup data.
(DBA, procedures, backup, backup procedures, data, periodicity, storage.

66. When a _________ is to be retrieved, the same _______ is used to compute the __________ where the record is _________. Retrievals are ________ since a ________ is provided, and there is no search involved in the _______.
(record, hash function, address, stored, faster, direct access, process.)

67. A________________ where only those ______ having corresponding rows in the both the _________ are __________ is called the ____________ or_________ This is the most common _________ operation.
(join operation, rows, relations, retrieved, natural join, inner join, join)

68. The __________ component is responsible for formatting and _________ on the user’s screen . The____________ component handles data processing logic,________ and data management logic.
(Presentation logic, presenting data,processing logic, business rules logic)

69. The separation of the __________ from the _________ enables us to provide a__________ description of the database without the need to specify ________.This is often called__________
(conceptual view, internal view, logical, physical structures, Physical data independence.)

70. _________ for supporting all the ___________ it must provide to_______ , a _______must be a large______ occupying substantial _________ and internal memory.
(Size, complex functions, users, DBMS, program, amount of disk space,.)

71. ____________ refers to the right of an individual to have ________ concerning him kept ________. Privacy and security are related. It is only through appropriate _________that privacy can be ensured.
(Privacy, certain information, confidential, security measures)

72. __________ is the most important ____________. SQL is referred to as a relational___________. It also contains facilities to define ________.
(SQL(Structured Query Language), relational data manipulation Language, Data Manipulation Language(DML), data definition Language)

73. ___________ are basically, there are two types of ________, one which defines permitted values _________ can have and another which defines a ________ between different attributes(generally known as _________).
(constraints, attributes, relationship, dependency)

74. Let X and Y be_________ of a________.Given the value of X,if there is only one value of Y corresponding to it, then Y is said to be functionally dependent on X. This is indicated by the notation: __________
(two attributes, relation, X Y.

75. A _______ has its recodes stored in a. In order to facilitate________ proper processing, the are stored in a order based on values of some field. The filenb requires minimal storage, but offers limited operations, which limits its usefulness.
(sequential file, physical sequence)