This set of RDBMS Assessment Questions and Answers focuses on “Sql Queries – IV”. 1. Find all the customers who have both a loan and an account at the Perryridge branch 2. Find all customers who do have a loan at the bank, but do not have an account at the bank. 3. Select the … Read more
This set of RDBMS Questions and Answers for Aptitude test focuses on “Sql Queries – III”. 1. Find all the bank customers having a loan, an account, or both at the bank. 2. Find all the bank customers having both a loan and an account at the bank 3. Find all customers who have an … Read more
This set of RDBMS Questions and Answers for Campus interviews focuses on “Sql Queries – II”. 1. Delete the accounts and loans of Downtown branch. 2. Add a column phoneNo to customer table. 3. Change the size of the branch_city to varchar(20). 4. Drop the column phoneNo from customer table. 5. For all customers who … Read more
This set of RDBMS Multiple Choice Questions & Answers (MCQs) focuses on “SQL Queries – I”. 1. List all branch names and their assests 2. List all accounts of Brooklyn branch 3. List all loans with amount > 1000. 4. List all accounts of Perryridge branch with balance < 1000. 5. List Numbers of accounts … Read more
This set of RDBMS Multiple Choice Questions & Answers (MCQs) focuses on “SQL Data Definition Problems (Bank Database Schema)”. Q1) Create a Bank Database schema with the following relations and select an appropriate primary key. account(account_number, branch_name, balance) branch (branch_name, branch_city, assets) customer (customer_name customer_street, customer_city) loan (loan_number, branch_name, amount) depositor((customer_name, account_number) borrower(customer_name, loan_number) NOTE: … Read more
This set of RDBMS Multiple Choice Questions & Answers (MCQs) focuses on “Recovery and Atomicity”. 1. The most widely used structure for recording database modification is called as _______ a) Log b) List c) Queue d) Stack 2. An update log record describes a ________ database write a) Single b) Double c) Triple d) Quadruple … Read more
This set of RDBMS Problems focuses on “Failure Classification and Storage”. 1. Which of the following can cause a transaction failure a) Logical error b) System error c) More than one of the mentioned d) None of the mentioned 2. If the transaction can no longer continue with its normal execution because of some internal … Read more
This set of RDBMS Multiple Choice Questions & Answers (MCQs) focuses on “Insert, Delete Operations and Predicate Reads”. 1. ________ deletes a data item from a database a) Delete(Q) b) Insert(Q) c) Drop(Q) d) None of the mentioned 2. Which of the following does not lock the entire index a) Phantom locking b) Phantom problem … Read more
This set of RDBMS Questions and Answers for Entrance exams focuses on “Multiversion Schemes, Snapshot Isolation”. 1. In _______ schemes, each write operation creates a new version of Q a) Multiversion b) Snapshot isolation c) Lock based d) Timestamp 2. If the first update is overwritten by a second, it is called as a _______ … Read more
This set of RDBMS Multiple Choice Questions & Answers (MCQs) focuses on “Validation Based Protocols”. 1. The _________ requires each transaction executes in two or three different phases in its lifetime a) Validation protocol b) Timestamp protocol c) Deadlock protocol d) View protocol 2. During __________ phase, the system reads data and stores them in … Read more
