Question
a.
The permissions of a role may allow members to access and administer the database
b.
Server roles, roles defined by administrators to control access to objects and data for non-administrator user
c.
Database roles, roles defined by administrators to control access to objects and data for administrator user
d.
None of the mentioned
Posted under SQL Server
Engage with the Community - Add Your Comment
Confused About the Answer? Ask for Details Here.
Know the Explanation? Add it Here.
Q. Point out the correct statement.
Similar Questions
Discover Related MCQs
Q. Which of the following role is created as a separate object in an Analysis Services database, and applies only to the database in which that role is created?
View solution
Q. _________ let you create external, user-defined functions using any common language runtime (CLR) language.
View solution
Q. Point out the wrong statement.
View solution
Q. Which of the following permission setting provides internal computation permission?
View solution
Q. If the __________ setting is used, the execution context corresponds to the Windows login user account IUSER_servername on the server.
View solution
Q. Which of the following namespace discover set of assemblies?
View solution
Q. Security for stored procedures is set with the _________ property on a stored procedure.
View solution
Q. If functions in one assembly call functions in a separate assembly, you must register both assemblies in ____________
View solution
Q. In Microsoft SQL Server 2005 Analysis Services (SSAS), a _________ is a language-specific representation of the name of a dimension.
View solution
Q. Point out the correct statement.
View solution
Q. Members of a _________ dimension can only be moved within the same level.
View solution
Q. Updates to the ______ attribute in a parent-child hierarchy must not include updates to any other properties or attributes.
View solution
Q. Point out the wrong statement.
View solution
Q. Which of the following is not supported by linked dimensions?
View solution
Q. The _______ attribute is the attribute in a dimension that identifies the columns in the dimension main table that are used in foreign key relationships to the fact table.
View solution
Q. Which of the following property is set to zero so that all levels are not created?
View solution
Q. By default, in a ________ schema, all attributes are directly related to the key attributes.
View solution
Q. Parent-child hierarchies are automatically detected by the _________ Wizard.
View solution
Q. _______ is currency used to store transactions on which measures to be converted are based in SSAS.
View solution
Q. Point out the correct statement.
View solution
Suggested Topics
Are you eager to expand your knowledge beyond SQL Server? We've curated a selection of related categories that you might find intriguing.
Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!
