Data Storage And Querying set 1

Computer Science offers students courses that focus on data storage and querying for various purposes. This allows students to develop skills in efficient data management and retrieval, which can be applied to a variety of industries.

1: ______ is a special type of integrity constraint that relates two relations & maintains consistency across the relations.
a. Entity Integrity Constraints          
b. Referential Integrity Constraint
c. Domain Integrity Constraints  
d. Domain Constraints
2: ________ is a portion of DML that involves information retrieval.
a. Programming Language         
b. Procedural Language
c. OOP Language
d. Query Language
3: ________ it requires a user to specify what data are needed and how to get those data.
a. Procedural DML      
b. Non Procedural DML
c. Abstract DML
d. None of the above  
4: ________ it requires a user to specify what data are needed without specifying how to get those data.
a. Procedural DML    
b. Non Procedural DML
c. Abstract DML  
d. None of the above  
5: __________ is a contiguous group of blocks allocated for use as part of a table, index, and so forth.
a. Tablespace      
b. Segment
c. Extent
d. Block
6: ___________ combines the data manipulating power of SQL with the data processing power of Procedural languages.
a. PL/SQL    
b. SQL
c. Advanced SQL
d. PQL
7: ___________ is the collection of memory structures and Oracle background processes that operates against an Oracle database.
a. Database       
b. Instance  
c. Tablespace
d. Segment
8: ___________ refers to the ability of the system to recover committed transaction updates if either the system or the storage media fails.
a. Isolation    
b. Atomicity  
c. Consistency
d. Durability
9: ______________ allows the algorithm to execute more quickly by performing CPU activity in parallel with I/O activity.
a. Buffering    
b. Double buffering  
c. Multiple buffering  
d. Double reading
10: _______________ has made PL/SQL code run faster without requiring any additional work on the part of the programmer.
a. SQL Server    
b. My SQL
c. Oracle  
d. SQL Lite