Oracle Quizzes & Trivia
26/11/2011
Questions: 50 | Attempts: 34
-
Sample QuestionExamine 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?
Oracle 11g New Features
Questions: 14 | Attempts: 32
-
Sample QuestionWhich of the following is a type of segment in Oracle?
Questions: 20 | Attempts: 32
-
Sample QuestionWHERE clauses allows alias names.
Questions: 15 | Attempts: 31
-
Sample QuestionWho is usually the main witness in a criminal case?
Questions: 50 | Attempts: 29
-
Sample Question1. 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?
Questions: 40 | Attempts: 29
-
Sample QuestionExamine 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?
Welcome, This is an oracle 10g test
Questions: 40 | Attempts: 29
-
Sample QuestionTo successfully complete the installation of Oracle 10g, which disk size do you need?
Questions: 65 | Attempts: 28
-
Sample QuestionWhich is NOT an accurate statement regarding the crime of assault?
Questions: 21 | Attempts: 27
-
Sample QuestionWhich is the bext example of the technique called "flooding"?
Oracle Quiz Prelims 1
Questions: 16 | Attempts: 25
-
Sample QuestionWhich table name is valid?
Questions: 40 | Attempts: 24
-
Sample QuestionYou 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?
Oracle Prelims 2
Questions: 8 | Attempts: 22
-
Sample QuestionWhat is the output of the below query: select instr('120000 12 0 .125',1,'.') from dual;
This a training test Quiz for PMPi Middleware: Welogic
Questions: 25 | Attempts: 16
-
Sample QuestionOracle Weblogic is a technology commonly used to be:
Tech Quiz
Questions: 10 | Attempts: 14
-
Sample QuestionWhen filling out a BB Ticket who do you set as the contact?
Answer the following questions.
Questions: 11 | Attempts: 12
-
Sample QuestionWhat is a constant challenge for sales executives?
Questions: 12 | Attempts: 11
-
Sample QuestionWhich of the following is an advantage of partitioning?
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 QuestionWhat would you say is your best feature?
Quiz to test knowledge
Questions: 4 | Attempts: 10
-
Sample QuestionWhat is the first thing we need?
Quiz to test knowledge
Questions: 4 | Attempts: 10
-
Sample QuestionWhat is the first thing we need?
Quiz
Questions: 10 | Attempts: 10
-
Sample QuestionEnterprises can ______ line managers with this Oracle Self Service HR system