November 4, 2024

Advance DBMS MCQ Questions & Answers

dbms
Share :

Advance DBMS MCQ Questions & Answer


  1. Which of the following refers to the problem of finding abstracted patterns (or structures) in the unlabeled data?
    Ans : Unsupervised learning
  2. KDD stands for _____
    Ans : Knowledge Discovery in Data
  3. _______ technique extracts useful information from the content of online documents
    Ans : Data Mining
  4. What is KDD in data mining?
    Ans : Knowledge Discovery Databases


  5. ____ involves grouing data points which exhibit similar charactristics.
    Ans : Clustering
  6. Data Mining is used by ___ companies such as LinkedIn and Facebook, data itself is their primary product.
    Ans : Social Media
  7. ______Process consists of data cleaning, data integration, data selection, data transformation, data mining, pattern evaluation and knowledge presentation
    Ans : Knowledge Discovery of Data
  8. What are the functions of Data Mining?
    Ans : All of These


  9. Which of the following is an essential process in which the intelligent methods are applied to extract data patterns?
    Ans : Data Mining
  10. GUI stand for___
    Ans : Graphical User Interface
  11. Data Mining is used by _____ companies study their subscribers‘ calling patterns to determine.
    Ans : Credit Card
  12. Which one of the following refers to querying the unstructured textual data?
    Ans : Information retrieval


  13. Which algorithm is used for frequent itemset mining?
    Ans : Apriori algorithm
  14. NLP stands for ____.
    Ans : Natural language processing
  15. Data Mining is used by ___ companies monitor the spending habits of the customer and can easily recognize duplicitous purchases with a certain degree of accuracy using rules derived by processing billions of transactions.
    Ans : Financial Institutions
  16. The ___ recieved from various data sources is stored in the database server.
    Ans : Data


  17. ____ method results in a simplified and condensed description of the original data that is much smaller in size/quantity but retains the quality of the original data.
    Ans : Data reduction
  18. ___ Data may be erroneous or may have outliers
    Ans : Noisy
  19. _____ is increasingly used by companies having solid consumer focus like in retail sales, advertising and marketing, financial institutions, bioinformatics etc.
    Ans : Data Mining
  20. Which of the following is not a type of association rule.
    Ans : inverse rule
  21. Which of the following is a classification algorithm?
    Ans : Decision Tree

For More Updates Regrading SPM Questions  – Click Here



For More Updates Join Our Channels :


Advance DBMS MCQ Questions & Answer

  1. ____ is a process of dividing the database into various sub-tables.
    Ans : Fragmentation
  2. Fragmentation is process of dividing a table into a set of smaller tables called as___
    Ans : Fragment
  3. What is KDD in data mining?
    Ans : Knowledge Discovery Database
  4. A distributed database has which of the following advantages over a centralized database?
    Ans : Modular Growth
  5. _____is a technique where the processing power of the computer is enhanced by adding multiple CPUs.
    Ans : Multicore


  6. Storing a separate copy of the database at multiple locations is which of the following?
    Ans : Data Replication
  7. A heterogeneous distributed database is which of the following?
    Ans :The same DBMS is used at each location and data are not distributed across all nodes
  8. _______database is designed for executing the day-to-day operations in businesses.
    Ans : Operational database
  9. A huge collection of information or data accumulated from several different sources is known as _____.
    Ans : Data
  10. The term FAT is stands for___
    Ans : File allocation table


  11. A distributed database has which of the following advantages over a centralized database?
    Ans : Modular Growth
  12. ……………………. is a subject-oriented, integrated, time-variant, nonvolatile collection or data in support of management decisions.
    Ans : Data Warehousing
  13. Location transparency allows for which of the following?
    Ans : All of these
  14. A heterogeneous distributed database is which of the following?
    Ans : A different DBMS is used at each location and data are distributed across all nodes.
  15. ____It ensures permanent data storage as it completes the specified operation and issues commit.
    Ans : Durability


  16. ___It ensures the data operation will complete either with success or with failure following the ‘all or nothing’ strategy.
    Ans : Atomicity
  17. ___&___ are the types of distributed database
    Ans : Heterogeneous and homogenous
  18. Acid properties stands for____
    Ans : Atomicity, Consistency, Integrity, Durability
  19. What do data warehouses support?
    Ans : OLAP
  20. _____ is a logical representation of tables in a distributed manner an multi-dimensionally database.
    Ans : Mining
  21. A distributed database can use which of the following strategies?
    Ans : All of these

For More Updates Join Our Channels :