Data stored in cursor is called ……………
record
active data set
object
none of the above
Correct Answer :
B. active data set
Related Questions
In which of the random-access method, stations do not sense the medium?
ALOHA
ETHERNET
CSMA/CA
CSMA/CD
Benefit of database normalization is
smaller number of tables
higher query processing efficiency
reduced I/O for most queries
reduced data redundancy
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
Symbol to represent weak entity set in ER Model
Dotted rectangle
Square
Doubly outlined rectangle
Diamond
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
Database locking concept is used to solve the problem of
Lost Update
Uncommitted Dependency
Inconsistent Data
All of the above
Volatile storage
loses its contents when power is switched off.
doesnt loses its contents when power is switched off.
creates backup when power is switched off.
none
Extended Entity Relationship model consists of which of the following
i) Specialization
ii) Generalization
iii) Categorization
i and ii only
ii and iii only
i and iii only
All i, ii iii
Secondary storage
magnetic disk
magnetic tape
juke box
cache
An operation that will increase the length of a list is
insert
modify
lookup
none of the above
The statement in SQL which allows to change the definition of a table is
Select
Update
Create
Alter
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
Technique used in log based recovery
Immediate database modification
Graph-based recovery
key dependencies
none of the above
The degree of the table with 500 rows and 7 columns is
500
7
3500
none of these
Attenuation can be also expressed in decibel dB) and commonly used because.
i) Signal strengths often fall off logarithmically
ii) Cascade losses and gains can be calculated with simple additions and subtractions
i only
ii only
Both A and B
None of the above
.................. means sending a digital signal over a channel without changing the digital signal to an analog signal.
Baseband transmission
Broadband transmission
Digital transmission
Analog transmission
A logical description of some portion of database that is required by a user to perform task is called as
System View
User View
Logical View
Data View
Consider the join of a relation R with relation S. If R has m tuples and S has n tuples,
then the maximum size of join is:
mn
m+n
m+n)/2
2 m+n)
Data stored in cursor is called ……………
record
active data set
object
none of the above
The class based addressing is known as
Classless addressing
Classful addressing
Classified addressing
Classical addressing
Commit operation …………… writes the changes made to the database.
temporarily
permanently
none of these
all of the above
Relational Algebra is
Data Definition Language.
Data Manipulation Language
Procedural query Language
None of the above
The output of the Data Definition Language is stored in the
view table
schema
metadata
all of the above.
Which of the following are the properties of entities?
Groups
Table
Attributes
Switchboards
The overall design of a database is called
Subschema of the database
Schema of the database
Structure of the database
View of the database
What is the result of the following SQL statement ?
SELECT A.emp_Name, B.ph_num
FROM emp A LEFT OUTER JOIN phone B
ON A. emp_ID = B.emp_ID
A list of employees phone number
A list of all employees that have spouses, with phone number included in the list
A list of all employees names, including the phone number if they have one
Two lists : One list of employees, the other of phone numbers
Multivalued dependency is removed in
4 NF
3 NF
2 NF
1 NF
Size of source and destination address in IP header
4 bits
8 bits
12 bits
32 bits
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
The syntax to select all column from the table is
select all from tablename
select * from tablename
select from tablename
none of these