Question 2
Marks : +2 | -2
Pass Ratio : 100%
Explanation: A default value is a value that is initially loaded into the attribute. All the tuples have the default value in the attribute for which it is specified in case any value is not externally specified.
Question 3
Marks : +2 | -2
Pass Ratio : 100%
revoke select on takes from amit;
Explanation: The query mentions the revoking of the select privilege. So, the query revokes the select authorization from amit.
Question 4
Marks : +2 | -2
Pass Ratio : 100%
What does p indicate in the following data type?
Explanation: The p in the parentheses indicates the number of fractional digits for seconds.
Question 5
Marks : +2 | -2
Pass Ratio : 100%
Explanation: A timestamp is a combination of date and time with date first.
Question 6
Marks : +2 | -2
Pass Ratio : 100%
What does the following statement do?
Explanation: The create table like statement creates a new relation which has a schema identical to that of the specified relation after the like keyword.