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 and SBI Assistant Manager(System). We have also included some important questions that are repeatedly asked in previous exams.
- OLAP stands for_____
(A) Online Arithmetic Processing
(B) Online Analysis Processing
(C) Online Analytical Processing
(D) None of the above
Answer
(C) Online Analytical Processing - The _____ operation allows the combining of two relations by merging pairs of tuples, one from each relation, into a single tuple.
(A) Join
(B) Intersection
(C) Union
(D) None of the above
Answer
(A) Join - ________is the multiplication of all the values in the attributes.
(A) Set difference
(B) Cartesian product
(C) Intersection
(D) None of the above
Answer
(B) Cartesian product - Which command is used to remove a relation from an SQL database?
(A) Delete
(B) Remove
(C) Drop
(D) None of the above
Answer
(C) Drop - In SQL, the spaces at the end of the string are removed by _______ function .
(A) Lower
(B) String
(C) Trim
(D) None of the above
Answer
(C) Trim - ________ is used to save permanently any transaction into database.
(A) commit
(B) rollback
(C) savepoint
(D) None of the above
Answer
(A) commit - A unit of storage that can store one or more records in a hash file organization is denoted as_______
(A) Bucket
(B) Disk pages
(C) Blocks
(D) Nodes
Answer
(A) Bucket - Which of the following operator used for appending two strings?
(A) %
(B) &
(C) +
(D) ||
Answer
(D) || - The management information system (MIS) structure with one main computer system is called a________
(A) Decentralized MIS structure
(B) Distributed MIS structure
(C) Centralized MIS structure
(D) None of the above
Answer
(C) Centralized MIS structure - The highest level in the hierarchy of data organization is called________
(A) data base
(B) data file
(C) data record
(D) None of the above
Answer
(A) data base
AffairsCloud Recommends Oliveboard Mock Test
AffairsCloud Ebook - Support Us to Grow
Govt Jobs by Category
Bank Jobs Notification
