What are the pre requisites?
Answer / guest
I. to modify datatype of a column ?
ii. to add a column with NOT NULL constraint ?
To Modify the datatype of a column the column must be empty.
To add a column with NOT NULL constrain, the table must be
empty.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is cursor status?
How do you update a table in sql?
what is the use of friend function? : Sql dba
What are aggregate and scalar functions?
How do you delete duplicates in sql query using rowid?
what is a materialized view? : Sql dba
What is the source code of a program?
what is the order of pre-defined exceptions.
What is nvarchar max in sql?
What is recursive stored procedure?
Mention what pl/sql package consists of?
What are the various restrictions imposed on view in terms of dml?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)