Unit-II RDBMS - Revision Q & A

A personal database system assumes that no transactions will happen at the same

time on one table. So the tables are not locked by the database system. This concept is known as

______________ This concepts leads to an error.

• Optional Locking, update

• No Locking, Update

• Optional Locking, Insert

• No Locking, Insert

A personal database management system does not lock table automatically.

• True

• False

Expand CTL

• Create Transaction Log

• Central Transaction Lock

• Central Transaction Log

• Correct Transaction Log

ORACLE 9i is a client/server database based on ____________________

• database model

• relational object oriented model

• object based database model

• relational database model

Dynamic SQL execution commands, such as ____________which integrate the

standard SQL statements with a procedural programming language

• INSERT and UPDATE

• INSERT and DELETE

• PREPARE and OPEN

• UPDATE and ALTER

Client communicate with the ORACLE database server through a middle ________ an

interface through a web browser.

• SQL* Plus

• iSQL* Plus

• Query

• none of the above

__________is an ORACLE‟s extension to SQL for creating procedural code to manipulate data.

• SQL

• iSQL

• DML

• PL/SQL

_______________an environment to enter, edit and execute SQL* Plus code (queries) or to run a

client-side script.

• SQL Plus

• iSQL Plus

• SQL Worksheet

• Notepad

__________ is a tool for creating a website which allows user to access ORACLE database through

web pages. It includes a web server.

• ORACLE 9i AS

• ORACLE 9i

• SQL Plus

• iSQL Plus

__________ manages and changes logical transactions.

• Data Control Language (DCL)

• Transaction Control Language (TCL)

• Data Definition Language (DDL)

• Data Manipulation Language (DML)