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

select trunc(760.5,-2) from dual returns

  1. Error

  2. 700

  3. 0

  4. 7


Correct Option: B
  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 a primary key contain more than one columns?

  1. True

  2. False


Correct Option: A
  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

What is the latest version of Teradata RDBMS available in market?

  1. V2R5

  2. V2R6

  3. V2R12

  4. V2R13


Correct Option: D

which table supports duplicate rows insertion?

  1. Set

  2. Multiset

  3. Volatile

  4. Temporary


Correct Option: B

which one is used to monitor performance of teradata processes?

  1. SQL assistant

  2. BTEQ

  3. PMON

  4. Statistics wizard


Correct Option: C

How many codd rules are applied in Teradata?

  1. 7

  2. 8

  3. 12

  4. 10


Correct Option: C

How many sessions can be handled in single session?

  1. 60

  2. 120

  3. 80

  4. 30


Correct Option: B

What type of distributions are there?

  1. SMP

  2. PMP

  3. MPP

  4. PPP


Correct Option: A,C
- Hide questions