Class 12th computer quiz for Database

Quiz -1 for last topic related to database section of chapter 3

Your Name:

Question 1 of 20:

Candidate key is?

Possible primary key

Foreign key

Duplicate key

Index

Question 2 of 20:

Which improves data integrity?

Keys

Tables

Rows

Columns

Question 3 of 20:

Normalization reduces?

Redundancy

Security

Speed

Backup

Question 4 of 20:

Composite key example?

Roll+Course

Roll

Name

Question 5 of 20:

Super key is?

Set of attributes identifying row

Only one column

Duplicate key

Foreign key

Question 6 of 20:

Data consistency means?

Accurate and uniform data

Duplicate data

Random data

Old data

Question 7 of 20:

A table without primary key is?

Poor design

Perfect design

Optimized

Normalized

Question 8 of 20:

DBMS provides?

Data management

Hardware

Network

Compiler

Question 9 of 20:

Relation means?

Table

Row

Column

Index

Question 10 of 20:

A record is also called?

Tuple

Attribute

Key

Schema

Question 11 of 20:

Foreign key is used to?

Link tables

Delete data

Sort data

Encrypt data

Question 12 of 20:

Attribute domain means?

Allowed values

Table name

Key

Row

Question 13 of 20:

Which is example of attribute?

Name

Table

Row

Index

Question 14 of 20:

DBMS stands for?

Database Management System

Data Backup System

Database Machine System

Data Manage Software

Question 15 of 20:

Table consists of?

Rows and columns

Only rows

Only columns

Indexes

Question 16 of 20:

A row in table is?

Record

Attribute

Key

Schema

Question 17 of 20:

What is redundancy?

Duplicate data

Unique data

Encrypted data

Sorted data

Question 18 of 20:

Deletion anomaly causes?

Loss of data

Duplicate data

Fast query

Security

Question 19 of 20:

Normalization improves?

Consistency

Redundancy

Duplication

Errors

Question 20 of 20:

Database schema defines?

Structure

Data

Backup

Security