Tag: technology

Quizzes (307) Questions (36705)

Questions Related to technology

Multiple choice technology databases

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

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

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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

ADD_MONTHS
COUNT
ROUND
DISTINCT
AVG
SUM

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

WHERE clause is used to restrict groups

True
False

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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

WHERE clause
GROUP BY clause
GROUP functions
DISTINCT keyword
FROM clause

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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?

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

Reveal answer Fill a bubble to check yourself

Multiple choice technology web technology

INDEX often improves the performance of SELECT. However, degrades the performance of DMLs

True
False

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

Identify the MANDATORY sections of a PL/SQL block

DECLARE
BEGIN
EXCEPTION
END

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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

True
False

Reveal answer Fill a bubble to check yourself

Multiple choice technology web technology

%TYPE attribute is used to declare a variable and associate its data type with the COLUMN of a TABLE OR previously declared VARIABLE

True
False

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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

SELECT
CREATE
DELETE
DROP
UPDATE
INSERT

Reveal answer Fill a bubble to check yourself

← Previous
1
2
…
3472
3473
3474
3475
3476
3477
3478
3479
3480
…
3670
3671
Next →