Which of the following is also known as Offline storage ?
primary storage
secondary storage
tertiary storage
none of the above
Correct Answer :
B. secondary storage
Related Questions
Which of the following works as a filter?
UPDATE
DROP
ALTER
SELECT
Primary storage
magnetic disk
magnetic tape
juke box
cache
Specialization is a
top-down approach.
bottom-up approach.
left-right approach.
none of the above
The host part in a class A type of an IP address has
12 bits
16 bits
24 bits
28 bits
Three SQL, DDL, CREATE commands are
Schema, Base and Table
Schema, Table and View
Base, Table and Schema
Key, Base and Table
which of the following is a binary operation?
project
select
rename
none of the above
Data fragmentation is performed by the …… and each fragment is stored at…………..
DBMS, same site
OS ,same site
DBMS ,different site
OS ,different site
Electromagnetic spectrum included in radiowaves are
i) Super High Frequency (SHF)
ii) Very High Frequency (VHF)
iii) Ultra High Frequency (UHF)
iv) High Frequencies (HF)
i, ii and iii only
i, ii and iv only
ii, iii and iv only
i, iii and iv only
Which of the following operator preserves unmatched rows of the relations being joined?
Inner join
Outer join
union
Intersect
A lock that allows concurrent transactions to access different rows of the same table is known as a
Field-level lock
Row-level lock
Table-level lock
Database-level lock
View never contains derived columns.
True
False
Cant say
none
DBMS utility which allows to reconstruct the correct state of database from the backup and history of transactions
Backup
Recovery
Grant
Troubleshooting
Which of the following is not a database object?
index
sequence
cursor
trigger
Thermal noise is often referred to as ............... noise, because it affects uniformly the different frequencies.
Gray
White
Blue
Black
The minimal set of super key is called
Primary key
Secondary key
Candidate key
Foreign key
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
In an E-R diagram attributes are represented by
rectangle.
square.
ellipse.
triangle.
EEPROM
Electrically Extractable Programmable Read Only Memory
Electrically Erasable Programmable Read Only Memory
Electronically Erasable Programmable Read Only Memory
Electrically Erasable Programmable Read Only Memory
Disk storage is referred to as
sequential access storage
direct access storage
random access storage
none of the above
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.
............... noise is caused by the random motion of the electrons in a wire and is avoidable.
Thermal
Intermodulation
Cross talk
Impulse
DECLARE is a(an)
executable statement.
declarative statement.
Ordered file
none of the above
A data manipulation command the combines the records from one or more tables is called
SELECT
PROJECT
JOIN
PRODUCT
Which of the following is true statement ?
SQL permits attribute names to be repeated in the same relation.
a SQL query automatically eliminates duplicates.
a SQL query will not work if there are no indexes on the relations
None of these
A subschema expresses
the logical view.
the physical view.
the external view.
all of the above.
In case of entity integrity, the primary key may be
not Null
Null
both Null & not Null.
any value.
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
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 statement
i) Aggregate functions work on a group of data and return a single value.
ii) ODBC connects the frontend with the database without considering its compatibility
iii) View definition cant be used at multiple places through with clause .
i and ii only
ii and iii only
i and iii only
i only
In which of the random-access method, stations do not sense the medium?
ALOHA
ETHERNET
CSMA/CA
CSMA/CD