DATABASE CONCEPTS MCQ Questions and Answers

by

 

Results

#1. A computer checks the …… of username and password for a match before granting access.

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

#3. A collection of interrelated records is called a

#4. Which of the following is the organised collection of large amount of interrelated data stored in a meaningful way used for manipulation and updating?

#5. Items such as names and addresses are considered as




#6. Which type of database, organised the data in the form of tree with nodes?

#7. The database stores information in

#8. To locate a data item for storage is

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

#10. In a relational database, a data structure that organises the information about a single topic into rows and columns, is




#11. The smallest unit of information about a record in a database is called a

#12. ……… are distinct items that don’t have much meaning to you in a given context.

#13. The cardinality property of a relation, refers to the

#14. Rows of a relation are called

#15. A collection of related files is called a




#16. In the relational modes, cardinality is termed as

#17. Which of the following contains information about a single ‘entity’ in the database like a person, place, event or thing?

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

#19. What is a stored question about information in a database?

#20. A program that generally has more user-friendly interface than a DBMS is called a




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

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

#23. What is the overall term for creating, editing, formatting, storing, retrieving a text document?

#24. The database administrator’s function in an organisation is

#25. The code that relational database management systems use to perform their database task is referred to as




#26. DBMS helps to achieve

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

#28. In which, the database can be restored up to the last consistent state after the system failure?

#29. ………… provides total solutions to reduce data redundancy, inconsistency, dependence and unauthorised access of data.

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




#31. Architecture of database management can be viewed as

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

#33. ……… is one reason for problems of data integrity.

#34. ……… means that the data contained in a database is accurate and reliable.

#35. Which of the following contains data descriptions and defines the name, data type and length of each field in the database?




#36. An advantage of the database management approach is

#37. Which of the following is the drawback of DBMS?

#38. In which of the following, database are used?

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

#40. Oracle is a (n)




#41. A set of possible data values is called

#42. The purpose of the primary key in a database is to

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

#44. 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 keysthat isunique. Such a key is called

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




#46. The particular field of a record that uniquely identifies each record is called the

#47. ……… is a primary key of one file that also appears in another file.

#48. ……… is an invalid type of database key.

#49. Key to represent relationship between tables is called

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




#51. A logical schema

#52. Data duplication wastes the space, but also promotes a more serious problem called

#53. When data changes in multiple lists and all lists are not updated. This causes

#54. Which database language is used to access data in existing database?

#55. An E-R diagram is a graphic method of presenting




#56. In an E-R diagram, an entity set is are represented by

#57. In an E-R diagram, attributes are represented by

#58. In E-R diagram, relationship type is represented by

#59. An entity set that does not have sufficient attributes to form a primary key, is a

#60. Relationship can be divided into




Previous
Finish

Google search

Looking for More Resources?