RAID 1 and Fallback

RAID 5 and Fallback

RAID 5 and No Fallback

RAID 1 and No Fallback

The increase of hash buckets has resulted in more hash collisions.

Duplicate NUPI values will produce the same row hash.

Uniform row distribution is accomplished using UPIs.

The low-order 16 bits of the row hash are input to the hash map.

Shared nothing

Shared memory

Shared everything

shared data

A Non Unique primary index may be more effective for query access and joins

A NUPI query simplifies the optimization process in the PE

A NUPI provides better data distribution

A NUPI requires less disk space to store the data row

1 AMP

Multi - AMP

2 -AMP

All-AMP

assigned at the table level

permanent space currently not used

spool space currently not used

subtracted form sysadmin

Teradata Manager

TDQM

BTEQ

QueryMan

length

char_length

char_len

len

is not null

is null

!= null

<> null

True

False

exp1 like exp2

exp1 like ltrim(exp2)

exp1 like rtrim(exp2)

ltrim(exp1) like exp2

True

False

INSERT INTO employees VALUES (NULL, 'JOHN','Smith');

INSERT INTO employees( first_name, last_name) VALUES ('JOHN','Smith');

INSERT INTO employees VALUES ('1000','JOHN','NULL');

INSERT INTO employees(first_name,last_name, employee_id) VALUES ('1000, 'john','Smith');

GRANT select, insert, update ON student_grades TO manager

GRANT select, insert, update ON student_grades TO ROLE manager

GRANT select, insert, modify ON student_grades TO manager WITH GRANT OPTION;

GRANT select, insert, update ON student_grades TO manager WITH GRANT OPTION;

You obtain the results retrieved from the public synonym HR created by the database administrator.

You obtain the results retrieved from the HR table that belongs to your schema.

You get an error message because you cannot retrieve from a table that has the same name as a public

You obtain the results retrieved from both the public synonym HR and the HR table that belongs to

A view can be created as read only.

A view cannot have an ORDER BY clause in the SELECT statement.

A view cannot be created with a GROUP BY clause in the SELECT statement.

A view must have aliases defined for the column names in the SELECT statement.

SELECT dept_id, job_cat, MAX(salary)

ELECT dept_id, job_cat, MAX(salary)

SELECT dept_id, MAX(salary)

SELECT dept_id, salary

SELECT last_name, 12*salary* commission_pct FROM emp;

SELECT last_name, 12*salary* (commission_pct,0) FROM emp;

SELECT last_name, 12*salary*(nvl(commission_pct,0)) FROM emp;

SELECT last_name, 12*salary*(decode(commission_pct,0)) FROM emp;

SUM(start_date)

AVG(start_date)

COUNT(start_date)

AVG(start_date, end_date)AVG(start_date, end_date)

SELECT last_name, (salary * 12) * commission_pct FROM EMPLOYEES;

SELECT last_name, (salary * 12) * IFNULL(commission_pct, 0) FROM EMPLOYEES;

SELECT last_name, (salary * 12) * NVL2(commission_pct, 0) FROM EMPLOYEES;

SELECT last_name, (salary * 12) * NVL(commission_pct, 0) FROM EMPLOYEES;