Which of the following is true about database access control?

A. to access a database the SQL Server login must be mapped to a database user
B. members of the sysadmin server role don't have access to databases by default
C. once a user logs in to the SQL Server, they have automatic access to underlying database objects
D. the database user login name must be different from the server login name


Answer: A

Computer Science & Information Technology

You might also like to view...

A database _____________is organized into rows and columns.

a. grid b. matrix c. table d. spreadsheet

Computer Science & Information Technology

Which of the following statements is false?

a. Experience has shown that the best way to develop and maintain a large pro-gram is to construct it from a small number of large, proven pieces—this tech-nique is called divide and conquer. b. Using existing functions as building blocks for creating new programs is a key aspect of software reusability—it’s also a major benefit of object-oriented programming. c. Packaging code as a function allows you to execute it from various locations in your program just by calling the function, rather than duplicating the possibly lengthy code. d. When you change a function’s code, all calls to the function execute the up-dated version.

Computer Science & Information Technology

What is the result of giving the which utility the name of a command that resides in a directory that is not in your search path?

What will be an ideal response?

Computer Science & Information Technology

Describe the Third Extended (ext3) File System.

What will be an ideal response?

Computer Science & Information Technology