1. Consequently R.Boyce-Codd jointly launched powerful definition for the third normal
form called______:
Correct : A. Boyce-Codd normal form
2. BCNF stands for:
Correct : C. Boyce-Codd normal form
3. Which forms simplifies and ensures that there is minimal data aggregates and repetitive groups:
Correct : A. 1NF
4. Which forms every non-prime attribute is fully dependent functionally on the candidate
key of a relational schema:
Correct : B. 2NF
5. PJNF stands form:
Correct : B. Project –join normal form
6. Which forms are based on the concept of functional dependency
Correct : C. 3NF
7. The DBMS utility, ____________ allows to reconstruct the correct state of database from
the backup and history of transactions.
Correct : B. Recovery
8. In the ........... normal form, a composite attribute is converted to individual attributes.
Correct : A. First
9. In RDBMS, Data is presented as a collection of ............
Correct : C. Relations
10. A .................. normal form, normalization will be needed where all attributes in a relation
are not functionally dependent only on the key attribute.
Correct : C. Third
11. To select all column from the table the syntax is:
Correct : B. Select * from table_name
12. For using a specific database …………… command is used.
Correct : A. use database
13. ………………… is a special type of integrity constraint that relates two relations & maintains consistency across the relations.
Correct : B. Referential Integrity Constraints
14. ____ ensures that once transaction changes are done, they cannot be undone or
lost, even in the event of a system failure.
Correct : C. Durability
15. Deadlocks are possible only when one of the transactions wants to obtain a(n)
____ lock on a data item.
Correct : B. exclusive
16. If several concurrent transactions are executed over the same data set and the second transaction updates the database before the first transaction is finished, the ____ property is violated and the database is no longer consistent.
Correct : C. isolation
17. A DBMS uses a transaction ____ to keep track of all transactions that update the
database
Correct : A. log
18. When a program is abnormally terminated, the equivalent of a ____ command
occurs.
Correct : A. COMMIT
19. In a(n) ____ backup of the database, only the last modifications to the database
are copied.
Correct : C. differential
20. Although the ____ locking approach improves the availability of data, its
management requires high overhead.
Correct : D. row-level
21. A(n) ____ lock exists when concurrent transactions are granted Read access on
the basis of a common lock.
Correct : C. shared
22. A ____ database state is one in which all data integrity constraints are satisfied.
Correct : C. consistent
23. The ____ statement is used to end a successful transaction.
Correct : A. COMMIT
24. ____ means that the data used during the execution of a transaction cannot be
used by a second transaction until the first one is completed.
Correct : D. Isolation
25. The three basic techniques to control deadlocks are: deadlock ____, deadlock
detection, and deadlock avoidance.
Correct : A. prevention
26. All transactions are controlled and executed by the DBMS (subject to some
limitations) to guarantee database ____.
Correct : A. integrity
27. In a ____ lock, the DBMS will lock an entire disk page.
Correct : C. page-level
28. According to the ANSI SQL standard, when does a transaction begin?
Correct : B. when the first SQL statement is encountered
29. The ____ lock allows concurrent transactions to access the same row as long as
they require the use of different fields within that row.
Correct : D. field-level
30. What is ACID properties
Correct : D. All of the above
31. Which refers to a property of computer to run several operation simultaneously
and possible as computers await response of each other:
Correct : A. Concurrency
32. Which is refers to a stalemate situation due to which no further progress is
possible as computer await response of each other:
Correct : B. Deadlock
33. Which is a duplicate copy of a file program that is stored on a different storage
media than the original location:
Correct : C. Backup
34. ............... joins are SQL server default
Correct : B. Inner
35. The ..................... is essentially used to search for patterns in target string.
Correct : A. Like Predicate
36. ................. requires that data should be made available to only authorized users.
Correct : C. Security
37. .............. is a combination of two of more attributes used as a primary key
Correct : A. Composite Key
38. To delete a database ................... command is used
Correct : C. drop database database_name
39. Some of the utilities of DBMS are .............
i) Transaction ii) Backup iii) File organization iv) Process Organization
Correct : C. ii, iii and iv only
40. There are _________ number of Normal forms that has been defined
Correct : B. 6
41. The primary key must be
Correct : C. Both A & B
42. Which of the following is not unary operation?
Correct : B. Union
43. Which is relation calculus:
Correct : C. Both
44. Which calculus is based on specifying a number of tuple variables:
Correct : A. Tuple relation calculus
45. SQL outputs a single table known as the ______:
Correct : D. Result set
46. Which of the following is related to information?
Correct : A. Data
47. Data is:
Correct : A. A piece of fact
48. Which of the following is element of the database?
Correct : D. All of these.
49. What represent a correspondence between the various data elements?
Correct : C. Relationships
50. Which of the following is an advantage of using database system?
Correct : D. All of these.
51. Which of the following is characteristic of the data in a database?
Correct : D. All of these.
52. Relationships could be of the following type:
Correct : D. All of these.
53. In a file-oriented system there is:
Correct : D. Al of these.
54. In a database system there is:
Correct : D. All of these.
55. VDL is used to specify:
Correct : D. None of these.
56. The DML provides following functional access to the database:
Correct : B. Add (or insert) records
57. 4GL has the following components inbuilt in it:
Correct : D. All of these.
58. Which of the following is database element?
Correct : D. All of these.
59. What separates the physical aspects of data storage from the logical aspects of data
representation?
Correct : D. Relationships
60. What scheme defines how and where the data are organized in a physical data storage?
Correct : A. External
61. Which of the following schemas defines the stored data structures in terms of the
database model used?
Correct : B. Conceptual
62. Which of the following schemas defines a view or views of the database for particular
users?
Correct : B. Conceptual
63. A collection of data designed to be used by different people is called.
Correct : A. Database
64. Which of the following is an object-oriented feature?
Correct : B. Abstraction
65. A physical data models are used to
Correct : D. All of these
66. Which data model organizes the data in the form of tables and relations?
Correct : A. Relational Model
67. Which company has developed the hierarchical model?
Correct : B. IBM
68. The name of the system database that contains descriptions of data in the database is
Correct : B. Metadata
69. System catalog is a system-created database that describes:
Correct : D. All of these
70. Following is the type of metadata:
Correct : D. All of these
71. What is refined data?
Correct : B. Information
72. Which of the following is a database element?
Correct : D. All of the above
73. What defines how and where data are organized in physical data storage?
Correct : A. Internal schema
74. What defines a view or views of the database for particular users?
Correct : B. External schema
75. To access information from a database, you need a ___________
Correct : B. DBMS
76. Which of the following is an advantage of a database?
Correct : D. All of the above
77. Which of the following is an example of a database application?
Correct : D. All of the above
78. DBMS stands for________________?
Correct : B. Database Management Systems
79. What is the name of the system database that contains descriptions of the data in the
database?
Correct : B. Data dictionary
80. IMS stands for ___________
Correct : A. Information Management System
81. Which of the following is the oldest database model?
Correct : A. Hierarchical
82. Which category of users need not be aware of the presence of the database system?
Correct : B. Naive
83. Database __________ , which is the logical design of the database, and the database _______,which is a snapshot of the data in the database at a given instant in time.
Correct : D. Schema, Instance
84. Course(course_id,sec_id,semester) Here the course_id,sec_id and semester are __________ and course is a _________ .
Correct : B. Attributes, Relation
85. Department (dept name, building, budget) and Employee (employee_id , name, deptname,salary) Here the dept_name attribute appears in both the relations .Here using common attributes in relation schema is one way of relating ___________ relations.
Correct : C. Tuple of distinct
86. A domain is atomic if elements of the domain are considered to be ____________
units.
Correct : B. Indivisbile
87. Which of the following products was an early implementation of the relational model
developed by E.F. Codd of IBM?
Correct : B. DB2
88. The following are components of a database except ________
Correct : C. Reports
89. An application where only one user accesses the database at a given time is an example
of a(n) ________ .
Correct : A. single-user database application
90. An on-line commercial site such as Amazon.com is an example of a(n) ________ .
Correct : C. e-commerce database application
91. SQL stands for ________ .
Correct : A. Structured Query Language
92. Because it contains a description of its own structure, a database is considered to be ________
Correct : C. self-describing
93. The following are functions of a DBMS except ________ .
Correct : A. creating and processing forms
94. Helping people keep track of things is the purpose of a(n) ________ .
Correct : A. Database
95. A DBMS that combines a DBMS and an application generator is ________ .
Correct : B. Microsoft's Access
96. Let us consider phone_number ,which can take single or several values . Treating phone_numberasan _________ permits instructors to have several phone numbers (including zero) associated with them.
Correct : C. Relation
97. Given the basic ER and relational models, which of the following is INCORRECT?
Correct : A. An attribute of an entity can have more than one value
98. In an object-oriented model, one object can access data of another object by passing:
Correct : B. Message
99. A view of database that appears to an application program is known as:
Correct : B. Subschema
100. An abstraction concept for building composite object from their component object is called: