Question
a.
USE Master
GO
BACKUP CERTIFICATE MySQLCert
TO FILE = 'C:\temp\MySQLCert'
WITH PRIVATE KEY (file='C:\temp\MySQLCertKey',
ENCRYPTION BY PASSWORD='MyStrongPassword2')
b.
USE Master
GO
BACK CERTIFICATE MySQLCert
TO FILE = 'C:\temp\MySQLCert'
WITH PRIVATE KEY (file='C:\temp\MySQLCertKey',
ENCRYPTION BY PASSWORD='MyStrongPassword2')
c.
USE Master
GO
BACKUP CERTIFICATE MySQLCert
TO FILE = 'C:\temp\MySQLCert'
WITH PUBLIC KEY (file='C:\temp\MySQLCertKey',
ENCRYPTION BY PASSWORD='MyStrongPassword2')
d.
USE Master
GO
BACKUP CERTIFICATE MySQLCert
TO SUBJECT = 'C:\temp\MySQLCert'
WITH PRIVATE KEY (file='C:\temp\MySQLCertKey',
ENCRYPTION BY PASSWORD='MyStrongPassword2')
Posted under SQL Server
GO
BACKUP CERTIFICATE MySQLCert
TO FILE = 'C:\temp\MySQLCert'
WITH PRIVATE KEY (file='C:\temp\MySQLCertKey',
ENCRYPTION BY PASSWORD='MyStrongPassword2')
Engage with the Community - Add Your Comment
Confused About the Answer? Ask for Details Here.
Know the Explanation? Add it Here.
Q. Which of the following is valid code to backup a certificate?
Similar Questions
Discover Related MCQs
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
Q. Point out the wrong statement.
View solution
Q. What will the fn_Dominates return if A dominates B where A and B both are security label?
View solution
Q. The major components of the Label Security Toolkit are _____________
View solution
Q. Return type of CertName field in vwVisibleLabels is __________
View solution
Q. Which of the following will not return user name of the current session?
View solution
Q. Grant ________ permission on the stored procedures to database roles for implementing call level security.
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!
.png)