MCQ IN COMPUTER SCIENCE & ENGINEERING

COMPUTER SCIENCE AND ENGINEERING

SQL

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]

Which option does not apply to partially contained databases?

A	You can use the ALTER statement to convert a noncontained database to a partially contained database.
B	CDC and CT are not supported in partially contained databases.
C	Numbered and temporary procedures are supported in partially contained databases.
D	Replication is not operational in partially contained databases.

Explanation:

Detailed explanation-1: -Partially contained databases do not allow the following features. Replication, change data capture, or change tracking.

Detailed explanation-2: -Contained database is defined as a database which has the database user without logins. It includes all settings related to databases along with its metadata, thus system will be having no dependency with SQL server login.

Detailed explanation-3: -The correct answer is 1-Additional database filegroups can be added via Transact-SQL statements.

Detailed explanation-4: -Contained database users are users that are configured directly at the database level, and don’t require an associated login in the master database. The benefit of this approach is that it makes your database more portable-and it also simplifies database deployments a little.

Detailed explanation-5: -How to connect to the contained database without creating the login and user on secondary instance. This blog is about contained database a SQL server feature introduce from SQL server 2012. This contained database are different from regular uncontained databases. Contained database don’t depend on SQL server instance.

There is 1 question to complete.