1. WordPress uses which database management system by default?
(A) Oracle
(B) MySQL / MariaDB
(C) PostgreSQL
(D) MongoDB
2. The default WordPress database table prefix is:
(A) wp_
(B) wpdb_
(C) wordpress_
(D) db_wp
3. The WordPress configuration file that contains database credentials is:
(A) wp-config.php
(B) functions.php
(C) index.php
(D) settings.php
4. Which WordPress table stores user information?
(A) wp_options
(B) wp_users
(C) wp_usermeta
(D) wp_posts
5. The wp_usermeta table stores:
(A) User roles and capabilities
(B) User passwords
(C) User login details only
(D) User uploaded media
6. Posts, pages, and custom post types are stored in:
(A) wp_content
(B) wp_posts
(C) wp_pages
(D) wp_types
7. Post meta information (custom fields) is stored in:
(A) wp_postmeta
(B) wp_posts
(C) wp_options
(D) wp_terms
8. Taxonomies like categories and tags are stored in:
(A) wp_terms
(B) wp_taxonomies
(C) wp_options
(D) wp_cats
9. The relationships between terms and taxonomies are stored in:
(A) wp_termmeta
(B) wp_term_relationships
(C) wp_postmeta
(D) wp_terms
10. Which table stores taxonomy details (like category, tag, or custom taxonomy type)?
(A) wp_terms
(B) wp_term_taxonomy
(C) wp_termmeta
(D) wp_options
11. WordPress settings (like site URL, admin email) are stored in:
(A) wp_options
(B) wp_settings
(C) wp_meta
(D) wp_config
12. WordPress comments are stored in:
(A) wp_commentmeta
(B) wp_comments
(C) wp_postmeta
(D) wp_users
13. Additional metadata for comments is stored in:
(A) wp_commentmeta
(B) wp_postmeta
(C) wp_meta
(D) wp_users
14. WordPress stores media attachments in:
(A) wp_media
(B) wp_posts
(C) wp_postmeta
(D) wp_uploads
15. Which table stores plugin and theme settings saved by developers?
(A) wp_meta
(B) wp_options
(C) wp_plugins
(D) wp_config
16. Each WordPress table has a unique:
(A) Key and prefix
(B) API and cache
(C) Theme and plugin
(D) None of the above
17. The GUID (Globally Unique Identifier) for a post is stored in:
(A) wp_posts
(B) wp_postmeta
(C) wp_options
(D) wp_terms
18. WordPress stores password hashes using:
(A) MD5 only
(B) PHPass library
(C) Plain text
(D) AES encryption
19. Which column in wp_posts indicates whether a post is published, draft, or private?
(A) post_type
(B) post_status
(C) post_visibility
(D) post_access
20. The “autoload” column in wp_options table determines:
(A) Whether option loads on every page
(B) Whether option is cached
(C) Whether option is deleted automatically
(D) Whether option is related to plugins
21. WordPress stores revisions of posts in which table?
(A) wp_revisions
(B) wp_posts
(C) wp_postmeta
(D) wp_options
22. Relationships between posts and terms (like assigning categories to posts) are stored in:
(A) wp_term_relationships
(B) wp_postmeta
(C) wp_taxonomies
(D) wp_terms
23. Which table stores WooCommerce orders (as custom post type)?
(A) wp_orders
(B) wp_posts
(C) wp_transactions
(D) wp_payments
24. WooCommerce order metadata is stored in:
(A) wp_ordermeta
(B) wp_postmeta
(C) wp_order_details
(D) wp_options
25. WordPress transient API data is stored in:
(A) wp_cache
(B) wp_transients
(C) wp_options
(D) wp_settings
26. User roles and capabilities are stored in:
(A) wp_users
(B) wp_capabilities
(C) wp_options
(D) wp_usermeta
27. Which column in wp_users table stores hashed passwords?
(A) user_password
(B) user_pass
(C) password
(D) wp_pass
28. The “meta_key” and “meta_value” columns are found in:
(A) wp_options
(B) wp_postmeta
(C) wp_commentmeta
(D) All of the above
29. Which table stores default WordPress widgets settings?
(A) wp_widgets
(B) wp_options
(C) wp_meta
(D) wp_settings
30. Custom menus created in WordPress are stored in:
(A) wp_nav_menus
(B) wp_terms and wp_term_taxonomy
(C) wp_postmeta
(D) wp_options
31. Each database table in WordPress uses which storage engine by default?
(A) InnoDB
(B) MyISAM (older installs)
(C) Both depending on WordPress version
(D) None of the above
32. Post content in WordPress is stored in which column of wp_posts?
(A) post_content
(B) post_body
(C) content
(D) post_text
33. WordPress automatically creates how many core database tables on fresh installation?
(A) 8
(B) 10
(C) 12
(D) 15
34. Which table stores the “siteurl” and “home” options?
(A) wp_users
(B) wp_options
(C) wp_posts
(D) wp_config
35. The wp_postmeta table is related to wp_posts using which key?
(A) post_id
(B) meta_id
(C) object_id
(D) user_id
36. WordPress multisite stores network-wide settings in:
(A) wp_multisite
(B) wp_sitemeta
(C) wp_options
(D) wp_sitesettings
37. Each site in a WordPress multisite has:
(A) Its own set of database tables
(B) A shared wp_options table
(C) Only one global wp_users table
(D) Both A and C
38. Which WordPress table stores scheduled cron jobs?
(A) wp_cron
(B) wp_schedules
(C) wp_options
(D) wp_meta
39. Custom post types are stored in:
(A) wp_posts
(B) wp_custom_posts
(C) wp_postmeta
(D) wp_options
40. WordPress database optimization can be performed using:
(A) phpMyAdmin
(B) WP-CLI
(C) Optimization plugins
(D) All of the above
41. The unique identifier for each row in wp_posts is:
(A) post_id
(B) ID
(C) post_key
(D) pid
42. Spam comments are stored in which table before deletion?
(A) wp_spam
(B) wp_comments
(C) wp_commentmeta
(D) wp_postmeta
43. The wp_links table is used for:
(A) Blogroll / links (legacy feature)
(B) Media library
(C) SEO backlinks
(D) User profile links
44. Default WordPress database character set is:
(A) UTF-8
(B) ASCII
(C) ISO-8859-1
(D) UTF-16
45. Which table is least used in modern WordPress versions?
(A) wp_posts
(B) wp_links
(C) wp_terms
(D) wp_options
46. The maximum recommended database size for WordPress performance depends on:
(A) Number of posts, media, and plugins
(B) WordPress version only
(C) PHP version only
(D) None of the above
47. WordPress revisions can cause database bloat in which table?
(A) wp_posts
(B) wp_postmeta
(C) wp_revisions
(D) wp_options
48. WordPress stores session data (if WooCommerce or plugins enable sessions) in:
(A) wp_sessions
(B) wp_usermeta
(C) wp_options
(D) wp_cache
49. The WordPress database abstraction class is:
(A) wp_db
(B) wp_data
(C) wp_query
(D) wpdb
50. Which of the following is TRUE about WordPress database?
(A) It is relational and uses MySQL/MariaDB
(B) All content and settings are stored in database
(C) Media files are NOT stored in DB, only their references are
(D) All of the above
