Oracle Advanced SQL and PL/SQL Developer Certification Questions and Answers (Dumps and Practice Questions)

Question : Consider following statements..
CREATE TABLE employees
( employee_number number(10) not null,
employee_name varchar2(50) not null,
salary number(6),
CONSTRAINT employees_pk PRIMARY KEY (employee_number)
);

INSERT INTO employees (employee_number, employee_name, salary)
VALUES (1001, 'John Smith', 62000);

INSERT INTO employees (employee_number, employee_name, salary)
VALUES (1002, 'Jane Anderson', 57500);

INSERT INTO employees (employee_number, employee_name, salary)
VALUES (1003, 'Brad Everest', 71000);

INSERT INTO employees (employee_number, employee_name, salary)
VALUES (1004, 'Jack Horvath', 42000);

What would be the output of following statement
SELECT * FROM employees WHERE employee_name LIKE '%h';


1. Rows containing employee name 'Jack Horvath'
2. Rows containing employee name 'Brad Everest'
3. Access Mostly Uused Products by 50000+ Subscribers
4. Rows containing employee name 'John Smith' and 'Jack Horvath'

Correct Answer : Get Lastest Questions and Answer : Exp: % Allows you to match any string of any length (including zero length)
_ Allows you to match on a single character






Question : Which of the query depict the given shared area ( Blue is a shared area)


1. SELECT columns
FROM table1
LEFT [OUTER] JOIN table2
ON table1.column = table2.column;
2. SELECT columns
FROM table1
INNER JOIN table2
ON table1.column = table2.column;
3. Access Mostly Uused Products by 50000+ Subscribers
FROM table1
RIGHT [OUTER] JOIN table2
ON table1.column = table2.column;
4. SELECT columns
FROM table1
FULL [OUTER] JOIN table2
ON table1.column = table2.column;

Correct Answer : Get Lastest Questions and Answer : Exp:





Question : Which of the query depict the given shared area ( Blue is a shared area)


1. SELECT columns
FROM table1
LEFT [OUTER] JOIN table2
ON table1.column = table2.column;
2. SELECT columns
FROM table1
INNER JOIN table2
ON table1.column = table2.column;
3. Access Mostly Uused Products by 50000+ Subscribers
FROM table1
RIGHT [OUTER] JOIN table2
ON table1.column = table2.column;
4. SELECT columns
FROM table1
FULL [OUTER] JOIN table2
ON table1.column = table2.column;

Correct Answer : Get Lastest Questions and Answer : Exp:

Related Questions

---

Question : What value is returned after executing the following statement?
REPLACE('123123tech', '123');

1. 123
2. tech
3. Access Mostly Uused Products by 50000+ Subscribers
4. None of the above




Question : What value is returned after executing the following statement?
REPLACE('0000123', '0', ' ');

1. 123
2. 4 space and 123
3. Access Mostly Uused Products by 50000+ Subscribers
4. None of the above




Question : What value is returned after executing the following statement?
MOD(15, 4)

1. 3
2. 4
3. Access Mostly Uused Products by 50000+ Subscribers
4. Null




Question : What value is returned after executing the following statement?
MOD(-100, 0)

1. 100
2. 0
3. Access Mostly Uused Products by 50000+ Subscribers
4. Null




Question : What value is returned after executing the following statement?
ADD_MONTHS('01-Aug-03', 3)

1. 01-Nov-03
2. 01-Nov-06
3. Access Mostly Uused Products by 50000+ Subscribers
4. 01-Sep-03




Question : What value is returned after executing the following statement?
ADD_MONTHS('21-Aug-03', -3)

1. 21-Jan-03
2. 21-Mar-03
3. Access Mostly Uused Products by 50000+ Subscribers
4. 21-Nov-03