BCA - IV SEM DBMS

Cartesian product in relational algebra is

• Unary operator

• Binary operator

• Ternary operator

• Not defined

ODBC stands for

• Object Database Connectivity.

• Oral Database Connectivity.

• Oracle Database Connectivity.

• Open Database Connectivity.

DML is provided for

• Description of the logical structure of a database.

• The addition of new structures in the database system.

• Manipulation & processing of the database.

• Definition of a physical structure of the database system.

The view of total database content is

• Conceptual view

• Internal view

• External view

• Physical View

Architecture of the database can be viewed as

• two levels

• four levels

• three levels

• one level

In the architecture of a database system external level is the

• Physical level

• Logical level

• Conceptual level

• View level.

The database schema is written in

• HLL

• DML

• DDL

• DCL

An entity set that does not have sufficient attributes to form a primary key is a

• Strong entity set

• Weak entity set

• Simple entity set

• Primary entity set

In an E-R diagram attributes are represented by

• Rectangle

• Square.

• Ellipse

• Triangle.

A logical Schema

• is the entire database.

• is a standard way of organising information into accessible parts.

• describes how data is actually stored on disk.

• both (A) and (C)