Databases

Which of the following is an appropriate effect obtained through the normalization of data in a relational database?

Which of the following is an appropriate description concerning foreign keys in a relational database?

When conditions (i) through (iv) are all fulfilled, which of the following is the E-R diagram that indicates the relationship between publishing companies, authors, and books? Here, the notation for the E-R diagram is as below.

[Notation]

Which of the following is the appropriate explanation of commit in transaction processing?

By joining tables “Employees in charge”, “Regions”, and “Customers” that are managed in a relational database, the table A that is shown below is obtained. Which of the following is the table “Customers” that is used for the joining? Here, a solid underline indicates a primary key and a dotted underline indicates a foreign key.

Which of the following is an appropriate purpose of conducting data normalization when a relational database is constructed?

An “Employee” table and a “Department” table that are to be managed with a relational database were created on the basis of the conditions (i) through (v). Which of the following is the most appropriate primary key for the “Employee” table?

Which of the following is the appropriate description concerning transaction processing?

When an activity for building a relational database is divided into steps A through C below, which of the following is the appropriate order of the steps?

The “Purchase_list” table in a relational database manages the purchases of products. This table should be normalized and divided into a “Purchase” table and a “Product” table. Which of the following is the most appropriate field that should be contained in common in the two divided tables? Here, each purchase includes only one product, and can be uniquely identified by Purchase_number. Also, each product can be uniquely identified by Product_number.

Which of the following is the appropriate description of a rollback in transaction processing?

Which of the following is the appropriate purpose of exclusive control in a database management system?

There are “Sales”, “Customer” and “Product” tables in a relational database. Among lists A through C, which of the following contains all and only the lists that can be created from the data in these tables? Here, a solid underlined part represents a primary key, and a dashed underlined column represents a foreign key.

In the description below concerning the design process of a relational database, which of the following is an appropriate combination of terms to be inserted into blanks A through C?

Analyze the target business operations, identify the data which is used there, and create B, consisting of entities and A. On the basis of the B created, design C.

Which of the following is an appropriate combination of relational database manipulations I through III and relational operations?

From a “Product” table and “Sales” table that are managed with a relational database, which of the following contains all and only the products where the total sales for each product in May is at least 20,000 yen?

Which of the following is a language used for the operation of a relational database?

When designing a database, which of the following is used for the purpose of organizing and representing the relation of data?

Which of the following is the most appropriate method for limiting the content of database to be displayed in accordance with its confidentiality and each user’s business needs?

Which of the following is an appropriate purpose of normalizing the data of a relational database?

Which of the following is a term for an operation that extracts only the rows (records) with a price of 100 yen or more, from the “Product” table of a relational database?

When the “Department,” “Location,” and “Employee” tables are joined to create Table A, which of the following is the “Employee” table that is to be joined? Here, an underline indicates a primary key, and a dotted underline indicates a foreign key.

From the “Product” table below, products whose supplier is “Company A” and the price is 1.40 dollars or more, and products whose supplier is “Company B” and the price is 1.70 dollars or less are extracted. Which of the following is a list of all of the obtained product names?

Which of the following is a database model that represents data in a table that is composed of rows and columns?

There is the “Employee” table and the “Department” table in a relational database. The “Employee” table and the “Department” table are joined, and employees who live in prefectures different from the prefectures that their departments are located in are extracted. How many employees are extracted?

In a relational database, which of the following is the reason for a primary key being specified?

In DBMS, which of the following is a function for maintaining consistency of data by preventing the occurrence of conflicts due to simultaneous access to the data ?

A customer name and his or her address, a product name and its unit price, the products and quantities ordered by the customer, and the date of order are managed by using a relational database. Which of the following is an appropriate table after normalization? Here, the underline represents primary keys, and there are same customer names and product names.

The result of the Information-Technology Engineers Examination by some of the employees of a company is shown below. In order to manage this table with a relational database, which of the following is an appropriate method to partition the table into two (2) tables? Here, this company has employees with the same name.

In a relational database, when (A∪B) and (A∩B) are performed on table A and table B shown below, which of the following is an appropriate combination of the resulting two tables among the three tables P, Q, and R? Here, (A∪B) shows the union of A and B, and (A∩B) shows the intersection of A and B.

In a system environment where several users have access to a database simultaneously, a new user tries to view a data record while another user is updating the same record. In order to assure data integrity in such circumstances, which of the following is an appropriate control method that should be used in the DBMS?

Sales data is to be managed with tables in a relational database. When the tables for sales data are designed, which of the following activities analyzes the relationship between the fields of the tables and decompose the tables so that there are no duplications or inconsistencies in the data?

Which of the following is an appropriate description about association of records for a relational database?

A “Sales Details” table and a “Products” table are managed in a relational database. What is the total number of notebooks sold?

Among the processes where multiple users simultaneously access the same database, which of the following is a process that does not need a countermeasure for securing transaction consistency?

Which of the following is an appropriate description of a rollback in transaction processing?

Which of the following effect is obtained by normalizing the tables of a relational database?

Which of the following is an appropriate effect obtained through the normalization of data in a relational database?

Which of the following is an appropriate description of a checkpoint in a DBMS?

There are the “Student” table, the “Subject” table, and the “Grade” table that are managed in a relational database. When one (1) student takes multiple subjects, and a student who is not registered in the “Student” table or a subject that is not registered in the “Subject” table cannot be registered in the “Grade” table, which of the following is appropriate to be set as a foreign key? Here, an underline in a table indicates a primary key.

Which of the following is an appropriate combination of words and phrases to be inserted into blanks A and B in the description below concerning normalization of data in a relational database?

One of the main purposes of normalization is to eliminate the duplication of data and A.
Normalization has multiple stages, and as it is advanced through them, B.

There are “Account”, “Customer” and “TransactionDetail” tables that are managed in a relational database. When a new customer deposits 10,000 yen at the same time as opening an account, which of the following is the appropriate order in which data is added to the tables? Here, of the underlines, a solid line represents a primary key, and a dashed line represents a foreign key.

Which of the following is an appropriate description concerning a transaction in a DBMS?

In a DBMS, which of the following is the information that is set and used as necessary for the purpose of performing data searches at high speed?

In the “Login record” table and the “Department” table below that are managed in a relational database, which of the following lists all and only the names of the departments to which the employees belong who have had a login result of failure, or who have had a login result of success at or before 09:00:00 on April 10, 2022?

Which of the following is the DBMS function that copies the contents of the database on one computer to the database on another computer, and synchronizes them so that the contents of both match?

Which of the following is an appropriate task that is performed in data analysis in database design?

In the diagram that represents the relationship of the elements that make up a relational database, which of the following is the appropriate combination of words to be inserted into A through C in the diagram?

Order data that was managed in one (1) table is divided into information concerning orders and information concerning products, and is managed in tables of a relational database after normalization is performed. Which of the following is the most appropriate combination of tables as the result of the normalization? Here, when the unit price differs for the same product, the product number also differs. In addition, there are no orderers with the same full name.

From the “Employee” table managed in a relational database, the employees whose names match ‘%葉_’ were extracted. How many employees were extracted? Here, “_” represents any one (1) character, and “%” represents a character string that consists of zero (0) or more of any characters.