Oracle and PL/SQL

Question 1 Multiple Choice (Single Answer)

Which of the following files in oracle is very useful in the event of a failure and is used for recovery purposes?

Parameter file
Archive file
Password file
Data files
Control files

Question 2 Multiple Choice (Single Answer)

Which of the following files is used in oracle in the event of an instance failure?

Data files
Control files
Redo log files
Password file
Parameter file

Question 3 Multiple Choice (Single Answer)

Which of the following queries returns the number of rows in the table student?

select count()from student;
select count(*)from student;
select No_Rows_Tablefrom student;
select max(age)from student;
select min(salary)from student;

Question 4 Multiple Choice (Single Answer)

Which of the following is the correct query to display name of student from the student table having name as 'aman' or 'harish'?

select name from studentwhere name ='aman' and 'harish';
select 'aman' and 'harish'from student;
select namefrom studentwhere name like 'aman' or name like 'harish';
select name from studentwhere name is 'aman' and 'harish';
select 'aman' and 'harish'from studentwhere name = student;

Question 5 Multiple Choice (Single Answer)

Which of the following object privileges in SQL is not supported by the Grant command?

Alter
Delete
Select
Update
Drop

Question 6 Multiple Choice (Single Answer)

Which of the following modes of shutdown in oracle allows oracle server to automatically rolls back all currently active transactions?

Normal
Abort
Immediate
Transactional
Force shutdown

Question 7 Multiple Choice (Single Answer)

Which of the following parameters in the create sequence command of SQL specifies that the values of the sequence are not preallocated?

Order
Nocache
Cache
Cycle
Start with

Question 8 Multiple Choice (Single Answer)

Which of the following segments in oracle is/are created when the application creates the table or cluster with the Create command?

Index segments
Temporary segments
Data segments
Rollback segments
Error segments

Question 9 Multiple Choice (Single Answer)

Which of the following components of SGA is/are shared by multiple users as the contents of its memory area?

Redo Log Buffer
Java Pool
Shared Pool
Large Pool
Streams Pool

Question 10 Multiple Choice (Single Answer)

Which of the following schemas in a distributed database specifies that the fragments are really the logical portions of the global relation which are physically dispersed at different sites of the network, and defines at which site a fragment is allocated?

Global schema
Fragmentation schema
Allocation schema
Local mapping schema
Data dictionary

Question 11 Multiple Choice (Single Answer)

Which of the following components of data block in oracle contains information about tables that have data in the data block?

Header
Table directory
Row directory
Row data
Free space

Question 12 Multiple Choice (Single Answer)

Which of the following types of cursors is/are declared and used by the user to process multiple rows returned by Select statement?

Implicit cursors
Explicit cursors
Open the cursor
Closing cursor
Active set

Question 13 Multiple Choice (Single Answer)

Which of the following statements in SQL allows users to control the properties of their current session by enabling or disabling roles of users and changing language settings?

DML Statements
System Control Statements
Embedded SQL Statements
Session Control Statements
Transaction Control Statements

Question 14 Multiple Choice (Single Answer)

Which of the following components of oracle process in the background performs process recovery when a user processor fails?

Processor monitor
System monitor
Recoverer process
Dispatcher
Lock processor

Question 15 Multiple Choice (Single Answer)

Which of the following statements is used to add methods but not attributes to an object type stored in the database?

Select
Update
Alter type
Grant
Revoke

Questions