Give the cobol definition of a varchar field 177 when can an insert of a new primary key value threaten referential integrity?
Answer / Meenakshi Sandiliya
In COBOL, define a variable as '01 my-varchar PIC X(177). To avoid threats to referential integrity when inserting a new primary key value, ensure that the foreign key in other tables references valid primary key values present in the table.
| Is This Answer Correct ? | 0 Yes | 0 No |
Why is it better to use an Integrity Constraint to validate data ?
Can group by and ordered by used in a single query?
What are the partitions types available in Oracle10g. How it will do? Simple example?
Why is group-clause used?
What is implicit cursor in dbms?
What is data types in database?
Enlist various transaction phases.
What is CRUD Operations?
what is scan listener.
What do you understand by join?
What are the main components of a database?
Enlist some commands of ddl?
Oracle (3253)
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)