Answer Posted / priyanka
there are basically two types of concurracnies...
1-> logical concurrency
2-> physical concurrency
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
To automatically record the time on which the data was modified in a table, which data type should you choose for the column?
1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.
How to insert new line characters into strings?
how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?
What encryption security is available in sql azure?
How do you create type- insensitive operator?
What causes index fragmentation?
While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?
Is sql server implemented as a service or an application? : Sql server database administration
Can you pass expressions to function parameters?
What is the purpose of sql profiler in sql server?
Can we take the full database backup in log shipping?
What are the tables in sql?
Is it possible in sql table to have more than one foreign key?
How to create a simple user defined function in ms sql server?
