DB Performance
DB Schema
Arrays/Prepared queries
Convey Miscelaneous
100
Is a cost of 1000 considered high, low, or it depends?
It Depends
100
What type of Data Schema changes we have?
Conversion, DB Setup, IPAccess
100
What is the downside of inserting the variables as literals in the query?
Oracle cannot cache the prepared queries, as they are always different, so it needs to do a hard parse every time it executes
100
What are Tumbas, Banquero y Ventas?
The translated last names of John Graves, Paul Banker and Clark Sells
200
What is an Index Range Scan
It is a search through an Index using a max and min values
200
what should we do if we are going to update an indexed column in all rows of a large table, before doing the update?
We should drop the index, and recreate it after the update
200
What is the delphi Class we use to create queries that can use array processing?
SQLConnection
200
What was the name of the first indian employee that Convey had?
Alagesan Govindarasan
300
What is the difference between the Rule Based Optimizer and the Cost Based Optimizer
RBO uses the indexes created to decide what plan to use, without paying attention to statistics. CBO uses statistics to decide what plan to use, and might not use the most obvious one
300
When we add a field in the CNVREMOTEFILE table, which file should I update, and which sections of the file should be updated?
DBSetup.sql, and both the xxxx year conversion and the table creation
300
What is the most common value of the pump step in powerview? What is the downside of a value 1000 times larger?
the most common value is 100. Setting the step value to a very high value makes commits of the pump operation to the DB much less often, so it is harder to spot errors. Also it can use much more memory as part of processing the pump
300
Order these products by order of creation: 1) 1099 Convey 2) Compass 3) AP 4) Powerview 5) Formview 2
1,4,5,3,2
400
What is the difference between Explain Plan and Autotrace?
Explain Plan analyzes the Query, Autotrace actually executes the query and displays the used plan
400
What is the right way to run an insert in cnvglobalsettings on every domain as part of the release?
We must use the scripts exposed by Julio in ASP Manager (soon to be implemented in OASIS) to execute a resource/SQL together with every domain deployment
400
Where does oracle Store the prepared statements cache for re-utilization?
In a section of memory called Shared Pool
400
What was the full name of Convey Argentina S.A. before we changed our name?
NOA Software Services S.A.
500
What are the Function Based Indexes? When can they be used?
Are Indexes built on functions of fields, instead of individual fields. The function in the query must match exactly the function in the index
500
a) When should we use char instead of varchar2 type? why? b) Where should the columns that are very often NULL go in the table? why?
a) never (or if ever, for 1 char fields), because char fields are padded to the full size b) whenever possible, towards the end of the table, to save space (if the row ends in NULL values, those values dont take space)
500
Create a human pyramid
He He....
500
Who wrote the original version of Relay Engine?
Jay Graham
M
e
n
u