Q. What is the purpose of transaction() method?

  • (A) Execute single query
  • (B) Handle HTTP requests
  • (C) Wrap operations in DB transaction
  • (D) Start server
πŸ’¬ Discuss
βœ… Correct Answer: (C) Wrap operations in DB transaction
Explanation: Ensures atomic operations with rollback support.

Q. What happens if exception occurs inside transaction()?

  • (A) Commit happens
  • (B) Rollback occurs
  • (C) Ignore error
  • (D) Server stops
πŸ’¬ Discuss
βœ… Correct Answer: (B) Rollback occurs
Explanation: Transaction is rolled back.

Q. Which relationship represents one-to-many?

  • (A) belongsTo()
  • (B) hasOne()
  • (C) hasMany()
  • (D) find()
πŸ’¬ Discuss
βœ… Correct Answer: (C) hasMany()
Explanation: hasMany defines one-to-many relationship.

Q. Which relationship represents many-to-one?

  • (A) belongsTo()
  • (B) hasMany()
  • (C) hasOne()
  • (D) filter()
πŸ’¬ Discuss
βœ… Correct Answer: (A) belongsTo()
Explanation: belongsTo defines many-to-one.

Q. Which relationship returns a single record?

  • (A) hasMany()
  • (B) hasOne()
  • (C) where()
  • (D) count()
πŸ’¬ Discuss
βœ… Correct Answer: (B) hasOne()
Explanation: hasOne returns one record.

Q. What is returned by queryBuilder()?

  • (A) PDO
  • (B) QueryBuilder instance
  • (C) Array
  • (D) Boolean
πŸ’¬ Discuss
βœ… Correct Answer: (B) QueryBuilder instance
Explanation: Used for advanced query building.

Q. Which method returns table name?

  • (A) table()
  • (B) getTableName()
  • (C) getTable()
  • (D) name()
πŸ’¬ Discuss
βœ… Correct Answer: (B) getTableName()
Explanation: getTableName() returns table name.

Q. Which method returns primary key?

  • (A) primary()
  • (B) getPrimaryKey()
  • (C) key()
  • (D) id()
πŸ’¬ Discuss
βœ… Correct Answer: (B) getPrimaryKey()
Explanation: Returns primary key column.

Q. Which method checks record count?

  • (A) exists()
  • (B) count()
  • (C) all()
  • (D) find()
πŸ’¬ Discuss
βœ… Correct Answer: (B) count()
Explanation: count() returns number of records.

Q. What condition is required for softDelete() to work?

  • (A) primary key exists
  • (B) deleted_at column exists
  • (C) table has index
  • (D) PDO enabled
πŸ’¬ Discuss
βœ… Correct Answer: (B) deleted_at column exists
Explanation: Soft delete uses deleted_at column.