BC0050-Oracle & Distributed Databases Model Question Paper

BC0050-Oracle & Distributed Databases Model Question Paper

Info iconThis preview shows pages 1–5. Sign up to view the full content.

View Full Document Right Arrow Icon
Model Question Paper Subject Code: BC0050 Subject Name: Oracle & Distributed Databases Credits: 4 Marks: 140 Part A (One mark questions) 1. A schema is a collection of all objects that a user has created. A) Schema B) Data C) Database D) Relation 2. The ______ attribute is used to declare variables based on definitions of columns in a table. A) %TYPE B) %ATTRIBUTE C) %ROWSET D) %NOTFOUND 3. The DBA creates a account in the database for each user who needs access. A) bank B) fictitious C) user D) nominee 4. ____ security includes monitoring and assigning users permissions to the various objects in the database. A) Database B) Relation C) Functional D) Data 5. Procedures and Functions are stored in the ______________
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
A) Package B) Memory C) Oracle Database D) RAM 6. A _______ is an Oracle object that holds which holds other objects within it. A) Package B) Memory C) Oracle Database D) RAM 7. Procedure declaration resembles a function declaration except that there is no _______. A) Data B) Data Type C) Function type D) SQL Type 8. A _____is a data base object, like a table or an index. A) database B) view C) Synonym D) trigger 9. The combination of HTTP clients, Application Server, and Oracle database together is called _________. A) Suite B) Developer Suite C) Oracle 9i Developer Suite D) Oracle database 10. The ______ offers a comprehensive set of middle – tier services. A) Client Applications B) Server Applications C) Business logic D) Application Server
Background image of page 2
11. Opening a _____ executes the query and identifies the active set that contains all the rows, which meet the query search criteria. A) Cursor B) Trigger C) Table D) View 12. Whenever any cursor (explicit or implicit ) is opened and used, ORACLE creates a set of _______system variables via which ORACLE keep track of the "current status" of the cursor. A) One B) Two C) Four D) Three 13. A ________reliably manages a large amount of data in a multiuser environment so that many users can concurrently access the same data. A) Server B) Database C) Client D) User 14. The ___________ objects are the logical structures that directly refer to the database's data which include structures like tables, views, and indexes. A) Database B) Server C) Schema D) Software 15. Oracle stores records relating to each other in a _______. A) table B) field C) column D) cursor
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
16. The _______ is the Oracle database management system that is able to store, manage and manipulate data. A) Oracle Instance B) Oracle Server C) Oracle Database D) Relation 17. A _______ is a network of databases managed by multiple database servers used together. A) Centralized Databases B) Distributed Databases C) Local Databases D) Physical Databases 18. The _________ concept is used to convert user transactions to data manipulation instructions.
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 20

BC0050-Oracle & Distributed Databases Model Question Paper

This preview shows document pages 1 - 5. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online