Databases

61 questions · IT Passport · 51–61

IPA 2023 · Question 59

A “Member_management” table that is managed in a relational database was normalized and divided into a “Store” table, a “Member_type” table, and a “Member” table. Which of the following is appropriate as the “Member” table? Here, an underline in a table indicates a primary key, and when one member registers with multiple stores, a member number is assigned for each store.

Member_management

Store_code	Store_name	Member_number	Member_name	Member_type_code	Member_type_name
001	Sapporo	1	Shiken Hanako	02	Gold
001	Sapporo	2	Joho Taro	02	Gold
002	Tokyo	1	Kodo Jiro	03	Regular
002	Tokyo	2	Gozen Sakurako	01	Platinum
003	Osaka	1	Gozen Sakurako	03	Regular

Store

Store_code	Store_name

Member_type

Member_type_code	Member_type_name

a)b)c)d)

IPA 2023 · Question 78

Which of the following lists all and only the appropriate descriptions concerning the setting of a primary key in a relational database?

AA field whose value duplicates that of another record cannot be used as a primary key.BIt cannot be set so that it overlaps with an index.CThe value of a primary key must be a numeric value.DA primary key can be composed of multiple fields.

a)A, Cb)A, Dc)B, Cd)B, D

IPA 2023 · Question 100

Which of the following is the join operation in a relational database?

a)From a table, a table is created by extracting the records that satisfy specific conditions.b)From a table, a table is created by extracting specific fields.c)From two (2) tables, a table is created by extracting the records that have the same values.d)From two (2) tables, a table is created by associating them according to the values of fields.

IPA 2022 · Question 77

Which of the following is an appropriate description concerning the ACID properties of transaction processing?

a)By preparing an index, the search speed when data is searched can be increased.b)By controlling so that a series of processes is either all executed or not executed at all when data is updated, atomicity can be ensured.c)By distributing copies of the database to multiple servers, availability can be increased.d)By normalizing tables, inconsistency and duplication of data can be prevented.

IPA 2022 · Question 98

Which of the following is the term for the operation that extracts only the Name column from the “Employee” table managed in a relational database?

Employee

Employee number	Name	Department code
H001	Shiken Hanako	G02
H002	Joho Taro	G01
H003	Kodo Jiro	G03
H004	Gozen Sakurako	G03
H005	Gogo Saburo	G02

a)Joinb)Projectionc)Selectiond)Union

IPA 2021 · Question 62

In an account transfer of a financial system, the consistency of the database is maintained by ensuring that, for the withdrawal processing from the transfer source account and the deposit processing to the transfer destination account, either both of the processes are executed or neither of them is executed. What is the term for handling such a series of processes for a database as a transaction and confirming the updated content of the database when the processing has been completed without inconsistency?

a)Commitb)Schemac)Roll forwardd)Lock

IPA 2021 · Question 75

Among the functions A through D concerning information systems, which of the following lists all and only those that are provided in a DBMS?

AAccess rights managementBFailure recoveryCConcurrency controlDFirewall

a)A, B, Cb)A, Dc)B, Cd)C, D

IPA 2020 · Question 57

An “Employee” table that is to be managed with a relational database is designed by using the items shown below. Which of the following is a redundant item that can be derived from other items?

Employee

Employee number	Employee name	Date of birth	Current age	Address	Hobby

a)Date of birthb)Current agec)Addressd)Hobby

IPA 2020 · Question 64

Among the descriptions A through C concerning data processing, which of the following lists all and only the effects obtained by introducing a DBMS?

AEven when multiple programs access the same data at the same time, consistency is maintained.BSince the DBMS decides the order of processing according to the priority of each transaction, the response time of real-time processing becomes shorter.CSince the efficiency of the page management of virtual memory improves, the access time to data becomes constant regardless of the amount of data.

a)Ab)A, Cc)Bd)B, C

IPA 2020 · Question 72

A single file was updated concurrently from two (2) PCs. When the processing for data n in the file was performed in the order of ① through ④, which of the following is the final value of data n? Here, the initial value of data n was 10.

a)5b)10c)12d)17

IPA 2020 · Question 73

In a relational database, which of the following is the result of executing an intersection operation on table A and table B?

Table A

Product name	Price
Gum	100
Rice cracker	250
Chocolate	150

Table B

Product name	Price
Rice cracker	250
Chocolate	150
Dorayaki	100

Product namePrice

a)GumRice crackerChocolateDorayaki100250150100b)GumRice crackerChocolateDorayaki100500300100c)Rice crackerChocolate500300d)Rice crackerChocolate250150