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
Discussion
2: ________ is a portion of DML that involves information retrieval.
a. Programming Language         
b. Procedural Language
c. OOP Language
d. Query Language
Discussion
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  
Discussion
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  
Discussion
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
Discussion
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
Discussion
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
Discussion
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
Discussion
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
Discussion
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  
Discussion