Insert
Modify
Look-up
All of the above E. None of the above
Answer is Right!
Answer is Wrong!
Database systems
2. A relational database management (RDBM) package manages data in more than one file at once. How does it organize these file? As A. tables B. relations C. tuple D. both (a) and (b) E. None of the above
tables
relations
tuple
both (a) and (b) E. None of the above
Answer is Right!
Answer is Wrong!
3. Which of the following is not the responsibility of the utilities component of DBMS software? A. creating the physical and logical designs B. removing flagged records for deletion C. creating and maintaining the data dictionary D. monitoring performance E. None of the above
creating the physical and logical designs
removing flagged records for deletion
creating and maintaining the data dictionary
monitoring performance E. None of the above
Answer is Right!
Answer is Wrong!
4. The database administration function includes A. application programming B. computer operations management C. database access planning D. All of the above E. None of the above
application programming
computer operations management
database access planning
All of the above E. None of the above
Answer is Right!
Answer is Wrong!
5. The master list of an indexed file A. is sorted in ascending order B. contains only a list of keys and record numbers C. has a number assigned to each record D. both (b) and (c) E. None of the above
is sorted in ascending order
contains only a list of keys and record numbers
has a number assigned to each record
both (b) and (c) E. None of the above
Answer is Right!
Answer is Wrong!
6. Which command is used to select distinct subject (SUB) from the table (BOOK)? A. SELECT ALL FROM BOOK B. SELECT DISTINCT SUB FROM BOOK C. SELECT SUB FROM BOOK D. All of the above E. None of the above
SELECT ALL FROM BOOK
SELECT DISTINCT SUB FROM BOOK
SELECT SUB FROM BOOK
All of the above E. None of the above
Answer is Right!
Answer is Wrong!
7. In order to use a record management system A. You need to understand the low-level details of how information in stored B. You need to understand the model the record management system uses. C. Both (a) and (b) D. All of the above E. None of the above
You need to understand the low-level details of how information in stored
You need to understand the model the record management system uses.
Both (a) and (b)
All of the above E. None of the above
Answer is Right!
Answer is Wrong!
8. The physical location of a record is determined by a mathematical formula that transforms a file key into a record location in A. a tree file B. an indexed file C. a hashed file D. a sequential file E. None of the above
a tree file
an indexed file
a hashed file
a sequential file E. None of the above
Answer is Right!
Answer is Wrong!
9. Queries to a database A. are written in English B. can use aggregate functions like SUM and COUNT C. both (a) and (b) D. All of the above E. None of the above
are written in English
can use aggregate functions like SUM and COUNT
both (a) and (b)
All of the above E. None of the above
Answer is Right!
Answer is Wrong!
10. A logical schema A. is the entire database B. is a standard way of organizing information into accessible parts C. describes how data is actually stored on disk D. All of the above E. None of the above
is the entire database
is a standard way of organizing information into accessible parts
describes how data is actually stored on disk
All of the above E. None of the above
Answer is Right!
Answer is Wrong!