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) An index is reaching a limitation on the number of pages it has, can you explain why this limitation exists and what work you would do to get around it?
IBM,
86
How do you view log files in sybase?
How to check parameter value in stored procedure sql server?
List different type of expressions with the example.
How to define an external table with a text file?
What is mssql?
Is there a difference in storage type of numeric and decimal data types in sybase? If yes, what?
Explain odi architecture?
What is de-normalization in sql database administration? Give examples?
Which are different types of database administration tools used in postgresql?
How to run sql commands in sql*plus?
Can a foreign key have a different name?
How will you hide an attribute? : sql server analysis services, ssas
What are different types of triggers?
Detail about query optimizer?
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.