Dear Aspirants,
Welcome to the Professional Knowledge Section in Affairscloud.com. Here we are providing sample questions in DBMS. It will be useful for the IBPS SO IT officer. We have also included some important questions that are repeatedly asked in previous exams.
- Which handles the SQL requests and converts it into a request the individual database understands?
A. Graphical User Interface(GUI)
B. ActiveX Data Objects (ADO)
C. Universal Data Access (UDA)
D. Open Database Connectivity(ODBC)
Answer
D. Open Database Connectivity(ODBC) - __________ is a database that contains billions of table rows.
A. Very Large Database (VLDB)
B. Holographic storage
C. Both (A) and (B)
D. None of the Above
Answer
A. Very Large Database (VLDB) - ACID is a concept that defines four transaction properties of a database.ACID stands for ______
A. Accuracy, Characteristics, Interface, Data mart
B. Atomicity, Consistency, Interface, Data mart
C. Accuracy, Characteristics, Isolation, Data mart
D. Atomicity, Consistency, Isolation, Durability
Answer
D. Atomicity, Consistency, Isolation, Durability - Which of the following is middle ware designed to support rapid high volume on-line transactions?
A. Oracle
B. Customer Information Control System(CICS)
C. Both (A) and (B)
D. None of the Above
Answer
B. Customer Information Control System(CICS) - Which of the following middle ware technology might need the Interface Definition Language (IDL)?
A. COBOL
B. RAI
C. CORBA
D. None of the Above
Answer
C. CORBA - CORBA stands for _______
A. Common Object Request Broker Application
B. Common Oriented Request Broker Application
C. Common Oriented Request Broker Architecture
D. Common Object Request Broker Architecture
Answer
D. Common Object Request Broker Architecture - The basic unit of PL/SQL is called ______
A. Array
B. Row
C. Unit
D. Block
Answer
D. Block - __________ is a refinement process of organizing data in the database to avoid data redundancy and anomalies in insert, delete and update operations.
A. Data Modeling
B. Normalization
C. Clustering
D. None of the Above
Answer
B. Normalization - Which term is used to describe the process of forecasting or discovering pattern in data?
A. Data Modeling
B. Data Warehousing
C. Data Mining
D. Normalization
Answer
C. Data Mining - Which of the following technology was Microsoft’s first attempt at an object-oriented database interface?
A. Data Access Objects (DAO)
B. ActiveX Data Objects (ADO)
C. Universal Data Access (UDA)
D. None of the Above
Answer
A. Data Access Objects (DAO)
AffairsCloud Recommends Oliveboard Mock Test
AffairsCloud Ebook - Support Us to Grow
Govt Jobs by Category
Bank Jobs Notification
