1) Between VARCHAR Vs Compression. Compression is best when? a) when the difference of maximum and average field length is low and compressibility is high b) when the difference of maximum and average field length is average and compressibility is low c) when the difference of maximum and average filed length is high and compressibility is high d) when the difference of maximum and average filed is high and compressibility is low Answer: a 2) What is not a characteristic of Tpump? a) Can utilize stored procedure b) has no session limit c) supports conditional processing d) can change the rate at which statements are sent to be processed Answer: a (doubt) 3) PERM space utilized can be calculated using which DBC viwe/table? a) DBC DiskSpace b) DBC SpaceUtilization c) DBC Space d) DBC Disk Answer: a 4) When there is a Read lock on the table and a request needing write lock is triggered what will be the status of the second request? a) Lock granted b) Request Queued c) Request abort d) Error Message Answer: a 5) Constant updating of rows in a table is achieved by a) Multiload b) Fastload c) Fastexport d) Tpump Answer: d 6) Which of the following can be used to enhance input records to Fastload before sending them to the database a) OUTMOD routine b) Notify exit routine c) INMOD routine d) DEFINE command Answer: c 7) When is NUSI Bitmapping done? a) When 2 or more weakly selective NUSIs are ANDed together b) When 2 ot more Weakly selective NUSIs are ORed together c) When 2 or more Weakly seletive NUSIs are NORed together d) all of the above Answer: a 8) ______ returns the hexadecimal row hash value for an expression a) HASHMAP b) HASHBAKAMP c) HASHBUCKET d) HASHROW Answer: d 9) The followning SQL is equivalent to - SELECT city, kind, sales, SUM(sales) OVER (ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) FROM monthly a) Cumulative sum b) Group sum c) Moving sum d) Moving Difference Answer: b 10) When rows are inserted into a table with an identity column, the identity column will always be consecutively numbered? a) True b) False Answer: b 11) SELECT CAST('bb12345bb' as CHAR(3)), (b = space). What is the answer set returned from the following query? a) 123 b) 1 c) bb1 d) No answer set is returned because you can't cast Integer data as Char Answer: 1 12) Which statements are true about work tables for TPump Versus MultiLoad a) 1. Multiload - Optional, 1 per target table. 2. TPump - no work tables needed b) 1. Multiload - Optional, 2 per target table. 2. TPump - Optional, 1 per target table. c) 1. Multiload - Optional, 1 per target table. 2. TPump - Optional, 1 per target table. d) None of the above Answer: d. MLOAD atleast need 1 work table. Need 2 work table if IMPORT mode, only one work table if DELETE mode. TPUMP doesnt need any work table , nly work table 13) A foreign Key column in a referenced table is defined as NOT NULL. A row is inserted into the following table. What one thing does referential Integrity check? a) If the row inserted is a Foreign key row b) If NO CHECK OPTION has been defined on the referenced table c) If the row exists in the referenced table with the same values as that in the referencing columns d) If the Foreign key in the referencing columns is an Identity Column 14) Maximum combination of columns allowed for PI are? a) 32 b) 16 c) 64 d) 128 Answer: c 15) Which statements are true about "Allows RI, USI, Triggers" for TPump Versus MultiLoad a) 1, MultiLoad- Yes 2. Tpump - No b) 1, MultiLoad- Yes 2. Tpump - Yes c) 1, MultiLoad- No 2. Tpump - Yes d) None of the above Answer: C ---------------- 1) I/P, output and CPU time - how to identify 2) Learn about inner query and outer query 3) another name for stale read - Answer - Access Lock 4) Another name of EXCEPT - optins MINUS, NOT IN, INSTEAD OF Answer - MINUS 5) Identity columns - Default identify column 6) create/modify/delete table will be performed in? options AMP, Parser, PR, Dispatcher 7) Empty table - load utility - FLOAD 8) How to identify access details. options a) DBC.allrights b) DBC.allrolerights User access details - dbc.allrights Access rights for a given role can be identified in the DBC.AllRoleRights 9) DBC.table list and its purpose DBC.TABLES - To get the table names DBC.INDICES - this table stores information about the indices, which table they are stored, etc. DBC.COLUMNS - this table stores the column information, not null/nullable, datatype, unique/non-unique. DBC.DBQLOGTBL - The DBC.DBQLogTbl stands for database query log. As the name explains, it contains all the core performance data for the queries that run on the system. Before you start querying this table ensure that Query logging is enabled for the User dbc.users dbc.dbase DBC.ERRORMSG - this table gives an understandable description of the Teradata errors Select count(distinct nodeid) from dbc.resusagescpu; --- this query will let you find the total no. of Teradata nodes in the system Select nodeid,count(distinct Vproc) from dbc.ResCpuUsageByAmpView group by 1; ---- this query will allow to find the no. of Vproc in the system 10) SELECT COUNT(DISTINCT(DEPT.NO) FROM DEPT. Options a) count of all dept id in dept table b) count of unique dept id including null c) count of unique dept id excluding null 11) Partition preceding 3 12) how to set unique record in MULTISET tables. options a) USI b)NUSI c)UPI d)NUPI Answer - UPI 13) User assigned to multiple role can change his role by using __ options a) create role b) set role c) grant role d) grant role with admin options. Answer: set role 14) Stale read is also called as options a) Access locks b) Read lock c) Write lock d) Exclusive lock. Answer - Access lock 15) Perm Space is 0, what can not be done options a) view and macro b) view and tables c) tables and stored procedure Answer: tables and stored procedure 16) Once the target AMP is determined for PI, ______ for that AMP must be consulted options a) cylinder Index b) Master Index Answer Master Index 17) To load the archive file to table. options a) Restore b) Copy c) Archive d) 18) Which utility is buit in with reporting capability Options a) MLOAD b)FLOAD c) FastExport d) TPump Answer: FastExport 19) Select emp nm , id from emp e1 where sal in ( select max(sal) from emp e2 where e2.empid= e1.empid); 2. 1 quetsion 9, Syntax error a) if a AMP in a Cluster down which which AMP it will point to. options like 1) next amp in the cluster 2) Adjacent amp to next cluster. 3) no Amp it will refer. 4) if amp down will wait for the amp to recover back. b) questions Corellated query. C) questions subquery.