Describe the grant/revoke ddl facility and how it is implemented?
When running a stored procedure definition script how would you guarantee the definition could be rolled back in the event of problems?
What is the purpose of having stored procedures in a database?
What is the difference between a scan component and a rollup component?
Explain the difference between the truncate and delete commands?
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)?
Can anyone give me an exaple of realtime start script in the graph?
What is the difference between dml expression and xfr expression?
How would you find out whether a sql query is using the indices you expect?
What is $mpjret?
How can I run the 2 gui merge files?
I am unable to connect sever database(oracle) from gde(db config file) local system.i set all these?
Describe the elements you would review to ensure multiple scheduled batch jobs do not collide with each other?
What are differences between different gde versions(1.10,1.11,1.12,1.13and 1.15)?what are differences between different versions of co-op?
When using multiple dml statements to perform a single unit of work, is it preferable to use implicit or explicit transactions, and why?