What is proper subset of candidate key?
No Answer is Posted For this Question
Be the First to Post Answer
how many clustered indexes can be created on a table? : Sql server database administration
table:employee EID ENAME MID(manager ids) 101 rama null 102 sita 101 103 siva 101 104 ganesh 103 . . . . . . for 103 ID the manager ID is 101(RAMA) and for 104 manager is SIVA if i give employee id (EID) you have to tell the manager for that EID write query? eample:if i give 102 .The query output should be manager for 102 ID that it should print RAMA as output
Is it possible to update the views? If yes, how, if not, why?
What is inner join? Explain with an example?
How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables?
4 Answers Credit Suisse, GCU, Symphony, TCS,
What is the maximum length of an alert name?
Does hive support indexing?
what is advantages in sql 2005 over sql 2000?
What is correlated subquery in sql server?
Do you know what are the restrictions applicable while creating views? : SQL Server Architecture
Do you know what guidelines should be followed to help minimize deadlocks?
How to configure and test odbc dsn settings?
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)