Advance D.B.M.S Multiple Choice Question & answer

1. What is a repository of data, intended to assist proficient storage of data, retrieval and preservation called?
a. DBMS
b. ADBMS
c. Database
d. RDBMS
Ans. c) Database

2. DBMS can provide the simultaneous implementation of different portions of the database. (True/False)
Ans. True

3. For sharing data among clients, the most frequent way is the creation of two-tier client/server databases. (True/False)
Ans. True

4. An application program comprises two components, one being the GUI. Name the other component.
a) Presentation logic
b) Business logic
c) Message logic
d) User interface logic
Ans. b) Business logic

5. The requirements of information from various branches as well as divisions are successfully supported by a ___ database.
Ans. Enterprise

6. In a ___ schema, we organise data into a structure that appears as a tree.
Ans. Hierarchical schema

7. Network schema provides permission for only 1:1 relationships. (True/False)
Ans. False

8. In the case of relational schema, every tuple is separated into fields which we call ___.
Ans. Domains

9. Which of the following is not considered as a logical structure of the database?
a) Tree
b) Relational
c) Network
d) Chain
Ans. d) Chain

10. Relational model makes use of some unknown terminology. A tuple is said to be equal to a ___.
Ans. Network

11. Logical data structure having 1:M relationship is considered as a:
a) Network b) Tree
c) Chain d) Relation
Ans. b) Tree

12. It is easy to preserve and update the ___ database
Ans. Centralised

13. In the case of distributed database, data is handled by numerous servers. (True/False)
Ans. True

15. QBE stands for ___.
Ans. Query by example

16. Domain integrity is also called ‘___’ integrity.
Ans. Attribute

17. There are two types of DROP commands: CASCADE and RISTRICT (True/False)
Ans. True

18. ___ command helps for the creation of SQL relations.
Ans. Create

19. With the help of WHERE and ___ commands it is possible to embed a SQL statement into another.
Ans. HAVING

20. It is not possible to query multiple relations in SQL. (True/ False)
Ans. False

21. A ___ is a subschema in which logical tables are generated from more than one base table.
Ans. View

22. During the query execution contents are taken from other tables. (True/False)
Ans. True

23. To recognise embedded SQL requests to the pre-processor, we use the ___ statement.
Ans. EXEC SQL

24. It is a good practice to append a colon before the host variables to differentiate them from other variables used in SQL. (True/False)
Ans. True

25. SQL offers ___ statements that make easy the process of concurrent transaction control.
Ans. Two

26. In transaction processing, the integrity rules of a database are maintained by ___ property.
Ans. Consistency

27. ___ permits to create and submit SQL queries dynamically or run time
a) Miscellaneous SQL
b) Dynamic SQL
c) Data Definition Language
d) SQL Preprocessor
Ans. Dynamic SQL

28. Using dynamic SQL, programs cannot create SQL queries as strings at run time. (True/ False)
Ans. False

29. SQL is supported by RDBMS. (True/False)
Ans. False

30. SELECT, INSERT, DELETE and UPDATE commands are used by ___ to modify the data.
Ans. DML

31. Decomposition helps to reduce data redundancy. (True/False)
Ans. True

32. Functional dependencies can be used to refine the ___.
Ans. Schema

33. Which of the following is preferred when there is a disagreement between data items in a database?
a) Redundancy
b) Inconsistency
c) Anomaly
d) Normalisation
Ans. (b) Inconsistency

34. When the data values are stored repeatedly in multiple copies in the database, it is known as ___.
Ans. Redundancy

35. How does Normalisation help?
a) By eliminating various database anomalies
b) By minimising redundancy
c) By eliminating data inconsistency
d) All of the above
Ans. (d) All of the above

36. An attribute (column) is said to be ___ if its value can be determined by any one or more attributes of the primary key, but not all.
Ans. Partially dependent

37. A table which is in ___ normal form may contain redundancies due to transitive dependencies.
Ans. Second

38. The Fifth Normal form is usually useful when we have large relational data models. (True/False)
Ans. True

39. The join dependency is a more generalised form of ___ dependency.
Ans. Multi-valued

40. An FD is a special case of an MVD and every FD is an MVD. (True/False)
Ans. True

41. The fifth normal form is also called ___.
Ans. Project-Join Normal Form (PJNF)

42. From a ___ point of view, it is standard to have tables that are in the Third Normal Form.
Ans. Rational model

43. According to relational database rules, a completely normalised database always has the best performance. (True/False).
Ans. False

44. Denormalisation is done to increase the performance of the database. (True/False).
Ans. True

45. Denormalisation is a technique to move from higher to lesser normal forms of database modelling in order to get faster access to the database. (True/ False)
Ans. True

46. ___ splits tables by rows, thus reducing the number of records per table.
Ans. Horizontal Fragmentation

47. SQL commands defines the actions to be taken to control ___.
Ans. Transaction Execution

48. ___ is formed with the combination of PK and FK.
Ans. Referential Integrity

49. ___ may be avoided if an appropriate index exists to allow ordered access to the records.
Ans. Sorting

50. Relations are said to be Union compatible if they have the same ___ and that to from same domain.
Ans. Attributes

51. MQO (Multi Query Optimisation) saves the evaluation cost and execution time by executing the common operations once over a set of queries (True/False)
Ans. True

52. ___ rely on nested loop joins for implementation.
Ans. Navigational strategies

53. ___ works reversely it starts with subquery first and after that executes the outer query.
Ans. Reverse lookup

54. It is required to validate update operations against stated relational database constraints (True/False)
Ans. True

55. ___ is defined as a set of rows that encode the changes made to a specific base table.
Ans. Delta stream

56. ___ represents a relational calculus expression.
Ans. Query graph

57. The query graph representation also indicates an order in which operations perform first. (True/False).
Ans. False

58. Semantic query optimisation helps inefficient query ___ by modifying one query into another.
Ans. Execution

59. Relational database constraints are used in the semantic query optimisation techniques. (True/False)
Ans. True

60. The key to achieving good stream processing performance is to optimise ___ together.
Ans. Multiple queries

61. The system knows the blocks containing the tuples of R, and it is not possible to get the blocks one by one. (True/ False)
Ans. False

62. We can use the index not only to get all the tuples of the relation it indexes, but also ___.
Ans. Secondary

63. It is an open function that initiates the process of getting tuples, but it does not get a tuple.
(True/ False)
Ans. Open function

64. The selection of an algorithm for each operator is one of the most fundamental elements of the process of transformation of a logical query plan into a physical query plan. (True/ False)
Ans. True

65. Tuple-at-a-time, unary operations require neither ___ nor ___.
Ans. False

66. ___ joins can be used for relations of any size. One relation does not need to necessarily fit in the main memory.
Ans. Nested-loop

67. Nested-loop does not allow us to avoid storing intermediate relations on disk in some situations. (True/ False)
Ans. False

68. In ___ algorithms, data is read into the main memory from the operand relations.
Ans. merged

69. In the second pass, all the sorted sublists are ___.
Ans. Two-pass

70. If there are M buffers available and we can pick M as the number of buckets, we can gain a factor of M in the size of the relations that we can handle. (True/ False)
Ans. True

71. The essential idea behind all hash-based algorithms is ___.
Ans. Last

72. The existence of an index on one or more attributes of relation makes available some algorithms that ___.
Ans. non-clustering