Which of the following addressing modes permits relocation without any change over in the code?
Indirect addressing
Indexed addressing
PC relative addressing
Base register addressing
Correct Answer :
B. Indexed addressing
Related Questions
A data type or format is specified for each _________
Relation
Tuple
Database
Domain
HSAM stands for ……….
Hierarchic Standard Access Method
Hierarchic Sequential Access Method
Hierarchic Sequential and Method
Hierarchic Standard and Method
Maximum height of a B+ tree of order m with n key values is
Logm(n)
(m+n)/2
Logm/2(m+n)
None of these
A _____ is used to define overall design of the database
code
data definition language
application program
schema
A relation is in attribute of other composite key. if an attribute of a composite key is dependent on an
2NF
3NF
BCNF
1NF
If a transaction T has obtained an exclusive lock on item Q, then T can
read Q
write Q
both read and write Q
write Q but not read Q
If both the functional dependencies : X�Y and Y�X hold for two attributes X and Y then the relationship between X and Y is
M:N
M:1
1:M
In an ER diagram the ___shape specifies the Attibute and a ____ shape specifies the primary key attribute.
Oval; An oval with an underlined attribute
Circle; A circle with bolded attribute inside it
Diamond; A bolded attribute
Square; An attribute within the square
Relations produced from an E-R model will always be
First normal form.
Second normal form.
Third normal form.
Fourth normal form.
Which of the following is not a recovery technique?
Deferred update
Immediate update
Two-phase commit
Shadow paging
As per equivalence rules for query transformation, selection operation distributes over
Union.
Set difference.
Intersection.
All of the above.
A weak entity has an ______ dependency on its owner entity, which can be used for both ON UPDATE and ON DELETE.
Direct
Indirect
Existence
No
_______ product was acquired by Informix, integrated into its RDBMS and introduced as the Informix Universal Server an ORDBMS.
Star
llustar
SQL
Cygnus
The size of a data item is called its _______, which can be a field of some record or may be a larger unit such as a record.
Similarity
Granularity
Dimensionality
Arity
Manager salary details are hidden from the employee .This is
Conceptual level data hiding.
External level data hiding.
Physical level data hiding.
None of these.
What is data integrity?
It is the data contained in database that is non redundant.
It is the data contained in database that is accurate and consistent.
It is the data contained in database that is secured.
It is the data contained in database that is shared.
Shadow paging has
no redo
no undo
redo but no undo
neither redo nor undo
According to the levels of abstraction, the schema at the intermediate level is called
Logical schema.
Physical schema.
Subschema.
None of the above.
_____ is a utility to capture a continuous record of server activity and provide auditing capability.
SQL server Profile
SQL server wizard.
SQL server service manager
SQL server setup
The data models defined by ANSI/SPARC architecture are
Conceptual, physical and internal
Conceptual, view and external
Logical, physical and internal
Logical, physical and view
In multiple granularity of locks SIX lock is compatible with
IX
IS
S
SIX
If an entity can belong to only one lower level entity then the constraint is
disjoint
partial
overlapping
single
What will be the number of columns and rows respectively obtained for the operation, A- B, if A B are Base union compatible and all the rows of a are common to B? Assume A has 4 columns and 10 rows; and B has 4 columns and 15 rows
4,0
0,0
4,5
8,5
operator is used to compare a value to a list of literals values that have been specified.
Like
COMPARE
BETWEEN
IN
An advantage of views is
Data security
Derived columns
Hiding of complex queries
All of the above
_____clause is an additional filter that is applied to the result.
Select
Order by
Group-by
Having
Key to represent relationship between tables is called
primary key
secondary key
foreign key
none of the above
Which of the following relational algebraic operations is not from set theory?
Union
Intersection
Cartesian Product
Select
Precedence graphs help to find a
Serializable schedule.
Recoverable schedule.
Deadlock free schedule.
Cascadeless schedule.
The normal form that is not necessarily dependency preserving is
2NF
3NF
BCNF
4NF