Database Administration and Security Quiz

Management role focusing on controlling corporate data resources (both computerized and manual).

Maintains a successful database environment, ensuring security and maintenance.

DBMS features and measures to meet organizational security requirements.

Basic syntax for specifying security restrictions in a database system.

People or programs interacting with database objects.

Defines the logical structure of the database (what data it contains).

Develops and maintains the physical implementation of the database.

Protects the DBMS and the database against unauthorized access, loss, and mishandling.

A SQL account that allows access to the database server.

An account within a specific database that has permissions to access its objects.

SQL command to create a new server login account.

SQL command to create a new database user account.

SQL command to assign permissions to a user or role.

SQL command to remove permissions previously granted to a user or role.

A collection of permissions that can be assigned to users or other roles.

A permission to perform a specific action in a database.

An account used to connect to the SQL Server service (also called an instance). It's the first step to access databases.

A user within a specific database that's linked to a login. It's granted permissions to access objects within the database.

Assigning a SQL Server login to a specific database user, allowing the login to access that database.

A graphical tool used to manage and administer SQL Server instances and databases.

A specific entity within a database, such as tables, views, or stored procedures, that stores and processes data.

The specific user responsible for creating a database object. They control access and modifications.

SQL command used to grant access or privileges on database objects to users.

SQL command used to remove access privileges from users on database objects.

The process by which a database management system (DBMS) verifies the identity of a user attempting to access the system. This involves checking the user's credentials against a database of authorized users.

The process of granting permissions to a user based on their verified identity. Once authenticated, the DBMS determines what actions the user is allowed to perform on the database.

Rights granted to users to perform specific actions on database objects. These include basic operations like SELECT, INSERT, DELETE, and UPDATE, as well as more advanced actions like ALTER and INDEX.

Pre-defined collections of privileges that grant users access to specific database resources. They simplify user management by grouping permissions based on their job responsibilities.

Security measures applied at the database server level, including logins and server roles. This controls access to the entire database server instance.

Security measures applied at the individual database level, including users and database roles. This controls access to specific databases within the server.

Predefined database roles with specific permissions that are built-in to SQL Server.

Database roles that you create yourself, allowing you to customize permissions for specific tasks.

A fixed database role allowing users to perform all configuration and maintenance tasks on a database.

A fixed database role allowing users to manage database security settings.

A fixed database role specifically designed to prevent users from reading any data in user tables within a database.

To assign a database role to a user, use ALTER ROLE followed by the role name, ADD MEMBER, and the username. Example: ALTER ROLE db_owner ADD MEMBER user1.

You can create custom roles with specific permissions to grant access to data or perform specific actions.

The 'USE myDB' command selects the database called 'myDB' as the current database for further operations.

A fixed database role that enables adding or removing access to the database for Windows logins, groups, and SQL Server logins.

A fixed database role that allows backing up the database.

A fixed database role that lets users execute any Data Definition Language (DDL) commands on the database.

A fixed database role that allows users to add, delete, or modify data within all user tables.

A fixed database role that allows users to read data from all user tables.

A fixed database role that restricts users from adding, modifying, or deleting any data in the user tables of the database.