DBMS-Introduction to Database Design Questions and Answers

Practice Mode
Showing 10 of 50 questions
Q41
What is database view?
  • A Virtual table from query
  • B Physical storage table
  • C Backup copy
  • D Temporary table
Answer: Option A
Explanation: A view is a virtual table based on the result of a SQL query, providing a customized data perspective.
Q42
Which normal form is the highest for most practical purposes?
  • A Boyce-Codd Normal Form
  • B Third Normal Form
  • C Fourth Normal Form
  • D Fifth Normal Form
Answer: Option A
Explanation: Boyce-Codd Normal Form (BCNF) is stronger than 3NF and sufficient for most database designs.
Q43
What is data mining?
  • A Pattern discovery in data
  • B Data storage optimization
  • C Data encryption
  • D User interface design
Answer: Option A
Explanation: Data mining discovers patterns and relationships in large datasets to extract valuable information.
Q44
Which SQL clause sorts results?
  • A ORDER BY
  • B SORT BY
  • C ARRANGE BY
  • D GROUP BY
Answer: Option A
Explanation: ORDER BY clause sorts the result set in ascending or descending order based on specified columns.
Q45
What is database transaction?
  • A Logical unit of work
  • B Database table
  • C User account
  • D Backup file
Answer: Option A
Explanation: A transaction is a logical unit of work that contains one or more SQL statements, following ACID properties.
Q46
Which key uniquely identifies records in a table?
  • A Primary key
  • B Foreign key
  • C Candidate key
  • D Super key
Answer: Option A
Explanation: Primary key uniquely identifies each record in a table and must contain unique, non-null values.
Q47
What is concurrency control?
  • A Manage simultaneous operations
  • B Data encryption
  • C Backup creation
  • D User authentication
Answer: Option A
Explanation: Concurrency control manages simultaneous operations on the database without conflict, ensuring data consistency.
Q48
Which SQL command retrieves data?
  • A SELECT
  • B GET
  • C FETCH
  • D RETRIEVE
Answer: Option A
Explanation: SELECT command retrieves data from one or more database tables based on specified criteria.
Q49
What is database backup?
  • A Data protection copy
  • B Data encryption
  • C Data compression
  • D Data transmission
Answer: Option A
Explanation: Database backup creates copies of data to restore in case of data loss, corruption, or system failure.
Q50
Which constraint defines primary key?
  • A PRIMARY KEY
  • B FOREIGN KEY
  • C UNIQUE
  • D NOT NULL
Answer: Option A
Explanation: PRIMARY KEY constraint uniquely identifies each record and automatically creates a unique index.

📚 More from Database

← All Topics 🎯 Practice ⏱️ Take Test 🔍 Search
Database
Back to Database
Other Subjects
Questions and Answers for Competitive Exams Various Entrance Test