Oracle and PL/SQL Online Test

Back

Oracle and PL/SQL

Description: Oracle and PL/SQL Test contains questions on database, SQL server questions
Number of Questions: 15
Created by: Tanya Dwivedi
Tags: Oracle PL SQL questions SQL questions Database questions DB questions IT questions Java/Oracle /C/C++ Computer Basics

Start the Quiz

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

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

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;

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;

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

Alter
Delete
Select
Update
Drop

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

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

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

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

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

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

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

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

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

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

- Hide questions

Oracle and PL/SQL

Find more quizzes from top tags