Top 150+ Solved Advanced Database Management Systems (ADBMS) MCQ Questions Answer
Q. VDL is used to specify:
a. Internal schema
b. External schema
c. Conceptual schema
d. None of these.
Q. The DML provides following functional access to the database:
a. Retrieve data and/or records
b. Add (or insert) records
c. Delete records from database files
d. All of these
Q. 4GL has the following components inbuilt in it:
a. Query languages
b. Report generators
c. Spreadsheets
d. All of these.
Q. Which of the following is database element?
a. Data
b. Constraints and schema
c. Relationships
d. All of these.
Q. What separates the physical aspects of data storage from the logical aspects of datarepresentation?
a. Data
b. Schema
c. Constraints
d. Relationships
Q. What scheme defines how and where the data are organized in a physical data storage?
a. External
b. Internal
c. Conceptual
d. None of these.
Q. Which of the following schemas defines the stored data structures in terms of thedatabase model used?
a. External
b. Conceptual
c. Internal
d. None of these
Q. Which of the following schemas defines a view or views of the database for particularusers?
a. External
b. Conceptual
c. Internal
d. None of these
Q. A collection of data designed to be used by different people is called.
a. Database
b. RDBMS
c. DBMS
d. None of these
Q. Which of the following is an object-oriented feature?
a. Inheritance
b. Abstraction
c. Polymorphism
d. All of these
Q. In ……………technique, data splits at decision points based on entropy
a. Cluster detection
b. Decision trees
c. Link analysis
d. All of the above
Q. Association of unknown instances with known instances is a processof………….technique
a. Memory based reasoning
b. Link analysis
c. Neural network
d. Genetic algorithm
Q. Which technique is based on linking of variables
a. Cluster detection
b. Decision trees
c. Link analysis
d. All of the above
Q. Forward propagation network is a structure of……………..
a. Memory based reasoning
b. Link analysis
c. Neural network
d. Genetic algorithm
Q. Data mining applications include
a. Customer segmentation
b. Market basket analysis
c. Risk management
d. All of the above