Important MCQ of Database Concepts of Computer Science

Important MCQ of Database Concepts of Computer Science

  1. DML(Data Manipulation Language)
  2. Query
  3. Relational Schema
  4. DDL(Data Definition Language)

Answer: D

  1. DML(Data Manipulation Language)
  2. DDL(Data Definition Language)
  3. Query
  4. Relational Schema

Answer: A

Explanation: The term “DML” stands for the Data Manipulation Language used to perform the required changes in the relation’s values.

  1. select * from emp where empid = 10003;
  2. select empid from emp where empid = 10006;
  3. select empid from emp;
  4. select empid where empid = 1009 and Lastname = ‘GELLER’;

Answer: D

Explanation: The Query given in option D does not contain the “from” clause, which specifies the relation from which the values have to be selected or fetched. Therefore the correct answer is D.

  1. It is a type of system software
  2. It is a kind of application software
  3. It is a kind of general software
  4. Both A and C

Answer: A

Explanation: The DBMS (or Database Management System) is a kind of system software used for several operations such as creating tables/databases, storing data, managing databases. It also allows modifying the data stored in the database as well.

  1. File Allocation Tree
  2. File Allocation Table
  3. File Allocation Graph
  4. All of the above

Answer: B

Explanation: The term “FAT” can be described as a file structure (or file architecture). In which all the information about the files where they are stored and where all these files need to be stored or in which directory, all that information generally stored in the file structure. Therefore the Operating system creates a table in which all the files and clusters are stored, known as the file allocation table.

Ques 22.The term “NTFS” refers to which one of the following?

  1. New Technology File System
  2. New Tree File System
  3. New Table type File System
  4. Both A and C

Answer: A

Explanation: In the old operating systems, the file structure used to store and manage files is called the FAT 32 ( or File Allocation Table). Later, when the technology evolves with time, a new type of file system is introduced, known as the New Technology File System. It overcomes all the drawbacks, issues that exist in FAT file architecture and has many other new features such as it is fast, it can handle files whose size is even greater than 4 GB.

  • Dotted rectangle.
  • Diamond
  • Doubly outlined rectangle
  • None of these

Answer: Doubly outlined rectangle

  • Network Model
  • Hierarchical Model
  • Relational Model
  • None of these

Answer: Network Model

  • Primary key
  • Secondary Key
  • Foreign Key 
  • None of these

Answer: Foreign Key 

  • Cartesian product 
  • Difference
  • Intersection
  • Product

Answer: d
Explanation: The fundamental operations are select, project, union, set difference, Cartesian product, and rename.

Answer: b
Explanation: The expression r − s produces a relation containing those tuples in r but not in s.

Answer: d
Explanation: Generalization Selection takes only one argument for operation.

  1. 6
  2. 7
  3. 8
  4. 9

Answer: B) 7


There are 7 relational operations.

  1. Select Operation
  2. Project Operation
  3. Union Operation
  4. Set Intersection
  5. Set Difference
  6. Cartesian Product
  7. Rename Operation
  1. Select Operation
  2. Set Difference
  3. Set Update
  4. Cartesian Product

Answer: C) Set Update


Set Update is NOT a type of relational operation.

  1. σ
  2. R
  3. P
  4. S

Answer: A) σ


Select operation is denoted by σ.

  1. Select
  2. Project
  3. Union
  4. Rename

Answer: B) Project


A list of the attributes we wish to appear in the result is displayed in Project operation.

  1. P
  2. R
  3. O

Answer: D) ∏


Project Operation is denoted by ∏.

One thought on “Important MCQ of Database Concepts of Computer Science”

Leave a Reply

Your email address will not be published. Required fields are marked *