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.
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
Answer & Solution
No Solution for this Answer..! Report or Discus this Question
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
Answer & Solution
No Solution for this Answer..! Report or Discus this Question
4. Relational schema and other metadata about relations are stored in a structure called the ____________ .
Metadata
Catalog
Log
Data Dictionary
Answer & Solution
No Solution for this Answer..! Report or Discus this Question
5. ___________ is the collection of memory structures and Oracle background processes that operates against an Oracle database.
Database
Instance
Tablespace
Segment
Answer & Solution
No Solution for this Answer..! Report or Discus this Question
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
Answer & Solution
No Solution for this Answer..! Report or Discus this Question
7. A tablespace is further broken down into ________
Tablespace
Segments
Extents
Blocks
Answer & Solution
No Solution for this Answer..! Report or Discus this Question
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
Answer & Solution
No Solution for this Answer..! Report or Discus this Question
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
Answer & Solution
No Solution for this Answer..! Report or Discus this Question
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
Answer & Solution
No Solution for this Answer..! Report or Discus this Question
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
Answer & Solution
No Solution for this Answer..! Report or Discus this Question
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
Answer & Solution
No Solution for this Answer..! Report or Discus this Question
15. The full form of DDL is
Dynamic Data Language
Detailed Data Language
Data Definition Language
Data Derivation Language
Answer & Solution
No Solution for this Answer..! Report or Discus this Question