Interested to Buy Any Domain ? << Click Here >> for more details...
What is auditing?
- 2 Answers
- 4956 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / s
Audit records the SQL statement executed against the table,
the AUTHID and the timestamp. AUDIT ALL records INSERT,
UPDATE, DELETE, SELECT. AUDIT CHANGES records INSERT,
UPDATE, DELETE.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / mehdee
When we create DB2 table, if we assign the AUDIT option,
then as this tabe being accessed, DB2 will records
information about all those access so that later the DBADM
person will be able to use their Monitoring software and
Analize/Locate the problem in case it was any. But most of
the time we do not assign the AUDIT option unless it is
required, because it will use lots of DB2 resurces as this
DB2 table being used.
| Is This Answer Correct ? | 0 Yes | 0 No |
How do you define a correlated name?
What is the difference between cursor and select statement?
Explain db2.
How do you declare a host variable (in COBOL) for an attribute named emp-name of type VARCHAR(25) ?
Which is faster delete or truncate?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
What is check constraint. Explain with example.
How do we specify index to include or not during bind process.
When is the access path determined for dynamic SQL?
What is isolation level?
In SPUFI suppose you want to select maximum of 1000 rows, but the select returns only 200 rows. What are the 2 SQLCODEs that are returned?
if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a unique index is also defined on ACC.NO and ACC.NAME then write a query to retrieve account holders records who have more than 1 ACC.
COBOL 
