Below you'll find all my writing tagged with the word Sql Interview Questions. The posts are listed in chronological order. Click the post title to read more.
– Sponsored Ads —
Are there any troubleshooting tips for OEM? (for DBA)
Can 2 functions have same name & input parameters but differ only by return datatype ?
Can functions be overloaded ?
Can one export a subset of a table? (for DBA)
Can one import tables to a different tablespace? (for DBA)
Can one improve the performance of [...]
– Sponsored Ads —
A table has the following data : [[5, Null, 10]]. What will the average function return ?
An insert statement followed by a create table statement followed by rollback ? Will the rows be inserted ?
Are views automatically updated when base tables are updated ?
Assume that there are multiple databases running on [...]
A query fetched 10 records How many times does a PRE-QUERY Trigger and POST-QUERY Trigger will get executed ?
Can a root window be made modal?
Can we create two blocks with the same name in form 3.0 ?
Can we use a restricted package procedure in ON-VALIDATE-FIELD Trigger ?
Can we use GO-BLOCK package in a pre-field trigger [...]
At what point of report execution is the before Report trigger fired?
How can a group in a cross products be visually distinguished from a group that does not form a cross product?
How can one dump internal database structures? (for DBA)
How does one create a RMAN recovery catalog? (for DBA)
How does Space allocation table place within [...]
Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?
Atleast how many set of data must a data model have before a data model can be base on it?
Can one export to multiple files?/ Can one beat the Unix 2 Gig limit? (for DBA)
Can one import/export between different versions of Oracle? [...]
An open form can not be execute the call_form procedure if you chain of called forms has been initiated by another open form?
Can a property clause itself be based on a property clause?
Can you have more than one content canvas view attached with a window?
Describe two phases of Two-phase commit ?
Differentiate simple and complex, snapshots [...]
Can a tablespace hold objects from different schemes?
Can a view based on another view?
Can objects of the same schema reside in different tablespaces?
Can one rename a database user (schema)? (for DBA)
Define Transaction ?
Do View contain Data ?
Explain the relationship among database, tablespace and data file ?
Explain the relationship among Database, Tablespace and Data file?
How are [...]