»Dotnet Ads
»Message Boards
Message Boards
Dotnet Books
»Member Details
Register
Login
LogOut
Submit Code
Submit Jobs
Submit Projects
»Competition
Community
Winners
Prizes
Write For Us
Members
»Other Resources
Links
Dotnet Resources
|
Sql Server interviewer topicsSQLServer is most and one of the basic back ends
Most of these topics are asked by interviewers
Basic database concepts * Investigation process, data requirements * Data Integrity Concepts (Domain Integrity, Constraints (PK, FK, Unique) Check constraint Datatypes, Null * Relations between tables and columns
Logical and Physical database design (Entity, Attributes, Degree of Normalization) * Entity, Attributes, Degree of Normalization
ER Model
Database Objects (Tables, Stored Procedures, UDF, Views, Synonyms, Triggers etc)
Basic SQL Syntax * Retrieving Data - Select * Filtering Data - Where
SQLPlus / Query Analyzer other tools
Grouping and Summarizing Data - Group by, compute, Top, Having, Cube, Rollup etc
Jions, Unions, SubQuery, IN, Exists etc
Using Transactions, Inserting. Deleting, Updating data
Cursors Packages Functions @, @@
Clustered and Non Clustered, Unique indexes
Index Architecture * Index and Heap * Index Options, maintaining indexes, Statistics * Index tuning, performance considerations
Selectivity, Density, Distribution of Data
Query Optimizer, Analyzer
Distributed Querying
Linking Servers Clustering Servers
Replication
Adhoc Query
Resource Maintenance (CPU, I/O, Memory, Processors)
Trace, System Monitor
Transactions and Locks
Managing Transactions (Execute, Rollback or cancel)
Locking (Tables, Columns, Rows)
Concurrency Issues
Lock Capabilities
Dynamic Locking, Lock Options
Security NT authentication
Data Base * ODBC, JDBC, Type of Drivers * ODBC Vs JDBC * OLE-DB, ADO, ADO Parameters * Distributed databases 2 phase commit
SQL Trace Server side logging
MTS, Weblogic, WebSphere - Connection Pooling, Transactions, Isolation Levels, Locking
Entity Beans Container managed, Bean managed
Handling Null fields
Persistency
RAID - Levels, usage
Any other topic re
|