Interested to Buy Any Domain ? << Click Here >> for more details...
System variable and temporary variables
- 0 Answers
- 2295 Views
- Wipro, I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
How to generate the Reports for the Database? I need an Example for it.Will we manually do this or else any script is there? Please let me know ASAP...
Can you explain important index characteristics?
List few advantages of stored procedure.
How does a profiler work?
What are a scheduled jobs?
What are three SQL keywords used to change or set someone?s permissions?
What is the parse query button used for?
Can a rule be bound to any column of any data type?
Mention the differences between substr and charindex in sql server.
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
What are triggers? How do you invoke a trigger on demand?
Explain what you mean by 3 tier architecture.
-
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)
