0

databases Online Quiz - 62

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

What is the result of a full table scan occurring on Teradata? (Choose two)

  1. All data rows are copied into temporary space

  2. Each data block for a table is read

  3. Each data row is accessed only one

  4. A random set of data blocks for a table is read


Correct Option: B,C

Of the following which is a true statement with regard to a primary index operation?

  1. When choosing a primary index you should pick a column with a severely limited value set

  2. If distribution is skewed an all-AMP operation will take longer than if all AMPs were evenly utilized

  3. Selecting a NUPI for storing data provides for maximum efficiency and makes the best use of the parallel features of Teradata

  4. The degree of uniqueness is not critical ot efficiency.


Correct Option: B
  1. Mature optimizer

  2. Industry standard access language(SQL)

  3. Concurrent users

  4. Parallel architecture


Correct Option: A,D
  1. Teradata Manager

  2. BTEQ

  3. Teradata SQL Assistant

  4. TDQM


Correct Option: D
  1. It is based on the Secondary Index

  2. It is based on the primary key of the table

  3. It is on the partitioning column

  4. It is based on the Primary Index of the table


Correct Option: D
  1. It is the Primary Key of the table, which guarantees uniqueness

  2. It allows instantaneous dropping of old data and rapid addition of new data

  3. It avoids full table scans without the overhead of a secondary index.

  4. It places all data in a specific range on the same AMP.


Correct Option: C,D
  1. creating a report to show a comparison of sales from this week to last week

  2. creating a report show how much credit can be extended to a customer

  3. creating a report that shows the top ten selling items across all stores for one year

  4. updating a checking account to reflect a deposit


Correct Option: D

How would you define a transaction?

  1. A logon, submittal of work, and logoff

  2. A single sql statement

  3. A logical unit or work

  4. A single sql, statement and the unit of recovery


Correct Option: C
  1. select count() from emp group by empno having count() >2;

  2. select empno, count() from emp having count() >2;

  3. select empno, count() from emp where count() >2;

  4. select empno, count() from emp group by empno having count() >2;


Correct Option: D
  1. Query

  2. Attribute

  3. Relation

  4. Record


Correct Option: D
  1. Isolation level2

  2. Isolation level3

  3. Isolation level4

  4. Isolation level1


Correct Option: C

Which normal forms require that non-key columns be functionally dependent solely on the primary key?

  1. Second

  2. Fifth

  3. Third

  4. None of above


Correct Option: C
  1. A commit tran is always implied for every transaction.

  2. Unchained mode is the default mode in ASE

  3. The server does not issue the begin tran implicity

  4. The value of @@tranchained is 0


Correct Option: A

The modulos operator (%) CANNOT be used on the _____ datatype.

  1. Tinyint

  2. Money

  3. Float

  4. Smallint


Correct Option: B
- Hide questions