Oracle sql online test for Certification

📁

Tutorial Collection

This guide is part of our comprehensive SQL Tutorials Hub.

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. 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?

ALTER TABLE student_masters ADD CONSTRAINT name(NOT NULL);

ALTER TABLE student_masters MODIFY(name varcher2(25) NOT NULL);

ALTER TABLE student_masters ADD CONSTRAINT NOT NULL (name);

ALTER TABLE student_masters MODIFY CONSTRAINT name(NOT NULL);

Question 1 of 15

2. 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?

Select last name, first nam FROM emp WHERE last name= ‘john’;

Select last name, first name FROM emp WHERE last name=UPPER (‘john’);

Select last name, first name FROM emp WHERE UPPER (last name)= ‘john’;

Select last name, first name. FROM emp WHERE LOWER (last name)= ‘john’;

Question 2 of 15

3. Examine the WORKER table below:

NAME NULL TYPE
WORKER ID NOT NULL NUMBER(3)
NAME NOT NULL VARCHAR2(25)
PHONE NOT NULL VARCHAR2(9)
ADDRESS VARCHAR2(50)
POSITION UPDATE

There are hundreds of records in the EMPLOYEE TABLE. You need to modify the phone column to hold only number values. Which statement will modify the data type appropriately?

The data type of a column cannot be modified if there is data in the column.

ALTER WORKER table MODIFY COLUMN phone NUMBER(9)

ALTER TABLE worker MODIFY phone NUMBER(9)

A VARCHAR2 data type cannot be changed to a NUMBER data type for a column.

Question 3 of 15

4. 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?

A column must be added to the worker table.

An arithmetic expression must be added that invokes the salary increment in the SELECT clause of the SELECT statement.

An arithmetic expression must be added that invokes the salary increment in the SET section of the upgrade clause.

An arithmetic expression must be added that invokes the salary increment in the UPDATE clause of the SELECT statement.

Question 4 of 15

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

EXECUTE create_table

GET create_table

RUN create_table

START create_table

Question 5 of 15

6. A group function produces ______.

A group of results from one row.

One result from many rows per group.

Many results from many rows per group.

One result from each row in a table.

Question 6 of 15

7. 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?

Instructions for online test

Related Posts

Leave a Comment Cancel Reply