View never contains derived columns.
True
False
Cant say
none
Correct Answer :
A. True
Related Questions
The collection of information stored in a database at a particular moment is?
View
Instance
Scheme
None of these
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
The language used in application programs to request data from the DBMS is referred to as the
DML
DDL
VDL
SDL
Which of the following statement returns data to the host variables one at a time?
SELECT
RETURN
FETCH
GET
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
In case of entity integrity, the primary key may be
not Null
Null
both Null & not Null.
any value.
Select the incorrect statement
View is derived from other tables.
Once a transaction has executed commit work its effect cant be undone by rollback work .
The input to the aggregate function avg can be non numeric data types
A primary key can never be null.
For large networks, _______ topology is used
Ring
Bus
Mesh
none of these
A relation is said to be in ………. If it doesnt contain partial dependency
1NF
2NF
3NF
BCNF
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
Related fields in a database are grouped to form a
data file.
data record.
menu.
bank.
The physical path over which a message travels
Thermal
Medium
Protocol
Impulse
Which of the following is/are error-free channel(s)
i) Noisy channel
ii) Noiseless channel
i only
ii only
Both
None of these
A transaction is said to have terminated if it has
either committed or aborted
either partially committed or aborted
either committed or failed
none of these
Primary storage
magnetic disk
magnetic tape
juke box
cache
Which of the following produces the relation that has attributes of R1 and R2
Cartesian product
Difference
Intersection
Product
Which of the following operator preserves unmatched rows of the relations being joined?
Inner join
Outer join
union
Intersect
In client/server computing data are
sent only upon the client's request
sent in complete copies for the client to filter and sort
never sent to the client machine
sent in very large sections to save processing time
The union of primary keys of a related entity becomes …………. Of a relation.
primarykey
superkey
candidatekey
foreignkey
What does the number of attributes in a relation is called?
Cardinality
Degree
Tuple
Order
Which of the following is a classical approach to database design?
Left Right approach
Right Left approach
Top Down approach
Bottom Up approach
Multivalued dependency is removed in
4 NF
3 NF
2 NF
1 NF
Symbol to represent weak entity set in ER Model
Dotted rectangle
Square
Doubly outlined rectangle
Diamond
The ________ states that a foreign key must either match a primary key value in another relation or it must be null.
entity integrity rule
referential integrity constraint
composite attribute
action assertion
The overall design of a database is called
Subschema of the database
Schema of the database
Structure of the database
View of the database
Event condition action model is related to
Views
Cursors
Triggers
None of these.
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).
In E-R diagram Generalization is represented by
Circle
Rectangle
Hyperbola
Triangle
A …………… is a memory area where data are processed.
view
trigger
cursor
none of the above
Transaction processing is associated with everything below except
producing detail, summary, or exception reports.
recording a business activity.
confirming an action or triggering a response.
maintaining data.