|
Related Questions |
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
|
|
What is an outer join?
|
View Answer
|
|
What are primary keys and foreign keys?
|
View Answer
|
|
Have you used rollup component? Describe how.
|
View Answer
|
|
Have you worked with packages?
|
View Answer
|
|
Explain what is lookup?
|
View Answer
|
|
How to handle if DML changes dynamically in abinitio
|
View Answer
|