What is the error message that you would get if you try to assign “Null” to an integer variable ?
Answer : error message: cannot convert null to int…
Browsing Tag
Persistent Systems interview questions and answers
129 posts
What is the difference between shell script and perl ?
Answer : Shell script is platform(OS) only for Unix flavour…
How to connect to the Database from QTP ?
Answer : Create an ADODB connection object which is required step for connecting to database as below….
What does the top command display ?
Answer : Top displays the top processes on the system and periodically…
What is DITA ?
Answer : Darwin Information Typing Architecture (DITA) is the most ideal approach…
What is indexing in database ?
Answer : Indexing is the One of the ways that will optimize the database searching…
What is Normalization ?
Answer : Normalization is the process of reorganizing data in a database…
Design a database for a hierarchical data like country, state, zone, street etc., The tags and length of the hierarchy are not specific and they can change anytime ?
Answer : Hierarchical data is a common relational data pattern for representing tree-like data structures…
What is the difference between comp and comp-3 usage ?
Answer : COMP is 2 bytes.COMP-3 is 8 bytes…
Lazy writer in Memory ?
Answer : Lazy write is an effect caused by the use of a write-back cache…
What is the difference between the SubQuery and Corelated SubQuery ?
Answer : The inner query is executed only once…
What is the Difference between join and union ?
Answer : The union operator combines the results of two or more queries into a single result set…
What is the difference between a HAVING CLAUSE and a WHERE CLAUSE ?
Answer : The HAVING clause sets conditions on the GROUP BY…
Difference between Clustered and Non-clustered index ?
Answer : Cluster index: Clustered index will be created…
