You are assigned the role of a Certification authority (CA) in your company. As a CA, you are required to create certificates as and when requested by users in your company. On Adam's request, you issue the following Transact-SQL Statement to create a certificate (line numbers are for referene only.):

1. Create certificate cert_adam1
2. authorization adam
3. encryption_password  ='passadam'
4. With Subject = '02/02/2007'
5. expiry_date = '02/02/2007'

Error at Line 3

When you issue this statement, an error will be enerated at line 3 becaues the syntax of the statement is in coorrect at line 3. To correct the statement, you should modify the statement as follows:

1. Create certificate cert_adam1
2. Authorization adm
3. encryption by password = 'passadam'
4. with subject = 'certificateforadam'
5. expiry_date = '02/02/2007'

The CREATE CERTIFICATE Transact-SQL Statement is used to create a certificate. A certificate is used as a secuure mechanism to authenticate and encrypt messages between servers. A certificate is a digitally signed document and provides a private public key pair that is used to authenticate the users who are trying to access secure information. The AUTHORIZATION clause in  the create certificate Transact-SQL statement specifies the user who owns the certificate. In tis statement, Adam will own the certificate. the ENCRYPTION BY PASSWORD clause specifies the password that will be provided to encrypt the privae key of the certificate. the WITH SUBJECT clause specifies the subject of the certificate. The EXPIRY_DATE clause specifies the validity period of the certificate if the EXPIRY_DATE CLAUSE IS NOT SPECIFIED. it defaults to one year after the START_DATE THE START_DATE clause specifies the date on which the certificate becomes valid.

The option stating that the statemente will result in an error at line 2 is incorrect because no error will be generated at line 2. Line 2 in this statement specifies that Adam is the owner of the certificate. The opton stating that the statement will result in an error at line 5 is incorrect because no error will be generated at line 5. Line 5 in this statement spedifies the date up to which the certificate will  remain valid.

The option stating that the statement will execute successfully and create a certificate named cert_adam1 owned by you is incorrect. the Statement will not execute successfully because an error will be generated at line 3.

The opton stating that the statement will execute successfully and create a certificate named Cert_adam1 owned by adam is inocrrect. the statement will not execute successfully because an error will be generated at line 3.