Data independence means
data is defined separately and not included in programs.
programs are not dependent on the physical attributes of data.
programs are not dependent on the logical attributes of data.
both B) and C).
Correct Answer :
Related Questions
Data fragmentation is performed by the …… and each fragment is stored at…………..
DBMS, same site
OS ,same site
DBMS ,different site
OS ,different site
In which of the following SET concept is used ?
Network Model
Hierarchical Model
Relational Model
None of these
A relation which is in 3NF is
in 1NF also
in 2NF also
free from transitive dependencies
All of these
In RDBMS, Data is presented as a collection of
Relation
Table
Attribute
Entity
The control of concurrent execution is left with the
operating system
controller unit of the kernel
concurrency control component of the database system
none
If the .................... is too much, the receiver may not be able to detect the signal at all or the signal may fall below the noise level.
Noise
Delay
Dispersion
Attenuation
DBMS utility which allows to reconstruct the correct state of database from the backup and history of transactions
Backup
Recovery
Grant
Troubleshooting
In ………… paging we make copy of the current page table.
physical
logical
shadow
duplicate
Which of the following is logical topology?
Bus
Ring
Star
None of these
The ________ states that a foreign key must either match a primary key value in another relation or it must be null.
entity integrity rule
referential integrity constraint
composite attribute
action assertion
The types of noiseless channels are
i) Selective Reject ARQ
ii) simplest protocol
iii) Go-Back-N ARQ
iv) Stop-and-Wait Protocol
i, ii only
ii and iv only
ii and iv only
i, iv only
A table that displays data redundancies yields ____________ anomalies
Insertion
Deletion
Update
All of the above
Data integrity refers to
the uniqueness of the data in a database
the correctness and completeness of the data in a database
the un redundancies of the data in a database
Data independence of the database
In client/server computing data are
sent only upon the client's request
sent in complete copies for the client to filter and sort
never sent to the client machine
sent in very large sections to save processing time
Which one of the following is provided by a data dictionary ?
User data
Database structure data
Sorted data
Functional data
Which of the following is a classical approach to database design?
Left Right approach
Right Left approach
Top Down approach
Bottom Up approach
Query processing is
converting data to insert in a database
translation of query to lower form
range of activities involved in extracting data from a database
none of the above
What are the different types of radio waves that are used for computer network applications?
i) Spread spectrum
ii) High power, single frequency
iii) High power, multiple frequency
iv) Low power, single frequency
v) Low power, multiple frequency
i, ii and iii only
i, ii and iv only
ii, iii and iv only
i, iii and iv only
Triggers are also called
active rules
passive rules
inferences
none of the above
A lock that allows concurrent transactions to access different rows of the same table is known as a
Field-level lock
Row-level lock
Table-level lock
Database-level lock
Which of the following produces the relation that has attributes of R1 and R2
Cartesian product
Difference
Intersection
Product
Which of the following normalization is needed, if an attribute of a composite key is dependent on an attribute of the other composite key?
BCNF
Second
Third
Fourth
A logical description of some portion of database that is required by a user to perform task is called as
System View
User View
Logical View
Data View
Which of the following is not a constraint on a single relation?
check
unique
not null
is duplicate
Noiseless channel has ……… types of protocols.
2
3
4
5
A …………… is a memory area where data are processed.
view
trigger
cursor
none of the above
The collection of information stored in a database at a particular moment is?
View
Instance
Scheme
None of these
The statement in SQL which allows to change the definition of a table is
Select
Update
Create
Alter
Which of the following is not proper state of transaction ?
Partially aborted
Partially committed
Aborted
Committed
RAID
Redundant Arrays of Independent Disks
Redundant Arrays of Independent Drives
Redundant Arrays of Interconnected Drives
Redundant Arrays of Interconnected Disks