TE0-122 12 Teradata SQL Certified Practice Test

Sample Questions:

Taking into account the following table: Create Emp_Table set table (EMP_NO Integer, Last_Name Char (20), First_Name Char (20), Hire_Date Date Format ‘YYYY-MM-DD’) Unique primary index (EMP_NO); Given the following statement: Insert into Emp_Table values ​​(1011, ‘Krishnaswamyn-lavanya’, ‘Rajagopal’, ‘2009-04-27’); What will two happen? (Choose two.)

In ANSI mode, the system returns an error.

Teradata mode, the system returns an error.

In ANSI mode, the chain is truncated and the line is inserted

The Teradata mode, the line is truncated and a row is inserted.

The manager requests data analysts to produce once a month summary added report of several tables for a meeting in one hour. What option will you require fewer steps to achieve this task?

Create multiple tables derived for a query report

Create multiple temporary tables for a consultation report

Create some global temporary tables for a consultation report

To create a more permanent table to upload data for a query report

None

The company has a policy to provide all role-level privileges. Taking into account the following: Account_user Rol Grant Select in the Account_records Grant database Run in the Account_Records Acount_Admin Role database Update the Database Database Gandication Ordatization Database Database of the Database of User List A is an account_user member and OrdendS_User Roles What is the impact of changes in the user’s default role by account_user for all?

A user can update the data from the database count_records.

A user can execute, and delete the statements on the account_ecords.

A user can insert accounts based on account_orters and execute account-based_ecords.

A user can execute the account according to base on bases and execute account-based_records.

None

Given the following very large table with current PPI statistics: Create the PPI_Table1 table (Column1 Integer No Null No Null, Date of the Column Date) Primary Partition (Column1) Partition by RANGO_N (column2 between ‘2009-01-01- 01 ‘Date and date “2011- 12-11’ Each interval ‘1’ year); Create Table PPI_Table2 (Column1 No Integer, Integer Integer) Primary Partition (Col1) starting by RANGO_N (Column2 between 1 and 6 each); Select * from PPI_Table1 T1, T2 PPI_Table2 where t1.column1 = t2column1; What statement is a certain steps that can be taken when attaching these tables?

Fusion of a single stop

Fusion of RowKey bases

Product to join the removal of the dynamic partition.

Union of the product without addressing the dynamic section.

None

User presentation of additional requests by the BTEQ session within the Multie Quest operation, which remains open. What two sessions in ANSI mode, on the basis of additional requests seem? (Choose two.)

1) Declaration of update, it seems that it is successful. 2) ET Operator appears as successful. 3) Then, the user sees using the selection, the statement that the update statement in step 1 is reflected in the table. 1) Declaration of update, it seems that it is successful. 2) Declaration of update, it seems to violate the verification restriction. 3) Then, the user sees using the selection, the statement that the update statement in step 1 is reflected in the table.

1) Declaration of update, it seems to violate the verification restriction. 2) Declaration of update, it seems that it is successful. 3) Declaration presented Rollback. 4) Then, the user sees using the selection, the statement that the update statement in step 2 is reflected in the table.

1) Declaration of update, it seems that it is successful. 2) Declaration of update, it seems to violate the verification restriction. 3) The update statement appears 4) The Rollback instruction appears. 5) Then, the user sees a use of the selection, the statement that the update operators in step 1 and 3 are not reflected in the table.

What expression will return a month, will have 300 days from today?

Month (Current_Date + 300)

(Current_Date + 300) MOD 12 + 1

Extract (from the month (Current_Date + 300))

Distribution ((Current_Date + 300), Month Interval)

None

What is the evaluation order by using having, where group per clause with each other in the same select one?

Where, group by, having

Group by, having, where

Where, group for

Group by, where,

None

Who this course is for:

• Those who want to get knowledge in Certifications & Check you skill Test while attend this Practice Test