[S1.2 General knowledge of relational databases (General knowledge about SQL)]
1.06
Choose two incorrect descriptions for SQL.
-
Standardization of SQL is promoted by ANSI and ISO.
-
There are parts where SQL is uniquely extended by the database management system.
- SQL requires compilation on the user side before execution.
- SQL can manipulate data (DML) but not define data (DDL).
[S1.2 General knowledge of relational databases (General knowledge about SQL)]
1.05
What is the SQL command equivalent to CRUD in a database? Choose the most appropriate combination.
- COMMIT, ROLLBACK, UNDO, DO
- CREATE, RESET, UNDO, DROP
- CREATE, READ, UPDATE, DELETE
- INSERT, SELECT, UPDATE, DELETE
- CONTINUE, REPEAT, UNTIL, DONE
[S1.1 General features of OSS-DB (License)]
1.04
You want to incorporate PostgreSQL into a commercial system and sell it. Choose the most appropriate one from the following descriptions.
-
PostgreSQL cannot be sold in commercial systems. Instead of shipping PostgreSQL with your system, it must be installed separately.
-
If you have a written license agreement with the PostgreSQL global development team that owns the copyright in PostgreSQL, you can sell it according to that agreement.
-
It can be sold on the condition that a certain amount based on the sales of the system is delivered to the PostgreSQL global development team.
-
If the copyright notice is properly made, it can be sold.
-
There are no restrictions on the use or sale of PostgreSQL, so you are free to sell it without any special precautions.
[S1.2 General knowledge of relational databases (Database design and normalization)]
1.03
Below is a part of the sales table that we want to normalize. Choose the two most important aspects to consider.
| Date | Customer Name | Customer Location | Item 1 | Qty 1| Item 2| Qty 2| Item 3| Qty 3|
+-----+--------------------+------------------------+----------+-----+-------+-----+--------+----+
|2/1 | Yodobashi | Ichibancho, Chiyoda-ku | TV | 5| PC | 3| Camera | 5|
|2/1 | Yamada | Minato-ku Azabudai | PC | 5| Radio | 2| | |
|2/1 | Kojima | Uchisaiwaicho, Chiyoda-ku | Refrigerator | 1| Washing machine | 4| Battery | 100|
|2/2 | Nojima | Ichibancho, Chiyoda-ku | TV | 10| | | | |
|2/5 | Yamada | Minato-ku Azabudai | Mouse | 10|DVD | 20 |CD | 20|
|2/8 | Kojima | Uchisaiwaicho, Chiyoda-ku | Camera | 10| | | | |
+-----+--------------------+------------------------+----------+-----+-------+-----+--------+----+
-
Since the dates have duplicates, such as 2/1 appearing three times, they are separated into a different table.
-
Separate the customers into a different table because they appear repeatedly.
-
If we know the customer name, we know the customer location, so we separate this combination into a different table.
-
Since Yodobashi and Nojima have duplicated locations, the locations are separated into a different table.
-
Separate the combination of items and quantities into a different table.
[S1.1 General features of OSS-DB (Major version / Minor version)]
1.02
Choose two appropriate descriptions of PostgreSQL's release cycle and support policies.
-
Minor updates are typically released once a year.
- Minor updates are typically released every six months.
-
Minor updates are typically released every three months.
-
The support period is five years from the release of each major version.
-
The support period is 10 years from the release of each major version.
-
The support period is five years from the release of each minor update.
[S1.1 General features of OSS-DB (Major version / Minor version)]
1.01
"Up to version 9, PostgreSQL's version numbering consisted of 3 numbers, such as 9.6.3. Starting with version 10, it consists of 2 numbers, such as 11.2.
Choose two appropriate explanations for this."
-
The first number is the major version, the second is the minor version, and the third is the patch version. Starting with version 10, patch versions are no longer indicated.
-
The first and second numbers together are the major version, and the third number is the minor version. Since version 10, minor versions are no longer indicated.
-
Up to version 9, the first two numbers are the major version, and after version 10, the first number is the major version. The last number is the minor version for all versions.
-
If the major versions are the same, the files that make up the database are compatible, but if they are different, they are incompatible and require database conversion during the upgrade.
-
Regardless of the version, if the version numbers are different, the files that make up the database are incompatible, and conversion of the database is required during the upgrade.
LPI-Japan Platinum Sponsors
© EDUCO All Rights Reserved.