What are defaults? Is there a column to which a default
can't be bound?
Answers were Sorted based on User's Feedback
Answer / guest
Defaults are used to assign some defalut values to
columns . These values are used if user doen to specify a
column value.
Timestamp canot have default clause attached to it
| Is This Answer Correct ? | 10 Yes | 5 No |
Answer / leena
A default is a value that will be used by a column, if no
value is supplied to that column while inserting data.
IDENTITY columns and timestamp columns can't have defaults
bound to them
| Is This Answer Correct ? | 4 Yes | 0 No |
Explain about post-relational databases?
In which database can extended stored procedures be added?
How to create an external table.
Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?
How can you fix a poorly performing query?
Where is dbms used?
How is data stored in dbms?
When installing the datastage7.5x2 edtion iam getting aproblem i.e the cpu count is 2 but the cpu count in installation is one . how can i install in my p.c (system is dual core).
How to use online Backups?
Explain about relational database management systems?
What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
What is dbms and its application?
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)