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

Maximum no. of secondry indexes allowed on single table

  1. 64

  2. 32

  3. 128

  4. 256


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

The rows of every table are distributed among all AMPs

  1. True

  2. False


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

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

which is correct about COMPOSITE KEY?

  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

A column with varchar datatype is populated with number values. What is the possible output with the default ORDER BY clause?

  1. 1 11 111 2 3 4

  2. 1 2 3 4 11 111

  3. 111 11 4 3 2 1

  4. ERROR due to data type mismatch


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

To solve this question, the user needs to understand the TRUNC function in SQL and how it rounds a given number to a specified number of decimal places or digits.

The TRUNC function in SQL is used to truncate a number to a certain number of decimal places or digits. It takes two arguments, the first being the number to be truncated and the second being the number of decimal places or digits to which the number should be truncated.

In this case, the number 1234.5678 is being truncated to the nearest 100th, or -2 decimal places. This means that any decimal places beyond the 100th place will be dropped.

Now let's go through each option and explain why it is right or wrong:

A. 12: This option is incorrect because truncating 1234.5678 to the nearest 100th place would result in the number 1200, not 12.

B. 1234: This option is incorrect because the TRUNC function rounds the number down to the nearest 100th place, but it does not remove any digits before the decimal point. So the resulting number will still be 1234 with two decimal places truncated.

C. 1200: This option is correct. Truncating 1234.5678 to the nearest 100th place yields the number 1200 since all decimal places beyond the 100th place are dropped.

D. 1234.56: This option is incorrect because truncating 1234.5678 to the nearest 100th place would result in the number 1200 with two decimal places removed, not 1234.56.

Therefore, the correct answer is:

The Answer is: C

Which utility can be used for constant updates in datawarehouse?

  1. Fastload

  2. Multiload

  3. Tpump

  4. Bteq


Correct Option: C

Fastload can be used for loading multiple tables at a time.

  1. True

  2. False


Correct Option: B

What are basic units of Teradata Arcitecture?

  1. PE

  2. AMP

  3. TDP

  4. CLIQUE

  5. VDISK


Correct Option: A,B,E

Intermediate querry results are stored in

  1. AMP

  2. BYNET

  3. PE

  4. VDISK


Correct Option: B
- Hide questions