List some of the rules that apply to creating and using a ‘view’
No Answer is Posted For this Question
Be the First to Post Answer
Write a query to include a constraint, to check whether the employee salary is greater than 5000?
What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?
Explain indexes disadvantages?
What is a derived table?
To automatically record the time on which the data was modified in a table, which data type should you choose for the column?
How can you fetch alternate records from a table?
What are the different types of locks in the database?
Explain what role entity and relationship play in an ER diagram.
Explain what is analysis service repository?
How adventureworkslt tables are related?
How to retrieve range of 10th rows to 20 th rows from total rows from a database table.? (Not from Dataset)
10 Answers Cognizant, Infosys,
Why is there a performance difference between two similar queries where one uses union and the other uses union all?
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)