Download App

COMPUTER APPLICATIONS M.C.Q [1M]

Database Concepts · CBSE STD 10 (CBSE - English Medium). 17 questions.

Questions

M.C.Q [1M]

🎯

Test yourself on this topic

17 questions · timed · auto-graded

MCQ 11 Mark
Which of the following best describes a form?
  • ✓
    Form enables people to enter or view data in a database easily
  • B
    Form summarises and prints data
  • C
    A form filters data from a database based on a criteria
  • D
    All of the above
Answer
Correct option: A.
Form enables people to enter or view data in a database easily
(a) Form enables people to enter or view data in a database easily.
View full question & answer→
MCQ 21 Mark
Duplication of data is known as
  • A
    data security
  • B
    data incomplete
  • ✓
    data redundancy
  • D
    None of these
Answer
Correct option: C.
data redundancy
(c) Data redundancy means duplication of data. It eliminates replication of data item into different files from a large database.
View full question & answer→
MCQ 31 Mark
Which of the following is not an example of database?
  • A
    Cross knot game
  • B
    Employee payroll management
  • ✓
    Numeric calculator
  • D
    Customer management system
Answer
Correct option: C.
Numeric calculator
(c) Numeric calculator because it is used to calculate the numeric numbers only as it is unable to store data.
View full question & answer→
MCQ 41 Mark
Which of the following fields will not make a suitable primary key?
  • A
    A customer’s account number
  • ✓
    A date field
  • C
    An auto number field
  • D
    A student’s admission number
Answer
Correct option: B.
A date field
(b) From the given options, data field can not be set as a primary key because it can’t be fixed for an object.
View full question & answer→
MCQ 51 Mark
Out of the following, which one is the most appropriate data field in context of employee table, if only one of these is required?
  • A
    Age in years
  • ✓
    Date of birth
  • C
    Age in days
  • D
    Age in months
Answer
Correct option: B.
Date of birth
(b) Date of birth is the most appropriate data field in context of employee table.
View full question & answer→
MCQ 61 Mark
Database is a combination of
  • ✓
    hardware and software
  • B
    hardware and operating system
  • C
    software and operating system
  • D
    utility programs
Answer
Correct option: A.
hardware and software
(a) A database consists of several components. These are data, software, hardware and user.
View full question & answer→
MCQ 71 Mark
Key field is a unique identifier for each record. It is defined in the form of
  • A
    rows
  • ✓
    columns
  • C
    tree
  • D
    query
Answer
Correct option: B.
columns
(b) Key is a data item that allows you to uniquely identify individual occurrences which is defined as the column or set of columns.
View full question & answer→
MCQ 81 Mark
A database that contains tables linked by common fields is called a
  • A
    Centralised database
  • B
    Flat file database
  • ✓
    Relational database
  • D
    None of these
Answer
Correct option: C.
Relational database
(c) Relational database stores data in the form of tables which are linked by common fields.
View full question & answer→
MCQ 91 Mark
RDBMS provides relational operators to manipulate the data. Here, RDBMS refers to
  • A
    Record Database Management System
  • ✓
    Relational Database Management System
  • C
    Reference Database Management System
  • D
    None of the above
Answer
Correct option: B.
Relational Database Management System
(b) RDBMS stands for Relational Database Management System, which provides operator to manipulate the data stored into the database table.
View full question & answer→
MCQ 101 Mark
Computer based record keeping system is known as
  • A
    Data Manipulation System
  • B
    Computerised Data System
  • C
    Computerised Record keeping system
  • ✓
    DBMS
Answer
Correct option: D.
DBMS
(d) DBMS is a collection of programs that enable user to create and maintain database. Also, it is a computer based record keeping system.
View full question & answer→
MCQ 111 Mark
DBMS is a program that controls the creation, maintenance and use of database. Here, DBMS referred to
  • A
    Digital Base Management System
  • B
    Data Build Management System
  • ✓
    DataBase Management System
  • D
    DataBase Management Service
Answer
Correct option: C.
DataBase Management System
(c) Here, DBMS stands for Database Management System.
View full question & answer→
MCQ 121 Mark
Which of the following is not the main building block of a database?
  • ✓
    Lists
  • B
    Queries
  • C
    Reports
  • D
    Forms
Answer
Correct option: A.
Lists
(a) The main building blocks of database are tables, queries, forms and reports.
View full question & answer→
MCQ 131 Mark
All the information about a thing or a person is known as a
  • A
    database
  • B
    file
  • C
    field
  • ✓
    record
Answer
Correct option: D.
record
(d) A record refers to a raw of data, which represents a complete set of information in a table.
View full question & answer→
MCQ 141 Mark
Data is stored in RDBMS in the form of
  • ✓
    table
  • B
    query
  • C
    report
  • D
    record
Answer
Correct option: A.
table
(a) Relational Database Management System stores data in the form of relation. As we know, relations are known as table.
View full question & answer→
MCQ 151 Mark
Database is made up of all the following components except
  • A
    tables
  • B
    queries
  • C
    forms
  • ✓
    formula bar
Answer
Correct option: D.
formula bar
(d) Database is made up of tables, queries and forms.
View full question & answer→
MCQ 161 Mark
Operations performed on a database are controlled by
  • ✓
    user
  • B
    hardware
  • C
    DBMS
  • D
    RDBMS
Answer
Correct option: A.
user
(a) Users are those persons, who need the information from the database to perform operations.
View full question & answer→
MCQ 171 Mark
Facilities offered by databases are
  • ✓
    The ability to store a large amount of data in a structured format, easy update, sort query, production of reports.
  • B
    Easy editing, spell check, perform calculations, library of mathematical functions, replication.
  • C
    The ability to rotate images, copy and paste, fill scale.
  • D
    None of the above
Answer
Correct option: A.
The ability to store a large amount of data in a structured format, easy update, sort query, production of reports.
(a) Databases have ability to store a large amount of data in structured format, easy update, sort query, production of reports.
View full question & answer→
Generate Paper FreeAll Database Concepts topics
M.C.Q [1M] - COMPUTER APPLICATIONS STD 10 Questions - Vidyadip