Hardest Quiz On Teradata Database! Trivia Questions Test

125 Questions | Total Attempts: 317

SettingsSettingsSettings
Please wait...
Hardest Quiz On Teradata Database! Trivia Questions Test

This trivia questions test is the Hardest Quiz on Teradata Database! This data base is the best source for creation of data warehouses and is easy to use by most programmers. In the quiz below, you will get to test out just how much you know about using this database. How about you give it a shot and get to see what new things you might learn.


Related Topics
Questions and Answers
  • 1. 
    Teradata parallel transporter can read  from  multiple source file simultaneously
    • A. 

      True

    • B. 

      False

  • 2. 
    Which three statements are true?
    • A. 

      An outer join requires an ON clause

    • B. 

      A cross join requires a WHERE clause

    • C. 

      An ON clause cannot be specified for a cross join

    • D. 

      A WHERE clause cannot be specified with a cross join

    • E. 

      For an implicit join, the join condition , if any, is specified in the WHERE clause

  • 3. 
    The definition of derived table is stored in the data dictionary.
    • A. 

      True

    • B. 

      False

  • 4. 
    What does the EXPLAIN output provide to assist the user in query analysis?
    • A. 

      Which step may be process in parallel

    • B. 

      What statistic should be collected on column

    • C. 

      Accurate time measurement for query processing

    • D. 

      Details of which indexes, if any, will be used to process the query

    • E. 

      Recommendations to improve the query based on  timing  and sizing

  • 5. 
    Give the syntax to create a new table from the existing employee table having the same DDL, same data and same statistics.
    • A. 

      CREATE TABLE Employee_Table _New AS Employee_table with DATA AND Statistics ;

    • B. 

      CREATE TABLE Employee_Table _New AS Employee_table ;

    • C. 

      CREATE TABLE Employee_Table _New AS Employee_table with DATA;

    • D. 

       None of the above options

  • 6. 
    Data of the volatile table is stored in
    • A. 

      Spool  space

    • B. 

      Temp space

    • C. 

      Permament space

    • D. 

      Data is not stored in volatile table

    • E. 

      Spool space or temp space depending on availability of space

  • 7. 
    Number of tables multi load can support
    • A. 

      1

    • B. 

      8

    • C. 

      3

    • D. 

      4

    • E. 

      5

  • 8. 
    Volatile table’s Lifetime is
    • A. 

      Within Session

    • B. 

      Within Statement where it is created

    • C. 

      Until it is dropped using drop statement

    • D. 

      None of the Above

  • 9. 
    The definition of volatile table is stored in the data dictionary.
    • A. 

      True

    • B. 

      False

  • 10. 
    Stats can Multi-Column not be collected on a volatile table.
    • A. 

      True

    • B. 

      False

  • 11. 
    Accessing records using UPI will always return many rows.
    • A. 

      True

    • B. 

      False

  • 12. 
    Only one work tables are created for all the target in a multi-load script.
    • A. 

      True

    • B. 

      False

  • 13. 
    Which two will happen during a transaction when no rows are available in a queue table?
    • A. 

      The transaction aborts automatically

    • B. 

      The SELECT AND CONSUME statement will generate new rows in the table

    • C. 

      The transaction enters a delay state until a row is inserted into the queue table

    • D. 

      The transaction aborts either by an ABORT statement or a DROP TABLE statement on the queue table

  • 14. 
    Secondary index can be useful for 
    • A. 

      Data distribution of tables

    • B. 

      Joining tables

    • C. 

      Processing aggregates

    • D. 

      Value comparison

    • E. 

      None of the above

  • 15. 
    Users (user ids) of the Teradata database are treated as a database in the Teradata system.
    • A. 

      True

    • B. 

      False

  • 16. 
    Teradata AMP’s is responsible for
    • A. 

      Data retrival 

    • B. 

      Lock Management

    • C. 

      Output conversion

    • D. 

      Managing sessions

  • 17. 
    A fallback table is fully available during the event of an unavailable AMP.
    • A. 

      True

    • B. 

      False

  • 18. 
    How many tables at maximum can be loaded using a Load operator?
    • A. 

      1

    • B. 

      5

    • C. 

      127

    • D. 

      4

    • E. 

      None of the above

  • 19. 
    The SQL statements in BTEQ scripts are not auto-commit in the case of BTET transaction mode.
    • A. 

      True

    • B. 

      False

  • 20. 
    Character comparison within BTEQ in BTET transaction is case sensitive.
    • A. 

      True

    • B. 

      False

  • 21. 
    Teradata PE is responsible for
    • A. 

      Managing session

    • B. 

      Parsing SQL request

    • C. 

      Optimizing SQL request

    • D. 

      Input conversion

    • E. 

      All of the above

  • 22. 
    Spool space and Temp space allocation done from permanent space of the database
    • A. 

      True

    • B. 

      False

  • 23. 
    Which DCL Statement is written correctly?
    • A. 

      GRANT SELECT,EXECUTE,DELETE TO User1 ON User1 

    • B. 

      GRANT SELECT,EXECUTE,DELETE ON Database1 TO Database1 

    • C. 

      GRANT SELECT,EXECUTE,DELETE TO User1 ON DATABASE Database1

    • D. 

      GRANT SELECT,EXECUTE,DELETE ON DATABASE Database1 TO User1 

  • 24. 
    Which two functionalities are available through the BTEQ tool? (multiple)
    • A. 

      Support Ad-Hoc quries

    • B. 

      Ls checkpoint Restartable

    • C. 

      Runs scripted batch queries

    • D. 

      Provides high volume data export

  • 25. 
    A multiload script is having 5 targets.How many error tables will be created when this script runs?
    • A. 

      5

    • B. 

      10

    • C. 

      2

    • D. 

      None of the above

  • 26. 
    How many tables are created during loading a table with MLOAD utility
    • A. 

      2

    • B. 

      3

    • C. 

      4

    • D. 

      None of the above

  • 27. 
    Which of the below happen in cleanup phase of Mload in case of successful execution(multiple)
    • A. 

      All lock are released

    • B. 

      Final error code is reported

    • C. 

      Empty error tables are dropped

    • D. 

      Store DML steps in work tables

    • E. 

      All of the above

  • 28. 
    See the below block of statement in side BTEQ script Employee Table is having 100 records in it before the btq run.DELETE FROM SQL_Class.EMPLOYEE;DELETE FROM TABLE SQL_Class.EMPLOYEE WHERE EMPLOYEE_ID>1000;IF ERRORCODE<>0 THEN GOTO QUIT1 DELETE FROM SQL_Class.EMPLOYEE WHERE EMPLOYEE_ID=999; .LABEL QUIT1 .QUIT ERRORLEVEL;.QUIT 0  HOW many records will be ther after script bteq script is executed?
    • A. 

      100 Records

    • B. 

      0 Records

    • C. 

      Depends on Number of employee with employee if>1000

    • D. 

      Depends on existant of employee with id 999

    • E. 

      Both option 3 and 4

  • 29. 
    Multiple instance of same temporary table can be created in same session
    • A. 

      True

    • B. 

      False

  • 30. 
    Which statement is written correctly?
    • A. 

      SELECT *,table2.logdate,table2.logtime FROM DBC.RESUsageSPMA db1 WHERE db1.thedate = table2.logdate AND db1.thetime=table2.logtime;

    • B. 

      SELECT table2.logdate,table2.logtime,(*) FROM DBC.RESUsageSPMA db1 WHERE db1.thedate = table2.logdate AND db1.thetime=table2.logtime;

    • C. 

      SELECT table2.logdate,table2.logtime,*  FROM DBC.RESUsageSPMA db1 WHERE db1.thedate = table2.logdate AND db1.thetime=table2.logtime;

    • D. 

      SELECT table2.logdate,table2.logtime,db1.*  FROM DBC.RESUsageSPMA db1 WHERE db1.thedate = table2.logdate AND db1.thetime=table2.logtime;

  • 31. 
    One Teradata DBC System has 10TB space.Under DBC one Database TDUSER is created with 2 TB space allocated to it .Under TDUSER another database “TEMP_DATABASE” is created . if that new database is given 1TB of space,where from the space is given?
    • A. 

      DBC

    • B. 

      TDUSER

    • C. 

      DBC or TDUSER as per the choise of administrator

    • D. 

      ”TEMP_DATABASE” cannot be created under TDUSER

  • 32. 
    Which of the following statement are true  Cliques in Teradata Server
    • A. 

      A clique is a set of nodes

    • B. 

      Clique has failover capability

    • C. 

      Both option 1 and 2

    • D. 

      None of the above

  • 33. 
    Which of the below happen in preliminary phase of MLOAD(multiple)
    • A. 

      Validate all statement on multi loads and sql

    • B. 

      Create work table one per target table

    • C. 

      Create error table two per target table

    • D. 

      Apply locks on target tables

    • E. 

      Get data from the source and apply to appropriate AMP worldtables

  • 34. 
    Which of the following information a secondary index subtable holds
    • A. 

      Value secondary index colums

    • B. 

      Secondary index Row Id

    • C. 

      Primary index Row Id

    • D. 

      All of the above

  • 35. 
    Loss of 2 AMP’s in fallback cluster causes the Teradata database to halt
    • A. 

      True

    • B. 

      False

  • 36. 
    TITLE of a COLUMN can be  used in where clause of query
    • A. 

      True

    • B. 

      False

  • 37. 
    Which two lock level are compatible with each other (multiple)
    • A. 

      Read and Write

    • B. 

      Read and Access

    • C. 

      Write and Access

    • D. 

      Exclusive and Read

  • 38. 
    See the below block of statement in side BTEQ script.Script is written inBTET transaction mode,BT; CREATE TABLE TEST1(COL1 INTERGER,COL2 INTERGER); INSERT INTO TEST1 VALUES(1.3);ET;What is true among the below options?
    • A. 

      Table Test1 will be created and one record will be inserted

    • B. 

      Table test1 will not be created since no PI is defined

    • C. 

      Table test one will not be created because  DDL Statement is not allowed inside BTET.

    • D. 

      Table TEST1 Will not be created because DDL Statementy is not the last statement inside BTET block

    • E. 

      Table test1 will be created but no records will be inserted inside that table

  • 39. 
    Which of the below are reasons behind the fast performance of fast load compare to BTEQ?
    • A. 

      Fast load assembles data into block to load

    • B. 

      It can use multiple session simultaneously to load

    • C. 

      Fast Load loads the records in one AMP’s memory

    • D. 

      Option A and B

    • E. 

      Option A,B and C

  • 40. 
    Filter Operator in TPT
    • A. 

      Consumes Data from a stream

    • B. 

      Sends data doen the stream

    • C. 

      Both option A and B

    • D. 

      None of the above

  • 41. 
    In teradata you must have NOT NULL constraint defined as Primary Key columns
    • A. 

      True

    • B. 

      False

  • 42. 
    Which of the below statements are supported by Fast Load?
    • A. 

      Create

    • B. 

      Drop

    • C. 

      Insert

    • D. 

      Update

    • E. 

      Delete

  • 43. 
    Write a query for SELECT the Student_ID,Last_name,first_Name,and Class_Code from the Student_Table. Only show the rows that have the Class_Code FR,JR,SR and if the First_Name ends in an ‘Y’ AND if their Last_Name ends in ‘Y’.Order By Class_Code
    • A. 

      Select Student_ID,Last_Name,First_Name,Class_Code from Student_Table Where     Class_Code=(‘FR’,’JR’,’SR’)And First_Name Like’%Y’ And Trim(Last_Name) Like ‘%Y’

    • B. 

      Select Student_ID,Last_Name,First_Name,Class_Code from Student_Table Where     Class_Code in (‘FR’,’JR’,’SR’)And First_Name Like’%Y’

    • C. 

      Select Student_ID,Last_Name,First_Name,Class_Code from Student_Table Where     Class_Code in (‘FR’,’JR’,’SR’)And First_Name Like’%Y’ And Trim(Last_Name) Like ‘%Y’ order by Class_Code

    • D. 

      Select Student_ID,Last_Name,First_Name,Class_Code from Student_Table Where     Class_Code in (‘FR’,’JR’,’SR’) And Trim(Last_Name) Like ‘%Y’ Order by Class_Code

  • 44. 
    See the below two block of statements in side BTEQ script.The script is written in ANSI     mode.1.DATABASE SQL_Class;SELECT*FROM SQL_Class EMPLOYEE, 2.DATABASE SQL_Class,COMMIT;SELECT *FROM SQL_Class EMPLOYEE,which of the following option is true?
    • A. 

      Both block will be successfully executed

    • B. 

      1st block will be executed successfully and 2nd block will fail.

    • C. 

      Both the block will fail

    • D. 

      2nd block will be executed successfully and 1st block will fail

  • 45. 
    In case of UPI,uniqueness value will always be 1
    • A. 

      True

    • B. 

      False

  • 46. 
    Which of the following secondary index creation statements are correct?(MULTIPLE)
    • A. 

      CREATE INDEX (ENAME) ON EMPLOYEE

    • B. 

      CREATE UNIQUE INDEX (ENAME,PHONE)ON EMPLOYEE

    • C. 

      CREATE INDEX ENAMEX(ENAME)ON EMPLOYEE

    • D. 

      CREATE SECONDARY INDEX (ENAME) ON EMPLOYEE

    • E. 

      ALL OF THE ABOVE

  • 47. 
    A table contains the following column:Inv_TSTIMESTAMP(6) WITH TIME ZONE Which expression returns the normalized hour (for the current session time zone) of column Inv_TS?
    • A. 

      EXTRACT(HOUR FROM Inv_TS)

    • B. 

      HOUR(Inv_TS AS TIMESTAMP(6)

    • C. 

      HOUR(CAST(Inv_TS AS TIMESTAMP(6)))

    • D. 

      EXTRACT(HOUR FROM CAST(Inv_TS AS TIMESTAMP(6)))

  • 48. 
    Which of the following condition much be true in order to make sure fast load is restartable using checkpoint?
    • A. 

      The error tables are not DROPPED in the script

    • B. 

      The target  tables are not DROPPED in the script

    • C. 

      The target is not created in script and a defined checkpoint

    • D. 

      NONE OF THE ABOVE

  • 49. 
    Access locks can be overwritten by exclusive locks
    • A. 

      True

    • B. 

      False

  • 50. 
    Multi Column Stats can not be Collected on Global Temporary tables
    • A. 

      True

    • B. 

      False

  • 51. 
    Which three function are performed on the database when a user submits a query to Teradata?(MULTILE)
    • A. 

      The BYNET passes the steps to the AMP

    • B. 

      The BYNET retrives the rows from the disks

    • C. 

      The AMP dispatches the plan steps to the BYNET

    • D. 

      The parser evaluates the SQL statemnets for ******

    • E. 

      The optimizer develops the least expencive plan

  • 52. 
    Which of the following statements is true regarding unique secondary index sub-table
    • A. 

      Subtable rows will reside in same AMP where main table rows reside

    • B. 

      Subtable rows will reside in different AMP where main table rows reside

    • C. 

      Subtable rows can reside in same or different AMP based on row hash of set column value

    • D. 

      None of these

  • 53. 
    SELECT with equality condition for a primary index is not allowed in fast export
    • A. 

      True

    • B. 

      False

  • 54. 
    Export operator in TPT is a type of
    • A. 

      Producer

    • B. 

      Consumer

    • C. 

      Stand alone

    • D. 

      Filter

    • E. 

      None of the above

  • 55. 
    Pick the query that finds out no of employee present in each department from the following option
    • A. 

      SELECTdepartment.deptno, COUNT (EMPLOYEE.Employee) from employee, Department where employee.deptno= department.deptno group by department.deptno

    • B. 

      SELECT COUNT (*) from employee

    • C. 

      Both 1 & 2

    • D. 

      None

  • 56. 
    BTEQ script can be used to
    • A. 

      Perform DML operations on tables.

    • B. 

      Report generation

    • C. 

      Import Export

    • D. 

      Loading huge files.

    • E. 

      All of the above

  • 57. 
    Secondary index can be useful for(Multiple)
    • A. 

      Data distribution of tables.

    • B. 

      Joining tables

    • C. 

      Processing Aggregates

    • D. 

      Value comparison

    • E. 

      None of the above

  • 58. 
    SQL Statements in BTEQ scripts are not autocommit in case of  BTET transaction mode.
    • A. 

      True

    • B. 

      False

  • 59. 
    Hash map contains
    • A. 

      Row hash to AMP Number mapping.

    • B. 

      PI value to Row Hash mapping

    • C. 

      PI value to AMP number mapping.

    • D. 

      None of the above

  • 60. 
    InMload Deleting based on UPI access is not permitted.
    • A. 

      True

    • B. 

      False

  • 61. 
    Stats can be collected on Derived Table
    • A. 

      True

    • B. 

      False

  • 62. 
    Which of the following are true regarding fast load.(Multiple)
    • A. 

      NO Secondary indexes are allowed on target table.

    • B. 

      No referential integrity is allowed on target table.

    • C. 

      No Triggers are allowed at load time

    • D. 

      Option 1 &2

    • E. 

      Option 1 and 3

  • 63. 
    Which expression will return what hour it will be in 3 hours 30 minutes?
    • A. 

      EXTRACT(HOUR FROM CURRENT_TIME * 00:30)

    • B. 

      EXTRACT(HOUR FROM CURRENT_TIME +’3.30 HOUR TO SECOND INTERVAL’)

    • C. 

      EXTRACT(HOUR FROM CURRENT_TIME +INTERVAL ‘3:30’ HOUR TO MINUTE)

    • D. 

      EXTRACT(HOUR FROM CURRENT_TIME + INTERVAL(‘3’ HOUR’ + ‘30’ MINUTE);

    • E. 

      EXTRACT(HOUR FROM CURRENT_TIME+(3 HOUR +’30’ MINUTE)INTERVAL)

  • 64. 
    During volatile Table Creation  if ON COMMIT option is explicitly not mentioned,by default it will be.
    • A. 

      ON COMMIT PRESERVE ROWS

    • B. 

      ON COMMIT  DELETE ROWS

    • C. 

      THE DDL was fail.

    • D. 

      Cant Say

  • 65. 
    SELECT Dept_No,First_Name,Last_Name,AVGSAL FROM EMPLOYEE_TABLE INNER  JOIN(Select DEpt_No,AVG(Salary) FROM Employee_Table GROUP BY Dept_No) as TeraSQL(Depty,AVGSAL) ON Dept_No=Depty.What is the name of the derived table?How many columns are in the derived table?Whats the name of the derived columns?
    • A. 

      Depty,1,Salary and dept_no

    • B. 

      TeraSQL,2,Depty and AVGSAL

    • C. 

      New,3,First_Name,Last_Name

    • D. 

      None of the above

  • 66. 
    Defination of volatile table is stored in Data Dictionary
    • A. 

      True

    • B. 

      False

  • 67. 
    Write the syntax that displays the column names,typeidentifier,and any user written comments on the columns within a table.
    • A. 

      HELP TABLE

    • B. 

      HELP TABLE;

    • C. 

      SHOW TABLE.

    • D. 

      None of the above

  • 68. 
    Which statements are supported by multiload (Multiple)
    • A. 

      INSERT

    • B. 

      UPDATE

    • C. 

      DELETE

    • D. 

      OPTION 1 &2

  • 69. 
    What is the syntax to display the names of all the tables(T).View(V),macros(M) and triggers(G)stored in user written table comments.
    • A. 

      SHOW USER

    • B. 

      HELP USER <USERNAME>

    • C. 

      HELP USER

    • D. 

      None of the above.

  • 70. 
    Teradata Parrallel Transporter can be used for
    • A. 

      Loading data into tables

    • B. 

      Export data from table

    • C. 

      Update Table

    • D. 

      Delete from tables

  • 71. 
    Which of the following statements will create tables which same properties.(Multiple)
    • A. 

      CREATE SET VOLATILE TABLE TABLE1(COL1 INTEGER, COL2 INTEGER,COL3 VARCHAR(10)) PRIMARY INDEX(COL1)ON COMMIT DELETE ROWS.

    • B. 

      CREATE MULTISET VOLATILE TABLE TABLE1(COL1 INTEGER,  COL2 INTEGER                     COL3 VARCHAR(10)) PRIMARY INDEX (COL1) ON COMMIT PRESERVE ROWS

    • C. 

      CREATE SET VOLATILE TABLE TABLE1(COL1 INTEGER,  COL2 INTEGER                     COL3 VARCHAR(10)) PRIMARY INDEX (COL1) ON COMMIT PRESERVE ROWS

    • D. 

      CREATE VOLATILE TABLE TABLE1(COL1 INTEGER, COL2 INTEGER,COL3 VARCHAR(10)) PRIMARY INDEX(COL1);

    • E. 

      CREATE MULTISET VOLATILE TABLE TABLE1(COL1 INTEGER,  COL2 INTEGER                     COL3 VARCHAR(10)) PRIMARY INDEX (COL1) ON COMMIT DELETE ROWS

  • 72. 
    Which of these statements are true?
    • A. 

      All AMPs can work in parallel.

    • B. 

      Each AMP can work on several requests in parallel

    • C. 

      Both a & b are correct

    • D. 

      None of a and b are correct.

  • 73. 
    Same value through hash algorithm may generate different row hash in different time
    • A. 

      True

    • B. 

      False

  • 74. 
    Which type of lock is applied on source in fast export utility
    • A. 

      Read

    • B. 

      Access

    • C. 

      Exclusive

    • D. 

      Write

  • 75. 
    A Teradata system has 6 AMPs employee id of employee table is primary index in that system.If the table has 12000 rows, how data will present in AMP disc:
    • A. 

      Each amp will have equal number of rows.

    • B. 

      Any AMP can have any number of rows depending on the availability during insertion

    • C. 

      Data will be inserted in a single AMP only based on availability during insertion

    • D. 

      None.

  • 76. 
    Which of the following statements are true regarding error tables of fastload(multiple)
    • A. 

      Error tables are automatically created by utility after providing names of those table

    • B. 

      First error table is for errors caused by duplicate values of UPI

    • C. 

      Second error table is for constraint violation

    • D. 

      First error table is for constraint violation

    • E. 

      Second error table is for errors caused by duplicate values for UPI

  • 77. 
    Accessing records using UPI is one AMP operation
    • A. 

      True

    • B. 

      False

  • 78. 
    In ideal situation records of one table will be stored in one amp disc
    • A. 

      True

    • B. 

      False

  • 79. 
    Fast load utility loads the record in the empty table
    • A. 

      True

    • B. 

      False

  • 80. 
    BYNET carries messages between AMPs and PE
    • A. 

      True

    • B. 

      False

  • 81. 
    Only one database can be created in one Teradata service
    • A. 

      True

    • B. 

      False

  • 82. 
    Which of the following are true regarding exclusive locks(multiple)
    • A. 

      Exclusive locks are placed when object are gone through structural changes

    • B. 

      Exclusive locks restrict access to the object by any other user

    • C. 

      Exclusive locks can be explicitly applied using locking modifier

    • D. 

      A and b

    • E. 

      A and c

  • 83. 
    Fast export supports only one select statement in a script
    • A. 

      True

    • B. 

      False

  • 84. 
    Data in global temporary table will remain
    • A. 

      Until the session end

    • B. 

      Until the data deleted by delete command

    • C. 

      Data can not be  kept in global temporary table

    • D. 

      Cant say

  • 85. 
    Which 2 lock level are compatible with each other(multiple).
    • A. 

      Read and Write

    • B. 

      Read and Access

    • C. 

      Write and access

    • D. 

      Exclusive and read

  • 86. 
    Multi column stats cannot be collected on global temporary table
    • A. 

      True

    • B. 

      False

  • 87. 
    Data in global temporary table is stored in
    • A. 

      Spool space

    • B. 

      Temp space

    • C. 

      Permanent space

    • D. 

      Data is not stored in global temporary table

    • E. 

      Spool or temp space

  • 88. 
    Which of the following are true regarding write locks(multiple)
    • A. 

      Write lock happen on DML request

    • B. 

      Write lock restrict access to any other user consistency

    • C. 

      Write lock restrict access to any other user consistency

    • D. 

      B and c

    • E. 

      A and b

  • 89. 
    Restart facility  is not available in fast export
    • A. 

      True

    • B. 

      False

  • 90. 
    A user seeing data with access locks get data with data consistency
    • A. 

      True

    • B. 

      False

  • 91. 
    Fast export supports only one select statement in a script
    • A. 

      True

    • B. 

      False

  • 92. 
    : A Non unique primary index will always spread the rows of the table evenly among AMPS
    • A. 

      True

    • B. 

      False

  • 93. 
    If source is having full row duplicates and target table is multiset table, will NUPI defined on it. Which of the following option is true regarding fastload utility
    • A. 

      Fastload will be successfully completed without rejecting any row since target table multiset

    • B. 

      Fastload will fail because fastloadcan not load duplicate record in target

    • C. 

      Fastload will be successfully completed but it will reject duplicate record

    • D. 

      Fastload will fail because it is not allowed in multiset table

  • 94. 
    A FALLBACK row is a copy of primary row stored in same AMP
    • A. 

      True

    • B. 

      False

  • 95. 
    A FALLBACK row is a copy of primary row stored in different AMP
    • A. 

      True

    • B. 

      False

  • 96. 
    Concatenation of input data file is not allowed in multiload
    • A. 

      True

    • B. 

      False

  • 97. 
    STATS can be collected on derived table
    • A. 

      True

    • B. 

      False

  • 98. 
    What will be the return code of bteq script in case of any syntax error in DML statement?
    • A. 

      00

    • B. 

      02

    • C. 

      04

    • D. 

      08

    • E. 

      12

  • 99. 
    Which statement is written correctly?
    • A. 

      SELECT *, table2.logdate,table2.logtime FROM DBC.ResUsageSPMA db1 WHERE db1.thedate=table2.logdate  AND db1.thetime=table2.logtime

    • B. 

      SELECT  table2.logdate,table2.logtime,(*) FROM DBC.ResUsageSPMA db1 WHERE db1.thedate=table2.logdate  AND db1.thetime=table2.logtime;

    • C. 

      SELECT  table2.logdate,table2.logtime,* FROM DBC.ResUsageSPMA db1 WHERE db1.thedate=table2.logdate  AND db1.thetime=table2.logtime

    • D. 

      SELECT  table2.logdate,table2.logtime,db1.* FROM DBC.ResUsageSPMA db1 WHERE db1.thedate=table2.logdate  AND db1.thetime=table2.logtime

  • 100. 
    Which of the following are true regarding read locks?(multiple)
    • A. 

      This is placed in response to a SELECT request

    • B. 

      This is placed in response to a SELECT request

    • C. 

      This lock can be explicitly placed using the LOCKING modifier.

    • D. 

      In multi-user environment with updates occurring and you need to keep data consistent, you want a read lock

    • E. 

      A, B and C

  • 101. 
    Arithmetic functions and aggregates are not processed in MLOAD?
    • A. 

      True

    • B. 

      False

  • 102. 
    Standalone operator in TPT requires to stream the data from producer operator:
    • A. 

      True

    • B. 

      False

  • 103. 
    Why would a NUPI be a better primary index choice than a UPI?
    • A. 

      To avoid skewing of the data

    • B. 

      To allow the index to have distinct values

    • C. 

      To guarantee even distribution of the table rows

    • D. 

      To allow access by a column with nonunique values

  • 104. 
    Error Files/tables are created in fast export utility?
    • A. 

      True

    • B. 

      False

  • 105. 
    How many tables are created during loading a table with MLOAD utility:
    • A. 

      2

    • B. 

      3

    • C. 

      4

    • D. 

      None of the above

  • 106. 
    How many number of sessions are created in a fast export script execution by default?
    • A. 

      2

    • B. 

      8

    • C. 

      6

    • D. 

      4

    • E. 

      None of the above

  • 107. 
    Accessing records using NUPI will always return one row?
    • A. 

      True

    • B. 

      False

  • 108. 
    Data Streams in TPT are DISK
    • A. 

      True

    • B. 

      False

  • 109. 
    Accessing records using USI will return Zero to one Row?
    • A. 

      True

    • B. 

      False

  • 110. 
    MultiLoad has data retrival capability:
    • A. 

      True

    • B. 

      False

  • 111. 
    How many ERROR tables are created in Fast Load Process?
    • A. 

      1

    • B. 

      2

    • C. 

      3

    • D. 

      Depends on number of targets

    • E. 

      Depends on Number of sessions working

  • 112. 
    Records can be exported from and imported into Teradata table using BTEQ utility?
    • A. 

      True

    • B. 

      False

  • 113. 
    Row distribution of Teradata tables depends on?
    • A. 

      Primary key

    • B. 

      Primary index

    • C. 

      Table type

    • D. 

      Secondary Index

    • E. 

      Server Settings

  • 114. 
    Selecting records using unique secondary index is?
    • A. 

      One AMP operation

    • B. 

      2 AMP operation

    • C. 

      ALL AMP Operation

    • D. 

      Depends on DATA

  • 115. 
    Load operator in Teradata parallel Transporter is equivalent to?
    • A. 

      MLOAD

    • B. 

      BTEQ

    • C. 

      FAST LOAD

    • D. 

      None of the above

  • 116. 
    How many MLOAD script can run the same time in a Teradata system?
    • A. 

      4

    • B. 

      10

    • C. 

      15

    • D. 

      32

  • 117. 
    In fast load we cannot insert or load into populated tables, to insert data using fast load before loading we cannot delete data in populated tables
    • A. 

      True

    • B. 

      False

  • 118. 
    Which of the below options is the best for joining columns in Teradata
    • A. 

      Joining column should be same data type

    • B. 

      Joining columns can be any data type

    • C. 

      Joining columns should be different datatype

    • D. 

      All of the above

  • 119. 
    Good query optimization includes which of the following
    • A. 

      Collect statistics on the join fields and PI columns

    • B. 

      Avoid in and not in use exists and non-exists

    • C. 

      Replace outer join with update

    • D. 

      All of the above

  • 120. 
    Select max(salary),min(salary),sum(salary),avg(salary),count (*) from employee , in this Query how many rows will be returned.
    • A. 

       9

    • B. 

      6

    • C. 

      2

    • D. 

      1

  • 121. 
    Select the correct order of sequence while creating and accessing global temporary table I. the user creates global temporary table II. Select and Insert III.  Query it until the session end because data will be dropped, table structure will stored
    • A. 

      II,I AND III

    • B. 

      I,II AND III

    • C. 

      II,III AND I

    • D. 

      I,III AND II

  • 122. 
    Explain cannot collect which of the following
    • A. 

      Product join

    • B. 

      Data skewness

    • C. 

      Full table scan

    • D. 

      No or low confidence

  • 123. 
    .More than one processed aggregate using different grouping function within a single select query
    • A. 

      True

    • B. 

      False

  • 124. 
    Mark for review Given the following table definition. CREATE TABLE employee ( Employee_id INTEGER NOT NULL, Employee_name varchar(50), Employee_job varchar(50)) Primary Index(employee_id), Which statement is a correct use of a comparision operator?
    • A. 

      Select * from employee where employee_job is null;

    • B. 

      Select * from employee where employee_job between positions;

    • C. 

      Select * from employee where employee_job IS’governance’ OR ‘quality’

    • D. 

      Select * from employee where employee_job IN ANY(maintenance, management, engineer);Clear response 

  • 125. 
    Which among this is correct ?
    • A. 

      0(successfully executed), 4(warning error), 8(configuration error), 12(fatal error).

    • B. 

      0(successfully executed), 12(warning error), 4(configuration error), 12(fatal error)

    • C. 

      4(successfully executed), 0(warning error), 8(configuration error), 12(fatal error)

    • D. 

      0(successfully executed), 12(warning error), 8(configuration error), 8(fatal error)