NEW
Font size
WorksheetsDatabase Concepts Class 12 Quiz
Total questions: 68
Worksheet time: 51mins
Data is a collection of ________ facts which have not been processed to reveal useful information.
Raw
None of the above
Facts
Processed
Which of the following properties belong to the database _______________.
A database is a representation of some aspect of the real world also called miniworld.
It is designed, built and populated with data for specific purposes.
It can be of any size and complexity.
All of the above
What are the benefits of databases ___________.
Lack of Data Integration
Data Inconsistency
All of the these
Data Redundancy
A ____________ is a collection of programs that enables users to rate, maintain and use a database.
None of the above
Database updation system
Database manageable system
Database management system
Which of the following is not a valid SQL type?
FLOAT
NUMERIC
DECIMAL
CHARACTER
Which of the following is not a DDL command?
TRUNCATE
UPDATE
ALTER
CREATE
What are the various operations that need to be performed on a database _____________.
Sharing the database
Manipulating the database
Defining the database
All of the above
What are the different characteristics of Database management systems?
Sharing of data
All of these
Insulation between programs and data
Self – describing Nature of a database system
A multiuser environment allows multiple users to access the database simultaneously; it means ___________.
Self-describing Nature of database system
Insulation between Program and data
None of these
Sharing of data
Any change in the structure of data would be done in the catalog and hence programs which access this data need not be modified. This property is called_____________.
Program-Data Independence
None of the above
Self describing
Sharing of data
What are the different types of DBMS users ____________.
All of these
Application programmers
Database Administrator
End users
Users who use the database for querying, modifying and generating reports as per their needs. They are not concerned about the working and designing of the database known as _________.
All of these
Application programmers
Database Administrator
End users
How many Primary keys can there be in a table?
Depends on DBA
Depends on number of Columns
Only 2
Only 1
Which of the following is not a Constraint in SQL?
Union
Primary Key
Not Null
Check
What operator tests column for absence of data?
Exists Operator
None of the above
IS NULL Operator
NOT Operator
__________ is responsible for authoring access, monitoring its use, providing technical support, acquiring software and hardware resources.
All of these
End users
Application programmers
Database Administrator
___________ write application program to interact with the database.
All of these
Application programmers
Database Administrator
End users
_________ determines the requirements of the end users and then develops specifications to meet these requirements.
End users
All of these
Database Administrator
System Analyst
__________ plays a major role in the database design and all the technical, economic and feasibility aspects.
End users
All of these
Database Administrator
System Analyst
Advantages of using DBMS approach.
All of these
Improved availability
Improved consistency
Reduction in Redundancy
Data in a DBMS is more concise because of the __________ of data.
None of these
Data is not Security
Central repository
Non availability of data
By making use of ___________, the DBA can provide security to the database.
All of these
Password
Database access rights
Controlling users
Limitation of using DBMS approach _________.
Both a) and b)
Security and recovery overheads
High cost
None of the above
__________ organize collection of data as a collection of relations where each relation corresponds to a table of values.
None of these
Data system
Database
Data method
A row is also called a ________.
None of the above
Both a) and b)
Field
Tuple
A column is also called ________.
Domain
Degree
Relation
Attribute
The data types of values in each column are called __________.
Degree
Domain
Attribute
Relation
The number of attributes in a relation is called the _________ of a relation.
Attribute
Relation
Domain
Degree
The number of rows in a relation is called the _________ of a relation.
Relation
Cardinality
Domain
Degree
Some of the examples of databases are ___________.
IBM DB2
Oracle
MySQL
All of the above
__________ are restrictions on the values, stored in a database based on the requirements.
None of these
Properties
Constraints
Method
What are examples of constraints in relational models?
Entity Integrity constraint
All of these
Key constraint
Domain constraint
What are the examples of key constraints?
Super key
All of these
Candidate key
Primary key
__________ is a set of attributes in a relation, for which no two tuples in a relation state have the same combination of values.
Super key
Candidate key
Primary key
All of the above
_________ key helps to protect duplication in the table.
All of these
Primary key
Candidate key
Super key
____________ is a language that is used to manage data stored in a RDBMS.
DDL
DML
SQL
None of the above
SQL Stands for __________.
Structured Query Language
System Query Language
None of the above
Social Query Language
DDL Stands for ___________.
Data Definition Language
None of the above
Domain Definition Language
Data Database Language
DML Stands for ___________.
Data Manipulation Language
None of the above
Data Manageable Language
Domain Manipulation Language
Database system needs to be installed on the Computer and this computer is known as ___________.
Database Server
Database storage
Database memory
None of the above
_________ command is used to create a new table in the database.
Select command
Alter command
Create command
Modify command
Which datatype belongs to numerical type?
Decimal
All of these
Number
Integer
What data type has a fixed length in the database?
None of these
Longvarchar(n)
Char(n)
Varchar(n)
Which syntax is correct for creating a table _________.
Create ( );
Create table
