Question

Values of one type can be converted to another domain using which of the following?

(a) Cast

(b) Drop type

(c) Alter type

(d) Convert

I had been asked this question by my college professor while I was bunking the class.

I'd like to ask this question from SQL Data Types and Schemas in chapter SQL : Queries, Constraints and Triggers of Database Management

Answer 1

Correct answer is (a) Cast

The best explanation: Example of cast :cast (department.budget to numeric(12,2)). SQL provides drop type and alter type clauses to drop or modify types that have been created earlier.