what difference between delet and truncate ?
Sql Programmer Interview Questions
2,216 sql programmer interview questions shared by candidates
Q. What is the view and materialized view?
SQL Server Architecture, Power Shell, Backup/Recovery, Cluster, Mirroring, Always ON, previous projects, T-SQL
PLSQL collection and how to update column using bulk update?
Everything about sql
Questions about the technologies I worked and how fast I can upgrade myself if needed to?
What DBA tools are used for
Trigger, views, sp, function, queries
Tell me about your self
Joins, Acid properties, constraints, diff types, aggregate functions, how to improve performance, cursor types of cursor, triggers type of triggers, views and materialized views diff also, operators bulk collect and for all statement,indexing, n its types, clustered and non-clustered index diff,correlated query,partitions, diff b/w truncate and drop, dml ddl n dcl commands, normalization, hierarchical representation from any table write a query, mutating error, instead of trigger indirect use, one question from package
Viewing 1201 - 1210 interview questions