Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?
No Answer is Posted For this Question
Be the First to Post Answer
What is replication with database mirroring? : sql server database administration
What is primary key, unique key, and foreign key?
How you can find out if an index is useful to the optimizer?
Explain Active/Active and Active/Passive cluster configurations
Explain what are the restrictions that views have to follow? : SQL Server Architecture
plss anybody specify tha constrian management system in dbms
What is a partition function in sql server?
Following are some of the question related to below mentioned query? select e1.salary from employee3 e1 where 2= ( select count(distinct(e2.salary)) from employee3 e2 where e2.salary>=e1.salary ) 1) What the query returns? 2) How it works? - Detail explanation (what the sub query does, why it is (where 2=)....etc...Please?
Explain atomicity?
Name the different type of indexes in sql?
What is normalization? Describe its different types.
I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration
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)