Database Structure WordPress MCQs

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