Q. Select course_id
from physics_fall_2009
where building= ’Watson’;

Here the tuples are selected from the view.Which one denotes the view ?

View solution

Q. Materialised views make sure that

View solution

Q. Updating the value of the view

View solution

Q. SQL view is said to be updatable (that is, inserts, updates or deletes can be applied on the view) if which of the following conditions are satisfied by the query defining the view?

View solution

Q. Which of the following is used at the end of the view to reject the tuples which do not satisfy the condition in where clause ?

View solution

Q. A relational database system needs to maintain data about the relations, such as the schema of the relations. This is called

View solution

Q. Relational schema and other metadata about relations are stored in a structure called the ____________ .

View solution

Q. ___________ is the collection of memory structures and Oracle background processes that operates against an Oracle database.

View solution

Q. A ________ is a logical grouping of database objects, usually to facilitate security, performance, or the availability of database objects such as tables and indexes.

View solution

Q. A tablespace is further broken down into ________

View solution

Q. __________ is a contiguous group of blocks allocated for use as part of a table, index, and so forth.

View solution

Q. ________ is the smallest unit of allocation in an Oracle database.

View solution

Q. DML is provided for

View solution

Q. The language used in application programs to request data from the DBMS is referred to as the

View solution

Q. The way a particular application views the data from the database that the application uses is a

View solution

Q. The DBMS language component which can be embedded in a program is

View solution

Q. A DBMS query language is designed to

View solution

Q. The full form of DDL is

View solution

Q. DDL Stands for ___________.

View solution

Q. DML Stands for _____________.

View solution