⟩ Most important DDL statements in SQL are
CREATE TABLE - creates a new database table
ALTER TABLE - alters (changes) a database table
DROP TABLE - deletes a database table
CREATE INDEX - creates an index (search key)
DROP INDEX - deletes an index
CREATE TABLE - creates a new database table
ALTER TABLE - alters (changes) a database table
DROP TABLE - deletes a database table
CREATE INDEX - creates an index (search key)
DROP INDEX - deletes an index
Tell me what is the difference between dropping a database and taking a database offline?
Tell me why should I go to all the trouble of creating a database when I have a perfectly good Excel Spreadsheet?
Do you know what is DCL?
Tell us what different steps will a SQL Server Developer takes to secure SQL Server?
Tell us how can you control the amount of free space in your index pages?
Tell us what are the different Topologies in which Replication can be configured?
Tell me what are the different Authentication modes in SQL Server and how can you change authentication mode?
Tell us what is the difference between the 2 operating modes of Database Mirroring?
Tell me what are the commands used in DCL?
Do you know what ODBC is?