Q. Which design pattern is used by DB::get_connection()?

  • (A) Factory
  • (B) Singleton
  • (C) Observer
  • (D) Builder
πŸ’¬ Discuss
βœ… Correct Answer: (B) Singleton
Explanation: It returns the same PDO instance (singleton).

Q. What happens if DB configuration is missing?

  • (A) Default values are used
  • (B) Warning is logged
  • (C) Exception is thrown
  • (D) Connection retries
πŸ’¬ Discuss
βœ… Correct Answer: (C) Exception is thrown
Explanation: Docs clearly mention exception is thrown.

Q. Which method should be used to obtain DB connection?

  • (A) new DB()
  • (B) connect()
  • (C) get_connection()
  • (D) init()
πŸ’¬ Discuss
βœ… Correct Answer: (C) get_connection()
Explanation: get_connection() is recommended way.

Q. What is the return type of get_connection()?

  • (A) MySQL connection
  • (B) PDO object
  • (C) DB instance
  • (D) QueryBuilder
πŸ’¬ Discuss
βœ… Correct Answer: (B) PDO object
Explanation: Returns PDO instance.

Q. Which environment variable defines database type?

  • (A) DB_DRIVER
  • (B) DB_ENGINE
  • (C) DB_TYPE
  • (D) DB_KIND
πŸ’¬ Discuss
βœ… Correct Answer: (C) DB_TYPE
Explanation: DB_TYPE specifies database type.

Q. Which database types are supported?

  • (A) MySQL, MongoDB, Redis
  • (B) MySQL, PostgreSQL, Oracle
  • (C) SQLite only
  • (D) Oracle only
πŸ’¬ Discuss
βœ… Correct Answer: (B) MySQL, PostgreSQL, Oracle
Explanation: Docs specify mysql, postgres, oracle.

Q. What happens if unsupported DB type is provided?

  • (A) Defaults to MySQL
  • (B) Silent failure
  • (C) Exception is thrown
  • (D) Fallback to SQLite
πŸ’¬ Discuss
βœ… Correct Answer: (C) Exception is thrown
Explanation: Unsupported DB type triggers exception.

Q. Which variable defines database host?

  • (A) DB_SERVER
  • (B) DB_HOST
  • (C) DB_URL
  • (D) DB_ADDR
πŸ’¬ Discuss
βœ… Correct Answer: (B) DB_HOST
Explanation: DB_HOST defines hostname.

Q. Which variable defines database name?

  • (A) DB_DATABASE
  • (B) DB_NAME
  • (C) DB_SCHEMA
  • (D) DB_TABLE
πŸ’¬ Discuss
βœ… Correct Answer: (B) DB_NAME
Explanation: DB_NAME is used.

Q. Which variable defines database port?

  • (A) DB_PORT
  • (B) DB_CONN_PORT
  • (C) DB_SOCKET
  • (D) DB_CHANNEL
πŸ’¬ Discuss
βœ… Correct Answer: (A) DB_PORT
Explanation: DB_PORT defines port.