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 more

Control Techniques MCQs

1. 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 more

Transaction Processing Concepts MCQs

1. 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 more

Data Base Design MCQs

1. 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 more

Relational Data models MCQs

1. 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 more

Database Management System (DBMS) MCQs

1. 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 more

Turing Machine MCQs

1. 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 more

Push down Automata MCQs

1. 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 more

Grammars MCQs

1. 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 more

Finite Automata MCQs

1. 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