MCQs
yyyy/mm/ddyyyy/mm/dd is the default format in sql
CastExample 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.
IndexIndex is the reference to the tuples in a relation.
Create typeThe create type clause can be used to define new types.Syntax : create type Dollars as numeric(12,2) final; .
BlobSQL therefore provides large-object data types for character data (clob) and binary data (blob). The letters "lob in these data types stand for "Large OBject.
Create 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.
Create table temp_instructor like instructor;
Catalogs, schemas