Natural mask for a Class A network
255.0.0.0
255.255.0.0
255.255.255.0
none of these
Correct Answer :
A. 255.0.0.0
Related Questions
The maximum number of children in a B-tree of order m is
m+1
m
m-1
m/2
Technique used in log based recovery
Immediate database modification
Graph-based recovery
key dependencies
none of the above
In an E-R diagram attributes are represented by
rectangle.
square.
ellipse.
triangle.
The physical path over which a message travels
Thermal
Medium
Protocol
Impulse
Which of the following statements is not true about two tier client server database architecture?
SQL statements are processed on tier server
SQL statements may be processed on some of the clients
Business logic is mostly processed on clients
Business logic may be processed on the server
A transaction has following states
i) Active
ii) Fail
iii) Abort
iv) Commit
i and ii only
ii and iii only
i and iii only
iii and iv only
Symbol to represent weak entity set in ER Model
Dotted rectangle
Square
Doubly outlined rectangle
Diamond
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).
Referential integrity
controls relationships between operations of an object
controls relationships between instances of a class
controls relationships between attributes in a table
controls relationships between tables in a database
Encoding method which does not provide for synchronization
B8ZS
Manchester
RZ
NRZ-L
In which of the following SET concept is used ?
Network Model
Hierarchical Model
Relational Model
None of these
What does a field or a combination of fields that has a unique value called ?
Foreign key
Secondary key
Primary key
Alternate key
Expand the acronym OLAP
Object Linked Access Program
Organizational Architecture Processing
Online Analytical Processing
none of these
Which of the following are the properties of entities?
Groups
Table
Attributes
Switchboards
In case of entity integrity, the primary key may be
not Null
Null
both Null & not Null.
any value.
The index table has …… Columns.
1
2
3
4
The raw facts and figures are:
Data
Data field
DBMS
DBASE
The left outer join takes all tuples
in the left relation which didnt match with any tuple in right relation
in the left relation which matched with a tuple in right relation
in the right relation which didnt match with any tuple in left relation
in the right relation which matched with a tuple in left relation
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
Repeaters operate in
i) Physical layer
ii) Datalink layer
iii) Transport layer
iv) Network layer
i and ii only
ii and iii only
ii only
i only
A ………… clause permits a view definition to be used in multiple places within a query.
where
exist
with
select
Radio frequencies below ............. are more suitable for omnidirectional applications.
300MHz
1GHz
5GHz
10 GHz
Specialization is a
top-down approach.
bottom-up approach.
left-right approach.
none of the above
Transaction access data using two operations
read(), print()
read(), write()
scan(), write()
none of the above
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)
Database locking concept is used to solve the problem of
Lost Update
Uncommitted Dependency
Inconsistent Data
All of the above
Select the correct
i) A timestamp-based scheduler cant produce live lock
ii) Aggregate functions cant appear with HAVING clause.
iii) Isolation is a property of database transaction.
i and ii only
ii and iii only
i and iii only
i only
Secondary storage
magnetic disk
magnetic tape
juke box
cache
Tertiary storage
magnetic tape
juke box
optical disk
All of the above
Select the incorrect statement(s)
i) Foreign key values can be left blank
ii) In SQL duplicates may be present
iii) Theta join operation doesnt remove duplicate columns.
iv) NULL value means string of blank characters.
i ,iii only
ii, iv only
iii, iv only
ii, iii, iv