0

databases Online Quiz - 45

Description: databases Online Quiz - 45
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0

Which of the following statements gets the total value of the column 'Price' in the 'Sales' table

  1. SELECT ADD(Price) FROM Sales

  2. SELECT TOTAL(Price) FROM Sales

  3. SELECT SUM(Price) FROM Sales

  4. SELECT SUM(Price) WHERE Sales


Correct Option: C

The difference between the DELETE and TRUNCATE SQL clauses is

  1. 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

  2. The TRUNCATE clause is identical to the DELETE clause

  3. 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

  4. None of these


Correct Option: A

select lpad(3400,10,*) from dual returns

  1. ******3400

  2. 3400******

  3. 3400

  4. Error


Correct Option: D

which one of the following is correct?

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

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

  3. to_char(sysdate,mm/yy)

  4. All the above


Correct Option: A

select nvl2(exp1,exp2,exp3) from dual. In this if exp1 is null,what will be the output?

  1. exp1

  2. exp2

  3. exp3

  4. error


Correct Option: B

With SQL, how do you select all the records from a table named 'Persons' where the value of the column 'FirstName' starts with an 'a'?

  1. SELECT * FROM Persons WHERE FirstName LIKE 'a%'

  2. SELECT * FROM Persons WHERE FirstName LIKE '%a'

  3. SELECT * FROM Persons WHERE FirstName='a'

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


Correct Option: A

Can 2 functions have same name & input parameters but differ only by return data type?

  1. True

  2. False


Correct Option: B

Which figure represents Terabyte

  1. 10^3

  2. 10^10

  3. 10^9

  4. 10^12


Correct Option: D

Teradata considered as fastest OLAP based RDBMS because of

  1. Parall architecture

  2. Serial architecture

  3. Scalability

  4. Performacnce


Correct Option: A

Which OS does not support teradata RDBMS installation

  1. UNIX-MPRAS

  2. UNIX-LINUX

  3. UNIX-AIX

  4. UNIX-HP-UX


Correct Option: C,D

Which is not a member of TTU(teradata tools and utilizes)?

  1. Fastload

  2. Multiload

  3. FastExport

  4. Datastage


Correct Option: D
  1. Set

  2. Multiset

  3. Volatile

  4. Temporary


Correct Option: B
- Hide questions