Computer Science
Class-VIII
Chapter-6 Introduction to Oracle
A. Tick and write the correct answer:
1. An ________ is a computer program that does some task.
a. user b. interface c. variable d. application
Answer: application
2. A user can use a full scale ________ language such as COBOL, C, or C++.
a. programming b. compiler c. database d. text
Answer: programming
3. Database applications have their own requirements, interfaces and ______.
a. variable b. string c. languages d. mechanism
Answer: languages
4. Modern applications generally consist of a graphical user interface with menus, tool bars, dialog boxes, and __________ that displays the application objects.
a. application b. windows c. sub menu d. language
Answer: windows
5. Developer/2000 tools are more limited than a ______ language.
a. compiler b. database c. text d. programming
Answer: programming
6. A user can use any amount of free text and ______ of any description.
a. fonts b. size c. effects d. preview
Answer: fonts
7. A database manager is a software system that lets you query, manipulate, and control data through the database language.
a. COBOL b. C c. SQL d. C++
Answer: SQL
8. _________ is the ability of the database manager to recover from transactions, application, system, and media failures.
a. application b. recovery c. data d. security
Answer: recovery
9. The abstraction comes from the concept of the _________.
a. transaction b. preview c. programming d. mechanism
Answer: transaction
10. The database manager provides such a strong_________ model.
a. recovery b. security c. abstraction d. language
Answer: security
B. Write true or false:
1. Database applications have their own requirements, interfaces and languages.
Answer: T
2. The two kinds of objects of interest are forms and reports.
Answer: T
3. The first version of the forms component of Developer/2000 was the IPG.
Answer: F
4. Forms also provide a way of entering and changing the information.
Answer: T
5. A transaction is a logical unit of work.
Answer: T
6. The process of restarting the database rolls back all the active transactions.
Answer: T
7. Most applications tend to commit the changes or to ask what to do.
Answer: T
8. Concurrency is the ability for multiple processes to access the database at the same time.
Answer: T
9. ORACLE7 handles security by locking tables and rows in different ways.
Answer: F
10. ORACLE7 gives you a very low level of concurrency and does so automatically.
Answer: F
C. Fill in the blanks:
1. A database applicaation is a program that uses data from a database management system such as ________.
Answer: ORACLE7
2. The form provides a good way to view the __________ that the application shows you.
Answer: infromation
3. The form can display a single________at a time or it can display several at once.
Answer: record
4. You should spend ample time on _____________, design, and testing to create the value in your applicatioin.
Answer: requirement
5. The database manager can figure out what to do when a ________ parts.
Answer: failure
6. The bad part is the complexity of the locking ________.
Answer: mechanism
7. Database theorists divided their architecture into___________ parts.
Answer: three
8. ____________ is the protection of the database against unauthorised access or change.
Answer: security
9. Developer/2000 and __________ combine to provide a high level of security for your applications.
Answer: ORACLE7
10. The second level of security is the ___________ authorisation system.
Answer: schema
D. Answer the following questions:
1. What is database application?
Answer: A database application is a program that uses data from a database management system such as ORACLE7.
2. What are the two kinds of objects of internet?
Answer: Two kinds of objects of internet are forms and reports.
3. What is applicaiton generator?
Answer: An application generator is a tool that builds application mainly through declarative specification of the application.
4. What are the two processes of locking tables?
Answer: If you specify a SHARE lock for the subpartition, then the database acquires an implicit ROW SHARE lock on the table. If you specify an EXCLUSIVE lock for the subpartition, then the database acquires an implicit ROW EXCLUSIVE lock on the table.
5. In how many parts did the database theorists divide?
Answer: Database theorists divided their architecture into three parts: the physical aspect, logical aspects and the logical aspects of the shared application views of the data.
6. What gives a way to eliminate password protection for users?
Answer: ORACLE7 gives you a way to eliminate password protection for users.
Some other Links:
.png)
No comments:
Post a Comment