Database 3

Question 1

how are SQL and QBE connected?

Answer 1

they both are used to access and manipulate data in a database

Question 2

what is SQL?

Answer 2

Structured Query Language

used widely by programmers to interrogated databases efficiently

Question 3

what is QBE?

Answer 3

Query By Example

its a simple query language where users creates a query using a form

Question 4

retrieve data from databases?

Answer 4

SELECT

Question 5

update data in a table?

Answer 5

UPDATE

Question 6

insert data into a table?

Answer 6

INSERT

Question 7

delete data from a table?

Answer 7

DELETE

Question 8

advantages of QBE?

Answer 8

allows inexperienced users to make complex database features

it searches through database filtering data based on data content graphically- user doesn’t have to know SQL

it includes language necessary to perform the searches in order to achieve results quickly using built-in logical conditions

can be used to create and modify data

Question 9

disadvantages of QBE?

Answer 9

it depends on the technical skills of the user or the time to create the query