SSC GK Computer : Database Management System

1. Part number, part description, and number of parts ordered are examples of 

(a) control

(b) output

(c) processing

(d) feedback

(e) input

2. Grouping and processing all of a firm’s transactions at one time is called

(a) a database management system

(b) batch processing

(c) a real-time system

(d) an on-line system

(e) None of these

3. Forms that are used to organize business data into rows and columns are called __________.

(a) transaction sheets

(b) registers

(c) business forms

(d) sheet-spreads

(e) spreadsheets

4. What refers to a set of characters of a particular design ? 

(a) keyface

(b) formation

(c) calligraph

(d) stencil

(e) typeface

5. _________ is used by public and private enterprises to publish and share financial information with each other and industry analysts across all computer platforms and the Internet.

(a) Extensible Markup Language (EML)

(b) Extensible Business Reporting Language (XBRL)

(c) Enterprise Application Integration (EAI)

(d) Sales Force Automation (SFA) software

(e) None of these

6. ROLLBACK in a database is ________ statement 

(a) TCL

(b) DCL

(c) DML

(d) DDL

(e) SDL

7. _______ provides total solutions to reduce data redundancy, inconsistency, dependence and unauthorized access of data

(a) DBMS

(b) Tables

(c) Database

(d) Protection passwords

(e) Centralization of data

8. ______ is one reason for problems of data integrity 

(a) Data availability constraints

(b) Data inconsistency

(c) Security constraints

(d) Unauthorized access of data

(e) Data redundancy

9. Dr. E.F. Codd represented ______ rules that a database must obey if it has to be considered truly relational 

(a) 10

(b) 8

(c) 12

(d) 6

(e) 5

10. A data warehouse 

(a) Contains numerous naming conventions and formats

(b) Is organized around important subject areas

(c) Contains only current data

(d) Can be updated by end users

(e) Explains some observed event or condition

11. Which of these is considered intelligent CASE tool 

(a) Toolkit

(b) Methodology companion

(c) Workbench

(d) Upper CASe

(e) Lower CASe

12. A collection of conceptual tools for describing data, relationships, semantics and constraints is referred to as 

(a) ER model

(b) Data base

(c) Data Model

(d) DBMS

(e) None of these

13. ______ search method is conducted for a specific title, domain, URL, or host

(a) Keyword

(b) Field

(c) Boolean

(d) Miscellaneous

(e) Logical

14. Attributes can be defined for 

(a) entity

(b) switch board

(c) macro

(d) pages

(e) None of the above

15. Where will we find the referential integrity command ? 

(a) Tools

(b) View

(b) Format

(d) Table

(e) None of these

16. Unlike filters queries can be saved as in a database. 

(a) objects

(b) filters

(c) database

(d) Any of the above

(e) None of these

17. What is a database ? 

(a) It is a collection of data arranged in rows

(b) It is a collection of data arranged in columns

(c) It is a collection of data arranged in rows and columns

(d) All of the above

(e) None of the above

18. External database is 

(a) Database created in EXCEL

(b) Database created using DBMS package

(c) Database created in MS-Word

(d) All of the above

(e) None of the above

19. Which command we will give if we want to show the database objects with it's decription ?

(a) Details

(b) Show

(c) List

(d) Any of the above

(e) None of the above

20. The software that is used to create text-based documents are referred to as ___________.

(a) DBMS

(b) suites

(c) spreadsheets

(d) presentation software

(e) word processors

Click here to Download Computer GK EBook