Trinity - Oracle Interview Preparation Questions
Call
whatsapp
9447387064 | 9847003556
0471-2335855 | 8089080088 | 0471-2334855
9447387064 | 9847003556
0471-2335855 | 8089080088 | 0471-2334855
Cisco Training in Trivandrum, Trinity Technologies

No.1 Training Institute in Kerala

ORACLE QUESTIONS : PART 1

Which of the following components comprise an Oracle architecture? 

Database related background processes

Tablespaces

Datafiles

All of the Mentioned

SHOW ANSWER

The ____________ contains a set of tables and views that Oracle uses as a reference to the database.

PGA

Library cache

Data dictionary

SGA

SHOW ANSWER

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

Data Block

Segment

Extent

Data File 

SHOW ANSWER

Oracle database’s design is also called as_____________

Database Abstraction

Database Instance

Database Schema

None of the Mentioned

SHOW ANSWER

What are the valid Oracle database schemas?

Logical Schema

Physical Schema

Logical and Physical Schema

None of the Mentioned

SHOW ANSWER

A _______________ is used to logically group data together

Database

Tablespace

Datafiles

Object

SHOW ANSWER

Below is the EMP table

 

EMPNO

ENAME

SALARY

A29

PANKAJ
10000
A23
SAHIL
20000
A48
ABHYUDAY

 

A83 
KRISHNA
30000 

 

Select count(SALARY) from EMP; will result in

1

0

3

None of the Mentioned

SHOW ANSWER

Which of the following queries displays the sum of all employee salaries for those employees not making commission, for each job, including only those sums greater than 2500?

select job, sum(Sal) from Emp where sum(Sal) > 2500 and comm is null;

select job, sum(Sal) from Emp where comm is null group by job having sum(Sal) > 2500;

select job, sum(Sal) from Emp where sum(Sal) > 2500 and comm is null group by job;

select job, sum(Sal) from Emp group by job having sum(Sal) > 2500 and comm is not null;

SHOW ANSWER

The ORDER BY clause can only be used in ___________ 

SELECT queries

INSERT queries

GROUP BY queries

HAVING queries

SHOW ANSWER

When a transaction modifies the database, Oracle copies the original data before modifying it. The original copy of the modified data is called

Undone Data

Archive Data

Redo Data

Undo Data

SHOW ANSWER

Database management systems are intended to _____________

 Eliminate data redundancy

Establish relationship among records in different files

Manage file access

All of the Mentioned

SHOW ANSWER

The language used application programs to request data from the DBMS is referred to as the

DML

DDL

Query language

All of the Mentioned

SHOW ANSWER

A collection of data designed to be used by different people is called a/an 

Organization

Database

Relationship

Schema

SHOW ANSWER
BACK | NEXT
TRINITY SOFTWARE SOLUTIONS,IInd floor, Radheyam Towers, Gandhari Amman Kovil Road, Pulimood, Trivandrum - 1
0471-2334855 | 2335855 | 9447387064 | 9847003556 info@trinitytechnology.in