Microsoft SQL Server Database Quiz Questions

RDBMS is indeed short for Relational Database Management System, which is designed to manage relational databases.

RDBMS uses tables to organize data, where each table is a collection of rows and columns.

RDBMSs use SQL (Structured Query Language) for querying and managing the data.

Normalization helps in reducing data redundancy and improving data integrity.

A primary key is a unique identifier for each record in a table.

Foreign keys create a relationship between tables to enforce referential integrity.

Transactions in an RDBMS ensure that a series of operations are completed successfully or not at all, maintaining data integrity.

RDBMSs support various constraints, including UNIQUE and CHECK, to enforce data integrity.

Views are used to present data from one or more tables in a simplified format.

RDBMSs are designed to handle multiple users and concurrent data modifications efficiently.

Features of an RDBMS include data integrity, SQL support, and relational data storage.

Common constraints in RDBMS include PRIMARY KEY, FOREIGN KEY, UNIQUE, and CHECK.

SQL commands like CREATE TABLE and ALTER TABLE are used to enforce constraints.

Types of SQL JOINs include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

The WHERE and HAVING clauses are used for filtering data in SQL.

Aggregation functions include COUNT, SUM, AVG, MIN, and MAX.

The ORDER BY clause is used to sort results in ascending or descending order.

Data modification statements include INSERT, UPDATE, and DELETE.

Commands like DROP TABLE and TRUNCATE TABLE are used to remove data or structure.

SQL keywords like CREATE TABLE and ALTER TABLE are used for table creation and management.

The DISTINCT keyword is used to remove duplicate values from the result set.

The GROUP BY clause groups rows with the same values into summary rows.

The SUM function calculates the total of a numeric column.

The UPDATE statement is used to modify existing records in a table.

The ORDER BY clause is used to sort the results of a query in ascending or descending order.

A FOREIGN KEY enforces a link between the data in two tables to maintain referential integrity.

A PRIMARY KEY uniquely identifies each record in a table.

The CREATE TABLE command is used to define a new table and its columns.

The MAX function is used to find the largest value in a column.

The DISTINCT keyword removes duplicate records from the result set.

The LIMIT clause (or its equivalent in SQL Server, TOP) is used to limit the number of rows returned by a query.

A view is a virtual table based on the result of a SELECT query, which simplifies complex queries.

The TRUNCATE TABLE statement removes all rows from a table without deleting the table itself.

The ALTER TABLE statement is used to modify the structure of an existing table.

A stored procedure is a precompiled collection of one or more SQL statements that can be executed as a unit.

A trigger is a stored procedure that automatically executes or fires when certain events occur in a table or view.

The UNIQUE keyword is used to ensure that all values in a column are distinct.

The JOIN clause is used to combine rows from two or more tables based on a related column between them.

A schema is a collection of database objects, including tables, views, and procedures, grouped together.

The CREATE INDEX keyword is used to create an index on a table to improve query performance.

The GETDATE() function returns the current date and time in SQL Server.

The EXECUTE command is used to run stored procedures or dynamic SQL statements.

The LEN() function returns the number of characters in a string.

The NULLIF() function returns NULL if the two specified expressions are equal; otherwise, it returns the first expression.

Data Definition Language (DDL) commands include CREATE, ALTER, and DROP.