⟩ How will you activate/deactivate integrity constraints?
The integrity constraints can be enabled or disabled by ALTER TABLE ENABLE CONSTRAINT / DISABLE CONSTRAINT.
The integrity constraints can be enabled or disabled by ALTER TABLE ENABLE CONSTRAINT / DISABLE CONSTRAINT.
Tell us what are the different types of Upgrades that can be performed in SQL Server?
Tell me what authentication modes does SQL Server support?
Can you explain about your SQL Server DBA Experience?
Do you know what does ‘SELECT’ do?
Tell me which autogrowth database setting is good?
Explain me where do you find the default Index fill factor and how to change it?
Explain me what are the operating modes in which Database Mirroring runs?
Explain me what is SQL?
Tell us some of the requirements to setup a SQL Server failover cluster?
Tell me what are the different SQL Server Versions you have worked on?