1. ………………….. operator is basically a join followed by a project on the attributes of first relation.
Correct : B. Semi-Join
2. Which of the following is not a binary operator in relational algebra?
Correct : D. Project
3. Centralizing the integrity checking directly under the DBMS ………….. duplication and ensures the
consistency and validity of the database.
Correct : D. Reduces
4. Which of the following is/are the DDL statements?
Correct : D. All of the above
5. ---------------- is used to retrieve tuples from the relation.
Correct : C. Select
6. ……………… defines rules regarding the values allowed in columns and is the standard mechanism
for enforcing database integrity.
Correct : B. Constraint
7. For like predicate which of the following is true.
i) % matches zero of more characters. ii) _ matches exactly one character.
Correct : C. Both of them
8. The relational model is based on the concept that data is organized and stored in two-dimensional
tables called ……………………….
Correct : C. Relations
9. ……………….. contains information that defines valid values that are stored in a column or data
type.
Correct : C. Index
10. Which of the syntax is correct for insert statement?
i) insert into <table_name> values <list of values> ii) insert into <table_name> (column list) values <list of values>
Correct : C. Both of them
11. ………………. first proposed the process of normalization.
Correct : B. Edgar F. Codd
12. For using a specific database …………… command is used.
Correct : A. Use database
13. Which of the following is not comparison operator?
Correct : C. =<
14. An outstanding functionality of SQL is its support for automatic ………… to the target data.
Correct : C. Navigation
15. ………………… is a special type of integrity constraint that relates two relations & maintains
consistency across the relations.
Correct : B. Referential Integrity Constraints
16. ……………..specifies a search condition for a group or an aggregate.
Correct : B. HAVING Clause
17. Drop Table cannot be used to drop a table referenced by a …………… constraint.
Correct : D. Foreign Key
18. Which are the not features of a DBMS which provide a number of advantages for data management:
Correct : D. None of these
19. Minimal data redundancy means improved _________:
Correct : B. Data consistency
20. Who access the database occasionally and have different needs each time:
Correct : B. Casual users
21. System analyst and application programmers are commonly referred to as …………………….
Correct : C. Software engineers
22. Who interact with the system without writing a program:
Correct : C. Sophisticated user
23. Who interact with the system by invoking one of the permanent application program:
Correct : A. Naïve users
24. The main interface that a naive user uses is a form interface using___:
Correct : B. GUI
25. The provision of _______ is a major objective for database system:
Correct : A. Data independence
26. ____ is a translates into low-level instruction that a query processor understands:
Correct : D. DDL compiler
27. Retrieval of data is done by using a ____:
Correct : B. Query
28. DML is a language by which user accesses or manipulates the ________:
Correct : A. Data model
29. Which is the central component of the DBMS software that can also be termed as the database control
system?
Correct : D. Data manager
30. Which is stored information about description of data in the database:
Correct : B. Data dictionary
31. After conversion of high level queries into low level commands for file access and is called
compiled_____:
Correct : B. DML
32. Which is installs, configures, troubleshoots and maintains a database system:
Correct : A. DBA
33. Which is incorporated to create an appropriate physical database that is transformed by a logical data
model:
Correct : D. None
34. In which end is really just any application that runs on top of the DBMS and acts as a user interface:
Correct : B. Front end
35. Data are stored in________ as database:
Correct : A. Data files
36. ACID properties of transactions are
Correct : D. Durability
37. DA stands for:
Correct : A. Data administrator
38. Which is the person responsible for overall control f the database system:
Correct : C. DBA
39. DBA stands for:
Correct : B. Database administrator
40. Transaction is an action used to perform some manipulation on data stored in the____:
Correct : C. Database
41. The data in the database at a particular moment in time is called a ________________
Correct : A. Database state
42. Which is a DBMS keeps back-up copies of the database:
Correct : A. Backup
43. In which the database can be restored up to the last consistent state after the system failure:
Correct : B. Recovery
44. How many levels of abstraction in DBMS:
Correct : B. 3
45. Which are the three levels of abstraction:
Correct : D. All of these
46. How many types of data independence:
Correct : B. 2
47. Which are the types of data independence:
Correct : C. Both
48. Which is the transformation of requests and results between different levels of abstraction:
Correct : B. Mapping
49. Which mapping exists between the conceptual and internal levels:
Correct : C. Both
50. Which mapping exists between the external and conceptual levels:
Correct : C. Both
51. The related and interconnected software components of a DBMS are described by the _______:
Correct : C. Both
52. Which are the types of physical DBMS architecture can be split :
Correct : C. Both
53. The DML is called:
Correct : A. Sublanguages
54. The overall description of a database is called______:
Correct : D. Database schema
55. Which is proper subset designed to support ‘views’ belonging to different classes of users in order to
hid or protect information:
Correct : B. Subschema
56. A data dictionary is a repository that manages _____:
Correct : C. Metadata
57. A tuple is a(n):
Correct : C. row of a table
58. An attribute is a(n):
Correct : D. column of a table
59. The method of access which uses key transformation is known as
Correct : B. Hashing
60. The statement in SQL which allows to change the definition of a table is
Correct : B. Alter
61. This is not a date type in SQL Server 2000
Correct : B. String
62. Which of the following is NOT a basic element of all versions of the E-R model?
Correct : D. Primary key
63. The SQL command to creating a table is:
Correct : C. Create table
64. ----------- is a virtual table
Correct : B. View
65. The DROP TABLE statement:
Correct : B. Deletes the table structure along with the table data
66. The SQL statement to create a view is:
Correct : A. CREATE VIEW
67. Which of the following is NOT a type of SQL constraint?
Correct : C. ALTERNATE KEY
68. The following are functions of a DBMS except ________
Correct : A. creating and processing forms
69. What SQL structure is used to limit column values of a table?
Correct : B. The CHECK constraint
70. Every time attribute A appears, it is matched with the same value of attribute B, but not the same
value of attribute C. Therefore, it is true that:
Correct : A. A → B
71. The different classes of relations created by the technique for preventing modification anomalies
are called:
Correct : A. Normal forms.
72. A relation is in this form if it is in BCNF and has no multivalued dependencies:
Correct : C. Fourth normal form.
73. Row is synonymous with the term:
Correct : A. Record
74. The primary key is selected from the:
Correct : B. Candidate keys
75. Which of the following is a group of one or more attributes that uniquely identifies a row?
Correct : A. Key
76. When the values in one or more attributes being used as a foreign key must exist in another set of
one or more attributes in another table, we have created a(n):
Correct : C. Referential integrity constraint.
77. A relation is considered a:
Correct : C. Two dimensional table
78. In the relational model, relationships between relations or tables are created by using:
Correct : B. Foreign keys
79. A functional dependency is a relationship between or among:
Correct : D. Attributes
80. Table is synonymous with the term:
Correct : D. Relation
81. Which of the following is not a restriction for a table to be a relation?
Correct : C. The columns must be ordered.
82. For some relations, changing the data can have undesirable consequences called:
Correct : B. Modification anomalies.
83. If attributes A and B determine attribute C, then it is also true that:
Correct : C. (A, B) is a composite determinant.
84. If attribute A determines both attributes B and C, then it is also true that:
Correct : A. A → B
85. One solution to the multivalued dependency constraint problem is to:
Correct : A. split the relation into two relations, each with a single theme
86. FD stands for:
Correct : A. Functional dependency
87. In which model of database data is stored in tables:
Correct : B. Relational model
88. How many types of keys in relation database design:
Correct : D. All of these
89. Which key is referencing a primary key in a table:
Correct : C. Foreign key
90. In which ways two tables may be related:
Correct : D. All of these
91. Which rules are defined in relational models they from as an essential part of any relation
database:
Correct : A. Integrity rules
92. Which are the types of integrity rule:
Correct : B. Referential integrity
93. ______states that primary keys should not be null:
Correct : A. Entity integrity
94. Which command creates database objects like tables, views and indexes:
Correct : A. Create command
95. Which command enables alteration the data stored in existing records:
Correct : B. Update command
96. Which are the dependencies types:
Correct : D. All of these
97. FDs are the types of constraints that are based on______:
Correct : A. Key
98. Who developed the normalization process:
Correct : A. E.F. codd
99. Which is a bottom-up approach to database design that design by examining the
relationship between attributes:
Correct : C. Normalization
100. In decomposition technique of splitting a relation into_____ relation: