RDBMS Objective Questions

RDBMS Multiple Choice Questions on “Nested SubQueries”. 1. What is a subquery? a) A subquery is a select-from-where expression that […]

RDBMS Multiple Choice Questions on “Decomposition Algorithms”. 1. What does the BCNF decomposition algorithm do? a) States a method to

RDBMS Multiple Choice Questions on “Join and Other Operations”. 1. A join of the form r ⨝r.A=s.B s is called

RDBMS Problems on “Failure Classification and Storage”. 1. Which of the following can cause a transaction failure a) Logical error

RDBMS Interview Questions and Answers on “Modification of Database”. 1. Insert the appropriate key word in the blank in the

RDBMS Multiple Choice Questions on “Database Design Process”. 1. Which of the following is not a process of generating a

RDBMS Multiple Choice Questions on “Evaluation of Expressions”. 1. If the results of one operation are passed on to the

RDBMS Multiple Choice Questions on “Recovery and Atomicity”. 1. The most widely used structure for recording database modification is called

RDBMS Multiple Choice Questions on “Join Expressions”. 1. The on condition appears at the _______ of the join expression a)

RDBMS Multiple Choice Questions on “Web Fundamentals”. 1. Browsers use a standardized syntax called? a) TCP/IP b) HTML c) XML

RDBMS online test on “Transformation of Relational Expressions”. 1. If on every legal database instant, the two expressions generate the

RDBMS Multiple Choice Questions on “SQL Queries”. 1. List all branch names and their assests Answer: select branch_name, assets from

RDBMS Multiple Choice Questions on “Views and Transactions”. 1. What is a view? a) An brief description of the schema

RDBMS Multiple Choice Questions on “Servlets and JSP”. 1. The _______ specification defines an application programming interface for communication between

RDBMS Multiple Choice Questions on “Estimating Statistics of Expression Results”. 1. Which of the following information does the database system