SQL5

Question 0

Login?

Answer 0

Is the process by which individual access to a computer system is controlled by identification of the user through the credentials he or she provides.

Question 1

Permission?

Answer 1

Is used to grant an entity access to an object.

Question 2

User account?

Answer 2

Is a logical representation of a person within an electronic system.

Question 3

3 different methods to login SQL server?

Answer 3

Widows domain login
Username login
SQL server login

Question 4

Sysadmin role?

Answer 4

Has full access to every server function, database, and object for that server.

Question 5

3 different types of SQL server service accounts ?

Answer 5

Local user account
Local system account
Domain user account

Question 6

Authentication?

Answer 6

Is the act of establishing or confirming a user or system identity.

Question 7

Create or remove account

Answer 7

Syntax
CREATE LOGIN ‘xps\Joe’
DROP LOGIN ‘xps\joe’

Question 8

Sa account

Answer 8

Is the built-in SQL administrator account associated with SQL authentication.

Question 9

Fixed server roles (8)?

Answer 9

Bulkadmin: bulk insert operations
Dbcreator: create,alter, drop,restore database
Diskadmin:create,alter,drop disk files
Processadmin:kill a running SQL server process
Securityadmin :manage the logins for the server
Serveradmin:configure server-wide setting,full-text search,shutting down server
Setupadmin:configure linked servers, extended stored procedures,startup stored procedures
Systemadmin: installation,permission settings

Question 10

Fixed database roles (9)?

Answer 10

Db accessadmin: only authorized a user to access the database
Db backupoperator: only backups,checkpoints.
Db datareader: authorized a user to read all data in the database
Db datawriter: allows to write all data in database
Db ddladmin: DDL commands
Db denydatareader
Db denydatawriter
Db owner: all permission in the database
Db securityadmin:

Question 11

3 recovery models?

Answer 11

Simple recovery
Full recovery
Bulk recovery

Question 12

Database backups?

Answer 12

Full backup
Differential backup: only backup data since the last full backup
Incremental backup: only backup data since the last full or incremental backup. (smaller,faster)

Question 13

Database restores?

Answer 13

Complete database restore
File restore
Page restore
Piecemeal restore
Recovery only
Transaction log restore
Create a mirror database
Create and maintain standby server

Sytanx
RESTORE DATABASE name of database FROM DISK =’name of backup’
GO