What is the difference between a Physical File & a Logical?
Answers were Sorted based on User's Feedback
Answer / david
In a database management system, a physical record is the actual binary representation of the data whereas the logical record is the text representation of the data that humans can read and understand.
| Is This Answer Correct ? | 4 Yes | 3 No |
Answer / satyendra prajapati
In physical file it takes memory because it contain actual record.logical file not contain memory because it does not contain data its views of the data stored in physical file.
physical file have only one data format.logical file have more than one record format.physical file may exist SSD(secondary storage).Logical file does not exist SSD.
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / saurav
Ph s like bytes are stored in a file.. Doesn't knw from whr d input is coming but lf is aware of it..
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / anwar khan
PF file hold the actual data of a database file.
LF is a view of the logical view of data
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / sarita
Physical file is the file that already present on disk or tape
and operating system can hide particular info of file is nothing but logical file.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / mithun paul
We can perform Update operations on PF. On the other hand
we can perform Update operations on simple LF(not with
multi format LF or Join LF)
Mithun Paul
KMG Infotech Ltd.
Kolkata
| Is This Answer Correct ? | 6 Yes | 6 No |
Answer / ankit singh
1. When we open a file stored on a disk, its logical file is
created and we work on that file.
2. Once we save the file, the changes we made are reflected
in the physical file. If we don't save the file, the
physical file doesn't get affected.
3. When we close the file, the logical file which was
created on opening the file, gets destroyed.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / teja
The Physical file stores the actual data.
The Logical File is a sequenced VIEW of the data in the Phsyical FIle.
| Is This Answer Correct ? | 1 Yes | 2 No |
Describe the function of SETLL operation in RPG language?
What is the symbol used for defining a new field in SDA?
Pgm A is invoked through HTTP. It is in Activtion group QILE. Pgm A calls Pgm B and Pgm C. Pgm B is in activation group TEMPACTGRP. Pgm A ends in error. Pgm A is called again. But it gives an error that TEMPACTGRP still exists and files are present in QTEMP. What is the cause and how will u fix?
CAN WE INSERT FIELD IN PHYSICAL FILE BY USING OPNQRYF?
What are the different types of messages in CL?
What is the use of SDA ?
Suppose we have field reference file we were any changes that corresponding Physical file then what will Happen in field reference file??
What are the system objects required for journalling?
Is it necessary to define all formats ? Which are mandatory and which are Optional ?
Can we use OVRDBF command without using of OPNQRYF ? Or can we use OPNQRYF command without using of OVRDBF command ?
how to validate input values in display file ?
What is the difference between array and a multiple occurrence data structure?