Oracle Database

1. What is the use of Library cache?

a) Contains User information, such as user privileges

b) Used to store shared SQL

c) Log of changes made to the database

d) All of the Mentioned

2. Which is the smallest unit of storage in an Oracle database?

a) Data Block

b) Segment

c) Extent

d) Data File

3. Which of the following object types below cannot be replicated?

a) Data

b) Sequence

c) View

d) Trigger

4. What is SQL * FORMS ?

a) SQL * FORMS is a 4GL tool for developing and executing Oracle based interactive based application

b) SQL * FORMS is a 3GL tool for connecting to a Database

c) SQL * FORMS is a reporting tool

d) None of the Mentioned

5. Which of the following components comprise an Oracle architecture?

a) Database related background processes

b) Tablespaces

c) Datafiles

d) All of the Mentioned

6. The management information system (MIS) structure with one main computer system is called a

a) Hierarchical MIS structure

b) Distributed MIS structure

c) Centralized MIS structure

d) Decentralized MIS structure

7. You want to be warned automatically when more than 100 sessions are opened with your database instance.Identify the action that would help you achieve this.

a) Set the TRACE_ENABLED parameter to TRUE

b) Set the threshold for the Current Logons Count metric

c) Set the LOG_CHECKPOINT_TO_ALERT parameter to TRUE

d) Set the SESSIONS_PER_USER limit in the profiles used by users

8. Which of the following statements concerning business rules is true?

a) It should be complex

b) It should not be convertible to computer code

c) It may include restrictions

d) All of the Mentioned

Declare 
	fvar number :=null;
	svar number :=5;
   Begin 
	goto <<>>
		if fvar is null then 
			<<>>
		svar:=svar+5;
		end-if;
		End;

What will be the value of svar after execution?

a) Error

b) 10

c) 5

d) None of the Mentioned

10. A _____________ is a set of tables physically stored together as one table that shares a common column

a) Index

b) Object

c) Datafiles

d) Cluster

{"name":"Oracle Database", "url":"https://www.quiz-maker.com/QUT7BG6","txt":"1. What is the use of Library cache?, 2. Which is the smallest unit of storage in an Oracle database?, 3. Which of the following object types below cannot be replicated?","img":"https://www.quiz-maker.com/3012/images/ogquiz.png"}

Quiz Maker