Information Management - Part 1/2

Information Management, FHNW 2020 Digitalization, Database Management, Technical Foundations

108

0.0 (0)

Marco Kofel

Set of flashcards Details

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>

Card list

Study

Logging to the nearest cellphone tower with the mobile phone after switching it on

Automatic direct input

Manual direct input

Acoustic direct input

Input of data via keyboard

Automatic direct input

Manual direct input

Acoustic direct input

Click with the mouse on a program icon to start it.

Automatic direct input

Manual direct input

Acoustic direct input

Dictation of a text via microphone

Acoustic direct input

Automatic direct input

Manual direct input

Receiving satellite signals and calculation of the position by a GPS sensor

Automatic direct input

Manual direct input

Acoustic direct input

Which statements about "Cloud Computing" are correct?

Software as a Service (SaaS) services are intended exclusively for private end-users.

Platform as a Service (PaaS) focuses on the provision of PC workstations in the leasing process.

Software as a Service (SaaS) is the provision of applications (e.g. business, collaboration and communication tools) as a service.

Platform as a Service (PaaS) mainly provides interactive gaming environments.

Which statements about "private cloud" are correct?

The administration of the cloud infrastructure is mostly done by the own organization.

The cloud infrastructure is operated exclusively for one organization.

The management of the cloud infrastructure can be transferred to a third party.

The cloud infrastructure is always managed on site.

Computing power and available memory can be allocated to the programs.

Data management

Resource management

Files can be protected against unauthorized access.

Data management

Resource management

Connected input and output devices can be integrated.

Data management

Resource management

Files can be stored structured (as in a catalog).

Data management

Resource management

Which of the following statements about the ISO/OSI reference model are correct?

This is a reference model only. I.e. it regulates the tasks of the protocol layers, but not how they are to be implemented.

The top three layers are for transport, the remaining layers are for applications.

The layers of the ISO/OSI reference model are numbered from bottom to top.

The model is independent of the hardware used or the network topology.

Which statements about the layer model and communication protocols are correct?

Application logs are found in the ISO/OSI layer model on the lowest layer.

The ISO/OSI layer model contradicts the concepts of a layer architecture.

Communication protocols are, among other things, agreements on the establishment, monitoring and termination of connections.

A layer model isolates the technical details of the layers from each other.

What is the name of the language with which the web pages can be described?

«Hypertext Markup Language» or «HTML»

«Webpage Markup Language» or «WPML»

«Unified Markup Language» or «UML»

«Hyperlink Markup Language» or «HLML»

How is the basic communication protocol of the Internet named?

"Hypertext Transfer Protocol" or short "HTTP"

"Transmission Control Protocol/Internet Protocol" or short "TCP/IP"

"Media-Access-Control" or short "MAC"

"Transport Layer Security" or short "TLS"

Which statements about "line switching" are correct?

All Internet protocols are optimized for line switching.

Intermediate exchanges store data packets and forward them on the optimal line.

Line switching has a worse performance of the entire network than packet switching.

The participants have their own channel during the transmission.

Responsible for addressing and forwarding data packets..

POP3 and IMAP

HTTP

FTP

SMTP

Send e-mails with it.

POP3 and IMAP

HTTP

FTP

TXP

SMTP

This protocol was developed for transferring files.

POP3 and IMAP

HTTP

FTP

TCP

Receive e-mails with it.

POP3 and IMAP

SMTP

FTP

HTTP

Web pages are usually transmitted with it.

HTTP

SMTP

TCP

FTP

Controls the connection between sender and receiver.

POP3 and IMAP

TCP

HTTP

SMTP

The system is more complex and there are higher requirements.

Multi-user mode

Single-user mode

Multi-program operation is a prerequisite

Multi-user mode

Single-user mode

Smartphones and desktop computers are often used.

Multi-user mode

Single-user mode

The system requirement is lower, but the resources are not used to full capacity.

Multi-user mode

Single-user mode

Which statements about Transport Layer Security (TLS) are correct?

Encryption is completely sufficient for establishing a secure connection in e-banking.

Formerly known as Secure Sockets Layer (SSL)

A certificate is only required in rare cases for TLS, then when a lot of money is involved.

Allows encrypted and secure communication over the Internet.

Which statements about operating systems are correct?

Multi-user system requires at least two concurrent users.

Operating systems for desktop and mobile devices do not differ in their core functionalities.

The hardware can only be used in interactive dialog mode.

An operating system includes all programs required for starting up a computer.

This defines the possible values that an attribute can have.

Value range

Integrity rule

Default value

Data type

If an input obligation exists for an attribute, this is a/an

Value range

Default value

Data type

Integrity rule

Each attribute must have one, at the latest when the attribute is transferred to the database.

Value range

Integrity rule

Data type

Default value

These are preset values defined for a column type, such as "CURRENT DATE".

Value range

Integrity rule

Data type

Default value

Hierarchical product categories in an online shop.

1:n relationship

1:1 relationship

n:m relationship

A list of parts for a product that consists of other products.

1:1 relationship

1:n relationship

n:m relationship

A hierarchical management structure in a company.

1:1 relationship

1:n relationship

n:m relationship

A hierarchical management structure in a company.

1:1 relationship

1:n relationship

n:m relationship

A marriage-like partnership between two persons.

1:1 relationship

1:n relationship

n:m relationship

Which statements about primary keys and foreign keys in the relation model are correct?

A relation can only contain a unique foreign key. This can include one or more attributes.

A relation has only one primary key. This can include one or more attributes.

The primary key value of a data set should never be changed.

Combined primary keys often consist of foreign keys.

Which statements about primary keys and foreign keys in the relation model are correct?

Two or more data records in a relation never have the same attribute values in the primary key.

The foreign key value of a data record should never be changed.

Two or more data records in a relation never have the same attribute value in the foreign key.

The primary key value of a data set should never be changed.

Which statements on normalization are correct?

In the standard normalization procedure, data sets are gradually converted from the 1st normal form to the 3rd normal form.

The number of tables tends to decrease with increasing normalization.

An objective of normalization is to have stable and flexible data structures.

During normalization, only n:m relationships are converted into 1:1 relationships.

Liste des carte

Étudier

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