Start learning →

IGNOU MCA Database Concepts — practice questions

Explore 30 free Database Concepts questions in IGNOU MCA Computer Science. Open each question or exercise to read its content, reference answers and available explanation.

Practise Database Concepts with Quill →

Database Concepts questions and exercises with answers

Showing questions 1–30 of 30.

Software used to create and manage databases is called a:Read the answer and worked solution →Rows of a table in a relational database are called:Read the answer and worked solution →Columns of a table in a relational database are called:Read the answer and worked solution →Duplicating the same data in different places is called:Read the answer and worked solution →The design of a database is called the database:Read the answer and worked solution →A request to a database for obtaining information is called a:Read the answer and worked solution →The most commonly used data model is the:Read the answer and worked solution →The number of attributes in a relation is called its:Read the answer and worked solution →The number of tuples in a relation is called its:Read the answer and worked solution →A set of values from which an attribute can take a value is its:Read the answer and worked solution →Data inconsistency occurs when the same data in different places:Read the answer and worked solution →The schema together with its constraints is stored by the DBMS as:Read the answer and worked solution →The state or snapshot of a database at a given time is called the database:Read the answer and worked solution →Constraints are used to ensure accuracy and what other quality of data?Read the answer and worked solution →The DBMS serves as an interface between the database and:Read the answer and worked solution →Attributes that could each uniquely identify tuples are called:Read the answer and worked solution →The candidate key chosen by the designer to identify tuples is the:Read the answer and worked solution →Candidate keys not chosen as the primary key are called:Read the answer and worked solution →A primary key made of more than one attribute is called a:Read the answer and worked solution →An attribute whose value is derived from the primary key of another relation is a:Read the answer and worked solution →Every data value associated with an attribute must be:Read the answer and worked solution →The relation in which a referenced primary key is defined is called the:Read the answer and worked solution →Match the database termRead the answer and worked solution →Sort the keysRead the answer and worked solution →Count the relationRead the answer and worked solution →True or false about databasesRead the answer and worked solution →One word is wrongRead the answer and worked solution →File system or databaseRead the answer and worked solution →Database concepts bingoRead the answer and worked solution →Pick the right database answerRead the answer and worked solution →

Worked practice questions

Software used to create and manage databases is called a:

  1. Database management system
  2. Database mapping schedule
  3. Database matching sequence
  4. Database masking standard
Show answer and solution

Correct answer: A. Database management system

1. A database is not managed by hand. 2. A dedicated piece of software does the creating and managing. 3. A database management system is software used to create and manage databases. 4. It is called a database system for short. _Source: syllabus Computer Science, Ch 8 'Database Concepts'_

Open this question →

Rows of a table in a relational database are called:

  1. Trumpets
  2. Tuples
  3. Turrets
  4. Tunnels
Show answer and solution

Correct answer: B. Tuples

1. A relational table has rows and columns. 2. Each has its own formal name in the relational model. 3. Rows and columns of a table are called tuples and attributes respectively. 4. So a row is a tuple. _Source: syllabus Computer Science, Ch 8 'Database Concepts'_

Open this question →

Columns of a table in a relational database are called:

  1. Attributes
  2. Aptitudes
  3. Altitudes
  4. Amplitudes
Show answer and solution

Correct answer: A. Attributes

1. The rows of a relation are called tuples. 2. The columns carry a different name. 3. Rows and columns of a table are called tuples and attributes respectively. 4. So a column is an attribute. _Source: syllabus Computer Science, Ch 8 'Database Concepts'_

Open this question →

How to practise

  1. Choose a Database Concepts question and try to work out your answer.
  2. Open the question to check the correct answer and read its worked solution.
  3. Continue in the app for bite-sized lessons, explanations and review with Quill. You can start without creating an account.

More Computer Science topics

Sorting and SearchingStacks and QueuesStructured Query Language