DBMS

Question 1

What are the the functions of DBMS?

Answer 1

• data storage, retrieval and update
• Concurrency control services
• recovery services
• provides a user accessible catalog

Question 2

what is SQL ?

Answer 2

Structured query language -is a transform oriented language with 2 major components.

• DDL - a language used to define the data in a database structure
• DML - a set of operations that modify data in a database

Question 3

importance of SQL

Answer 3

SQL is used in other standards and even influences development of other standards as a definitional tool. Examples include:

• ISO’s Information Resource Directory System (IRDS) Standard
• Remote Data Access (RDA) Standard

Question 4

SELECT CLAUSE _____

Answer 4

Specifies which columns are to appear in output

Question 5

DISTINCT clause ____

Answer 5

is used to eliminate duplicates

Question 6

What clause is used to name a column

Answer 6

AS clause

Question 7

Pools of values from which actual values appearing in columns of a table are drawn are known as

Answer 7

Domains

Question 8

the process of exploiting the inherent data structures of a data model is referred to as

Answer 8

Data Definition

Question 9

How we input, remove, amend and retrieve in a relation is a process referred to as

Answer 9

Data Manipulation

Question 10

the overall accuracy, completeness, and consistency of data is referred to as

Answer 10

Data integrity