Difference between rowid and rownum in SQL?
Answer / yash
the difference between ROWNUM and ROWID is that ROWNUM is temporary while ROWID is permanent
| Is This Answer Correct ? | 1 Yes | 0 No |
Explain what is meant by replication of database?
How can we get count of the number of records in a table?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
How to transfer Logins from SQL Server 2000 to 2005
Explain the steps to use transact-sql cursor?
Explain indexed views?
Explain contrast amongst grouped and non-bunched records?
How do you simulate a deadlock for testing purposes
two tables are there.1st table EMP has two columns ID and name and contains data 1,A 2,B 3,C 2nd table EmpSal has 2 columns ID and Salary Contains data -1,1000 2,5000 3,3000 Find name of employee having maximum salary ?
What are different types of collation sensitivity?
let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration
What is the difference between locking and multi-versioning?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)