DataBase Management System Objective Type Questions And Answers

1) A multiple - form file management system  ?

1. Lets you define different forms for different operations
2. Lets you create a look up form with an associated read only password to prevent access by unauthorized users.
3. Both A and B
4. Allows you to entry data in all the forms
5. None of above

Show/Hide Answer

Answer = C 
Explanation:Multiple form management system allows to perform different operations along with checks for the unauthorized access.

2) Embedded pointer provide ?

1. A secondary access path
2. A physical record key
3. An inverted index
4. None of above

Show/Hide Answer

Answer = A 
Explanation: Embedded pointer is a pointer set in a data record instead of in a directory. 

3) In relational schema, each tuple is divided into fields called ?

1. Relations
2. Domains
3. Queries
4. All of above

Show/Hide Answer

Answer = B 
Explanation:No Explanation

4) A logical schema ?

1. is the entire database
2. is a standard way of organizing information into accessible parts
3. describes how data is actually stored on disk
4. All of above

Show/Hide Answer

Answer =B 
Explanation: A logical schema is a data model of a specific problem domain expressed in terms of a particular data management technology.

5) Administrate supervision of database activity is the responsibility of ?

1. Database administrator
2. DP Manager
3. DB Manager
4. DP Administration
5. None of above

Show/Hide Answer

Answer = A 
Explanation: No Explanation

6) What software packages are commonly for business that have to track extensive lists of clients and inventory?

1. Special purpose packages
2. Custom made programs
3. Single function application packages
4. Data management packages
5. None of above

Show/Hide Answer

Answer = D 
Explanation: No Explanation

7) Periodically adding, changing and deleting file records is called file ?

1. updating
2. upgrading
3. restructuring
4. renewing
5. None of above

Show/Hide Answer

Answer = A
Explanation: No Explanation

8)  Data security threats include ?

1. hardware failure
2. privacy invasion
3. fraudulent manipulation of data
4. All of above

Show/Hide Answer

Answer = B 
Explanation: No Explanation

9) The online soft copy display a customer's charge account to respond to an inquiry is an example of  ?

1. forecasting report
2. exception report
3. regularly scheduled report
4. on demand report

Show/Hide Answer

Answer = D
Explanation: No Explanation

10) In order to understand DBMS, it is important to understand?

1. the physical schema
2. all sub schema that are system support
3. one sub schema
4. Both A and B
5. None of above

Show/Hide Answer

Answer = C 
Explanation:No Explanation

‹‹ Previous

Next ››

Do You Like This? Please take 5 seconds to share with your firends.