COMP9 - Database Security and DDL

In database security, which prevents/detects/deters improper disclosure of information?

• Availability

• Data masking techniques
• Network firewalls
• Confidentiality

Which is a way of translating data into a coded from, making it readable only to those who have a passkey or password?

• Encryption
• Decryption
• Compression
• Data Encoding

In database security, which prevents/detects/deters improper denial of access to services?

• Network Firewalls
• Confidentiality

• Availability

• Data Encryption Techniques

In SQL Server Management Studio, what account is validated by the database and can only connect to the database once the correct password is submitted?

• Guest account
• Windows Authentication account
• SQL Server Authentication account
• Local User account

In SQL Server Management Studio,  what account is the one that can only connect to an active database and can be a window user or a group?

• Windows User

• Database Administrator Account
• Local User Account
• SQL Server Authentication

What schema role in SSMS allows the user to add or remove access to the database for windows login, windows group, and SQL Server logins?

• db_owner
• db_datareader
• db_accessadmin
• db_securityadmin

Which schema role in SSMS can modify the role of user membership and manage permissions?

• db_datawriter
• db_securityadmin

• db_datareader
• db_ddladmin

In SSMS, what happens when a Windows user's access is revoked in Active Directory?

• The user can no longer access SSMS or its resources.
• The user retains access to SSMS but with limited features.
• The user can still access SSMS but cannot modify any resources.
• The user is automatically granted access to all SSMS resources.

In SSMS , what happens if you try to create a new table in SSMS with a name that already exists in the database?

• The table is created with a different name automatically.
• An error occurs indicating that the table name already exists.
• The existing table is overwritten without warning.
• A warning message is displayed but the table is created.

You need to remove a database named "SalesDB" entirely from the SQL Server instance. Which SQL statement would accomplish this?

• DROP TABLE SalesDB;
• DELETE DATABASE SalesDB;
• DROP DATABASE SalesDB;
• REMOVE DATABASE SalesDB;