U-3 RDBMS / Class-10th IT 402 / Test-2 Ans

 

Class- 10^th

Subject : Information Technology (402)

Book : Domestic Data Entry Operator

UNIT-3 RELATIONAL DATABASE MANAGEMENT SYSTEMS (BASIC)

Revision Test -2

Answer

1) This unique field is called the Primary Key .It  is a unique value that identifies a row in a table.

2) When primary key constraint is applied on one or more columns then it is known as Composite Primary Key.

3)  A foreign key  is a column or group of columns in a relational database table that provides a link between data in two tables.

4)  A database  is an organized collection of data.

5)  A Ms- Access , My SQL  is a software package that can be used for creating and managing databases.

6) A Ms- Access / My SQL  is a database management system that is based on the relational model.

7) Three popular DBMS software are Oracle ,  Ms-Access  & My SQL .

8) Field properties can be set in both the design view  and datasheet view  .

9)  Composite Key is a combination of one or more  columns.

10) A table is a set of data elements (values) that is organized using a model of vertical columns(which are identified by their name) and horizontal rows

11) A table is a set of data elements that is organized using a model of vertical  column  and horizontal rows .

12)  A column / field / attribute  is a set of data values of a particular type, one for each row of the table.

13)  A row / record / tuple  represents a single, data item in a table.

14)  Data types   are used to identify which type of data we are going to store in the database.

15)  There are two  ways to create a table.