Querying from Databases Flashcards

1
Q

This process of accessing data is known as

A

Data retrieval

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

When choosing a system for data retrieval, the following factors are of importance

A

Performance
Capacity
Data Security
Cost

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

should be measured by the time it takes for data to be retrieved and the number of requests that can be processed at one time.

A

Performance

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

refers to not just the number of files that can be stored, but also how large each file can be.

A

Capacity

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

Protecting the information from people who are not authorized to view it is a function of data security.

A

Data Security

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

There are three areas of concern involving cost

A

support personnel
software
and hardware

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

developed by the mathematician George Boolein the 1800s, is used to search databases and is recognized by most search engines, such as Google. Search is conducted for keywords connected by the operators AND, OR, and NOT.

A

Boolean Logic

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

Boolean searching is often used with

A

Truncations and wildcards

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

The most common use of structured query language(SQL) is

A

to obtain and display information from databases.

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

Used with a number of optional keywords and extensions to access table data.

A

SELECT

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

shortcut to indicate all columns, such as SELECT*FROM customers

A

Asterisk (*)

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

used to list and separate specific columns, such as SELECT PatientID, LastName, FirstName, FROM County

A

Comma (,)

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

limits the number of rows, such as SELECT PatientID, LastName, FirstNAME, From County = ‘Monterey’

A

WHERE

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

eliminates, such as FROM County <> ‘Monterey’

A

NOT or <>

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

limits, such as WHERE Service Date BETWEEN “1-july-2011’ AND ‘1-September-2011’

A

BETWEEN

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

limits, such as WHERE City NOT IN (‘Salinas’, ‘King City’)

A

NOT IN

17
Q

allows wild card characters _, %, [], [^]

A

LIKE

18
Q

dictates arrangement, such as SELECT PatientID, LastName, FirstName FROM County, ORDER BY County

A

ORDER BY

19
Q

is an integrated group of software applications used to report, analyze, and access data

A

Statistical Analysis System (SAS)

20
Q

The three primary steps of an SAS program include the following:

A

Data
Procedures
Metaprogramming Language