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 :