NEW
Font size
WorksheetsMultiple Choice Questions
Total questions: 54
Worksheet time: 27mins
A ________ is an organized collection of data.
Database
Digital Document
Spreadsheet
None of these
A database is an integrated collection of ________.
Data records
Files
Objects
All of these
A DBMS enables several user application programs to access the ____ database.
Other Database
Same Database
Both a & b
None of these
________ are dedicated computers that hold the actual databases and run only the DBMS and related software.
Database Server
Decided Server
Web Server
None of these
What is/are the advantage(s) of database?
Reduces Data Redundancy
Sharing of Data
Data Integrity
All of these
When the same piece of data is stored in two or more locations, it is called __.
Data Redundancy
Data Integrity
Data Consistency
Data Accuracy
________ prevents creating multiple copies in the database.
Data Redundancy
Data Integrity
Data Consistency
None of these
means that the data is accurate and consistent in the database.
Data Redundancy
Data Integrity
Data Consistency
None of these
Only authorized users should be allowed to access the database and their identity should be authenticated using a username and password known as ___.
Data Redundancy
Data Consistency
Data Security
Data Integrity
Database Management System automatically takes care of ____________.
Data Redundancy
Backup and Recovery
Data Security
None of these
prevent multiple mismatching copies of the same data in the database and only valid data will be added in the database.
Data Redundancy
Backup and Recovery
Data Consistency
None of these
in a table represents a set of information with the same Structure in every row
Tuples
Record
Both a & b
None of these
A is the actual text, number or date that you enter when adding data to your database.
Values
Table
Boolean
None of these
The unique field present in the table is called ________.
Primary Key
Candidate Key
Foreign Key
None of these
When the primary key is applied on multiple columns is known as __________.
Primary Key
Candidate key
Foreign Key
Composite Primary Key
key can store multiple same records in the table.
Primary Key
Candidate Key
Foreign Key
None of these
Which of the following is NOT true about the primary key?
A primary key uniquely identifies records
A table can have only one primary key
A primary key field can be NULL
Value in the primary key field is different for every tuple.
Which of the following is not an example of DBMS?
PostgreSQL
SQLite
FoxPro
Impress
Data can be organized into ________.
Flat File
Relational
Both a & b
None of these
Data stored in a single table is known as ________.
Flat File
Relational
Both a & b
None of these
Data is stored in multiple tables, which are connected together via a common field.
Flat File
Relational
Both a & b
None of these
Which of the following data models sets a relation between the two or more tables?
Relational Data Model
Network Data Model
Hierarchical Data Model
Connection Data Model
The details associated with an entity are called ________.
Table
Attributes
Records
Primary key
A ________ is represented as rows in a table.
Field
Attribute
Record
Candidate key
Which of the following cannot be considered as an example of a database?
Dictionary
Newspaper
Marks Register
Telephone directory
A database is an organized collection of ________.
Data
Attributes
Record
None of these
Which of the following software is appropriate to store data about school students?
MS Access
Writer
Calc
Impress
Duplication of data is called ________.
Inconsistency
Consistency
Redundancy
Foreign Key
Which of the following is not the advantage of database?
Sharing of Data
Reduce Data Redundancy
Increase Data Inconsistency
Data Security
Which of the following field of table "Book" can act as primary key?
Book_number
Subject
Price
Author_name
A key which is referring to the primary key of another table is called ________.
Alternate Key
Primary Key
First Primary Key
Foreign Key
A foreign key is a reference of the ______ key in another table.
Alternate
Primary
Candidate
None of these
The users of the database can share the data among themselves. There are various levels of authorisation to access the data, and consequently the data can only be shared based with the authorized users. In this, we are discussing about the ____.
Advantage of Database
Disadvantage of Database
Database Servers
Structure of Database
In which of the following forms can a data value be represented?
Numeric
Character
Alphanumeric
All of the above
Data Security is an important concept in a database. It says ___________.
Only authorised users should be allowed to access the database.
Users identity should be authenticated using a username and password.
Both of the above.
Unauthorised users should be allowed to access the database under any circumstances.
__________ means that the data is accurate and consistent in the database.
Data Redundancy
Data Security
Data Integrity
Data Privacy
A _______ is a feature of a database using which we can enter data in a table in an easy and user friendly manner.
Query
Report
Form
Field
A _________ is an organized collection of data.
File
Database
Algorithm
Spreadsheet
A ____ is a software package that can be used for creating and managing databases.
Operating System
Database Management System (DBMS)
Spreadsheet
Web Browser
A ______ is a database management system that is based on the relational model.
Relational Database Management System (RDBMS)
Hierarchical DBMS
NoSQL engine
File manager
Three popular DBMS software are ________, _________, & ________.
MySQL, Oracle, Microsoft Access
Excel, Notepad, Paint
HTTP, HTML, CSS
Ubuntu, Android, iOS
A ________ is a unique value that identifies a row in a table.
Foreign key
Primary key
Composite key
Candidate key
Composite Key is a combination of ______ columns.
two or more
exactly two
three only
single
The raw facts constitutes ____________.
Information
Data
Knowledge
Metadata
An ___ is a real world object about which information is to be stored in a database.
entity
attribute
tuple
schema
The data values for all the fields related to a person or object is called a _______.
table
field
record
key
All the field values that are eligible to be the primary key are the ______ keys for that table.
alternate
candidate
foreign
composite
State whether the following statement is true or false: A database cannot be organised.
True
False
State whether the following statement is true or false: Data is the collection of raw facts.
True
False
State whether the following statement is true or false: A table can be created without a primary key.
True
False
State whether the following statement is true or false: Two tables can be related in a network data model.
True
False
State whether the following statement is true or false: MS Access is an example of a database.
True
False
State whether the following statement is true or false: Data Integrity means that data is accurate and consistent in the database.
True
False
State whether the following statement is true or false: Base automatically adds the column as primary key if we don’t add.
True
False
