Explain what is dbcc?
No Answer is Posted For this Question
Be the First to Post Answer
After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas
Explain indexing and what are the advantages of it?
What are the basic functions for master, msdb, model, tempdb and resource databases?
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 do you mean by normalisation?
How do you find the error, how can you know the number of rows effected by last SQL statement?
How except clause is differs from not in clause?
What is policy management?
What is master database? : SQL Server Architecture
What is temporal table?
How will u test the stroded procedures and functions? difference between SP and Triggers
What is the syntax for encrypting a column in SQL Server?
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)