|
Related Questions |
View Answer |
|
what is difference between file and table in abinitio
|
View Answer
|
|
what is backward compatibility in abinitio
|
View Answer
|
|
How to Create Surrogate Key using Ab Initio?
|
View Answer
|
|
What does dependency analysis mean in Ab Initio?
|
View Answer
|
|
How to create repository in abinitio for stand alone system(LOCAL NT)?
|
View Answer
|
|
What is the difference between rollup and scan?
|
View Answer
|
|
What is the difference between a DB config and a CFG file?
|
View Answer
|
|
Describe how you would ensure that database object definitions (Tables, Indices, Constraints, Triggers, Users, Logins, Connection Options, and Server Options etc) are consistent and repeatable between multiple database instances (i.e.: a test and production copy of a database).
|
View Answer
|
|
Describe the “Grant/Revoke” DDL facility and how it is implemented.
|
View Answer
|
|
When running a stored procedure definition script how would you guarantee the definition could be "rolled back" in the event of problems.
|
View Answer
|
|
Explain the difference between the “truncate” and "delete" commands.
|
- Abinitio Interview Questions & Answers">
View Answer
|
|
Describe the process steps you would perform when defragmenting a data table. This table contains mission critical data.
|
View Answer
|
|
Describe the elements you would review to ensure multiple scheduled "batch" jobs do not "collide" with each other.
|
View Answer
|
|
When using multiple DML statements to perform a single unit of work, is it preferable to use implicit or explicit transactions, and why.
|
View Answer
|
|
How can you force the optimizer to use a particular index?
|
View Answer
|
|
How would you find out whether a SQL query is using the indices you expect?
|
View Answer
|
|
What is a cursor? Within a cursor, how would you update fields on the row just fetched?
|
View Answer
|
|
Why might you create a stored procedure with the 'with recompile' option?
|
View Answer
|
|
What is the purpose of having stored procedures in a database?
|
View Answer
|
|
What are Cartesian joins?
|
View Answer
|