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

  2. Row id

  3. Hash map

  4. Hash value


Correct Option: B

Teradata Basic concepts dictate that a Primary Key can be NULL

  1. True

  2. False


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

Which among these are pseudo columns

  1. rowid

  2. sysdate

  3. rownum

  4. all of the above


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

which is correct regarding CHECK CONSTRAINT?

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