DBS - Final Exam

Specifies which columns are to appear in the output ...

• FROM

• WHERE

• SELECT

• GROUP

Ideally, a database language should allow a user to ...

(Jawaban lebih dari satu)

• Create the database and relation structures

• Perform basic data management tasks

• Perform simple queries

• Perform complex queries

In Aggregate Functions, to returns the number of values in specified column ...

• AVG

• COUNT

• MAX

• SUM

Specifies the table or tables to be used ...

• FROM

• WHERE

• SELECT

• GROUP

Apakah yang dimaksud dengan transform-oriented language?

• Designed to use relations to transform inputs into required outputs

• Defining the database structure and controlling access to the data

• Retrieving and updating data

• Specified what information required by user

In Aggregate Functions, to returns the sum of the values in specified column ...

• AVG

• COUNT

• MAX

• SUM

Specifies the order of the output ...

• FROM

• ORDER BY

• SELECT

• GROUP

Apakah yang dimaksud dengan Data Definition Language?

• Designed to use relations to transform inputs into required outputs

• Defining the database structure and controlling access to the data

• Retrieving and updating data

• Specified what information required by user

In Aggregate Functions, to returns the average of the values in specified column ...

• AVG

• COUNT

• MAX

• SUM

Filters the rows subject to some condition ...

• WHERE

• GROUP

• HAVING

• ORDER BY