Information Management (LEC)

Which language is used to provide commands for defining relation schemes, deleting relations, and creating indices, among others?

• Data Query Language

• Data Manipulation Language

• Data Control Language

• Data Definition Language

Which language can be used to insert, delete, and update tuples in a relation?

• Structured Query Language

• Data Query Language

• Data Manipulation Language

• Interactive Data Manipulation Language

Which command is used to list the attributes needed to be included in the output of the query?

• FROM

• SELECT

• WHERE

• ORDER BY

Which keyword is used to include the names of the relations that are to be used in the query?

• FROM

• SELECT

• WHERE

• GROUP BY

Which clause in SQL consists of a predicate that involves the attributes of the relations described in the FROM clause?

• SELECT

• GROUP BY

• ORDER BY

• WHERE

Which term refers to a collection of letters, numbers, or facts that, by itself, derive little or no value?

• Knowledge

• Information

• Intelligence

• Data

Which term describes processed data that provides value and allows for feedback to fine-tune data collection methods?

• Data

• Knowledge

• Information

• Intelligence

Which component is used to store the database itself and the software applications used to create and maintain it?

• Software

• Hardware

• Data

• Network

Which component refers to the interface layer between users and the physical database?

• Network

• Software

• Hardware

• Data

Which term refers to the people whose jobs require access to the database system for querying, updating, and generating useful reports?

• Application Programmers

• Naive Users

• End user

• Sophisticated Users