DBMS Language
Relationship
Primary key
Foreign Key
Table Name
100

To create the structure of the relations

DDL

100

What do you mean by one to many relationships?

  1. One teacher can have many classes
100

data (or information) occupying the memory space at multiple places.

Data Redundancy

100

attribute

Column

100

term "DFD" stands for

Data flow diagram

200

Ability to query information from the database and insert tuples into, delete tuples from, and modify tuples in the database

DML

200

term "FAT" is stands for

  1. File Allocation Table
200

What is the relation calculus?

  1. It is a non-procedural language
200

the number of attributes in a relation

Degree

200

Which one of the following refers to the total view of the database content?

Conceptual view

300

Which of the following refers collection of the information stored in a database at a specific time?

Instance of the database

300

For what purpose the DML is provided?

Manipulation & processing of the database

300

The term "ODBC" stands for_____

Open database connectivity

300

n the relation model, the relation are generally termed as ________

Tables

300

The Database Management Query language is generally designed for the _____

Support end-users who use English like commands

400

Which of the following keys is generally used to represents the relationships between the tables?

Foreign key

400

A computer security protocol for logging-in can be considered as the example of the ______ component of an information system.

  1. Procedure
400

The term "SQL" stands for

Structured query language

400

Which one of the following keyword is used to find out the number of values in a column?

  1. COUNT
400

Which one of the following commands is used to modify a column inside a table?

  1. Alter
500

A computer security protocol for logging-in can be considered as the example of the ______ component of an information system.

  1. Procedure
500

Which of the following levels is considered as the level closed to the end-users?

Which of the following levels is considered as the level closed to the end-users?

500

The architecture of a database can be viewed as the ________

  1. Three-level
500

The term "ODBC" stands for_____

  1. Open database connectivity
500

For what purpose the DML is provided?

  1. Manipulation & processing of the database