Tag: databases

Order By

Sort

Arrange

All the above

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