DBMS Concepts & SQL Essentials MCQs
1. What is the primary function of a Relational Database Management System (RDBMS) such as Oracle or MySQL? A) Managing data storage on physical disksB) ...
Read more1. What is the primary function of a Relational Database Management System (RDBMS) such as Oracle or MySQL? A) Managing data storage on physical disksB) ...
Read more1. What is the primary purpose of concurrency control in database management systems? a) To ensure consistency and isolation of transactionsb) To maximize throughput and ...
Read more1. What is a transaction system?a) A system for handling financial transactions onlyb) A system for managing database operations that ensures ACID propertiesc) A system ...
Read more1. What is normalization in database design? a) Organizing data in random orderb) Structuring data to eliminate redundancy and dependencyc) Adding random data to the ...
Read more1. What is a tuple in a relational data model?a) A column in a tableb) A row in a tablec) A unique identifier in a ...
Read more1. What is the primary difference between a database approach and a traditional file accessing approach?a) Database approach provides centralized data storage, while traditional approach ...
Read more1. Which technique allows a Turing machine to simulate any other Turing machine with an arbitrary input? a) Multitape Turing machineb) Multihead Turing machinec) Universal ...
Read more1. Which of the following is an example of a Pushdown Automaton (PDA)? a) Deterministic Finite Automaton (DFA)\b) Non-deterministic Finite Automaton (NFA)\c) Deterministic Pushdown Automaton ...
Read more1. Which of the following is NOT a type of grammar in Chomsky hierarchy?a) Context-sensitive grammarb) Regular grammarc) Linear grammard) Context-free grammar Answer: c) Linear ...
Read more1. Which of the following is NOT a type of Finite Automata?A) NDFAB) DFAC) PDAD) 2-way DFAAnswer: C) PDAExplanation: Finite Automata includes NDFA (Non-Deterministic Finite ...
Read more