TOP

Prospects of OSS-DB

Exam Overview

OSS-DB Silver

OSS-DB Gold

Detailed Objectives

Schedule Exam

Sample Exam Questions

Japanese

 

 

Sample Questions of OSS-DB Exam Silver "General Knowledge"

[General knowledge - License]

2.13

Choose two appropriate descriptions about the PostgreSQL license.

  1. The source code of PostgreSQL has been released, and anyone can download it. 
  2. If you modify the source code of PostgreSQL, you have an obligation to disclose it. 
  3. When redistributing PostgreSQL source code by modifying it, there is no need to display the copyright.

  4. PostgreSQL developers are obligated to correct fatal bugs.

  5. PostgreSQL can be used for free without user registration.
Answer and Commentary

[General knowledge - general features of OSS-DB]

2.12

Choose two false statements about database related features that PostgreSQL supports.

  1. Procedures
  2. Functions
  3. Database triggers 

  4. Sequences

  5. Synonyms
Answer and Commentary

[General knowledge - community]

2.11

Please choose two statements that are incorrect about the Japan PostgreSQL User Group.

  1. It is an NPO corporation that works to promote the spread of PostgreSQL
  2. They are manage a mailing list for exchanging information about PostgreSQL
  3. They are provide paid support for PostgreSQL 

  4. They fix bugs in PostgreSQL

  5. They translate the manual for PostgreSQL
Answer and Commentary

[General knowledge - database design, normalization]

2.10

Choose the most appropriate one as an explanation of data normalization.

  1. To derive the best performance of the database, the data should be normalized. 
  2. In order to minimize the capacity of the database, the data should be normalized. 
  3. Data should be normalized in order to improve the maintainability of the data. 

  4. To facilitate data backup, data should be normalized. 

  5. In order to simplify the SQL statement of data retrieval, the data should be normalized. ‍
Answer and Commentary

[General knowledge - general features of OSS-DB]

2.09

Choose two statements that are correct about the character sets (encoding method) supported by PostgreSQL.

  1. When the server and client are on the same machine, you need to use the same character set 
  2. Japanese shift JIS is supported as a server character set
  3. Japanese shift JIS as a client character set is supported

  4. You can use a different character set for each database in the database cluster 

  5. You can use a different character set for each table in the database
Answer and Commentary

[General knowledge - installation method (how to use database management command)]

2.08

Please choose two statements that are true about the replication functionality of PostgreSQL.

  1. Individual databases may be specified for replication in a single PostgreSQL database cluster.
  2. Data updates may only occur against a master instance in a PostgreSQL replication architecture. 
  3. A maximum of eight slave instances may be specified in a PostgreSQL replication architecture.

  4. When the master instance fails, a read-only slave instance may be promoted to an updateable master instance.

  5. When all instance servers are down, data updates on the master instance also stops automatically.
Answer and Commentary

[General knowledge - general knowledge of RDBMS]

2.07

Please choose the most accurate description
regarding indexes.

  1. The use of indexes always results in faster searches of tables.
  2. Creation of an index results in data updates of tables being slow.
  3. Where multiple indexes exist on a table, it is not possible to predict which will be used for a search.

  4. Where only one index exists on a table, that index will always be utilized for a search.

  5. All of the above are incorrect.
Answer and Commentary

[General knowledge - community]

2.06

Choose the correct statement regarding the PostgreSQL manual.

  1. Only an English version of PostgreSQL manual exists.
  2. Because the Japanese PostgreSQL manual contains many mistakes introduced by its machine translation from the English version of the manual, the English version should be utilized where possible.
  3. The Japanese PostgreSQL manual is professionally translated from English and is available free of charge.
  4. The Japanese PostgreSQL manual is translated from English by volunteers and available free of charge.
  5. Because Japanese engineers work on PostgreSQL, the manual is authored in Japanese during software development, it is translated into English and released overseas.
Answer and Commentary

[General knowledge - License]

2.05

Choose the two descriptions that most accurately
describe DDL and DML?

  1. DDL stands for Data Drop Language, and refers to SQL commands that delete data, such as DROP TABLE or DELETE.
  2. DML is an abbreviation for Data Maintenance Language, and refers to SQL commands used for maintaining databases such as VACUUM and ANALYZE.

  3. DDL stands for Data Definition Language and refers to SQL commands that allow the definition of database objects, such as CREATE TABLE.

  4. DML is an abbreviation of Data Manipulation Language, and refers to SQL commands that perform data manipulation such as SELECT or UPDATE.

  5. DML is an abbreviation of Data Making Language, and refers to SQL commands that create data such as CREATE TABLE and INSERT.

Answer and Commentary

[General knowledge - License]

2.04

Choose two descriptions out of the following that are true about the PostgreSQL license.

  1. The same GPL-based license as the Linux kernel is used.
  2. A BSD-based license named ‘PostgreSQL license’ is used.
  3. You are not permitted to sell software for a fee that has been created by modifying the PostgreSQL source code.
  4. Selling software for a fee that has been created by modifying the PostgreSQL source code carries no obligation to disclose the modified parts.

  5. Selling software for a fee that has been created by modifying the PostgreSQL source code carries no obligation to disclose the modified parts.

Answer and Commentary

[General knowledge - general features of OSS-DB]

2.03

I want to modify the functionality of PostgreSQL.
Choose the answer from the following descriptions.

  1. The only way to do this is to request the PostgreSQL global development community to alter the code base.
  2. You may request the Japan based PostgreSQL User Group to modify the source code for a fee.
  3. If you purchase the source code for a fee, you can freely modify it and distribute it.
  4. The source code is free, but special permission from the global development team is necessary to distribute the modified code.

  5. Source code obtained free of charge maybe modified and then distributed for a fee.

Answer and Commentary

[General knowledge - general knowledge about
relational databases
(database design and normalization)]

2.02

Choose the most appropriate reason to perform database normalization.

  1. IImprove access performance by keeping the data size constant.
  2. To improve access performance by standardizing the data search path.

  3. Easily maintain data by eliminating duplication of data.

  4. To simplify data retrieval by simplifying data dependency.

  5. Standardizing the structure of the table makes it easy to back up the data.

Answer and Commentary

[General Knowledge - General Knowledge of OSS-DB]

2.01

Choose two statements from the following that give an appropriate explanation of the PostgreSQL tablespace

  1. Improves performance by dividing up a large table and distributing it across multiple disks.

  2. Improves performance by placing the table and index on separate disks.

  3. Specifies the file name as the tablespace, and the table and index are created within that file space.

  4. Specifies the directory name as the tablespace, and the table and index are created as a file within that directory.

  5. The tablespace used by the table can only be specified when creating a new table with CREATE TABLE and cannot be modified after it is created.

Answer and Commentary

LPI-Japan
Platinum Sponsors

  • 株式会社リンク
  • Citrix社
  • 株式会社コンピュータマネジメント
  • サイバートラスト株式会社
  • 株式会社デージーネット
  • 株式会社エンベックス
  • 富士通株式会社
  • 株式会社GOSPA
  • 株式会社日立製作所
  • 株式会社HTKエンジニアリング
  • 株式会社アイエスエフネット
  • KENスクール
  • 株式会社リーディング・エッジ社
  • リナックスアカデミー
  • 日本電気株式会社
  • NECソリューションイノベータ株式会社
  • 株式会社アウトソーシングテクノロジー
  • 株式会社Ping-t
  • 日本SGI株式会社
  • 株式会社ソルクレオ
  • 株式会社ゼウス・エンタープライズ

© EDUCO (General Incorporated Association Educo) all rights reserved.