0

databases Online Quiz - 239

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

Clique is a

  1. Group of nodes that share a common set of disk arrays.

  2. Group of AMP's that share a common set of VDisk

  3. Group of PE's used for fault tolerance.

  4. Group of teradata systems.


Correct Option: A

Each row in teradata system is identified using

  1. Row hash

  2. Row id

  3. Hash map

  4. Hash value


Correct Option: B

Which two statements about the Transient Journal are true?

  1. It permits successful rollback to the last archive

  2. After the transaction is committed, the Before Images are discarded

  3. Transient Journal operation is automatic

  4. Before Images are kept until manually purged


Correct Option: B,C
  1. rowid

  2. sysdate

  3. rownum

  4. all of the above


Correct Option: D

which constraint allow NULL value

  1. foreign key constraint

  2. unique key constraint

  3. check constraint

  4. All of the above


Correct Option: D

delete from table_name

  1. deletes data from table_name which cannot be rolled back

  2. deletes data from table_name but can be rolled back

  3. drops table_name

  4. none of the above


Correct Option: B
  1. both column data type must be same

  2. both colmun data type need not be same

  3. one of the data type must be different

  4. both column data type and length must be same


Correct Option: B
  1. check (salary>(select salary from emp where uid=10))

  2. check (salary >(select salary from emp where rowid=10 ))

  3. check (salary >2568)

  4. check (salary >select salary from emp where dno=10)


Correct Option: C

truncate command

  1. deletes data from table but keeps table structure

  2. deletes data as well table structure

  3. drops table

  4. none of the above


Correct Option: A

deference between union and union all

  1. Union all will remove the duplicate rows from the result set while Union does'nt

  2. Union will remove the duplicate rows from the result set while Union all does'nt

  3. Both Union and Union all will remove duplicate rows from result set

  4. All of the above


Correct Option: B

SELECT TRUNC(1234.5678,-2) FROM DUAL;

  1. 12

  2. 1234

  3. 1200

  4. 1234.56


Correct Option: C

What are basic units of Teradata Arcitecture?

  1. PE

  2. AMP

  3. TDP

  4. CLIQUE

  5. VDISK


Correct Option: A,B,E
- Hide questions