Data Types(Engineering > Computer Science And Engineering > Dbms Questions And Answers ) Questions and Answers
Explanation:-
Answer: Option A. -> CastCastExample 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.
Explanation:-
Answer: Option A. -> IndexIndexIndex is the reference to the tuples in a relation.
Explanation:-
Answer: Option B. -> Create table . . . asCreate table . . . asThe 'create table . . . as' statement closely resembles the create view statement and both are defined by using queries.The main difference is that the contents of the table are set when the table is created, whereas the contents of a view always reflect the current query result.