Oracle Quizzes & Trivia

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

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

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.

Oracle Model Test 04

ORACLE MODEL TEST 04

26/11/2011

Questions: 50 | Attempts: 34 | Last updated: Nov 25, 2011

Sample Question
Examine the structure of student table: Name Null Type STU ID NAME VARCHER2( 2N5O) T NULL NUMBER(3) ADDRESS VARCHER2(50) GRADUATION DATE Currently the table is empty. You have decided that null values should not be allowed for the NAME column. Which statement restricts NULL values from being entered into column?

A.ALTER TABLE student ADD CONSTRAINT name(NOT NULL);

B. ALTER TABLE student ADD CONSTRAINT NOT NULL (name);

C. ALTER TABLE student MODIFY(name varcher2(25) NOT NULL);

D. ALTER TABLE student MODIFY CONSTRAINT name(NOT NULL);

Oracle 11g New Features_15 March

Oracle 11g New Features

Questions: 14 | Attempts: 32 | Last updated: Mar 13, 2013

Sample Question
Which of the following is a type of segment in Oracle?

Views

Tables

Procedures

Partitions

Oracle Constraints By Blue Blaze

ORACLE CONSTRAINTS BY BLUE BLAZE

Questions: 20 | Attempts: 32 | Last updated: Jan 31, 2013

Sample Question
WHERE clauses allows alias names.

True

False

Db Ch 18

DB CH 18

Questions: 15 | Attempts: 31 | Last updated: Feb 18, 2013

Sample Question
Who is usually the main witness in a criminal case?

The patrol officer

The victim

The defendant

The investigator

Oracle Test 5

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

Sample Question
1. Evaluate the SQL statement: 1 SELECT a.emp_name, a.sal, a.dept_id, b.maxsal 2 FROM employees a, 3 (SELECT dept_id, MAX(sal) maxsal 4. FROM employees 5 GROUP BY dept_id) b 6 WHERE a.dept_id = b.dept_id 7 AND a.sal < b.maxsal; What is the result of the statement?

The statement produces an error at line 1.

The state ment produces an error at line 3.

The statement produces an error at line 6.

The statement returns the employee name, salary, department ID, and maximum salary earned in the department of the employee for all departments that pay less salary then the maximum salary paid in the company.

The statement returns the employee name, salary, department ID, and maximum salary earned in the department of the employee for all employees who earn less than the maximum salary in their department.

Oracle Preparatory Exam-1

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

Sample Question
Examine this package specification and body: CREATE OR REPLACE PACKAGE theater_pck IS PROCEDURE find_seats_sold (v_movie_id IN NUMBER DEFAULT 34, v_theater_id IN NUMBER); END theater_pck; CREATE OR REPLACE PACKAGE BODY theater_pck IS current_avg_cost_per_ticket NUMBER; PROCEDURE find_seats_sold (v_movie_id IN NUMBER DEFAULT 34, v_theater_id IN NUMBER) IS v_seats_sold gross_receipt.seats_sold%TYPE; v_budget studio.yearly_budget%TYPE; BEGIN SELECT seats_sold INTO v_seats_sold FROM gross_receipt WHERE movie_id = v_movie_id AND theater_id = v_theater_id; END find_seats_sold; FUNCTION get_budget (v_studio_id IN NUMBER) RETURN number IS v_yearly_budget NUMBER; BEGIN SELECT yearly_budget INTO v_yearly_budget FROM studio WHERE id = v_studio_id; RETURN v_yearly_budget; END get_budget; END theater_pck; Which will successfully invoke the FIND_SEATS_SOLD procedure within SQL*Plus?

EXECUTE find_seats_sold (500,11);

Theater_pck.find_seats_sold (500,11);

EXECUTE theater_pck.find_seats_sold (500,11);

SELECT find_seats_sold(movie_id, theater_id) FROM gross_receipt;

Halian Oracle Test

Halian Oracle test

Welcome, This is an oracle 10g test

Questions: 40 | Attempts: 29 | Last updated: Jan 7, 2013

Sample Question
To successfully complete the installation of Oracle 10g, which disk size do you need?

800MB

1.2GB

1.5GB

Db Ch11

DB CH11

Questions: 65 | Attempts: 28 | Last updated: Feb 15, 2013

Sample Question
Which is NOT an accurate statement regarding the crime of assault?

Finding the perpetrator in cases of assault is generally an easy task for police to accomplish

The crime of assault has decreased in the last decade

Nearly half of all violent crimes in the 1990's were for aggravated assault

About seventy percent of assault victims are acquainted with their attackers

Db Ch 17

DB CH 17

Questions: 21 | Attempts: 27 | Last updated: Feb 18, 2013

Sample Question
Which is the bext example of the technique called "flooding"?

Filling a small foreign nation with drug money

Spreading a false rumor of a takeover of a company to inflate the price of the company's stock

Ordering merchandise from a foreign company at an inflated price and hiding the difference in a secret account

Saturating a residential area with a home repair con game and then leaving without finishing the repairs

Ilp Oracle Quiz Prelims 1

ILP Oracle Quiz Prelims 1

Oracle Quiz Prelims 1

Questions: 16 | Attempts: 25 | Last updated: Feb 22, 2013

Sample Question
Which table name is valid?

Invoices-1996

Catch_#22

1996_invoices

.#_667

Oracle Final Test

oracle final test

Questions: 40 | Attempts: 24 | Last updated: Feb 4, 2013

Sample Question
You attempt to query the data base with this command: SELECT name,salary FROM employee WHERE salary= (SELECT salary FROM employee WHERE last_name= ‘Wagner’ OR dept_no=233) Why could this statement cause an error?

A. Sub queries are not allowed in the where clause.

B. Logical apparatus are not allowed in where clause.

C. A multiple row sub query used with a single row comparison operator.

D. A single row query is used with a multiple row comparison operator.

Ilp Oracle Prelims 2

ILP Oracle Prelims 2

Oracle Prelims 2

Questions: 8 | Attempts: 22 | Last updated: Feb 22, 2013

Sample Question
What is the output of the below query: select instr('120000 12 0 .125',1,'.') from dual;

13

Compilation error

Syntax error

None of the above

Pmpi Middleware: Weblogic Test Evaluation

PMPi Middleware: Weblogic Test Evaluation

This a training test Quiz for PMPi Middleware: Welogic

Questions: 25 | Attempts: 16 | Last updated: Jun 4, 2014

Sample Question
Oracle Weblogic is a technology commonly used to be:

Web Server

Application Server

Data Base

Authentication Software

Testing Oracle Knowledge

Quiz to test knowledge

Questions: 4 | Attempts: 10 | Last updated: Dec 31, 2012

Sample Question
What is the first thing we need?

A quiz solution

A recording solution

A publishing solution

Section 1 Oracle Acad

Questions: 15 | Attempts: 8 | Last updated: Oct 13, 2017

Sample Question
A row is called a record.

True

False

Section 2 Oracle Acad

Questions: 15 | Attempts: 7 | Last updated: Nov 10, 2017

Sample Question
Flat file databases avoid data duplication.

True

False

Oracle Quiz

Please read through all questions and respond to the best of your knowledge

Questions: 5 | Attempts: 6 | Last updated: Feb 6, 2012

Sample Question
Using Account#7238896 provide the 3 different places (tab names) you can locate the following: Risk Code Payment Terms Collector Name

Bank Imformation Tab

Collection Tab

Profile Tab

Account Tab

Section 3 Oracle Acad

Questions: 30 | Attempts: 5 | Last updated: Oct 26, 2017

Sample Question
A new system would have a mixture of both Procedural and Structural Business Rules as part of the documentation of that new system.

True

False

« Previous 1 23Next »