Oracle Quizzes & Trivia

From deploying SOAs to managing SOAs, the Oracle SOA is one of the most significant software in computing. With its Suite, developers can effectively develop and manage services. Take this quiz assess your knowledge of Oracle SOA.

Questions: 10 | Attempts: 100 | Last updated: Feb 21, 2018

Sample Question
What product does Oracle SOA produce?

Security

Sportswear

Software

Data processing

Oracle Hyperion Planning Assessment Test

Properly accessing the skills of an applicant before an interview is effective with the Oracle Hyperion Planning assessment test. This solution is both Web and Excel-based, and used for planning, budgeting, forecasting, and...

Questions: 10 | Attempts: 100 | Last updated: Feb 22, 2018

Sample Question
What is Oracle Hyperion?

A centralized planning process

A device for storing predictions

A tool for keeping private information

A marketable product

Fun Trivia Question On Paid

You think you know about Paid?Let's find out.

Questions: 15 | Attempts: 100 | Last updated: Apr 7, 2015

Sample Question
Despite a reputation-scarring scandal, what golfer was the top earning U.S. athlete in 2009?

Jim Furyk

Jack Nicklaus

Tiger Woods

Phil Mickelson

Oracle Business Intelligence Suite Enterprise Edition (OBIEE) Quiz

Questions: 18 | Attempts: 98 | Last updated: Oct 24, 2018

Sample Question
Which of the following sections in PL-SQL Anonymous Block

Declare

Exception

Run

Oracle Mock Test 1

Mock test for 10g oracle

Questions: 30 | Attempts: 91 | Last updated: Jan 31, 2013

Sample Question
Evaluate the SQL statement: SELECT ROUND(TRUNC(MOD(1600,10),-1),2) FROM dual; What will be displayed?

0

1

0.00

An error statement

Oracle Dataguard And Active Data Guard

Just the basics on these fine Oracle products

Questions: 3 | Attempts: 84 | Last updated: Jan 28, 2013

Sample Question
Which database editions is Data Guard available for?

Oracle Database Standard Edition One

Oracle Database Standard Edition

Oracle Database Enterprise Edition

Oracle Database Express Edition

Oracle Database Personal Edition

Oracle Quiz-1

Questions: 30 | Attempts: 78 | Last updated: Mar 2, 2012

Sample Question
The DBA issues this SQL command: CREATE USER scott IDENTIFIES by tiger; What privileges does the user Scott have at this point?

No privileges.

Only the SELECT privilege

Only the CONNECT privilege.

All the privileges of a default user

Oracle Test 3

Oracle questions

Questions: 50 | Attempts: 72 | Last updated: Feb 4, 2013

Sample Question
After creating a new user for your Oracle database, a user still complains he or she cannot log in because of insufficient privileges errors. Which of the following actions should you take?

Reset the user's password

Grant create table privileges to the user

. Grant the CONNECT role to the user

. Unlock the user's account

Quiz Questions Over Oracle Software

Based on oracle concepts

Questions: 20 | Attempts: 68 | Last updated: Dec 8, 2017

Sample Question
Databases overall structure is maintained in a file called

Redolog file

Data file

Control file

All of the above

Oracle Mock 2

A view A trigger target A mutating table A constraining table

Questions: 40 | Attempts: 65 | Last updated: Jan 31, 2013

Sample Question
The ALTER FUNCTION statement can be used to do which of the following? (Choose all that apply.)

Modify the list of parameters for a function

Change the program unit's processing section.

Recompile the program unit's code

Create an overloaded function

Oracle Quiz-2

Questions: 30 | Attempts: 60 | Last updated: Mar 2, 2012

Sample Question
1. Which of the following queries can you use to search for employees with the pattern 'A_B' in their names?

SELECT last_name FROM employees WHERE last_name LIKE '%A\_B%' ESCAPE '\\';

SELECT last_name FROM employees WHERE last_name LIKE '%A_B%' ESCAPE;

SELECT last_name FROM employees WHERE last_name LIKE 'A_B%' ESCAPE '%';

SELECT last_name FROM employees WHERE last_name LIKE '%A\_B%' ESCAPE '\';

Oracle Solaris 11 - System Configuration

Questions: 12 | Attempts: 60 | Last updated: Feb 22, 2013

Sample Question
What does SMF stands for ?

System Management Facility

System Media Font

Service Management Facility

Service Management Files

Oracle Solaris 11 - Storage

Questions: 17 | Attempts: 60 | Last updated: Feb 22, 2013

Sample Question
Which among these is the root file system on Oracle Solaris 11 ?

SMP

Admin

Rootvg

ZFS

What Do You Know About Oracle?

Questions about Oracle

Questions: 10 | Attempts: 60 | Last updated: Dec 8, 2017

Sample Question
Cloud computing is a term for computing platforms that provide flexible, scalable resources that are accessed over a network.

True

False

Db Ch8

Questions: 44 | Attempts: 59 | Last updated: Feb 15, 2013

Sample Question
Undercover would could be characterized as a form of

Stationary surveillance

Interactive surveillance

Tactical intervention

Sexual harassment

Oracle 10g Rac

Questions: 7 | Attempts: 56 | Last updated: Jan 16, 2013

Sample Question
Using Oracle Database 10.2 Enterprise Edition, you can create and configure a new ASM instance for a new RAC cluster using which two tools? (Choose two.)

CRSCTL

Oracle Universal Installer (OUI)

Enterprise Manager Grid Control

Database Configuration Assistant (DBCA)

.ASMCMD

Db Ch 10

Questions: 29 | Attempts: 55 | Last updated: Feb 15, 2013

Sample Question
Which statement most accurately reflects the status of robberies in the United States?

Institutions, rather than people, are typically the targets of robberies

Bank robberies are the third most common type of robbery in the U.S.

The overall incidence of robberies has declined since the late 1980's

During the 1990's over two million robberies were reported to police each year

Oracle Forms

Oracle forms quiz

Questions: 10 | Attempts: 52 | Last updated: Jan 21, 2013

Sample Question
Define The Word 'S' in OOPS

Structures

Standards

Specification

Oracle Computer Technology Quiz Questions

Questions: 20 | Attempts: 48 | Last updated: Dec 8, 2017

Sample Question
which sql statement generates the alias annual salary for the calculated column salary*12?

Select ename,salary*12'annual salary' from employee

Select ename,salary*12 as initcap(annual salary)from employee

Select ename,salary*12"annual salary" from employee

Select ename,salary*12 as annual salary from employee

Db Ch 14

Questions: 58 | Attempts: 47 | Last updated: Feb 18, 2013

Sample Question
What are the most likely hours a professional burglary would be committed?

10:00AM - 3:00PM and 7:00PM - 12:00AM

12:00PM - 4:00PM and 12:00AM - 5:00AM

9:00AM - 2:00PM and 6:00PM - 11:00PM

1:00PM - 5:00PM and 9:00PM - 3:00AM

Oracle 10g

Total number of questions : 45 Time :1 hour

Questions: 8 | Attempts: 44 | Last updated: Feb 18, 2013

Sample Question
Consider the following code snippet: declare flag boolean; begin flag:=true; begin flag:=NOT flag; if(flag)then DBMS_OUTPUT.PUT_LINE('Hai'); else DBMS_OUTPUT.PUT_LINE('Hello'); end if; end; end; Which of the following gives the outcome of the above code snippet

The code segment prints Hai.

The code segment prints NULL.

The code segment prints Hello.

Grvmock

Oracle PL/SQL quiz

Questions: 46 | Attempts: 43 | Last updated: Feb 18, 2013

Sample Question
Select incorrect variable declarations

Foo_number varchar2(10);

Foo_text number(10);

Foo_char char(1) := 'Y';

Foo_time date;

Foo_text varchar2(10) := 'hello world';

Oracle Functions And Coding Quiz Questions

Questions: 20 | Attempts: 42 | Last updated: Dec 8, 2017

Sample Question
Which two are attributes of /SQL*Plus? (Choose two)

A. /SQL*Plus commands cannot be abbreviated.

B. /SQL*Plus commands are accesses from a browser.

C. /SQL*Plus commands are used to manipulate data in tables.

D. /SQL*Plus commands manipulate table definitions in the database.

E. /SQL*Plus is the Oracle proprietary interface for executing SQL statements.

Db Ch 13

Questions: 48 | Attempts: 41 | Last updated: Feb 15, 2013

Sample Question
Which is the most common form of physical child abuse?

Burns on the abdomen and arms

Kicking uncontrollably

Repeated slaps to the face

Excessive beating

Multiple Choice Quiz Questions Of Oracle

Questions: 30 | Attempts: 39 | Last updated: Dec 8, 2017

Sample Question
Which two statements are true about rebuilding an index? (Choose two.)

The resulting index may contain deleted entries.

A new index is built using an existing index as the data source.

Queries cannot use the existing index while the new index is being built.

During a rebuild, sufficient space is needed to accommodate both the old and the new index in their respective tablespaces.

« Previous 123 4 Next »