Study resources on Kenyaplex

Get ready-made curriculum aligned revision materials

Exam papers, notes, holiday assignments and topical questions – all aligned to the Kenyan curriculum.

Or go directly to:

Class notes Holiday assignments Topical questions Other resources

What are the two major components of SQL and what function do they serve?

Answers

A data definition language (DDL) for defining the database structure.
A data manipulation language (DML) for retrieving and updating data.

kevowmuchiri answered the question on July 4, 2018 at 15:37

Answer Attachments

Next: Define the two principal integrity rules for the relational model. Discuss why it is desirable to enforce these rules.

Previous: Explain the function of each of the clauses in the SELECT statement. What restrictions are imposed on these clauses? a)FROM b) WHERE c)GROUP BY d)HAVING e)SELECT

View more Computer Science Questions and Answers | Return to Questions Index

Exams With Marking Schemes

Related Questions

Define the two principal integrity rules for the relational model. Discuss why it is desirable to enforce these rules. (Solved)

Define the two principal integrity rules for the relational model. Discuss why it is desirable to enforce these rules.

Date posted: July 4, 2018 . Answers (1)
Discuss the differences between the candidate keys and the primary key of a table. Explain what is meant by a foreign key. How do foreign... (Solved)

Discuss the differences between the candidate keys and the primary key of a table. Explain what is meant by a foreign key. How do foreign keys of tables relate to candidate keys? Give examples to illustrate your answer.

Date posted: July 4, 2018 . Answers (1)
Discuss the properties of a relational table. (Solved)

Discuss the properties of a relational table.

Date posted: July 4, 2018 . Answers (1)
Discuss the advantages and disadvantages of DBMSs. (Solved)

Discuss the advantages and disadvantages of DBMSs.

Date posted: July 4, 2018 . Answers (1)
Describe the functions that should be provided by a modern full-scale multi-user DBMS. (Solved)

Describe the functions that should be provided by a modern full-scale multi-user DBMS.

Date posted: July 4, 2018 . Answers (1)
Describe the problems with the traditional two-tier client-server architecture and discuss how these problems were overcome with the three-tier client-server architecture. (Solved)

Describe the problems with the traditional two-tier client-server architecture and discuss how these problems were overcome with the three-tier client-server architecture.

Date posted: July 4, 2018 . Answers (1)
Describe the five components of the DBMS environment and discuss how they relate to each other (Solved)

Describe the five components of the DBMS environment and discuss how they relate to each other

Date posted: July 4, 2018 . Answers (1)
Describe the main characteristics of the database approach. (Solved)

Describe the main characteristics of the database approach.

Date posted: July 4, 2018 . Answers (1)
Discuss the meaning of each of the following terms: (a) Data (b) database (c) database management system (d) application program (e) data independence (Solved)

Discuss the meaning of each of the following terms:
(a) Data
(b) database
(c) database management system
(d) application program
(e) data independence

Date posted: July 4, 2018 . Answers (1)
Outline four types of memory as used in data structures (Solved)

Outline four types of memory as used in data structures.

Date posted: July 3, 2018 . Answers (1)
Define Data structures (Solved)

Define Data structures.

Date posted: July 3, 2018 . Answers (1)
Explain the difference between nominal and real gross domestic product (GDP). (Solved)

Explain the difference between nominal and real gross domestic product (GDP).

Date posted: July 3, 2018 . Answers (1)
Explain how an interactive DVD can be used to train users of an information system (Solved)

Explain how an interactive DVD can be used to train users of an information system

Date posted: July 3, 2018 . Answers (1)
An interactive DVD can be used to provide training. Describe how data is written onto a DVD. (Solved)

An interactive DVD can be used to provide training. Describe how data is written onto a DVD.

Date posted: July 3, 2018 . Answers (1)
Explain how auditing software is used on a computer network (Solved)

Explain how auditing software is used on a computer network

Date posted: July 3, 2018 . Answers (1)
Describe the role of the programmer during software development. (Solved)

Describe the role of the programmer during software development.

Date posted: July 3, 2018 . Answers (1)
Explain the main difference between evolutionary prototyping and throw-away prototyping. (Solved)

Explain the main difference between evolutionary prototyping and throw-away prototyping.

Date posted: July 3, 2018 . Answers (1)
Describe how real-time processing could be used to process orders on the website. (Solved)

Describe how real-time processing could be used to process orders on the website.

Date posted: July 3, 2018 . Answers (1)
The libraries use a database management system (DBMS). Identify four responsibilities of the database administrator (Solved)

The libraries use a database management system (DBMS). Identify four responsibilities of the database administrator

Date posted: July 3, 2018 . Answers (1)
Describe the main contents of a typical acceptable use policy relating to ICT. (Solved)

Describe the main contents of a typical acceptable use policy relating to ICT.

Date posted: July 3, 2018 . Answers (1)