Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

CompLec > SQL Commands > Flashcards

SQL Commands Flashcards

1
Q

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

A

Physical acces path (PAP)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

A visual approach to developing database queries or requests.

A

Query-By-Example (QBE)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

DQL

A

Data Query Language

-Select

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

DML

A

Data Manipulation Language

-Insert, Update, Delete, Select

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

DDL

A

Data Definition Language

-Create, Alter

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

DCL

A

Data Control Language

-Grant, Revoke

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

4 parts of SQL and its meaning its usage.

A

Structured Query Language

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

It can produce reports and other outputs.

A

Database programs

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Each letter, special character is composed of 8 bits.

A

ASCII (American Standard Code for Information Interchange)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q
  • SQL/Flowchart

- ERD and flowchart

A

ANSI (American National Standard Institute)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Commands that manipulate the data in a database.

A

Data Manipulation Language

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Delimeter which means ALL.

A

*

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q
  • Used to create a record

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

A

Insert

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

-Used to remore rows from table

DELETE from PERSONAL where ID=1

A

Delete

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q
  • Used to change certain records

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

A

Update

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Directs or performs all activities to maintain a database environment.

A

Database administrator

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

3 popular DBMSs for end users.

A

Microsoft Access and FileMaker Pro

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

Example of open-source database systems

A

PostgreSQL - ORDBMS

MySQL - RDBMS

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

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

A

Special-Purpose Database Systems

  1. Hazmat
  2. Israeli Holocausf
  3. Tableau
  4. Art and Antique organizer deluxe
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

6 important characteristics of databases to consider.

A
  1. No. Of users
  2. Size
  3. Cost
  4. Ability to be integrated
  5. Performance
  6. Vendor consideration
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

Use for collecting input/data entry

A

Front-end application

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

Use for source codes/program codes

A

Back-end application

23
Q

Manipulate content of a database to produce useful information.

A

Database applications

24
Q

Development of seamless integration of traditional databases with the internet.

A

Semantic web

25
Q

W3C

A

World Wide Web Consortium

26
Q

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

A

Semantic Web

27
Q

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

A

Tim Berners-Lee

28
Q

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

A

Data warehouse

29
Q

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

A

Data warehouse

30
Q

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

A

Data warehouse

31
Q
  • A subset of data warehouse

- smaller data warehouse

A

Data marts

32
Q

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

A

Data mining

33
Q

To extract data PATTERNS from DATA

A

Data mining

34
Q

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

A

Business intelligence

35
Q
  • 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.
A

Competitive intelligence

36
Q
  • Steps an organization takes to protrct information sought by “hostile” intelligence gatherers.
  • Safeguarding secrets and keeping safe
A

Counterintelligence

37
Q
  • Data may be spread across several smaller databases connected via telecommuncations devices
  • Data warehouses
A

Distributed databases

38
Q

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

A

Online Analytical Processing (OLAP)

39
Q

-Stores both data and its processing instructions

A

Object-oriented database

40
Q

A procedure or action, has name and body,

A

Method

41
Q

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

A

Message

42
Q

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

A

Object-oriented database management system (OODBMS)

43
Q

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

A

Object-relational database management system (ORDBMS)

44
Q

Visual databases for storing images.

A

Visual database

45
Q

For storing sound

A

Audio databases

46
Q

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

A

Spatial data technology

47
Q

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

A

Virtual database system

48
Q

4 next generation of database system

A

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

49
Q

Holds a duplicate set of frequently used data

A

Replicated database

50
Q

5 OLAPs applications

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

An approach to swiftly answer multi-dimensional analytical queries.

A

OLAP

52
Q

Database + OOPL

A

OODBMS

53
Q

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

A

Logical access path (LAP)

CompLec (2 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions