Basic Database Terminology MCQ

Test your knowledge with important Basic Database Terminology MCQ and their applications. These MCQs are beneficial for competitive exams too. Explore 30 + more Basic Database Terminology MCQs at Bissoy

• In MySQL databases, the structure representing the organizational views of the entire databases is ____________
  ক

  Schema

  খ

  View

  গ

  Instance

  ঘ

  Table
• The MySQL server used in its client/server architecture is _______________
  ক

  mysqla

  খ

  mysqlb

  গ

  mysqlc

  ঘ

  mysqld
• Which is the MySQL instance responsible for data processing?
  ক

  MySQL client

  খ

  MySQL server

  গ

  SQL

  ঘ

  Server daemon program
• How is communication established with MySQL?
  ক

  SQL

  খ

  Network calls

  গ

  A programming language like C++

  ঘ

  APIs
• What represents a ‘tuple’ in a relational database?
  ক

  Table

  খ

  Row

  গ

  Column

  ঘ

  Object
• What represents an ‘attribute’ in a relational database?
  ক

  Table

  খ

  Row

  গ

  Column

  ঘ

  Object
• MySQL is freely available and is open source.
  ক

  True

  খ

  False
• What is data in a MySQL database organized into?
  ক

  Objects

  খ

  Tables

  গ

  Networks

  ঘ

  File systems
• Which type of database management system is MySQL?
  ক

  Object-oriented

  খ

  Hierarchical

  গ

  Relational

  ঘ

  Network