What are the different types of collation sensitivity?
No Answer is Posted For this Question
Be the First to Post Answer
Differentiate between delete and truncate.
2) Consider a Table name A which has below records ID --- 5 5 5 5 5 Consider another table B which has below records ID -- 5 5 5 5 5 5 5 5 How many rows will be returned by each of the below queries a) select * from A inner join B on A.id = b.ID b) select * from A left join B on A.id = b.ID c) select * from A right join B on A.id = b.ID
What are transactions and its controls?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?
What do you mean by sql server agent?
How you can get the list of largest tables in a database?
Explain rdbms?
What happens to a statement batch if there is a compilation error?
What are the system database in sql server 2005?
What is the recovery model? List the types of recovery model available in sql server?
How to stop a loop early with break statements in ms sql server?
Explain tablesample?
Oracle (3253)
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)