Oracle Quizzes & Trivia

Recently Updated

Oracle Model Test 04

26/11/2011

Questions: 50 | Attempts: 34

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

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

Views

Tables

Procedures

Partitions

Oracle Constraints By Blue Blaze

Questions: 20 | Attempts: 32

Sample Question
WHERE clauses allows alias names.

True

False

Db Ch 18

Questions: 15 | Attempts: 31

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

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

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

Welcome, This is an oracle 10g test

Questions: 40 | Attempts: 29

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

800MB

1.2GB

1.5GB

Db Ch11

Questions: 65 | Attempts: 28

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

Questions: 21 | Attempts: 27

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

Oracle Quiz Prelims 1

Questions: 16 | Attempts: 25

Sample Question
Which table name is valid?

Invoices-1996

Catch_#22

1996_invoices

.#_667

Oracle Final Test

Questions: 40 | Attempts: 24

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

Oracle Prelims 2

Questions: 8 | Attempts: 22

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

This a training test Quiz for PMPi Middleware: Welogic

Questions: 25 | Attempts: 16

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

Web Server

Application Server

Data Base

Authentication Software

Pmrc February Quiz

Tech Quiz

Questions: 10 | Attempts: 14

Sample Question
When filling out a BB Ticket who do you set as the contact?

Yourself

The Teamlead

Chris Foot

Doug Russell

None of the above

Oracle Mock

Time :

Questions: 3 | Attempts: 13

Sample Question
DML

Language

Data Manipulation Language

Language

Oracle Test

Questions: 10 | Attempts: 12

Sample Question
What does the method extend(n,i) do?

Append n elements and sets each to the same value as the I th element

It can be used to build generic and reusable code

Add a single null element at ith position

.add n null elements at ith position

Appends n elements and sets each to a null value.

Oracle_architecture

Questions: 45 | Attempts: 12

Sample Question
Data base Provides platform for

Easy Data management

Facilita tedata sharing

Reduces data redundancy

Simplifying data

Oracle Fusion Solution

Answer the following questions.

Questions: 11 | Attempts: 12

Sample Question
What is a constant challenge for sales executives?

How to act in front of peers

How to increase revenue

How to be productive

Oracle Partitioning

Questions: 12 | Attempts: 11

Sample Question
Which of the following is an advantage of partitioning?

Complexity

Inconsistent access speed

Extra space

Security

Which Oracle Character Are You?

Which character from the crime thriller Oracle are you most like? "As the countdown begins, the body count rises." Oracle releases on July 30th, 2012. For more information, visit www.jc-martin.com.

Questions: 17 | Attempts: 11

Sample Question
What would you say is your best feature?

My sharp, logical mind

My ever-present sunny smile :)

My impressive physique

My grit and determination

My easygoing charm