10.MCQ Database Concepts

  • Post author:
  • Post category:Blog
  • Reading time:52 mins read

 

1. DBMS is

(1) collection of data

(2) set of programs to access those data 

(3) set of programs to update those data 

(4) All of the above 

(5) None of the above 

2.Devices that could be used to input data into a database are 

(1) keyboard, fax roller ball 

(2) mouse, keyboard, monitor 

(3) mouse, keyboard, touch screen 

(4) All of the above

(5) None of the above 

3. What is the overall term for creating, editing, formatting, storing, retrieving a text document? [IBPS PO 2012)

(1) Word processing

(2) Spre heet design 

(3) Web design 

(4) Database management 

(5) Presentation generation

4. DBMS is comprised of tables that made up of rows called ……… and columns called …… 

(1) fields, records 

(2) records, fields 

(3) address, fields 

(4) ranges, sheet

(5) records, ranges 

5. A database that contains tables linked by common fields is called a 

(1) centralised database 

(2) flat file database 

(3) relational database 

(4) All of these

(5) None of these 

6. Which of the following places the common data elements in order from smallest to largest? 

(1) Character. File, Record, Field, Database 

(2) Character, Record, Field, File, Database

(3) Character,Field. Record, File, Database 

(4) Bit, Byte, Character, Record, FDatabase 

(5) None of the above

7. Which of the following contains information about a single entity in the database like a person, place, or event? [SBI PO 2010]

(1) Query 

(2) from

(3) Record 

(4) Table

(5) None of these

8. The primary key must be 

(1) numeric 

(2) unique

(3) multiple 

(4) related 

(5) object 

9. A program that generally has more user-friendly interface than a DBMS is called a [SBI PO 2010) 

(1) front end

(2) repository 

(3) back end

(4) form 

(5) None of these

10. Periodically adding, changing and deleting file records is called ……….. file. 

(1) updating 

(2) upgrading 

(3) restructuring 

(4) renewing 

(5) None of these

11. The smallest unit of information about a record in a database is called a (1) cell

(2) field 

(3) record

(4) query 

(5) None of these 

(Allahabad Bank Clerk 2008] 


12. Items such as names and addresses are considered as 

(1) input 

(9) data 

(3) output

(4) records 

(5) information 


13. ….means that the data contained in a database is accurate and reliable. [SBI PO 2008) 

(1) Data redundancy 

(2) Data integrity 

(3) Data reliability 

(4) Data consistency

(5) None of the above 


14. Which of the following objects is/are contained in database? 

(1) Table

(2) Queries 

(3) Form

(4) All of these 

(5) None of these 


15. A ………… is a collection of data that is stored electronically as a series of records in a table. 

(1) spreadsheet 

(2) presentation 

(3) database

(4) web page 

(5) None of these 


16. A collection of conceptual tools for describing data, relationships, semantics and constraints is referred to as [IBPS Clerk 2012]

(1) ER model 

(4) DBMS

(2) database 

(3) data model 

(5) None of these

17. Dr EF Codd represented ………. rules that a database must obey if it has to be considered truly relational. [1BPS Clerk 2012) 

(1) 10 

(2) 8 

(3) 12 

(4) 6

(5) 5 

18. ………… is one reason for problems of data integrity. [IBPS Clerk 2012) (1) Data availability constraints 

(2) Data inconsistency 

(3) Security constraints 

(4) Unauthorised access of data

(5) Data redundancy 

19. In files, there is a key associated with each record which is used to differentiate among different records. For every file, there is atleast one set of keys that is unique. Such a key is called 

(1) unique key

(2) prime attribute 

(3) index key

(4) primary key 

(5) null key 

20. Rows of a relation are called

(1) relation 

(2) tuples 

(3) data structure 

(4) an entity

(5) None of these 

21………… provides total solutions to reduce data redundancy, inconsistency, dependence and unauthorised access of data. [IBPS Clerk 2012] 

(1) DBMS 

(2) Tables 

(9) Database 

(4) Protection passwords

(5) Centralisation of data 

22. The database stores information in [SBI PO 2010]

(1) rows and columns 

(2) blocks 

(3) tracks and sectors 

(0) All of the above 

(5) None of the above

23. Which of the following types of table constraints will prevent the entry of duplicate rows? 

(1) Primary key

(2) Unique 

(3) Null

(4) Foreign key 

(5) None of these 

24. The dBASE III Plus is mostly used for

(1) office automation 

(2) database management problems 

(3) scientific problems 

(4) calculations only 

(5) None of the above

25. Which out of the following is not a DBMS software?

(1) dBASE 

(2) FoxPro 

(3) ORACLE 

(4) SyBase 

(5) Database 2000

26. The database administrator’s function in an organisation is 

(1) to be responsible for the technical aspects of managing the information contained in organisational databases.

(2) to be responsible for the executive level aspects of decision regarding the information management

(3) to show the relationship among classes in a data warehouse 

(4) to define which data mining tools used to extract data 

(5) None of the above 

27. The primary key must be a (n)……field.

(1) numeric 

(2) object 

(3) unique

(4) related 

(5) None of these 

28. The particular field of a record that uniquely identifies each record is called the [SBI PO 2012]

(1) key field

(2) primary field 

(3) master field 

(4) order field 

(5) None of these

29. ……are distinct items that don’t have much meaning to you in a given context. [SBI PO 2012) 

(1) Fields

(2) Data 

(3) Queries

(4) Properties 

(5) None of these

30. A collection of related files is called a

(1) character 

(2) field 

(3) database 

(4) record 

(5) None of these

31. A logical schema [SBI PO 2011] 

(1) is the entire database 

(2) is a standard way of organising information into accessable part 

(3) describes how data is actually stored on disk 

(4) All of the above

(5) None of the above 

32. In the relational modes, cardinality is termed [IBPS Clerk 2011]

(1) number of tuples 

(2) number of attributes 

(3) number of tables 

(4) number of constraints

(5) None of the above 

33. To locate a data item for storage is 

(1) field

(2) feed 

(3) database

(4) fetch 

(5). None of these 

34. An ER diagram is a graphic method of presenting  [IBPS Clerk 2011]

(1)primary keys and their relationships 

(2) primary keys and their relationships to instances

(3) entity classes and their relationships

(4)entity classes and their relationships to primary keys 

(5) None of the above 

35. A computer checks the…..of username and  password for a match before granting access. (SBI Clerk 2011]  

(1) website

(2) network 

(3) backup file

(4) database 

(5) None of these

36. Architecture of database can be viewed as 

(1) two levels

(2) four levels 

(3) three levels

(4) one level 

(5) None of these 

37. An entity set that does not have sufficient attributes to form a primary key, is a (IBPS Clerk 2011]

(1) strong entity set 

(2) weak entity set 

(3) simple entity set 

(4) primary entity set 

(5) None of these

38. In an ER diagram, attributes are represented by

(1) rectangle 

(2) square 

(3) ellipse

(4) triangle 

(5) circle 

39. In case of entity integrity, the primary key may be 

(1) not null 

(2) null 

(3) Both 1′ and 2

(4) any value 

(5) None of these 

40. In an ER diagram, an entity set is represented by a 

(1) rectangle 

(2) ellipse 

(3) diamond box 

(4) circle 

(5) None of these

41……is a primary key of one file that also appears in another file. [IBPS Clerk 2013] 

(1) Physical key 

(2) Primary key 

(3) Foreign key

(4) Logical key 

(5) None of these

42…….is an invalid type of database key, [IBPS Clerk 2013]

(1) Structured primary key 

(2) Atomic primary key 

(3) Primary key 

(4) Composite primary key

(5) None of the above 

43. An advantage of the database management approach is 

(1) data is dependent on programs 

(2) data redundancy increases 

(3) data is integrated and can be accessed by multiple programs 

(4) All of the above

(5) None of the above 

44. Key to represent relationship between tables is called [SBI Clerk 2010] (1) primary key 

(2) secondary key 

(3) foreign key

(4) composite key 

(5) None of these 

45. DBMS helps to achieve

(1) data independence 

(2) centralised control of data 

(3) selection of data 

(4) Both ‘l’ and ‘2’

(5) None of the above 

46. A set of possible data values is called 

(1) attribute

(2) degree 

(9) tuple

(4) domain 

(5) None of these

46. A set of possible data values is called

(1) attribute 

(2) degree 

(3) tuple

(4) domain 

(5) None of these 

47. In ER diagram, relationship type is represented by [IBPS Clerk 2012) 

(1) ellipse

(2) dashed ellipse 

(9) rectangle 

(4) diamond

(5) None of these 

48. In a relational database, a data structure that organises the information about a single topic into rows and columns, is [RBI PO 2011] 

(1) block

(2) record 

(3) tuple

(4) table 

(5) None of these