Database Quiz Set 1

A database is an organized collection of _________.

• Data

• Attributes

• Records

• None of the above

__________ store data in Single table.

• Flat file

• Relational file

• Single file

• One file

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 will help to maintain unique record in the table?

• Foreign Key

• Primary Key

• Composite Key

• Alternate Key

A key which is referring to the primary key of another table is called _______

• Alternate Key

• Primary Key

• First Primary Key

• Foreign Key

When data is stored, maintained and retrieved from multiple tables then special database software are required called ______

• DBMS

• RDBMS

• Special DBMS

• All of the above

___________ represent a single data item in a table.

• Tuples

• Attributes

• Relation

• All of the above

Which data type will be appropriate to store information as Salary, Fees, Price etc.

• Alphanumeric Data types

• Numeric Data type

• Binary Data types

• Date Time

Char is a _____ length data type and varchar is a _____ length data type.

• Fixed, Variable

• Variable, Fixed

• Variable, Variable

• Fixed, Fixed

Relationship can be created between

• two tables only

• one table only

• Two or More tables

• none of the above