placement-level MCQ test (PHP + MySQL PDO)

  • Home
  • Blog
  • placement-level MCQ test (PHP + MySQL PDO)
Featured

placement-level MCQ test (PHP + MySQL PDO)

March 31, 2026 in Php

🧠 MCQ Test: PHP + MySQL (PDO)

🔹 Section A: Basics (1–10)

1. What does PDO stand for?
A) PHP Database Object
B) PHP Data Object
C) Personal Data Object
D) Program Data Object

2. Which function is used to connect PDO?
A) mysqli_connect()
B) new PDO()
C) connect_db()
D) db_open()

3. Which fetch mode returns associative array?
A) PDO::FETCH_NUM
B) PDO::FETCH_ASSOC
C) PDO::FETCH_OBJ
D) PDO::FETCH_BOTH

4. What does AUTO_INCREMENT do?
A) Deletes rows
B) Increases value automatically
C) Encrypts data
D) Joins tables

5. Which SQL command is used to read data?
A) INSERT
B) UPDATE
C) SELECT
D) DELETE

6. Which method executes prepared statement?
A) run()
B) execute()
C) query()
D) start()

7. Which is NOT a CRUD operation?
A) CREATE
B) READ
C) MODIFY
D) DELETE

8. Which is correct PDO DSN format?
A) mysql://localhost/db
B) mysql:host=localhost;dbname=test
C) localhost:mysql:test
D) db:mysql://localhost

9. Which function fetches single row?
A) fetch()
B) fetchAll()
C) get()
D) row()

10. Which function returns last inserted ID?
A) getLastId()
B) lastInsertId()
C) insertId()
D) lastId()

🔹 Section B: Intermediate (11–20)

11. Prepared statements help prevent?
A) Syntax error
B) SQL Injection
C) Server crash
D) Memory leak

12. Which symbol is used in named parameters?
A) ?
B) :
C) @
D) #

13. bindParam() binds by?
A) Value
B) Reference
C) Copy
D) Pointer

14. Which is safer?
A) Direct query
B) Prepared statement
C) Echo SQL
D) None

15. What does rowCount() return?
A) Columns
B) Tables
C) Affected rows
D) Errors

16. Which JOIN returns all rows from left table?
A) INNER JOIN
B) RIGHT JOIN
C) LEFT JOIN
D) FULL JOIN

17. Which is used for error handling?
A) try-catch
B) echo
C) die()
D) print()

18. Which function hashes password?
A) md5()
B) hash()
C) password_hash()
D) encrypt()

19. Which verifies password?
A) password_check()
B) password_verify()
C) verify_pass()
D) check_hash()

20. Index is used for?
A) Delete data
B) Speed up query
C) Insert data
D) Backup

🔹 Section C: Advanced (21–30)

21. Transaction starts with?
A) start()
B) beginTransaction()
C) open()
D) init()

22. Which method saves transaction?
A) save()
B) commit()
C) push()
D) execute()

23. Which undoes transaction?
A) cancel()
B) rollback()
C) undo()
D) reverse()

24. VARCHAR is?
A) Fixed length
B) Dynamic length
C) Integer
D) Boolean

25. CHAR is?
A) Dynamic
B) Fixed
C) Float
D) Object

26. ACID stands for?
A) Atomic, Consistent, Isolated, Durable
B) Active, Clear, Indexed, Data
C) Auto, Control, Input, Data
D) None

27. Which is faster for large data?
A) No index
B) Index
C) Random query
D) SELECT *

28. SQL Injection occurs when?
A) Query too fast
B) User input not sanitized
C) DB full
D) Server slow

29. LIMIT is used for?
A) Delete rows
B) Restrict results
C) Join tables
D) Insert rows

30. Which is best practice?
A) Plain SQL
B) Prepared statements
C) Hardcoded values
D) No validation

✅ Answer Key

1-B   2-B   3-B   4-B   5-C
6-B   7-C   8-B   9-A   10-B11-B  12-B  13-B  14-B  15-C
16-C  17-A  18-C  19-B  20-B21-B  22-B  23-B  24-B  25-B
26-A  27-B  28-B  29-B  30-B

🎯 Score Evaluation

  • 25–30 → 🔥 Job Ready
  • 18–24 → 👍 Good, revise advanced
  • 10–17 → ⚠️ Needs practice
  • <10 → ❌ Learn basics again
🇮🇳 Amazon India 🌍 Amazon Global

aditya singh