IBPS IT Officer MCQ – 40 (DBMS)

The IBPS Specialist Officer (SO) Exam 2016 for recruitment of specialist officer vacancies in public sector banks has been announced. So we D2G Team is here with IBPS SO Material.

1. The executive responsible for the data processing function in an organization is?
a) PM
b) DBMS
c) DP
d) DPM

Click here to View Answer
Answer b) DBMS

2. Which of the following is NOT a type of Microsoft Access database object?
a) Queries
b) Workbooks
c) Forms
d) Tables

Click here to View Answer
Answer b) Workbooks

3. A file containing relatively permanent data is?
a) Random file
b) Transaction file
c) Master file
d) Sequential file

Click here to View Answer
Answer c) Master file

4. The complete picture of data stored in database is known as?
a) Record
b) Scheme
c) System flowchart
d) DBMS

Click here to View Answer
Answer b) Scheme

5. A subset of characters within a data field is known as?
a) Record
b) File
c) Data string
d) Byte

Click here to View Answer
Answer c) Data string

6. Data items groped together for storage purposes are called a?
a) Record
b) Title
c) List
d) string

Click here to View Answer
Answer a) Record

7. Which of the following terms does not describe a database structure used by a DBMS to link data from several files?
a) Relational
b) Structural
c) Network
d) All of the

Click here to View Answer
Answer b) Structural

8. In a relational schema, each tuple is divided into fields called?
a) Relations
b) Domains
c) Queries
d) All of the above

Click here to View Answer
Answer b) Domains

9. How do you filter by selection?
a) Right click the field value and select filter by selection from the shortcut menu
b) Find and double click the value on which you want to base the filter
c) Find and select the value on which you want to base the filter and select tools>filter by selection from the menu
d) None of the above

Click here to View Answer
Answer a) Right click the field value and select filter by selection from the shortcut menu

10. Which of the following is not a data type ?
a) Picture/graphic
b) Data/time
c) Texst
d) Number

Click here to View Answer
Answer a) Picture/graphic

Check out our latest videos on youtube