Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Know your CUBRID - Beginner Quiz

# of questions: 20

Description: The beginner level quiz consists of 20 questions. They are intended to check if users know the basics of the CUBRID database such as what operating system is supported, what software is required to be pre-installed prior to the CUBRID installation, what data types exist in CUBRID, what the result is after a given simple SQL query is executed, basic requirements for tables and views, etc.

After this beginners test, users will learn the important details they have to pay attention to when starting to work with CUBRID.

Question 1

1. What are the mandatory prerequisites to install CUBRID and CUBRID Manager on Windows?

  • Java System Development Kit
  • Java JRE
  • Microsoft Visual C++ 2008 Redistributable Package
  • PHP

Question 2

2. Which of the followings is a CUBRID keyword?

  • ASSERTION
  • BREADTH
  • DICTIONARY
  • CUBRID

Question 3

3. What is the result of the following SQL?
SELECT TRUNC(34567.34567, 3) FROM db_root;

  • 34567.345
  • 34567.34500
  • 34567.34000
  • 34567.00000

Question 4

4. What is the result of executing the following SQL?
SELECT ((CAST ({3,3,3,2,2,1} AS SET))+(CAST ({4,3,3,2} AS MULTISET))) FROM db_root;

  • {1, 2, 2, 2, 3, 3, 3, 3, 3, 4}
  • {1, 2, 3, 4}
  • {1, 2, 2, 3, 3, 3, 4}
  • Error

Question 5

5. What is true about the CUBRID “MULTISET” data type?

  • Is a collection type that allows the duplication of elements.
  • Is a collection of sub-collections.
  • This data type is equivalent to the LIST data type.
  • CUBRID does not have such a data type.

Question 6

6. Which of the following programming languages is supported for CUBRID stored procedures?

  • Java
  • SQL
  • T-SQL
  • C

Question 7

7. Which of the following Operating Systems is supported by CUBRID?

  • Windows
  • Linux
  • Mac

Question 8

8. Which of the following is true about identifiers in CUBRID?

  • An identifier can begin with a digit.
  • An identifier must begin with a letter; it must not begin with a number or a symbol.
  • It is not case-sensitive.
  • CUBRID keywords are not allowed.

Question 9

9. What is the result of the following SQL?
SELECT ((CAST ({3,3,3,2,2,1} AS LIST))*(CAST ({4,3,3,2} AS MULTISET)))
FROM db_root;

  • {1, 2, 3, 3}
  • {2, 3, 3}
  • {1, 2, 3, 4}
  • Error

Question 10

10. What is the result of the following SQL?
SELECT BIT_COUNT(8) FROM db_root;

  • 1
  • 8
  • 16
  • Syntax Error

Question 11

11. Which of the following statements are true about OID?

  • OID is synonym with a Primary Key.
  • OID (Object Identifier) is an object identifier represented by physical location information.
  • OID stands for “Object Information Data”
  • When an OID is used, accessibility is improved because the object in the heap file can be directly accessed without referring to the table.

Question 12

12. What session command must be entered to execute a SQL in CSQL?

  • ;run
  • ;x
  • ;
  • ;r

Question 13

13. Which of the following statements is true?

  • The language that will be used in the CUBRID DBMS can be set with the CUBRID_LANG environment variable.
  • The default value of the language is en_US.
  • It has the same value as the database character set.
  • None of the above is true

Question 14

14. What is the result of the following SQL statement?
SELECT TRANSLATE('12345abcdeabcde','abcde', NULL);

  • ‘abcde’
  • ‘NULL’
  • NULL
  • Syntax Error

Question 15

15. How do you connect using CSQL to a remote database (located on a machine having IP=192.168.1.3)?

  • >csql -C demodb/192.168.1.3
  • >csql -C demodb@192.168.1.3
  • >csql -C demodb[192.168.1.3]
  • >csql -C demodb:192.168.1.3

Question 16

16. Which of the followings is true about SHARED and DEFAULT column attributes?

  • SHARED and DEFAULT are attributes related to the initial value of the column.
  • You can change the value of SHARED and DEFAULT in the ALTER TABLE statement.
  • SHARED and DEFAULT are synonyms.
  • SHARED means that column values are identical in all rows.

Question 17

17. What is the result of the following SQL statement?
SELECT EVALUATE (1 <> 0);

  • TRUE
  • 1
  • 0
  • FALSE

Question 18

18. What conditions must be met by a View to be an Updateable View?

  • The DISTINCT or UNIQUE statement must not be included.
  • The GROUP BY... HAVING statement must not be included.
  • The UNION statement must not be included.
  • There are no updateable views in CUBRID.

Question 19

19. Which of the followings is true about the CUBRID Transactions support?

  • CUBRID has support for commit, rollback, savepoint per transaction.
  • CUBRID has support for distributed transactions (two-phase commit).
  • CUBRID has support for ensuring transaction consistency in the event of system or database failure.
  • CUBRID has support for resolving deadlocks automatically.

Question 20

20. How do you get the list of all the user tables in a database?

  • Using CUBRID system catalog
  • Calling CUBRID system stored procedures
  • SELECT * FROM db_tables;
  • You can’t do this in CUBRID




You are either using a very old browser or a browser that is not supported.
In order to browse cubrid.org you need to have one of the following browsers:



Internet Explorer: Mozilla Firefox: Google Chrome: