Explain the first normal form(1nf)?
No Answer is Posted For this Question
Be the First to Post Answer
What's the difference between a primary key and a unique key?
Which table keeps the locking information?
How to change the data type of an existing column with "alter table" statements in ms sql server?
What is self contained scalar sub query?
What are the restraints imposed on the table design by a merge replication?
What are the advantages of using cte?
What is trigger in salesforce?
Write a stored procedure for emplpoyee and department table to get DeptName which having no employee. Table Structure- Emp-Emp_Id,Emp_Name,Dept_id Dept-Dept_Id,Dept_Name
If there exist a index on the table, and we then make a view on that table (include the indexed column from base table) than why do we require indexing on view?Doesnt it create an overhead?
Well sometimes sp_reanmedb may not work you know because if some one is using the db it will not accept this command so what do you think you can do in such cases?
how to find 6th highest salary
Explain about system database?
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)