(Terminologies) Database Administration and Security PRE-FINAL

PRE-FINAL

Data Administrator (DA)

Who is responsible for controlling the overall corporate data resources, both computerized and manual?

Database Administrator (DBA)

Who maintains a successful database environment by performing activities to keep the data secure?

Logical design

What type of database model is built first by the Data Administrator before implementation?

Physical structures (databases)

What does the DBA design, implement, maintain, and secure?

Managerial orientation

What orientation does the Data Administrator (DA) have?

Technical orientation

What orientation does the Database Administrator (DBA) have?

Policies and standards

What does the DA define related to data definitions, naming, and abbreviations?

Programming standards

What does the DBA enforce to ensure consistent database management?

Database security

What refers to DBMS features and measures that comply with the organization’s security requirements?

SQL security model

What model provides basic syntax used to specify security restrictions?

Users

What concept in SQL represents people or programs performing actions on database objects?

Objects

What are defined in SQL standards and can be manipulated by users such as tables, indexes, and views?

Privileges

What refer to the rights of users to manipulate database objects?

Roles

What is a named collection of database access privileges that authorize a user to connect and use system resources?

Authentication

What process verifies the identity of a user before granting access?

Authorization

What determines what actions an authenticated user is allowed to perform?

Login

What allows a user to connect to a SQL Server service instance?

Database user

What must a login be mapped to in order to access objects within a database?

GRANT

Which SQL command is used to provide privileges to users on database objects?

REVOKE

Which SQL command is used to remove privileges from users or roles?

CREATE LOGIN

Which SQL statement creates a new server level login in SQL Server?

ALTER LOGIN

Which SQL statement modifies login credentials such as name or password?

CREATE USER

Which SQL statement links a login account to a specific database?

ALTER ROLE

Which SQL command adds a user to a database role?

Privileges

What controls whether a user can modify an object owned by another user?

Role

What groups privileges together so they can be assigned efficiently to many users?

Fixed database roles

What are predefined roles in a database that cannot be changed or deleted?

User defined database roles

What type of roles can be created manually by administrators?

db_owner

Which fixed database role can perform all configuration and maintenance activities and drop the database?

db_securityadmin

Which fixed database role can modify role membership and manage permissions?

db_accessadmin

Which fixed database role can add or remove access to the database for logins and groups?

db_backupoperator

Which fixed database role can perform database backups?

db_ddladmin

Which fixed database role can run any Data Definition Language (DDL) command?

db_datawriter

Which fixed database role can add, delete, or change data in all user tables?

db_datareader

Which fixed database role can read all data from user tables?

db_denydatareader

Which fixed database role cannot read any data in user tables?

db_denydatawriter

Which fixed database role cannot add, modify, or delete data in user tables?

Privileges

What in SQL determines whether a user can SELECT, INSERT, DELETE, UPDATE, or ALTER data?

Security measures

What are implemented by the DBA to protect the database against loss, corruption, or mishandling?

SQL Server Management Studio (SSMS)

What tool can be used to check newly created logins or changes in login credentials?

Data Administrator (DA)

Who determines the contents and logical boundaries of each database?

Database Administrator (DBA)

Who facilitates database development, enforces standards, and provides data backup and recovery services?

Authentication and Authorization

What two processes begin the setup of database security?

Privileges

What SQL feature uses the GRANT and REVOKE commands to control access?

Fixed database role

What is the predefined set of privileges that cannot be altered by the user?

User defined role

What kind of database role can be customized and created by users?

Database security

What ensures that only the right people have access to the right data?

SQL

What language uses GRANT and REVOKE commands to assign or remove privileges?

Database level role

What type of role applies only within its own database?

Server level role

What type of SQL role includes logins and server roles?

Data backup and recovery services

What DBA service ensures the database can be restored after data loss?

SQL commands

What include CREATE LOGIN, CREATE USER, GRANT, REVOKE, and ALTER ROLE?

End users

Who are supported by the DBA as part of managerial services?

Privileges

What are rights or authorizations to perform actions on database objects?

Database environment

What does the DBA maintain to keep data secure and organized?