• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
Techgoeasy

Techgoeasy

Learn Oracle, PHP, HTML,CSS,Perl,UNIX shell scripts

  • Home
  • Oracle
    • Oracle database
    • Oracle Ebusiness Suite
    • Oracle weblogic
    • Oracle Performance Tuning
    • Oracle Hyperion
    • Oracle Cloud Tutorials
  • SQL
  • interview questions
  • Linux
  • PHP and HTML
  • Downloads
  • General
Home » Oracle » Oracle sql online test

Oracle sql online test

September 5, 2018 by techgoeasy Leave a Comment


Oracle sql online test

Oracle SQL is the widely used in various Products. Having a knowledge in Oracle SQL is plus point.

This Oracle sql online test check the understanding on various topics like Oracle table, Oracle view ,constraints, type of index, sequences, subqueries , oracle joins ,materialized view, primary key constraints , single row function ,sql queries and many more

The below test is randomized sql test and select 15 questions from the set of many questions,so each time you try to attempt it, you will get different questions in different order and option would also be in different order, So it will be fun practicing with this tool. You can try as many times as you want till you feel comfortable about it

Instructions for online test

1.This quiz consists of 15 questions .It is recommended to complete the test in 30 min
2. It consists both single choice and more than  one choice questions to test your knowledge
3. You can press the submit button at the end of your test and get the final score
4.You will also get the know the correct choice after you finished the test.

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • Show paginator
  • Hide paginator

1. You must permanently remove all data from the sales_data table, but will need the table structure in the future. What single command should be issued?

Question 1 of 15

2. You need to analyze how long your orders to be shipped from the date that the order is placed. To do this you must create a report that displays the customer number, date order, date shipped and the number of months in whole numbers from the time the order is placed to the time the order is shipped. Which statement produces the
required results?

Question 2 of 15

3. How would you add a foreign key constraint on the dept_no column in the EMP table. Referring to the ID column in the DEPT table?

Question 3 of 15

4. Examine the structure of student_masters table:
Name Null Type
STU ID NOT NULL NUMBER(3)
NAME VARCHER2(25)
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?

Question 4 of 15

5. You query a database with the following command:

SELECT dept_no, AVG (MONTHS_BETWEEN (SYSDATE, hire_date)) FROM worker_company
WHERE AVG (MONTHS_BETWEEN (SYSDATE, hire_date)) > 60
GROUP BY dept_no
ORDER BY AVG (MONTHS_BETWEEN (SYSDATE, hire_date) )

Where does the statement cause an error?

Question 5 of 15

6. The emp table contains these columns:
Last_name Varchar2 (25)
First_name Varchar2 (25)
Salary Number7, 2
You need to display the names of employees on more than an average salary of all
employees. Evaluate the SQL statement.
SELECT, LAST_NAME, FIRST_NAME from emp where salary< avg(salary);

Which change should you make to achieve the desired results?

Question 6 of 15

7. You need to store currency data and you know that data will always have two digits to the right of the decimal points. However the number of digits to the left of the decimal place will vary greatly. Which data type would be most appropriate to store the data?

Question 7 of 15

8. What command should be used to execute a script file named create_table.sql from the SQL Plus environment?

Question 8 of 15

9. You have been instructed to create a report that shows different jobs in each division within your company. No duplicate roles can be displayed. Which of the following SELECT statements should be used?

Question 9 of 15

10. Your company will be granting workers a $150 salary increase. You need to evaluate results of the increase from the worker table prior to the actual modification. You do not want to store in the results in the current database. Which of the following is untrue?

Question 10 of 15

11. What should be done after each fetch statement in a PL/SQL block?

Question 11 of 15

12. The emp table contains these columns:
FIRST-NAME VARCHER2(25)
COMISSION NUMBER(3,2)
Evaluate this SQL statement
SELECT first-name,commission FROM emp WHERE commission= (SELECT comission FROM emp WHERE UPPER(first-name)= ‘smith’)
Which statement will cause this statement to fail?

Question 12 of 15

13. You create the sal table with this command

CREATE TABLE sal (purchase-no NUMBER(9)
CONSTRAINT sale-purchase-no-pk PRIMARY KEY,
costumer-id NUMBER(9) CONSTRAINT sale-customer-id-nl NOT NULL);

Which index or indexes are created for this table?

Question 13 of 15

14. A group function produces ______.

Question 14 of 15

15. You want of display the details of all employees whose last names is john. But you are not sure in which case last names are stored. Which statement will list all the employees whose last name is john?

Question 15 of 15

Loading... Loading...

 

I hope you like this Oracle sql online test and it helps in your examination preparation. Best of Luck for the Oracle certification Examination. Please do provide feedback on it. We will also be adding more quizes and questions in future.

Happy Learning!!!!

Related Articles
How to prepare for OCI Associate Certified Examination
Oracle Sql Tutorials
Tips for Passing OCI examination
Oracle Performance & Tuning Quiz


Filed Under: Oracle, Oracle Sql Tagged With: Good Question for Oracle Sql

Reader Interactions

Leave a Reply Cancel reply

Primary Sidebar

Top Posts & Pages

  • Oracle Indexes and types of indexes in oracle with example
  • Top 30 Most Useful Concurrent Manager Queries
  • Top 46 Oracle ASM Interview Questions
  • Oracle dba interview questions and answers
  • 40 question you must know about R12.2



Subscribe to our mailing list

Enter your email address to subscribe to this blog and receive notifications of new posts by email

Recent Posts

  • Multi Language Support in 11i/R12
  • EBS PDB service name disappear from listener in 19c
  • how to download oracle e-business suite 12.2 software
  • Step by step upgrade process to R12.2 Upgrade part -2(Main Upgrade Driver for R12.2.0)
  • Step by step upgrade process for R12.2 Upgrade Part -1

Copyright © 2021 : TechGoEasy

  • Hire me
  • Privacy Policy
  • Contact Us
  • New? Start Here
  • About Us