SELECT ADD(Price) FROM Sales

SELECT TOTAL(Price) FROM Sales

SELECT SUM(Price) FROM Sales

SELECT SUM(Price) WHERE Sales

The TRUNCATE clause deletes all rows in a database table, while the DELETE clause can have a WHERE condition and might or might not delete all rows in a table

The TRUNCATE clause is identical to the DELETE clause

The DELETE clause deletes all rows in a database table, while the TRUNCATE clause can have a WHERE condition and might or might not delete all rows in a table

None of these

True

False

******3400

3400******

3400

Error

Error

700

0

7

to_char(sysdate,'mm/yy')

to_char('sysdate','mm/yy')

to_char(sysdate,mm/yy)

All the above

exp1

exp2

exp3

error

SELECT * FROM Persons WHERE FirstName LIKE 'a%'

SELECT * FROM Persons WHERE FirstName LIKE '%a'

SELECT * FROM Persons WHERE FirstName='a'

SELECT * FROM Persons WHERE FirstName='%a%'

True

False

True

False

10^3

10^10

10^9

10^12

Parall architecture

Serial architecture

Scalability

Performacnce

UNIX-MPRAS

UNIX-LINUX

UNIX-AIX

UNIX-HP-UX

Fastload

Multiload

FastExport

Datastage

V2R5

V2R6

V2R12

V2R13

Set

Multiset

Volatile

Temporary

SQL assistant

BTEQ

PMON

Statistics wizard

7

8

12

10

60

120

80

30

SMP

PMP

MPP

PPP