Question 1

What is true about MERGE command? Choose all that apply.

technology databases

It is a DML command
It is a DDL command
Provides the ability to conditionally update or insert data into a database table
Provides the ability to MERGE VIEWS and INDICES of a TABLE

Answer

Correct Option: A,C

Question 2

Select TYPES of JOINS. Choose all that apply.

technology databases

EQUI-JOIN
NONEQUI-JOIN
SELF-JOIN
OUTER-JOIN
MERGE-JOIN
TRANSACTION-JOIN

Answer

Correct Option: A,B,C,D

Question 3

Choose the MANDATORY clauses of SELECT SQL statement

technology databases

SELECT
WHERE
GROUP BY
FROM
ORDER BY
HAVING

Answer

Correct Option: A,D

Question 4

ALIAS can be used for TABLE as well as COLUMN to simplify interpretation of SQL query

technology databases

True
False

Answer

Correct Option: A

Question 5

Identify the correct output select INITCAP('ORACLE BASICS') from dual;

technology databases

ORACLE BASICS
Oracle Basics
oracle basics
oracleBasics

Answer

Correct Option: B

Question 6

Identify the correct output --- select CONCAT('ORACLE' || 'BASICS') from dual;

technology databases

ORACLE BASICS
ORACLEBASICS
oraclebasics
oracleBasics

Answer

Correct Option: B

Question 7

Identify the correct output --- select SUBSTR('ORACLE BASICS',-6,5) from dual;

technology databases

BASIC
BASICS
E BAS
ORACL

Answer

Correct Option: A

Question 8

Identify the correct output --- select TRUNC(TO_DATE('01-SEP-1995', 'DD-MON-YYYY'),'YEAR') from dual;

technology databases

01-SEP-1995
01-JAN-1995
01-JAN-1996
1995
1996

Answer

Correct Option: B

Question 9

Identify the correct output --- select ADD_MONTHS(TO_DATE('01-SEP-1995', 'DD-MON-YYYY'), 6) from dual;

technology databases

01-MAR-1996
01-FEB-1996
07-SEP-1995
06-SEP-1995

Answer

Correct Option: A

Question 10

Identify the correct output --- select LAST_DAY(TO_DATE('01-SEP-1995', 'DD-MON-YYYY')) from dual;

technology databases

31-AUG-1995
30-SEP-1995
31-OCT-1995
31-DEC-1995

Answer

Correct Option: B

Question 11

Which functions mentioned below are GROUP functions? Choose all that apply

technology databases

ADD_MONTHS
COUNT
ROUND
DISTINCT
AVG
SUM

Answer

Correct Option: B,E,F

Question 12

WHERE clause is used to restrict groups

technology databases

True
False

Answer

Correct Option: B

Question 13

One can NOT delete a row from the VIEW if view definition contains ... Choose all that apply

technology databases

WHERE clause
GROUP BY clause
GROUP functions
DISTINCT keyword
FROM clause

Answer

Correct Option: B,C,D

Question 14

An application developer wants to query row count of a table, ORDERS which has millions of records. ORDERS table has composite PRIMARY KEY on (ORDER_ID, CUSTOMER_ID) columns and those two columns appear at position 1 and 2 respectively in the ORDERS table. Which query will be more efficient?

technology databases

select count(*) from orders;
select count(1) from orders;
select count(3) from orders;
select count(5) from orders;

Answer

Correct Option: B

Question 15

Identify the MANDATORY sections of a PL/SQL block

technology databases

DECLARE
BEGIN
EXCEPTION
END

Answer

Correct Option: B,D

Question 16

%ROWTYPE attribute is used to declare a variable and associate it's data type with the TABLE/CURSOR object.

technology databases

True
False

Answer

Correct Option: A

Question 17

Within a PL/SQL block, which commands are allowed? Choose all that apply

technology databases

SELECT
CREATE
DELETE
DROP
UPDATE
INSERT

Answer

Correct Option: A,C,E,F

Question 18

INSERT, UPDATE, DELETE commands when used in a PL/SQL block, should contain INTO clause to hold the data returned by SQL statement

technology databases

True
False

Answer

Correct Option: B

Question 19

IF-THEN-ELSE-ENDIF construct is used for conditional control in a PL/SQL block. What happens if the condition in IF-THEN-ELSE-ENDIF block evaluates to NULL?

technology databases

The SQL statements in the IF condition are processed.
The SQL statements in the ELSE condition are processed.
IF-THEN-ELSE-ENDIF construct is skipped.
The SQL statements in the IF condition as well as ELSE condition are processed.

Answer

Correct Option: C

Question 20

Identify the ITERATIVE control constructs in PL/SQL. Choose all that apply

technology databases

Cursors
Cursor For Loop
Simple Loop
Exit Loop
Numeric For Loop
While Loop

Answer

Correct Option: B,C,E,F

Description: databases Online Quiz - 10
Number of Questions: 20
Created by: Aliensbrain Bot
Tags: databases

databases Online Quiz - 10

Find more quizzes from top tags