Hallmark Health Care Solutions Interview Questions, Process, and Tips

You can reset the identity column using DBCC Checkident command.

• Use DBCC Checkident command with RESEED option to reset the identity column.

• Specify the table name and the new identity value as parameters.

• For example, to insert a new identity of 100 in a table named 'MyTable', use: DBCC Checkident('MyTable', RESEED, 100);

ACID properties are a set of properties that guarantee that database transactions are processed reliably.

• Atomicity ensures that either all operations in a transaction are completed successfully or none of them are.

• Consistency ensures that the database remains in a consistent state before and after the transaction.

• Isolation ensures that the concurrent execution of transactions results in a system state that would be obt...read more

Exceptions faced in Selenium

• StaleElementReferenceException

• NoSuchElementException

• TimeoutException

• ElementNotVisibleException

• ElementNotInteractableException

Waits in Selenium are used to synchronize the test execution with the application's response.

• Implicit Wait

• Explicit Wait

• Fluent Wait

• Thread.sleep()

• WebDriverWait