DBMS MCQ 2023

Database Management System (DBMS) MCQ 2023

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. Who created the first DBMS?

a) Edgar Frank Codd

b) Charles Bachman

c) Charles Babbage

d) Sharon B. Codd

5. 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

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

a) Image

b) Text

c) Table

d) Graph

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

a) Hierarchical

b) Network

c) Distributed

d) Decentralized

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

a) MySQL

b) Microsoft Acess

c) IBM DB2

d) Google

9. Which of the following is not a feature of DBMS?

a) Minimum Duplication and Redundancy of Data

b) High Level of Security

c) Single-user Access only

d) Support ACID Property

10. Which of the following is a feature of the database?

a) No-backup for the data stored

b) User interface provided

c) Lack of Authentication

d) Store data in multiple locations

11. 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

12. Which of the following is a function of the DBMS?

a) Storing data

b) Providing multi-users access control

c) Data Integrity

d) All of the above

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

a) Data

b) Data Languages

c) Data Manager

d) All of the above

14. 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

15. What is information about data called?

a) Hyper data

b) Tera data

c) Meta data

d) Relations

16. What does an RDBMS consist of?

a) Collection of Records

b) Collection of Keys

c) Collection of Tables

d) Collection of Fields

17. 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

18._____________ is a hardware component that is most important for the operation of a database management system.

a) Microphone

b) High speed, large capacity disk to store data

c) High-resolution video display

d) Printer

19. The DBMS acts as an interface between ________________ and ________________ of an enterprise-class system.

a) Data and the DBMS

b) Application and SQL

c) Database application and the database

d) The user and the software

20. The ability to query data, as well as insert, delete, and alter tuples, is offered by ____________

a) TCL (Transaction Control Language)

b) DCL (Data Control Language)

c) DDL (Data Definition Langauge)

d) DML (Data Manipulation Langauge)

21.______________ 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

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

a) Drop table

b) Delete

c) Purge

d) Remove

23. 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

24. Which of the following command is correct to delete the values in the relation teaches?

a) Delete from teaches;

b) Delete from teaches where Id =’Null’;

c) Remove table teaches;

d) Drop table teaches;

25. Procedural language among the following is __________

a) Domain relational calculus

b) Tuple relational calculus

c) Relational algebra

d) Query language

26._________________ operations do not preserve non-matched tuples.

a) Left outer join

b) Inner join

c) Natural join

d) Right outer join

27. Which forms have a relation that contains information about a single entity?

a) 4NF

b) 2NF

c) 5NF

d) 3NF

28. The top level of the hierarchy consists of ______ each of which can contain _____.

a) Schemas, Catalogs

b) Schemas, Environment

c) Environment, Schemas

d) Catalogs, Schemas

29._______ indicates the maximum number of entities that can be involved in a relationship.

a) Greater Entity Count

b) Minimum cardinality

c) Maximum cardinality

d) ERD

30. The user IDs can be added or removed using which of the following fixed roles?

a) db_sysadmin

b) db_accessadmin

c) db_securityadmin

d) db_setupadmin

31. The traditional storage of data organized by the customer, stored in separate folders in filing cabinets is an example of ______________ type of ‘database’ management system.

a) Object-oriented database management system

b) Relational database management system

c) Network database management system

d) Hierarchical database management system

32. After groups have been established, SQL applies predicates in the ___________ clause, allowing aggregate functions to be used.

a) Where

b) Having

c) Group by

d) With

33. What does a foreign key combined with a primary key create?

a) Network model between the tables that connect them

b) Parent-Child relationship between the tables that connects them

c) One to many relationship between the tables that connects them

d) All of the mentioned

34. Which of the following is correct according to the technology deployed by DBMS?

a) Pointers are used to maintain transactional integrity and consistency

b) Cursors are used to maintain transactional integrity and consistency

c) Locks are used to maintain transactional integrity and consistency

d) Triggers are used to maintain transactional integrity and consistency

35. Which of the following is correct regarding the file produced by a spreadsheet?

a) can be used as it is by the DBMS

b) stored on disk in an ASCII text format

c) all of the mentioned

d) none of the mentioned

36.______ resembles Create view.

a) Create table . . . as

b) Create view as

c) Create table . . .like

d) With data

37. The query specifying the SQL view is said to be updatable if it meets which of the following conditions?

a) select clause contains relation attribute names but not have expressions, aggregates, or distinct specification

b) from clause has 1 relation

c) query does not have group by or having clause

d) All of the mentioned

38. Which of the following is the subset of SQL commands used to manipulate Oracle Structures, including tables?

a) Data Described Language

b) Data Retrieval Language

c) Data Manipulation Language

d) Data Definition Language

39. For designing a normal RDBMS which of the following normal form is considered adequate?

a) 4NF

b) 3NF

c) 2NF

d) 5NF

40. Which of the following represents a query in the tuple relational calculus?

a) { }{P(t) | t }

b) {t | P(t)}

c) t | P() | t

d) All of the mentioned

41. The oldest DB model is _______________

a) Network

b) Physical

c) Hierarchical

d) Relational

42. The subset of a super key is a candidate key under what condition?

a) No proper subset is a super key

b) All subsets are super keys

c) Subset is a super key

d) Each subset is a super key

43. 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

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

a) Name

b) Street

c) Id

d) Department

45. 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

46. The ______ is the one in which the primary key of one relation is used as a normal attribute in another relation.

a) Referential relation

b) Referencing relation

c) Referenced relation

d) Referred relation

47. Which one of the following is a procedural language?

a) Domain relational calculus

b) Tuple relational calculus

c) Relational algebra

d) Query language

48. The_____ operation allows the combining of two relations by merging pairs of tuples, one from each relation, into a single tuple.

a) Select

b) Join

c) Union

d) Intersection

49. The result which operation contains all pairs of tuples from the two relations, regardless of whether their attribute values match.

a) Join

b) Cartesian product

c) Intersection

d) Set difference

50. The _______operation performs a set union of two “similarly structured” tables.

a) Union

b) Join

c) Product

d) Intersect

51. The most commonly used operation in relational algebra for projecting a set of tuple from a relation is

a) Join

b) Projection

c) Select

d) Union

52. The _______ operator takes the results of two queries and returns only rows that appear in both result sets.

a) Union

b) Intersect

c) Difference

d) Projection

53. In SQL the spaces at the end of the string are removed by _______ function.

a) Upper

b) String

c) Trim

d) Lower

54._____ operator is used for appending two strings.

a) &

b) %

c) ||

d) _

55. The union operation is represented by

a) ∩

b) U

c) –

d) *

56. The intersection operator is used to get the _____ tuples.

a) Different

b) Common

c) All

d) Repeating

57. The union operation automatically __________ unlike the select clause.

a) Adds tuples

b) Eliminates unique tuples

c) Adds common tuples

d) Eliminates duplicate

58. If we want to retain all duplicates, we must write ________ in place of union.

a) Union all

b) Union some

c) Intersect all

d) Intersect some

59. The number of attributes in relation is called as its

a) Cardinality

b) Degree

c) Tuples

d) Entity

60._____ clause is an additional filter that is applied to the result.

a) Select

b) Group-by

c) Having

d) Order by

61._________ joins are SQL server default

a) Outer

b) Inner

c) Equi

d) None of the mentioned

62. The _____________ is essentially used to search for patterns in target string.

a) Like Predicate

b) Null Predicate

c) In Predicate

d) Out Predicate

63. A _____ indicates an absent value that may exist but be unknown or that may not exist at all.

a) Empty tuple

b) New value

c) Null value

d) Old value

64. Using the ______ clause retains only one copy of such identical tuples.

a) Null

b) Unique

c) Not null

d) Distinct

65. The primary key must be

a) Unique

b) Not null

c) Both Unique and Not null

d) Either Unique or Not null

66. A Delete command operates on ______ relation.

a) One

b) Two

c) Several

d) Null

67. Which one of the following deletes all the entries but keeps the structure of the relation.

a) Delete from r where P;

b) Delete from instructor where dept name= ’Finance’;

c) Delete from instructor where salary between 13000 and 15000;

d) Delete from instructor;

68. Which of the join operations do not preserve non matched tuples?

a) Left outer join

b) Right outer join

c) Inner join

d) Natural join

69. What type of join is needed when you wish to include rows that do not have matching values?

a) Equi-join

b) Natural join

c) Outer join

d) All of the mentioned

70. The operation which is not considered a basic operation of relational algebra is

a) Join

b) Selection

c) Union

d) Cross product