© 2014 Firstsoft Technologies (P) Limited. login
Hi 'Guest'
Home SiteMap Contact Us Disclaimer
enggedu

Home Placements Interview Questions Database Interview Questions And Answers Page7▼

Database Interview Questions And Answers

42. What are the types of Indexes

Indexes can be clustered and non-clustered indexes.
Clustered index keeps all the records in the database in the order of clustered index key.
There can be only one clustered index per table.
Non-clustered indexes are stored as B-tree structure in their own storage separate from data storage in the table.

43. What are the disadvantages of the Indexes?

Indexes improve query performance but it slows down data modification operations.
Indexes consume disk space.

44. Delete vs. Truncate table?

Delete logs the deletion of each row whereas Truncate doesn't log deleted rows in the transaction log. This makes truncate command is bit faster than Delete command.

45.Define constraints

Constraints enforce integrity of the database. Constraints can be of following types
Not Null
Check
Unique
Primary key
Foreign key

46.Define stored procedure?

Stored procedure is a set of pre-compiled SQL statements, executed when it is called in the program.

47. Define Trigger?

Triggers are similar to stored procedure except it is executed automatically when any operations are occurred on the table.

48. Primary key and unique key ?

Stored procedure is a set of pre-compiled SQL statements, executed when it is called in the program.

Previous Next
1 2 3 4 5 6 7 8 9
SLogix Student Projects
bottom