Brainscape's Knowledge GenomeTM

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


See full index

ITEC > Databases > Flashcards

Databases Flashcards

1
Q

Which data type is used to represent product order code that composes alphanumeric characters?

A

String

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q
  • What database is sorted by using an assigned name and number?
A

Character string

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

Why is it important to ensure that data support business goals

A

To aid in making strategic decisions

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

In which category of the Data, Information, Knowledge, Wisdom (DIKW) hierarchy would business intelligence be located?

A

Knowledge

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

Which field must contain a unique value in order for a relational database table to function?

A

Primary Key

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

What are the three main categories of databases?

A

Flat file, relational, hierarchal

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

What is the database administrator’s role in security?

A

To institute protocols to protect the databases from external threats

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

What is the role of drivers in facilitating communication between applications and databases?

A

They allow the application to interact with the database.

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

Which SQL clause is used to inform the database management system (DBMS) which tables should be interrogated by the query?

A

HERE

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

What indicates a specific Internet location?

A

The IP address

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

Which part of a Uniform Resource Locator (URL) identifies the location of the document on the server?

A

Resource path ID

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

Which part of a Uniform Resource Locator (URL) identifies the location of the document on the server?

A

Resource path ID

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

Which transmission medium should be used when sending data transmissions from Singapore to Mexico City?

A

Radio signals

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

What statement is true concerning compiled and interpreted computer language?

A

A compiler translates an entire program into executable program, which can be run at a later time, while the interpreter does this incrementally.

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

Which language is often used for rapid prototyping and the creation of GUIs?

A

Python

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

Which language is often used for rapid prototyping and the creation of GUIs?

A

Python

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

Which is true of databases and the applications that interact with them?

A

Which is true of databases and the applications that interact with them?

18
Q

Which is a characteristic of high-level languages?

A

The source code has to be compiled.

19
Q

How does an interpreter work?

A

It takes the most recently entered instructions, converts it into machine language, and executes it.

20
Q

Which risk assessment question is part of the Initiation Phase?

A

Could the end users reject the outcome of the project?

21
Q

Which risk assessment question is part of the Initiation Phase?

A

Could the end users reject the outcome of the project?

22
Q

What effect does scope creep have on a project?

A

It increases unplanned costs for the project.

23
Q

What effect does scope creep have on a project?

A

It increases unplanned costs for the project.

24
Q

ng user needs in the design of an information system?

A
25
Q

Which system requirement is an example of considering user needs in the design of an information system?

A

Allowing secure access to customer account information

26
Q

Which type of systems testing includes having the customer test the system in an operational setting to see if it is useful?

A

User Acceptance

27
Q

Which type of systems conversion involves starting the conversion with a portion of end users?

A

Pilot

28
Q

Which type of systems conversion involves starting the conversion with a portion of end users?

A

Pilot

29
Q

What are two necessary elements of business continuity planning?

A

Assessing key organizational activities

Identifying risks that may occur

30
Q

What is a role of the systems administrator?

A

To install and maintain network resources

31
Q

What is a role of the systems administrator?

A

To install and maintain network resources

32
Q

What are two necessary elements of business continuity planning?

A

Assessing key organizational activities

Identifying risks that may occur

32
Q

Which is a characteristic of high-level languages?

A

The source code has to be compiled.

32
Q
A
32
Q
A
32
Q
A
32
Q
A
33
Q

Which regulation governs the actions of a company in the case of data records being compromised, lost, or stolen?

A

Security Breach Notification laws

34
Q

Which transmission medium should be used when sending data transmissions from Singapore to Mexico City?

A

Radio signals

34
Q

Which is true of databases and the applications that interact with them?

A

Which is true of databases and the applications that interact with them?

34
Q

What effect does scope creep have on a project?

A

It increases unplanned costs for the project.

ITEC (5 decks)

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