SQL Commands

Question 1

When the DBMS goes to a storage device to retrieve the requested data, it follows a path to the _________ where data is stored.

Answer 1

Physical acces path (PAP)

Question 2

A visual approach to developing database queries or requests.

Answer 2

Query-By-Example (QBE)

Question 3

DQL

Answer 3

Data Query Language

-Select

Question 4

DML

Answer 4

Data Manipulation Language

-Insert, Update, Delete, Select

Question 5

DDL

Answer 5

Data Definition Language

-Create, Alter

Question 6

DCL

Answer 6

Data Control Language

-Grant, Revoke

Question 7

4 parts of SQL and its meaning its usage.

Answer 7

Structured Query Language

DQL: Select
DML: Inset, Update, Delete, Select
DDL: Create, Alter
DCL: Grant, Revoke

Question 8

It can produce reports and other outputs.

Answer 8

Database programs

Question 9

Each letter, special character is composed of 8 bits.

Answer 9

ASCII (American Standard Code for Information Interchange)

Question 10

• SQL/Flowchart

- ERD and flowchart

Answer 10

ANSI (American National Standard Institute)

Question 11

Commands that manipulate the data in a database.

Answer 11

Data Manipulation Language

Question 12

Delimeter which means ALL.

Answer 12

*

Question 13

• Used to create a record

Ex. INSERT into PERSONAL (ID, FirstName, LastName, Salary)

Answer 13

Insert

Question 14

-Used to remore rows from table

DELETE from PERSONAL where ID=1

Answer 14

Delete

Question 15

• Used to change certain records

- UPDATE PERSONAL set Lastname=’Santos’, Salary=35000 where Firstname=’Maria’

Answer 15

Update

Question 16

Directs or performs all activities to maintain a database environment.

Answer 16

Database administrator

Question 17

3 popular DBMSs for end users.

Answer 17

Microsoft Access and FileMaker Pro

Question 18

Example of open-source database systems

Answer 18

PostgreSQL - ORDBMS

MySQL - RDBMS

Question 19

Packages that are used for specific purposes or in specific industries.

Answer 19

Special-Purpose Database Systems

1. Hazmat
2. Israeli Holocausf
3. Tableau
4. Art and Antique organizer deluxe

Question 20

6 important characteristics of databases to consider.

Answer 20

1. No. Of users
2. Size
3. Cost
4. Ability to be integrated
5. Performance
6. Vendor consideration

Question 21

Use for collecting input/data entry

Answer 21

Front-end application

Question 22

Use for source codes/program codes

Answer 22

Back-end application

Question 23

Manipulate content of a database to produce useful information.

Answer 23

Database applications

Question 24

Development of seamless integration of traditional databases with the internet.

Answer 24

Semantic web

Question 25

W3C

Answer 25

World Wide Web Consortium

Question 26

It allowas people to access and manipulate a number of traditional databases at the same time through the internet.

Answer 26

Semantic Web

Question 27

The web is the universal medium of DATA, INFORMATION and KNOWLEDGE exchange.

Answer 27

Tim Berners-Lee

Question 28

A database that holds business information from many sources in the enterprise, covering all aspects of the company's products, processess and customers.

Answer 28

Data warehouse

Question 29

It is the collection of large amount of data or the central repository.

Answer 29

Data warehouse

Question 30

It is the place where data can be stored for more convenient mining.

Answer 30

Data warehouse

Question 31

- A subset of data warehouse | - smaller data warehouse

Answer 31

Data marts

Question 32

It is an information-analysis too, for discovering patterns and relationships in a data warehouse or data mart.

Answer 32

Data mining

Question 33

To extract data PATTERNS from DATA

Answer 33

Data mining

Question 34

Gathering the right information in a timely manner and usable form and analyzing it to have a positive impact on business.

Answer 34

Business intelligence

Question 35

- Aspect of business intelligence limited to information about competitors and the ways that knowledge affects strategy, tactics and operations. - The focus is on the external business environment.

Answer 35

Competitive intelligence

Question 36

- Steps an organization takes to protrct information sought by "hostile" intelligence gatherers. - Safeguarding secrets and keeping safe

Answer 36

Counterintelligence

Question 37

- Data may be spread across several smaller databases connected via telecommuncations devices - Data warehouses

Answer 37

Distributed databases

Question 38

Software that allows users to explore data from a number of different perspectives.

Answer 38

Online Analytical Processing (OLAP)

Question 39

-Stores both data and its processing instructions

Answer 39

Object-oriented database

Question 40

A procedure or action, has name and body,

Answer 40

Method

Question 41

A request to execute or run a method, invokes method.

Answer 41

Message

Question 42

Programs that manipulate an object-oriented database and provide a user-interface and connections to other application programs.

Answer 42

Object-oriented database management system (OODBMS)

Question 43

A DBMS capable of manipulating audio, video and graphical data.

Answer 43

Object-relational database management system (ORDBMS)

Question 44

Visual databases for storing images.

Answer 44

Visual database

Question 45

For storing sound

Answer 45

Audio databases

Question 46

Stores and access data according to the locations it describes and permits spatial queries and analysis.

Answer 46

Spatial data technology

Question 47

Allow different databases to work together as a unified database system.

Answer 47

Virtual database system

Question 48

4 next generation of database system

Answer 48

I - Internet D - Distributed database E - Expert system A - AI system

Question 49

Holds a duplicate set of frequently used data

Answer 49

Replicated database

Question 50

5 OLAPs applications

Answer 50

1. E-Commerce 2. Marketing 3. Budgeting 4. Forecasting 5. Financial Reporting

Question 51

An approach to swiftly answer multi-dimensional analytical queries.

Answer 51

OLAP

Question 52

Database + OOPL

Answer 52

OODBMS

Question 53

When an application requests data from the DBMS, the application follows a ___________.

Answer 53

Logical access path (LAP)