adplus-dvertising
frame-decoration

Question

Point out the correct statement.

a.

In versions of SQL Server through SQL Server 2014, sub-securables cannot use brackets in the form ‘[sub name]’. Use ‘sub name’ instead

b.

HAS_PERMS_BY_NAME returns NULL when the query fails

c.

In ADO.net, the sub-securable_class argument is valid only if the securable_class argument is set to OBJECT

d.

None of the mentioned

Posted under SQL Server

Answer: (a).In versions of SQL Server through SQL Server 2014, sub-securables cannot use brackets in the form ‘[sub name]’. Use ‘sub name’ instead

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.
Add Comment

Similar Questions

Discover Related MCQs

Q. _________ returns a list of the permissions effectively granted to the principal on a securable.

View solution

Q. What is the syntax for fn_my_permissions function in SQL Server 2014?

View solution

Q. Point out the wrong statement.

View solution

Q. The schema securable scope contains the following securable is __________

View solution

Q. Which of the following returns a row for each security principal in a SQL Server database?

View solution

Q. Any SQL Server authentication login can see ________ login name.

View solution

Q. To add or remove server role membership use ____________

View solution

Q. Point out the wrong statement.

View solution

Q. Which of the following script creates master key?

View solution

Q. Which of the statement is used to create a new certificate with a valid subject in SQL Server?

View solution

Q. Point out the wrong statement.

View solution

Q. Like data compression, TDE database encryption is performed at the ______ level.

View solution

Q. Which of the following is valid code to backup a certificate?

View solution

Q. Which of the following catalog view is used to monitor TDE?

View solution

Q. ___________ encryption was introduced in SQL Server 2005 and is available in all editions of SQL Server.

View solution

Q. Which of the following functions decrypts data by using a symmetric key?

View solution

Q. Which of the following condition in the where clause will return the login identification name of the user?

View solution

Q. Point out the correct statement.

View solution

Q. View that contains the list of all the security labels present in the database are __________

View solution

Q. Which of the following retrieves a SecurityLabel instance describing the subject label of the current database user?

View solution
View All MCQs on SQL Server

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!

Computer Graphics

Step into the visual side of computing with our Computer Graphics MCQs. Cover topics...

PHP

Venture into server-side scripting with our PHP MCQs. Cover everything from syntax...

MySQL Database

Enhance your knowledge of relational databases with our MySQL MCQs. Understand...

Digital Communication

Master the basics of electronic communication with our Digital Communication MCQs....

Hadoop

Dive into the world of big data with our Hadoop MCQs. Cover key concepts including...

Internet of Things (IoT)

Discover how devices communicate with each other in the smart world with our IoT...

HTML

Start your journey in web development with our HTML MCQs. Learn the building blocks...

Digital Image Processing (DIP)

Delve into the techniques of enhancing digital images with our Digital Image...

Software Architecture and Design

Get a strong hold on the blueprint of software systems with our Software Architecture...