We create a journal / journal table at creation of table?

False.

Journal or Journal table is created at creation time of database
or users. we can also create these using MODIFY statement of
database or user.

At table creation time we just specify
1. Enable or disable journaling for that table
2. which journaling table to be used
3. what type of journaling to be used(Before / After/ Dual Before / Dual After)

what is a permanent journal and explain different types?

A Permanent Journal captures a picture of any row that changes. This would include UPDATES, INSERTS, and DELETES. Permanent Journals do not double the data or PERM for a table, but only doubles the rows that change.

i.e
The Permanent Journal stores only images of rows that have been changed due to an INSERT, UPDATE, or DELETE command.

There are four image options for the Permanent Journal:

· Before Journal

· After Journal

· Dual Before Journal

· Dual After Journal

Create a table with Fall back ,Before Journal and dual after journal features?

create table student ,
fallback,
before journal,
dual after journal
(
sno integer,
sname varchar(30),
sfee decimal(10,2)
)
unique primary index(sno);

what are the different image options for Permanent Journal?

There are four image options for the Permanent Journal:

· Before Journal

· After Journal

· Dual Before Journal

· Dual After Journal

Permanent Journals are automatically purged in teradata. True / False?

False.

The Permanent Journal must be manually purged from time to time.

which objects require Perm space in teradata?

Tables and Stored Procedures objects require Perm Space

Views, Macros , Triggers doesn't require Perm space.

Does Permanent Journals and Secondary indexes require Perm Space?

Ans: Yes

useful URLs?

http://www.coffingdw.com/Teradata_Basics/teradata_basics.htm#chapter_9___advanced_topics_that_you_will_be_tested_on/teradata_cabinets_nodes_vprocs_and_disks.htm