Advanced Database Management System MCQ with Answers

MCQs on Advanced Database Management System (DBMS) can be quite frustrating for those who are not well-versed in the topic. However, with a little bit of preparation, you can defeat most DBMS MCQs with ease. Here are the 50 most important advanced DBMS MCQs with answers that will help you to crack the exams.

Advanced Database Management System MCQ with Answers. Advanced DBMS MCQ questions are very useful for the preparation for MCA, BCA, MSC IT, BSC IT, GATE, NET, and other Academic and Competitive Exams.

Table of Contents

Brief about Advanced Database Management System

Advanced Database Management System (DBMS) encompasses the design, implementation, management, and organization of databases. DBMS technology allows for the efficient retrieval of information by supporting different query languages.

The following are some DBMSs that are commonly used in business: Oracle, MySQL, Microsoft SQL Server, PostgreSQL, and MongoDB. A DBMS is a critical component of any information system and should be selected carefully to meet the specific needs of a given organization.

What is Advanced Database Management System

Advanced Database Management System (ADBMS) is a type of database management system (DBMS) that provides an enterprise with advanced capabilities for managing data, including advanced data modeling and analysis, improved data security, scalability, and performance optimization.

ADBMS typically provides additional functionality, such as data warehousing, data mining, data lakes, and business intelligence capabilities, compared to a standard DBMS. These advanced capabilities allow businesses to better utilize their data to gain insight and make decisions.

72 Advanced Database Management System MCQ with Answers.

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
Answer: (C)

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

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

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
Answer: (B)

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

6. In a ___ schema, we organize data into a structure that appears as a tree.
Answer: (Hierarchical schema)

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

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

9. Which of the following is not considered a logical structure of the database?
a) Tree
b) Relational
c) Network
d) Chain
Answer: (D)

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

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

12. It is easy to preserve and update the ___ database
Answer: (Centralized)

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

15. QBE stands for ___.
Answer: (Query by example)

16. Domain integrity is also called ‘___’ integrity.
Answer: (Attribute)

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

18. ___ command helps for the creation of SQL relations.
Answer: (Create)

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

20. It is not possible to query multiple relations in SQL.
Answer: (F)

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

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

23. To recognize embedded SQL requests to the pre-processor, we use the ___ statement.
Answer: (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)
Answer: (T)

25. SQL offers ___ statements that make easy the process of concurrent transaction control.
Answer: (Two)

26. In transaction processing, the integrity rules of a database are maintained by ___ property.
Answer: (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
Answer: (B)

28. Using dynamic SQL, programs cannot create SQL queries as strings at run time.
Answer: (F)

29. SQL is supported by RDBMS. (True/False)
Answer: (F)

30. SELECT, INSERT, DELETE and UPDATE commands are used by ___ to modify the data.
Answer: (DML)

31. Decomposition helps to reduce data redundancy. (True/False)
Answer: (T)

32. Functional dependencies can be used to refine the ___.
Answer: (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
Answer: (B)

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

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

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

37. A table that is in ___ normal form may contain redundancies due to transitive dependencies.
Answer: (Second)

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

39. The join dependency is a more generalized form of ___ dependency.
Answer: (Multi-valued)

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

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

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

43. According to relational database rules, a completely normalized database always has the best performance. (True/False).
Answer: (F)

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

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.
Answer: (T)

46. ___ splits tables by rows, thus reducing the number of records per table.
Answer: (Horizontal Fragmentation)

47. SQL commands define the actions to be taken to control ___.
Answer: (Transaction Execution)

48. ___ is formed with the combination of PK and FK.
Answer: (Referential Integrity)

49. ___ may be avoided if an appropriate index exists to allow ordered access to the records.
Answer: (Sorting)

50. Relations are said to be Union compatible if they have the same ___ and that from the same domain.
Answer: (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)
Answer: (T)

52. ___ relies on nested loop joins for implementation.
Answer: (Navigational strategies)

53. ___ works reversely it starts with the subquery first and after that executes the outer query.
Answer: (Reverse lookup)

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

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

56. ___ represents a relational calculus expression.
Answer: (Query graph)

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

58. Semantic query optimisation helps inefficient query ___ by modifying one query into another.
Answer: (Execution)

59. Relational database constraints are used in semantic query optimization techniques. (True/False)
Answer: (T)

60. The key to achieving good stream processing performance is to optimise ___ together.
Answer: (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.
Answer: (F)

62. We can use the index not only to get all the tuples of the relation it indexes but also ___.
Answer: (Secondary)

63. It is an open function that initiates the process of getting tuples, but it does not get a tuple.

Answer: (T)

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.
Answer: (T)

65. Tuple-at-a-time, unary operations require neither ___ nor ___.
Answer: (F)

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

67. Nested-loop does not allow us to avoid storing intermediate relations on disk in some situations.
Answer: (F)

68. In ___ algorithms, data is read into the main memory from the operand relations.
Answer: (merged)

69. In the second pass, all the sorted sublists are ___.
Answer: (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.
Answer: (T)

71. The essential idea behind all hash-based algorithms is ___.
Answer: (Last)

72. The existence of an index on one or more attributes of relation makes available some algorithms that ___.
Answer: (Non-clustering)

If you need more MCQs about the Advanced Database System, click here on the link

Advanced-Data Structure MCQ sample papers with answers

Advanced Database Management System Quiz

Test your knowledge of the latest advancements in database management systems and find out if you are up-to-date with the latest trends in the industry. This quiz will assess your understanding of database systems and the technologies that drive them, allowing you to gain a better understanding of the technology behind the world’s leading database management systems. Take the quiz now and see how much you know!

Created on December 03, 2022 By Sofia Islam

Advanced Database Management System Quiz

Welcome to the Advanced Database Management System Quiz presented by Eguardian India! Test your knowledge and refine your understanding of database management systems today.

With this quiz, you'll gain an understanding of the basics of database systems, their various components, and the tools used to create them. So get ready to flex your database management muscles and prove yourself an expert with the help of Eguardian India!

1 / 25

___ is a mechanism that is used to deal with problems arising due to concurrency.

Atomicity

Locking

Isolation

None of the above

2 / 25

___ is a set of properties concerning user that are relevant for security purposes.

Access control

Multilevel security

Credential

None of the above

3 / 25

In ____ data is encoded using some coded algorithm.

Statistical database

Encryption

Decryption

None of the above

4 / 25

___ specifies the channels along which information is allowed to move.

Credential

Connect channels

Flow chart

Access control

5 / 25

___ allows information to pass from a higher classification level to a lower classification level through improper means.

A flow policy

Covert channel

Invert channel

Storage channel

6 / 25

___ proposed public key encryption.

Diffie

Hellmann

Both A & B

None of the above

7 / 25

___ can provide end-to-end encryption on the channel between sender A and receiver B.

Public key encryption

DES

PES

All of the above

8 / 25

___is the scrambled message produced as output.

Decrypt

Plaintext

Cipher text

Public keys

9 / 25

___ is a means a associating a mark unique to an individual with a body of text.

Encryption

Digital signatures

Cipher text

None of the above

10 / 25

___ is a means a associating a mark unique to an individual with a body of text.

Encryption

Digital signatures

Cipher text

None of the above

11 / 25

___ helps us extracting meaningful new patterns that cannot be found necessary by merely queering or processing data or metadata in the data warehouse.

Data mart

Data mixing

Metadata

KDD

12 / 25

KDD stands for-

Knowledge Data Discovery

Knowledge Discovery Process

Knowledge Data Product

None of the above

13 / 25

In ___ data is available by value or range.

Roll-up

Drill-down

Pivot

Selection

14 / 25

___ the data with additional sources of information.

Data selection

Enrichment

Metadata

Data cleansing

15 / 25

___ knowledge deduces new information based on applying pre-specified logical rules of deduction new given data.

Inductive knowledge

Superlative knowledge

Deductive knowledge

None of the above

16 / 25

___ rules correlate the presence of a set of items with another range of values for another set of variables.

Classification rules

Sequential patterns

Association rules

Logical patterns

17 / 25

The goal of ___ is to work from existing set of events or transactions to create a hierarchy of classes.

Classification hierarchies

Association rules

Regression rules

None of the above

18 / 25

___ is a technique derived from artificial intelligence research that uses generalized, regression and provides an iterative method to carry it out.

Regression

Neural network

KDD

Classification trees

19 / 25

___ are a class of randomized search procedures capable of adaptive and robust search over a wide range of search space topologies.

Neural networks

Regression

KDD

Genetic Algorithm

20 / 25

___ is a collection of information as well as supporting system.

Data mixing

KDD

Data warehouse

None of the above

21 / 25

___ is a term used to describe the analysis of complex data from the data warehouse

DSS

OLAP

OLTP

Data warehouse

22 / 25

___ support an organizations leading decision makes with higher level data for complex and important decisions.

OLAP

DSS

OLTP

Data mixing

23 / 25

Data warehouses are ___.

Nonvolatile

Both a and b

Volatile

None of above

24 / 25

The process of returning cleaned data to the source is called ____.

Cleansing

Purging data

Encryption

Back flushing

25 / 25

In ___ data is summarized, with increasing generalization.

Drill down

Rollup

Pivot

Sorting

Your score is

The average score is 0%

Conclusion

The Advanced Database Management System MCQ with Answers quiz was a success. I hope the quiz might be beneficial in testing your knowledge of the advanced database management system. You have enjoyed taking the quiz and found it helpful in reinforcing your understanding of the material.

I hope that you found this quiz helpful and informative; if so, please share it on all forms of social media with your friends and family members. If you have any questions, please feel free to contact us.

Read More MCQs: