is it important for a database administrator to understand the operating system and file access? : Sql server administration
No Answer is Posted For this Question
Be the First to Post Answer
I am learning Testing, so i want to learn SQL also because SQL is important for Testing. I want to know which is best Institute in Ameerpet or SR Nagar or any other place in Hyd? Please help me.
What are the differences between stored procedure and the dynamic sql?
Explain different backup plans?
What are window functions in sql server?
Does transparent data encryption provide encryption when transmitting data across the network?
Explain the first normal form(1nf)?
What is b tree index?
Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.
Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.
What is the difference between Userdefined function and stored procedure? Explain and give the example also
as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration
Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?
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)