A relation which is in 3NF is
in 1NF also
in 2NF also
free from transitive dependencies
All of these
Correct Answer :
D. All of these
Related Questions
The minimal set of super key is called
Primary key
Secondary key
Candidate key
Foreign key
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
A data manipulation command the combines the records from one or more tables is called
SELECT
PROJECT
JOIN
PRODUCT
Which of the following is not an Aggregate function?
Min
Max
Select
Avg
Size of source and destination address in IP header
4 bits
8 bits
12 bits
32 bits
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
The collection of information stored in a database at a particular moment is?
View
Instance
Scheme
None of these
Three SQL, DDL, CREATE commands are
Schema, Base and Table
Schema, Table and View
Base, Table and Schema
Key, Base and Table
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
For large networks, _______ topology is used
Ring
Bus
Mesh
none of these
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
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
In which of the random-access method, stations do not sense the medium?
ALOHA
ETHERNET
CSMA/CA
CSMA/CD
The transaction consists of all statements executed between
the begin transaction and end transaction
the start transaction and end transaction
the begin transaction and finish transaction
none of the above.
Which of the following is logical topology?
Bus
Ring
Star
None of these
The race condition occurs when
Two concurrent processes attempt to interact with each other.
Two concurrent processes interact with different data files.
Two concurrent processes attempt to hold a data item .
none of the above.
Triggers are also called
active rules
passive rules
inferences
none of the above
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 does the number of attributes in a relation is called?
Cardinality
Degree
Tuple
Order
The database environment has all of the following components except:
users.
separate files.
database.
database administrator.
In RDBMS, Data is presented as a collection of
Relation
Table
Attribute
Entity
A transaction which may not complete its execution successfully is termed as
Failed
Aborted
Blocked
Finished
What does a field or a combination of fields that has a unique value called ?
Foreign key
Secondary key
Primary key
Alternate key
An association of several structure of a data base can be expressed graphically by?
Tuple
Record
Relationship
Field
Aggregate functions are also called
serial functions
non-serial functions
row functions
column functions
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
Multivalued dependency is removed in
4 NF
3 NF
2 NF
1 NF
In which of the following SET concept is used ?
Network Model
Hierarchical Model
Relational Model
None of these
In case of entity integrity, the primary key may be
not Null
Null
both Null & not Null.
any value.
Which of the following layer uses trailer of the frame for error detection?
Transport layer
Network layer
Datalink layer
None of these