Database Concepts MCQ Questions And Answers For Competitive Exams
||Database Concepts MCQ Questions And Answers For Competitive Exams||Database Concepts Questions And Answers For JOA IT||
👉Microsoft Windows MCQ Questions And Answers For Competitive Exams
1. A ......... is a collection of data that is stored electronically as a series of records in a table.
(a) Spreadsheet
(b) Presentation
(c) Database
(d) Web page
2. A collection of interrelated records is called a
(a) utility file
(b) management information system
(c) database
(d) spreadsheet
(e) datasheet
3. Which of the following is the organised collection of large amount of interrelated data stored in a meaningful way used for manipulation and updation?
(a) Database
(b) File
(c) Folder
(d) Data-mining
(e) None of these
4. Items such as names and addresses are considered as
(a) input
(b) data
(c) output
(d) records
5. Which type of database, organised the data in the form of tree with nodes?
(a) Network Database
(b) Hierarchical Database
(c) Relational Database
(d) Multiple Database
6. The database stores information in
(a) rows and columns
(b) blocks
(c) tracks and sectors
(d) All of the above
7. To locate a data item for storage is
(a) field
(b) feed
(c) database
(d) fetch
8. Devices that could be used to input data into a database are
(a) keyboard, fax roller ball
(b) mouse, keyboard, monitor
(c) mouse, keyboard, touch screen
(d) All of the above
9. In a relational database, a data structure that organises the information about a single topic into rows and columns, is
(a) block
(b) record
(c) tuple
(d) table
10. The smallest unit of information about a record in a database is called a
(a) cell
(b) field
(c) record
(d) query
11. ……… are distinct items that do not have much meaning to you in a given context.
(a) Fields
(b) Data
(c) Queries
(d) Properties
(e) None of these
12. A collection of related files is called a
(a) character
(b) field
(c) database
(d) record
(e) None of these
13. Which of the following contains information about a single ‘entity’ in the database like a person, place, event or thing?
(a) Query
(b) Form
(c) Record
(d) Table
14. DBMS is comprised of tables that made up of rows called ......... and columns called ....... .
(a) fields, records
(b) records, fields
(c) address, fields
(d) ranges, sheet
15. What is a stored question about information in a database?
(a) Query
(b) Sort
(c) Report
(d) Record
(e) Field
16. A program that generally has more user-friendly interface than a DBMS is called a
(a) front end
(b) repository
(c) back end
(d) form
17. Which of the following object(s) is/are contained in database?
(a) Table
(b) Query
(c) Form
(d) All of these
18. Which of the following places the common data elements in order from smallest to largest?
(a) Character, File, Record, Field, Database
(b) Character, Record, Field, File, Database
(c) Character, Field, Record, File, Database
(d) Bit, Byte, Character, Record, Field, File, Database
19. What is the overall term for creating, editing, formatting, storing, retrieving a text document?
(a) Word processing
(b) Spreadsheet design
(c) Web design
(d) Database management
(e) Presentation generation
20. The database administrator’s function in an organisation is
(a) to be responsible for the technical aspects of managing the information contained in organisational databases
(b) to be responsible for the executive level aspects of decision regarding the information management
(c) to show the relationship among entity classes in a data warehouse
(d) to define which data mining tools must be used to extract data
||Database Concepts MCQ Questions And Answers For Competitive Exams||Database Concepts Questions And Answers For JOA IT||
21. The code that relational database management systems use to perform their database task is referred to as
(a) QBE
(b) SQL
(c) OLAP
(d) Sequel Server
22. DBMS helps to achieve
(a) data independency
(b) centralised control of data
(c) selection of data
(d) Both (a) and (b)
23. Which out of the following is not a DBMS software?
(a) dBASE
(b) FoxPro
(c) Oracle
(d) Database 2000
24. In which, the database can be restored up to the last consistent state after the system failure?
(a) Backup
(b) Recovery
(c) Redundancy
(d) Security
25. ............ provides total solutions to reduce data redundancy, inconsistency, dependency and unauthorised access of data.
(a) DBMS
(b) Tables
(c) Database
(d) Protection password
(e) Centralisation of data
26. Periodically adding, changing and deleting file records is called ......... file.
(a) updating
(b) upgrading
(c) restructuring
(d) renewing
27. Architecture of database management can be viewed as
(a) two levels
(b) four levels
(c) three levels
(d) one level
28. A collection of conceptual tools for describing data, relationships, semantics and constraints is referred to as
(a) E-R model
(b) database
(c) data model
(d) DBMS
(e) None of these
29. ......... is one reason for problems of data integrity.
(a) Data availability constraints
(b) Data inconsistency
(c) Security constraints
(d) Unauthorised access of data
(e) Data redundancy
30. ......... means that the data contained in a database is accurate and reliable.
(a) Data redundancy
(b) Data integrity
(c) Data reliability
(d) Data consistency
31. Which of the following contains data descriptions and defines the name, data type and length of each field in the database?
(a) Data dictionary
(b) Data table
(c) Data record
(d) Data filed
32. An advantage of the database management approach is
(a) data is dependent on programs
(b) data redundancy increases
(c) data is integrated and can be accessed by multiple programs
(d) All of the above
33. Which of the following is the drawback of DBMS?
(a) Improvement in data
(b) Backup and recovery
(c) Complexity
(d) Maintenance of data integrity
34. In which of the following, database is used?
(a) Banking
(b) Finance
(c) Sales
(d) All of these
35. A database that contains tables linked by common fields is called a
(a) centralised database
(b) flat file database
(c) relational database
(d) All of the above
36. Oracle is a(n)
(a) hardware
(b) high level language
(c) operating system
(d) system software
(e) RDBMS
37. The cardinality property of a relation, refers to the
(a) number of database
(b) number of columns
(c) number of rows
(d) number of tables
38. Rows of a relation are called
(a) relation
(b) tuples
(c) data structure
(d) entities
39. A set of possible data values is called
(a) attribute
(b) degree
(c) tuple
(d) domain
40. The purpose of the primary key in a database is to
(a) unlock the database
(b) provide a map of the data
(c) uniquely identify a record
(d) establish constraints on database operations
(e) None of the above
||Database Concepts MCQ Questions And Answers For Competitive Exams||Database Concepts Questions And Answers For JOA IT||
41. In case of entity integrity, the primary key may be
(a) not null
(b) null
(c) Both (a) and (b)
(d) any value
42. 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
(a) unique key
(b) prime attribute
(c) index key
(d) primary key
43. Which of the following types of table constraints will prevent the entry of duplicate rows?
(a) Primary key
(b) Unique
(c) Null
(d) Foreign key
44. The particular field of a record that uniquely identifies each record is called the
(a) key field
(b) primary field
(c) master field
(d) order field
(e) None of these
45. ......... is a primary key of one file that also appears in another file.
(a) Physical key
(b) Primary key
(c) Foreign key
(d) Logical key
(e) None of these
46. ......... is an invalid type of database key.
(a) Structured primary key
(b) Atomic primary key
(c) Primary key
(d) Composite primary key
(e) None of the above
47. Key to represent relationship between tables is called
(a) primary key
(b) secondary key
(c) foreign key
(d) composite key
(e) None of these
48. Which database language is used to access data in existing database?
(a) DDL
(b) DML
(c) DCL
(d) None of these
49. An E-R diagram is a graphic method of presenting
(a) primary keys and their relationships
(b) primary keys and their relationships to instances
(c) entity classes and their relationships
(d) entity classes and their relationships to primary keys
(e) None of the above
50. In an E-R diagram, an entity set is represented by
(a) rectangle
(b) square
(c) ellipse
(d) triangle
51. In an E-R diagram, attributes are represented by
(a) rectangle
(b) square
(c) ellipse
(d) circle
52. In E-R diagram, relationship type is represented by
(a) ellipse
(b) dashed ellipse
(c) rectangle
(d) diamond
(e) None of these
53. An entity set that does not have sufficient attributes to form a primary key, is a
(a) strong entity set
(b) weak entity set
(c) simple entity set
(d) primary entity set
(e) None of these
54. Relationship can be divided into
(a) One-to-one
(b) Many-to-one
(c) One-to-many
(d) All of the above
55. 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
56. A logical schema
(a) is the entire database
(b) is a standard way of organising information into accessable part
(c) describes how data is actually stored on disk
(d) All of the above
57. Data duplication wastes the space, but also promotes a more serious problem called
(a) isolated
(b) data inconsistency
(c) other than those given as options
(d) program dependency
(e) separated data
58. When data changes in multiple lists and all lists are not updated. This causes [
(a) Data redundancy
(b) Information overload
(c) Duplicate data
(d) Data consistency
(e) Data inconsistency
||Database Concepts MCQ Questions And Answers For Competitive Exams||Database Concepts Questions And Answers For JOA IT||
| Join Our Telegram Group | Click Here |
| Advertisement with us | Click Here |
| Download Himexam APP | Click Here |
| Himachal GK | Click Here |
.png)
%20in%20the%20Education%20Department%20(42).png)
