Millionaire Mode

SQL Server Database Fundamentals

Question 1 of 20

You want to track date and time of the last write access (INSERT, UPDATE) per row. How can you achieve that?

  1. Add a TIMESTAMP column to the table; SQL Server will automatically track date and time of every change.
  2. Add a DATETIME column to the table and assign getdate() as the default value.
  3. Add a DATETIME column to the table and write a trigger that sets its value.
  4. Add a UNIQUEIDENTIFIER column to the table and use it with SQL Server's built functions

Prize Money

15₹7 Crores
14₹1 Crore
13₹50,00,000
12₹25,00,000
11₹12,50,000
10₹6,40,000
9₹3,20,000
8₹1,60,000
7₹80,000
6₹40,000
5₹20,000
4₹10,000
3₹5,000
2₹2,000
1₹1,000