Data Storage and Querying Mcqs

Our collections of Multiple choice questions and answers focuses on study of Data Storage and Querying. These questions are chosen from a collection of most authoritative and best reference books on DBMS. Our aim is to prepare an individual for competitive exams like NTS | GAT | ECAT | Data Warehouse jobs | Data Mining | DB administration jobs | Nadra Jobs | Software House and Data Base and Web Developer jobs | University and College entrance exams and various tests and job interviews. One should practice our Mcqs to assimilate Data Storage and Querying in DBMS comprehensively.

  1. Home
  2. »
  3. Computer Science Mcqs
  4. »
  5. DBMS Mcqs
  6. »
  7. Data Storage and Querying Mcqs

1.
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?

The from clause has only one database relation.

The query does not have a group by or having clause.

The select clause contains only attribute names of the relation, and does not have any expressions, aggregates, or distinct specification.

All of the mentioned

2.
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 ?

With

Check

With check

All of the mentioned

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

Metadata

Catalog

Log

Dictionary

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

Metadata

Catalog

Log

Data Dictionary

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

Database

Instance

Tablespace

Segment

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

Tablespace

Segments

Extents

Blocks

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

Tablespace

Segment

Extent

Block

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

Database

Instance

Tablespace

Database Block

10.
DML is provided for

Description of logical structure of database

Addition of new structures in the database system

Manipulation & processing of database

Definition of physical structure of database system

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

DML

DDL

VDL

SDL

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

Module

Relational model

Schema

Sub schema

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

The data definition language (DDL)

The data manipulation language (DML)

The database administrator (DBA)

A query language

14.
A DBMS query language is designed to

Support end users who use English-like commands.

Support in the development of complex applications software.

Specify the structure of a database.

All of the above

15.
The full form of DDL is

Dynamic Data Language

Detailed Data Language

Data Definition Language

Data Derivation Language

error: You are not allowed to do so.....
0Shares
0
Scroll to Top