Mention the 3 ways to get a count of the number of records in a table.
No Answer is Posted For this Question
Be the First to Post Answer
Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?
Other than truncate statement, which other command can by-pass the trigger on the tables?
Write a query to find 5th highest amount paid from the customer table.
What is an example of a foreign key?
What happens if null values are involved in comparison operations?
Is it possible to have more then one foreign key in a single table? if possible, is this the good way to design the table?
Do you know what are the properties of the relational tables?
What is use of attribute hierarchy optimized state? : sql server analysis services, ssas
Define ACID properties in a Database?
How do triggers work?
An employee table, with the columns id, name, sal and dob. Query to select emp names of all highest salaries(there are 4-5 people having the same salary which happens to be the highest).
How many index keys possible for a table