In case of entity integrity, the primary key may be
not Null
Null
both Null & not Null.
any value.
Correct Answer :
A. not Null
Related Questions
Which of the following is the unit of signaling speed or modulation rate or the rate of symbol transmission?
Data rate
Bit rate
Signal to Noise Ratio
Baud rate
The statement in SQL which allows to change the definition of a table is
Select
Update
Create
Alter
In mesh topology, if the number of devices is n , then the number of ports present in each device is
n
n+1
n-1
n/2
Technique(s) used for data recovery after any failure
Logging
Recovery manager
Both A and B are true
Both A and B are false
In the architecture of a database system external level is the
physical level.
logical level.
conceptual level
view level.
The access protocol used by traditional Ethernet
CSMA/CA
CSMA/CD
CSMA
Token ring
In which of the following SET concept is used ?
Network Model
Hierarchical Model
Relational Model
None of these
which of the following is a binary operation?
project
select
rename
none of the above
In two-phase locking protocol the two phases are
growing phase and shrinking phase
execution phase and blocking phase.
running phase and sleeping phase.
none of the above
Tertiary storage
magnetic tape
juke box
optical disk
All of the above
When all attributes in a relation tuple are not functionally dependent only on the key attribute. Which of the following normalization is needed?
first
second
third
fourth
An entity set which have sufficient attributes to form a primary key
Tree structure
Subtree structure
Strong entity set
Table structure
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
Which of the following is not proper state of transaction ?
Partially aborted
Partially committed
Aborted
Committed
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
Data fragmentation is performed by the …… and each fragment is stored at…………..
DBMS, same site
OS ,same site
DBMS ,different site
OS ,different site
Benefit of database normalization is
smaller number of tables
higher query processing efficiency
reduced I/O for most queries
reduced data redundancy
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
The class based addressing is known as
Classless addressing
Classful addressing
Classified addressing
Classical addressing
A composite attribute is converted to individual attributes in which of the following normal form ?
first
Second
third
fourth
Aggregate functions are also called
serial functions
non-serial functions
row functions
column functions
A relation which is in 3NF is
in 1NF also
in 2NF also
free from transitive dependencies
All of these
What is the max data capacity of STP?
1 Gbps
56 Mbps
100 Mbps
256 Mbps
Object based data models are used in describing the abstraction of the following levels?
Conceptual and view
Only physical
Physical and conceptual
Only conceptual
Which of the following file organization provides very fast access to any arbitrary record of a file?
Ordered file
Unordered file
Hashed file
B-tree
Encoding method which does not provide for synchronization
B8ZS
Manchester
RZ
NRZ-L
A subschema expresses
the logical view.
the physical view.
the external view.
all of the above.
Specialization is a
top-down approach.
bottom-up approach.
left-right approach.
none of the above
What does the number of attributes in a relation is called?
Cardinality
Degree
Tuple
Order
RAID
Redundant Arrays of Independent Disks
Redundant Arrays of Independent Drives
Redundant Arrays of Interconnected Drives
Redundant Arrays of Interconnected Disks