Advance DBMS MCQ Questions & Answer
- Which of the following refers to the problem of finding abstracted patterns (or structures) in the unlabeled data?
Ans : Unsupervised learning - KDD stands for _____
Ans : Knowledge Discovery in Data - _______ technique extracts useful information from the content of online documents
Ans : Data Mining - What is KDD in data mining?
Ans : Knowledge Discovery Databases
- ____ involves grouing data points which exhibit similar charactristics.
Ans : Clustering - Data Mining is used by ___ companies such as LinkedIn and Facebook, data itself is their primary product.
Ans : Social Media - ______Process consists of data cleaning, data integration, data selection, data transformation, data mining, pattern evaluation and knowledge presentation
Ans : Knowledge Discovery of Data - What are the functions of Data Mining?
Ans : All of These
- Which of the following is an essential process in which the intelligent methods are applied to extract data patterns?
Ans : Data Mining - GUI stand for___
Ans : Graphical User Interface - Data Mining is used by _____ companies study their subscribers‘ calling patterns to determine.
Ans : Credit Card - Which one of the following refers to querying the unstructured textual data?
Ans : Information retrieval
- Which algorithm is used for frequent itemset mining?
Ans : Apriori algorithm - NLP stands for ____.
Ans : Natural language processing - 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 - The ___ recieved from various data sources is stored in the database server.
Ans : Data
- ____ 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 - ___ Data may be erroneous or may have outliers
Ans : Noisy - _____ is increasingly used by companies having solid consumer focus like in retail sales, advertising and marketing, financial institutions, bioinformatics etc.
Ans : Data Mining - Which of the following is not a type of association rule.
Ans : inverse rule - 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
- ____ is a process of dividing the database into various sub-tables.
Ans : Fragmentation - Fragmentation is process of dividing a table into a set of smaller tables called as___
Ans : Fragment - What is KDD in data mining?
Ans : Knowledge Discovery Database - A distributed database has which of the following advantages over a centralized database?
Ans : Modular Growth - _____is a technique where the processing power of the computer is enhanced by adding multiple CPUs.
Ans : Multicore
- Storing a separate copy of the database at multiple locations is which of the following?
Ans : Data Replication - 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 - _______database is designed for executing the day-to-day operations in businesses.
Ans : Operational database - A huge collection of information or data accumulated from several different sources is known as _____.
Ans : Data - The term FAT is stands for___
Ans : File allocation table
- A distributed database has which of the following advantages over a centralized database?
Ans : Modular Growth - ……………………. is a subject-oriented, integrated, time-variant, nonvolatile collection or data in support of management decisions.
Ans : Data Warehousing - Location transparency allows for which of the following?
Ans : All of these - 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. - ____It ensures permanent data storage as it completes the specified operation and issues commit.
Ans : Durability
- ___It ensures the data operation will complete either with success or with failure following the ‘all or nothing’ strategy.
Ans : Atomicity - ___&___ are the types of distributed database
Ans : Heterogeneous and homogenous - Acid properties stands for____
Ans : Atomicity, Consistency, Integrity, Durability - What do data warehouses support?
Ans : OLAP - _____ is a logical representation of tables in a distributed manner an multi-dimensionally database.
Ans : Mining - A distributed database can use which of the following strategies?
Ans : All of these
For More Updates Join Our Channels :
