Secondary storage
magnetic disk
magnetic tape
juke box
cache
Correct Answer :
A. magnetic disk
Related Questions
Database locking concept is used to solve the problem of
Lost Update
Uncommitted Dependency
Inconsistent Data
All of the above
As a side-effect of database update ,the system automatically executes a statement called
a view
a grant permission
a trigger
all of the above
Which of the following operator preserves unmatched rows of the relations being joined?
Inner join
Outer join
union
Intersect
Data Manipulation Language DML) is not to
Create information table in the Database
Insertion of new information into the Database
Deletion of information in the Database
Modification of information in the Database
A functional dependency between two or more non-key attributes is called
Transitive dependency
Partial transitive dependency
Functional dependency
Partial functional dependency
In E-R diagram Generalization is represented by
Circle
Rectangle
Hyperbola
Triangle
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
Expand the acronym OLAP
Object Linked Access Program
Organizational Architecture Processing
Online Analytical Processing
none of these
The database environment has all of the following components except:
users.
separate files.
database.
database administrator.
The union of primary keys of a related entity becomes …………. Of a relation.
primarykey
superkey
candidatekey
foreignkey
Specialization is a
top-down approach.
bottom-up approach.
left-right approach.
none of the above
Which of the following is not a constraint on a single relation?
check
unique
not null
is duplicate
Which of the following are the properties of entities?
Groups
Table
Attributes
Switchboards
A type of query that is placed within a WHERE or HAVING clause of another query is called
Super query
Sub query
Master query
Multi-query
What does a field or a combination of fields that has a unique value called ?
Foreign key
Secondary key
Primary key
Alternate key
Which one of the following is provided by a data dictionary ?
User data
Database structure data
Sorted data
Functional data
In RDBMS, Data is presented as a collection of
Relation
Table
Attribute
Entity
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
Which command is used to cancel privileges granted through the GRANT command ?
CANCEL
OVER
STOP
REVOKE
Related fields in a database are grouped to form a
data file.
data record.
menu.
bank.
The command used to delete a particular column in a relation
UPDATE
DROP
ALTER
DELETE
Which of the following aggregate function doesnt ignore NULLs in its results?
COUNT
COUNT(*)
MAX
none of these
Functional dependencies are generalization of
Relation dependencies
Data dependencies
key dependencies
none of the above
State which of the following statements are True
i) TCP is connection oriented but unreliable
ii) UDP is connection oriented but unreliable
iii) TCP is connectionless but reliable
iv) UDP is connectionless but reliable
i and ii only
ii and iii only
i and iii only
None of these
A transaction which may not complete its execution successfully is termed as
Failed
Aborted
Blocked
Finished
Technique(s) used for data recovery after any failure
Logging
Recovery manager
Both A and B are true
Both A and B are false
Which of the following will NOT eliminates the ambiguities of a null value?
Define the attribute as required
Define subtypes
Define each attribute as having an initial value that is recognized as blank
Define supertypes
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
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)
Log into a computer across an internet
IMAP
TELNET
POP3
Infrared