Set of flashcards Information Management

Flashcards	108
Students	25
Language	English
Category	Technology
Level	University
Created / Updated	08.06.2020 / 12.05.2025
Weblink	https://card2brain.ch/box/20200608_information_management
Embed	<iframe src="https://card2brain.ch/box/20200608_information_management/embed" width="780" height="150" scrolling="no" frameborder="0"></iframe>

The attributes that are to be displayed must be listed after the SQL query element "SELECT".

Combination

Projection

Selection

Combination

Projection

Selection

The term refers to the selection of certain rows (data records) as a subset of a table or stored query.

Combination

Projection

Selection

Combination

Projection

Selection

Which statements about SQL in general are correct?

Manufacturers of database systems strictly adhere to the pure SQL standard. There are no proprietary extensions.

SQL queries return the results in table form.

SQL is the most common language for database systems.

SQL has a relatively low instruction set.

Manufacturers of database systems strictly adhere to the pure SQL standard. There are no proprietary extensions.

SQL queries return the results in table form.

SQL is the most common language for database systems.

SQL has a relatively low instruction set.

Which statements about SQL commands are correct?

SELECT is the command for data queries.

Database tables can be created with INSERT INTO.

The age of a table can be queried with ALTER TABLE.

DROP TABLE deletes a data record from a table.

SELECT is the command for data queries.

Database tables can be created with INSERT INTO.

The age of a table can be queried with ALTER TABLE.

DROP TABLE deletes a data record from a table.

Which statements about the query concepts "projection" and "selection" are correct?

Projection and selection can be combined.

A projection always shows a subset of the existing data records in the result.

A projection is achieved by column selection (attribute selection).

A selection always results in a grouping of data records (functions).

Projection and selection can be combined.

A projection always shows a subset of the existing data records in the result.

A projection is achieved by column selection (attribute selection).

A selection always results in a grouping of data records (functions).

Which statements on the query concept "JOIN" are correct?

JOIN can be combined with restricting criteria (selection).

JOIN is a query concept that makes data denormalization.

JOIN is a query concept that cannot be combined with other concepts.

You can query data records from two or more tables with JOIN.

JOIN can be combined with restricting criteria (selection).

JOIN is a query concept that makes data denormalization.

JOIN is a query concept that cannot be combined with other concepts.

You can query data records from two or more tables with JOIN.

Which statements about grouping records in SQL queries are correct??

The grouping of data records is only possible with two attribute values.

The minimum value (minimum) and the maximum value (maximum) for attributes can be output via the grouping.

The grouping allows the calculation of statistical values such as "average" and "standard deviation".

The grouping function "Count " can only be applied to numbers.

The grouping of data records is only possible with two attribute values.

The minimum value (minimum) and the maximum value (maximum) for attributes can be output via the grouping.

The grouping allows the calculation of statistical values such as "average" and "standard deviation".

The grouping function "Count " can only be applied to numbers.

What does the abbreviation SQL stand for?

Simple Query Language

Simplified Question Language

Structured Query Language

Stored Question Language

Simple Query Language

Simplified Question Language

Structured Query Language

Stored Question Language

Which statements to the elements of the SQL command SELECT are correct?

The attributes to be output in the result are specified directly after SELECT.

JOIN specifies which conditions a data record must fulfill in order to be processed.

FROM specifies from which tables data records are queried.

DISTINCT always outputs multiple identical data records.

The attributes to be output in the result are specified directly after SELECT.

JOIN specifies which conditions a data record must fulfill in order to be processed.

FROM specifies from which tables data records are queried.

DISTINCT always outputs multiple identical data records.

Which statements about nested queries are correct?

A previously saved query can be specified as data source as a table (relation).

Queries cannot be connected (JOIN) like "normal" tables (relations) in a query.

A query can be used as a filter (criterion) in a query.

A query can be completely inserted after FROM in the query (in the SQL editor).

A previously saved query can be specified as data source as a table (relation).

Queries cannot be connected (JOIN) like "normal" tables (relations) in a query.

A query can be used as a filter (criterion) in a query.

A query can be completely inserted after FROM in the query (in the SQL editor).

Which statements about the challenges of digitalization for companies are correct?

In digitalization, a company focuses on potential customer benefits.

A company tries to take the customer's perspective during digitalization.

A company avoids competition with other companies during digitalization.

The company tries to create added value for the customer during digitalization.

Keyboard commands:

= turn,

= for-/backward,

= scroll

In digitalization, a company focuses on potential customer benefits.

A company tries to take the customer's perspective during digitalization.

A company avoids competition with other companies during digitalization.

The company tries to create added value for the customer during digitalization.

Which statements about Industry 4.0 are correct?

In the Industry 4.0 approach, the conversion is first implemented in individual "use cases".

Industry 4.0 is a combination of technologies, methods, models, data, services and processes.

Industry 4.0 is independent of the value chains of market services.

An important prerequisite for the implementation of industry 4.0 concepts are lean processes.

Keyboard commands:

= turn,

= for-/backward,

= scroll

In the Industry 4.0 approach, the conversion is first implemented in individual "use cases".

Industry 4.0 is a combination of technologies, methods, models, data, services and processes.

Industry 4.0 is independent of the value chains of market services.

An important prerequisite for the implementation of industry 4.0 concepts are lean processes.

Which statements regarding the definitions of information technology (IT) and information systems (IS) are correct?

IT deals with the presentation, storage, transmission and processing of information

IS deals first of all with the technical aspects of business IT.

IS deals with all activities around development, introduction, operation, use and replacement of information systems..

IT deals exclusively with the distribution of information within companies.

Keyboard commands:

= turn,

= for-/backward,

= scroll

IT deals with the presentation, storage, transmission and processing of information

IS deals first of all with the technical aspects of business IT.

IS deals with all activities around development, introduction, operation, use and replacement of information systems..

IT deals exclusively with the distribution of information within companies.

Which statements about Industry 4.0 are correct?

Industry 4.0 describes the third industrial revolution combining mechanization and electrification.

Industry 4.0 describes the approach of tapping new potentials from the networking of people, products, machines, systems and companies.

Industry 4.0 is to be understood as a concept.

Industry 4.0 is also a buzzword for the technology-driven upheaval of the information age.

Keyboard commands:

= turn,

= for-/backward,

= scroll

Industry 4.0 describes the third industrial revolution combining mechanization and electrification.

Industry 4.0 describes the approach of tapping new potentials from the networking of people, products, machines, systems and companies.

Industry 4.0 is to be understood as a concept.

Industry 4.0 is also a buzzword for the technology-driven upheaval of the information age.

Which statements about business information systems and information systems are correct?

Design-oriented business information systems always considers information systems to be unchangeable.

Information systems are socio-technical ("man-machine") systems.

One goal of business information systems is the design of socially acceptable, technically stable and economically sustainable information systems.

Business information systems can be understood as an "interdisciplinary field between business administration and computer science".

Keyboard commands:

= turn,

= for-/backward,

= scroll

Design-oriented business information systems always considers information systems to be unchangeable.

Information systems are socio-technical ("man-machine") systems.

One goal of business information systems is the design of socially acceptable, technically stable and economically sustainable information systems.

Business information systems can be understood as an "interdisciplinary field between business administration and computer science".

Which statements about Industry 4.0 are correct?

Industry 4.0 refers to digitalization and networking.

Industry 4.0 refers to the combination of different methods and digital technologies.

Industry 4.0 sees itself as a further development of industrial production

Industry 4.0 refers to a single, new analog technology.

Keyboard commands:

= turn,

= for-/backward,

= scroll

Industry 4.0 refers to digitalization and networking.

Industry 4.0 refers to the combination of different methods and digital technologies.

Industry 4.0 sees itself as a further development of industrial production

Industry 4.0 refers to a single, new analog technology.

Which of the following aspects belong to the requirements for a database management system?

No redundancy

Data independence

Single-user operation

Usability

Keyboard commands:

= turn,

= for-/backward,

= scroll

No redundancy

Data independence

Single-user operation

Usability

What tasks does a database management system have?

Make data available to all users, regardless of their authorization.

Restore a correct database state in case of errors.

Protect data from unauthorized access.

Precautions against possible errors due to incorrect input, system errors or multiple access.

Keyboard commands:

= turn,

= for-/backward,

= scroll

Make data available to all users, regardless of their authorization.

Restore a correct database state in case of errors.

Protect data from unauthorized access.

Precautions against possible errors due to incorrect input, system errors or multiple access.

Which statements regarding processing, access and storage of data with files are correct?

No continuous indexing is necessary for random or direct access.

The data do not have to be sorted in random or direct processing.

All data are stored next to each other for random or direct access.

The optional or direct storage is particularly suitable for master data.

Keyboard commands:

= turn,

= for-/backward,

= scroll

No continuous indexing is necessary for random or direct access.

The data do not have to be sorted in random or direct processing.

All data are stored next to each other for random or direct access.

The optional or direct storage is particularly suitable for master data.

A GUEST books different HOTEL ROOMS, a HOTEL ROOM is booked by different GUESTS.

n:m relationship

1:n relationship

1:1 relationship

Keyboard commands:

= turn,

= for-/backward,

= scroll

n:m relationship

1:n relationship

1:1 relationship

A FATHER can have several CHILDREN, a CHILD has only one biological FATHER.

1:1 relationship

1:n relationship

n:m relationship

1:1 relationship

1:n relationship

n:m relationship

A PERSON has a valid PASSPORT, a valid PASSPORT always belongs to a PERSON.

n:m relationship

1:1 relationship

1:n relationship

n:m relationship

1:1 relationship

1:n relationship

One BANK CLIENT has one personal CONSULTANT, one CONSULTANT supports several BANK CLIENTS.

1:n relationship

1:1 relationship

n:m relationship

1:n relationship

1:1 relationship

n:m relationship

What can be improved by good data organization in middle management (leading level)

Effectiveness (doing the right thing)

Efficiency (doing things right)

Strategy and planning

Effectiveness (doing the right thing)

Efficiency (doing things right)

Strategy and planning

What can be improved by good data organization in employees (operational level)

Effectiveness (doing the right thing)

Efficiency (doing things right)

Strategy and planning

Effectiveness (doing the right thing)

Efficiency (doing things right)

Strategy and planning

Information Management - Part 1/2

Create or copy sets of flashcards

Create or copy sets of flashcards

Log in to see all the cards.

SWITCHaai

Office 365

Edulog

Apple ID

Google