Database

1. What is the full form of DBMS?

A) Data of Binary Management System

B) Database Management System

C) Database Management Service

D) Data Backup Management System

2. What is a database?

A) Organized collection of information that cannot be accessed, updated, and managed

B) Collection of data or information without organizing

C) Organized collection of data or information that can be accessed, updated, and managed

D) Organized collection of data that cannot be updated

3. What is DBMS?

A) DBMS is a collection of queries

B) DBMS is a high-level language

C) DBMS is a programming language

D) DBMS stores, modifies and retrieves data

4. Which type of data can be stored in the database?

A) Image oriented data

B) Text, files containing data

C) Data in the form of audio or video

D) All of the above

5. In which of the following formats data is stored in the database management system?

A) Image

B) Text

C) Table

D) Graph

6. Which of the following is not a type of database?

A) Hierarchical

B) Network

C) Distributed

D) Decentralized

7. Which of the following is not an example of DBMS?

A) MySQL

B) Microsoft Acess

C) IBM DB2

D) Google

8. Which of the following is not a function of the database?

A) Managing stored data

B) Manipulating data

C) Security for stored data

D) Analysing code

9. Which of the following is a component of the DBMS?

A) Data

B) Data Languages

C) Data Manager

D) All of the above

10. Which of the following is known as a set of entities of the same type that share same properties, or attributes?

A) Relation set

B) Tuples

C) Entity set

D) Entity Relation model

11. The values appearing in given attributes of any tuple in the referencing relation must likewise occur in specified attributes of at least one tuple in the referenced relation, according to _____________________ integrity constraint.

A) Referential

B) Primary

C) Referencing

D) Specific

12. ______________ is a set of one or more attributes taken collectively to uniquely identify a record.

A) Primary Key

B) Foreign key

C) Super key

D) Candidate key

13. Which command is used to remove a relation from an SQL?

A) Drop table

B) Delete

C) Purge

D) Remove

14. Which of the following set should be associated with weak entity set for weak entity to be meaningful?

A) Neighbour set

B) Strong entity set

C) Owner set

D) Identifying set

15. A relational database consists of a collection of

A) Tables

B) Fields

C) Records

D) Keys

16. A ________ in a table represents a relationship among a set of values.

A) Column

B) Key

C) Row

D) Entry

17. The term _______ is used to refer to a row.

A) Attribute

B) Tuple

C) Field

D) Instance

18. The term attribute refers to a ___________ of a table.

A) Record

B) Column

C) Tuple

D) Key

19. For each attribute of a relation, there is a set of permitted values, called the ________ of that attribute.

A) Domain

B) Relation

C) Set

D) Schema

20. Database __________ which is the logical design of the database, and the database _______ which is a snapshot of the data in the database at a given instant in time.

A) Instance, Schema

B) Relation, Schema

C) Relation, Domain

D) Schema, Instance

21. Course(course_id,sec_id,semester) Here the course_id,sec_id and semester are __________ and course is a _________

A) Relations, Attribute

B) Attributes, Relation

C) Tuple, Relation

D) Tuple, Attributes

22. Department (dept name, building, budget) and Employee (employee_id, name, dept name, salary) Here the dept_name attribute appears in both the relations. Here using common attributes in relation schema is one way of relating ___________ relations.

A) Attributes of common

B) Tuple of common

C) Tuple of distinct

D) Attributes of distinct

23. A domain is atomic if elements of the domain are considered to be ____________ units.

A) Different

B) Indivisbile

C) Constant

D) Divisible

24. The tuples of the relations can be of ________ order.

A) Any

B) Same

C) Sorted

D) Constant

25. Student(ID, name, dept name, tot_cred) In this query which attributes form the primary key?

A) Name

B) Dept

C) Tot_cred

D) ID

26. Which one of the following is a set of one or more attributes taken collectively to uniquely identify a record?

A) Candidate key

B) Sub key

C) Super key

D) Foreign key

27. A _____ is a property of the entire relation, rather than of the individual tuples in which each tuple is unique.

A) Rows

B) Key

C) Attribute

D) Fields

28. Which one of the following attribute can be taken as a primary key?

A) Name

B) Street

C) Id

D) Department

29. An attribute in a relation is a foreign key if the _______ key from one relation is used as an attribute in that relation.

A) Candidate

B) Primary

C) Super

D) Sub

30. An ________ is a set of entities of the same type that share the same properties, or attributes.

A) Entity set

B) Attribute set

C) Relation set

D) Entity model

31. Entity is a _________

A) Object of relation

B) Present working model

C) Thing in real world

D) Model of relation

32. The descriptive property possessed by each entity set is _________

A) Entity

B) Attribute

C) Relation

D) Model

33. The attribute name could be structured as an attribute consisting of first name, middle initial, and last name. This type of attribute is called

A) Simple attribute

B) Composite attribute

C) Multivalued attribute

D) Derived attribute

34. The attribute AGE is calculated from DATE_OF_BIRTH. The attribute AGE is

A) Single valued

B) Multi valued

C) Composite

D) Derived

35. Which of the following can be a multivalued attribute?

A) Phone_number

B) Name

C) Date_of_birth

D) All of the mentioned

36. Which of the following is a single valued attribute

A) Register_number

B) Address

C) SUBJECT_TAKEN

D) Reference

37. _____________ express the number of entities to which another entity can be associated via a relationship set.

A) Mapping Cardinality

B) Relational Cardinality

C) Participation Constraints

D) None of the mentioned

38. An entity in A is associated with at most one entity in B, and an entity in B is associated with at most one entity in A.This is called as

A) One-to-many

B) One-to-one

C) Many-to-many

D) Many-to-one

39. An entity in A is associated with at most one entity in B. An entity in B, however, can be associated with any number (zero or more) of entities in A.

A) One-to-many

B) One-to-one

C) Many-to-many

D) Many-to-one

40. Data integrity constraints are used to:

A) Control who is allowed access to the data

B) Ensure that duplicate records are not entered into the table

C) Improve the quality of data entered for a specific property

D) Prevent users from changing the values stored in the table

41. Establishing limits on allowable property values, and specifying a set of acceptable, predefined options that can be assigned to a property are examples of:

A) Attributes

B) Data integrity constraints

C) Method constraints

D) Referential integrity constraints

42. Which one of the following uniquely identifies the elements in the relation?

A) Secondary Key

B) Primary key

C) Foreign key

D) Composite key

43. Drop Table cannot be used to drop a table referenced by a _________ constraint.

A) Local Key

B) Primary Key

C) Composite Key

D) Foreign Key

Database

More Quizzes