In ………… paging we make copy of the current page table.
physical
logical
shadow
duplicate
Correct Answer :
C. shadow
Related Questions
Which of the following is/are error-free channel(s)
i) Noisy channel
ii) Noiseless channel
i only
ii only
Both
None of these
Mail services are available to network users through the
Session layer
Presentation layer
Application layer
Transport layer
The maximum number of children in a B-tree of order m is
m+1
m
m-1
m/2
Which of the following concurrency control schemes is not based on serializability property?
Two-phase locking
Timestamped based locking
Graph-based locking
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
Only one communication channel is needed rather than n channels to transmit data between two communicating devices
parallel
serial
analog
digital
What is the result of the following SQL statement ?
SELECT A.emp_Name, B.ph_num
FROM emp A LEFT OUTER JOIN phone B
ON A. emp_ID = B.emp_ID
A list of employees phone number
A list of all employees that have spouses, with phone number included in the list
A list of all employees names, including the phone number if they have one
Two lists : One list of employees, the other of phone numbers
What is ACID properties of Transactions?
Atomicity, Consistency, Isolation, Database
Atomicity, Consistency, Isolation, Durability
Atomicity, Consistency, Inconsistent, Durability
Automatically, Concurrency, Isolation, Durability
It is possible to define a schema completely using
VDL and DDL.
DDL and DML.
SDL and DDL.
VDL and DML.
............... noise is caused by the random motion of the electrons in a wire and is avoidable.
Thermal
Intermodulation
Cross talk
Impulse
In two-phase locking
the data items are locked in growing phase.
the data items are released in shrinking phase.
Both A and B are true
Both A and B are false
Log into a computer across an internet
IMAP
TELNET
POP3
Infrared
The statement
Every foreign-key value must match a primary-key value in an associated table
Is related to
View
Cursor defination
Referential intergrity
Trigger
An advantage of the database management approach is
data is dependent on programs.
data redundancy increases.
data is integrated and can be accessed by multiple programs.
none of the above.
Which of the following will NOT eliminates the ambiguities of a null value?
Define the attribute as required
Define subtypes
Define each attribute as having an initial value that is recognized as blank
Define supertypes
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 RDBMS, Data is presented as a collection of
Relation
Table
Attribute
Entity
Datalog is
procedural query language
nonprocedural query language
scan(), write()
none of the above
The class based addressing is known as
Classless addressing
Classful addressing
Classified addressing
Classical addressing
In the architecture of a database system external level is the
physical level.
logical level.
conceptual level
view level.
The overall design of a database is called
Subschema of the database
Schema of the database
Structure of the database
View of the database
A table that displays data redundancies yields ____________ anomalies
Insertion
Deletion
Update
All of the above
B-Tree is used for
searching data
storing data
both A and B
none of these
Range variables are designed using the
TO clause
FROM clause
RANGE clause
none of the above
Extended Entity Relationship model consists of which of the following
i) Specialization
ii) Generalization
iii) Categorization
i and ii only
ii and iii only
i and iii only
All i, ii iii
Benefit of database normalization is
smaller number of tables
higher query processing efficiency
reduced I/O for most queries
reduced data redundancy
In an Entity-Relationship Diagram Diamonds represents
Attributes
Multi-valued attributes
Weak entity set
Relationship sets
A logical schema
is the entire database.
is a standard way of organizing information into accessible parts.
describes how data is actually stored on disk.
both A) and C)
The mode in which data item may be locked
Partner
Mutual
Exclusive
Atomic
RAID
Redundant Arrays of Independent Disks
Redundant Arrays of Independent Drives
Redundant Arrays of Interconnected Drives
Redundant Arrays of Interconnected Disks