Sample Exam Questions

Next >

From the objective of OSS-DB Exam Silver
S1.2 General knowledge of relational databases (General knowledge about SQL)

Sample Question

1.06

Choose two incorrect descriptions for SQL.

 
  1. Standardization of SQL is promoted by ANSI and ISO.

  2. There are parts where SQL is uniquely extended by the database management system.

  3. SQL requires compilation on the user side before execution.
  4. SQL can manipulate data (DML) but not define data (DDL).

※This sample exam is different from those that appear in the actual OSS-DB Exam.
2024/04/25

Answer and Explanation

SQL is a language used for defining (DDL) and manipulating (DML) data in relational databases.
SQL can be passed as-is to the database management system and does not need to be compiled.
Although SQL is standardized and can use the same syntax regardless of the type of database management system, there are parts where SQL is uniquely extended by the database management system.
There are several SQL standards, including SQL86, SQL92, and SQL:1999. The standardization of SQL is promoted by ANSI (American National Standards Institute) and ISO (International Standards Organization).

Therefore, the correct answers are C and D.

Next >