Correct : B. each user can "see" only a small part of the entire database
2. A Database Management System (DBMS) is
Correct : B. collection of programs to access data
3. Which of the following is not a level of data abstraction?
Correct : B. critical level
4. Disadvantages of File systems to store data is:
Correct : D. all of the above
5. In an Entity-Relationship Diagram Rectangles represents
Correct : A. entity sets
6. Which of the following is not a Storage Manager Component?
Correct : B. logical manager
7. Data Manipulation Language enables users to
Correct : D. all of the above
8. Which of the following is not an Schema?
Correct : C. critical schema
9. Which of the following is Database Language?
Correct : D. all of the above
10. Which of the following in not a function of DBA?
Correct : A. network maintenance
11. Which of the following represents a relationship among a set of values.
Correct : A. a row
12. Column header is refer as
Correct : C. attributes
13. A Relation is a
Correct : B. subset of a cartesian product of a list of domains
14. In mathematical term Table is referred as
Correct : A. relation
15. In mathematical term Row is referred as
Correct : C. tuple
16. _______ allow us to identify uniquely a tuple in the relation.
Correct : A. superkey
17. Minimal Superkeys are called
Correct : B. candidate keys
18. Which of the following is not Modification of the Database
Correct : C. sorting
19. Which of the following is Relation-algebra Operation
Correct : D. all of the above
20. Which of the following in not Outer join?
Correct : D. all of the above
21. Who proposed the relational model?
Correct : B. e.f. codd
22. Set of premitted values of each attribute is called
Correct : A. domain
23. Logical design of database is called
Correct : C. database schema
24. Snapshot of the dta in the database at a given instant of time is called
Correct : B. database instance
25. Which of the following is not Unary operation?
Correct : D. union
26. Which of the following is not binary operation?
Correct : B. project
27. Which of the following is correct regarding Aggregate functions?
Correct : A. it takes a list of values and return a single values as result
28. A command to remove a relation from an SQL database
Correct : B. drop table
29. which of the following is not an Aggregate function?
Correct : C. select
30. The attribute that can be divided into other attributes is called
Correct : B. composite attribute
31. In an Entity-Relationship Diagram “Ellipses” represents
Correct : A. attributes
32. In an Entity-Relationship Diagram “Diamonds” represents
Correct : D. relationship sets
33. What is ACID properties of Transactions?
Correct : B. atomicity, consistency, isolation, durability
34. If every non-key attribute is functionally dependent on the primary key, the relation will be in
Correct : C. third normal form
35. Database locking concept is used to solve the problem of
Correct : D. all of the above
36. UML is stands for
Correct : B. unified modeling language
37. Data Manipulation Language (DML) is not to
Correct : A. create information table in the database
38. Which of the following in true regarding Referential Integrity?
Correct : C. every foreign-key value must match a primary-key value in an associated table
39. ODBC stands for ______
Correct : C. open database connection
40. Which algebra is widely used in DBMS?
Correct : A. relational algebra
41. Which of the following is an unary operation?
Correct : A. selection operation
42. Which SQL Query is use to remove a table and all its data from the database?
Correct : C. drop table
43. In precedence of set operators the expression is evaluated from:
Correct : B. left to right
44. In DBMS FD stands for _______
Correct : D. functional dependency
45. How many types of keys in Database Design?
Correct : D. all of these
46. Which of the following is based on Multi Valued Dependency?
Correct : D. fourth
47. Which of the following is the structure of the Database?
Correct : B. schema
48. The minimal set of super key is called
Correct : C. candidate key
49. A relation that has no partial dependencies is in which normal form
Correct : B. second
50. A functional dependency between two or more non-key attributes is called
Correct : A. transitive dependency
51. A logical description of some portion of database that is required by a user to perform task is called as
Correct : B. user view
52. ______________ is a classical approach to database design?
Correct : C. top – down approach
53. _____________ refers to the correctness and completeness of the data in a database?
Correct : B. data integrity
54. A table that displays data redundancies yields ____________ anomalies
Correct : D. all of the above
55. A lock that allows concurrent transactions to access different rows of the same table is known as a
Correct : A. field-level lock
56. A type of query that is placed within a WHERE or HAVING clause of another query is called
Correct : B. sub query
57. A transaction completes its execution is said to be
Correct : D. committed
58. A in a table represents a relationship among a set of values.
Correct : C. row
59. The term is used to refer to a row.
Correct : B. tuple
60. For each attribute of a relation, there is a set of permitted values, called the of that attribute.
Correct : A. domain
61. A domain is atomic if elements of the domain are considered to be units.
Correct : B. indivisbile
62. Which one of the following is a set of one or more attributes taken collectively to uniquely identify a record?
Correct : C. super key
63. Consider attributes ID, CITY and NAME. Which one of this can be considered as a super key?
Correct : B. id
64. The subset of a super key is a candidate key under what condition?
Correct : A. no proper subset is a super key
65. A is a property of the entire relation, rather than of the individual tuples in which each tuple is unique.
Correct : B. key
66. Which one of the following attribute can be taken as a primary key?
Correct : C. id
67. Which one of the following cannot be taken as a primary key?
Correct : D. street
68. An attribute in a relation is a foreign key if the key from one relation is used as an attribute in that relation.
Correct : B. primary
69. The relation with the attribute which is the primary key is referenced in another relation. The relation which has the attribute as a primary key is called
Correct : C. referenced relation
70. The is the one in which the primary key of one relation is used as a normal attribute in another relation.
Correct : C. referenced relation
71. A integrity constraint requires that the values appearing in specified attributes of any tuple in the referencing relation also appear in specified attributes of at least one tuple in the referenced relation.
Correct : A. referential
72. The operation allows the combining of two relations by merging pairs of tuples, one from each relation, into a single tuple.
Correct : B. join
73. The result which operation contains all pairs of tuples from the two relations, regardless of whether their attribute values match.
Correct : B. cartesian product
74. The operation performs a set union of two “similarly structured” tables
Correct : A. union
75. The most commonly used operation in relational algebra for projecting a set of tuple from a relation is
Correct : C. select
76. The operator takes the results of two queries and returns only rows that appear in both result sets.
Correct : B. intersect
77. A is a pictorial depiction of the schema of a database that shows the relations in the database, their attributes, and primary keys and foreign keys.
Correct : A. schema diagram
78. The provides a set of operations that take one or more relations as input and return a relation as an output.
Correct : B. relational algebra
79. Which one of the following provides the ability to query information from the database and to insert tuples into, delete tuples from, and modify tuples in the database?
Correct : A. dml(data manipulation langauge)
80. To remove a relation from an SQL database, we use the command.
Correct : D. drop table
81. Updates that violate are disallowed.
Correct : A. integrity constraints
82. The clause allows us to select only those rows in the result relation of the clause that satisfy a specified predicate.
Correct : A. where, from
83. The clause is used to list the attributes desired in the result of a query.
Correct : B. select
84. Which of the following statements contains an error?
Correct : D. select empid where empid = 1009 and lastname = ‘geller’;
85. In SQL the spaces at the end of the string are removed by function.
Correct : C. trim
86. The union operation is represented by
Correct : B. u
87. The intersection operator is used to get the tuples.
Correct : B. common
88. If we want to retain all duplicates, we must write in place of union.
Correct : A. union all
89. The number of attributes in relation is called as its
Correct : B. degree
90. clause is an additional filter that is applied to the result.
Correct : C. having
91. joins are SQL server default
Correct : B. inner
92. The is essentially used to search for patterns in target string.
Correct : A. like predicate
93. A indicates an absent value that may exist but be unknown or that may not exist at all.
Correct : C. null value
94. If the attribute phone number is included in the relation all the values need not be entered into the phone number column. This type of entry is given as
Correct : C. null
95. The predicate in a where clause can involve Boolean operations such as and. The result of true and unknown is false and unknown is while unknown and unknown is
Correct : D. unknown, false, unknown
96. Using the clause retains only one copy of such identical tuples.
Correct : D. distinct
97. The primary key must be
Correct : C. both unique and not null
98. The result of unknown is unknown.
Correct : D. not
99. Aggregate functions are functions that take a as input and return a single value.
Correct : A. collection of values
100. A Boolean data type that can take values true, false, and