In the architecture of a database system external level is the
physical level.
logical level.
conceptual level
view level.
Correct Answer :
D. view level.
Related Questions
Noiseless channel has ……… types of protocols.
2
3
4
5
The physical path over which a message travels
Thermal
Medium
Protocol
Impulse
Which of the following works as a filter?
UPDATE
DROP
ALTER
SELECT
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
The statement
Every foreign-key value must match a primary-key value in an associated table
Is related to
View
Cursor defination
Referential intergrity
Trigger
Repeaters operate in
i) Physical layer
ii) Datalink layer
iii) Transport layer
iv) Network layer
i and ii only
ii and iii only
ii only
i only
In an Entity-Relationship Diagram Diamonds represents
Attributes
Multi-valued attributes
Weak entity set
Relationship sets
Which of the following extracts its data from the result of an SQL SELECT statement.
View
Synonym
Sequence
Transaction
In mesh topology, if the number of devices is n , then the number of ports present in each device is
n
n+1
n-1
n/2
The control of concurrent execution is left with the
operating system
controller unit of the kernel
concurrency control component of the database system
none
The collection of information stored in a database at a particular moment is?
View
Instance
Scheme
None of these
Which of the following layer uses trailer of the frame for error detection?
Transport layer
Network layer
Datalink layer
None of these
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
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
The class based addressing is known as
Classless addressing
Classful addressing
Classified addressing
Classical addressing
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
The union of primary keys of a related entity becomes …………. Of a relation.
primarykey
superkey
candidatekey
foreignkey
Which of the following is the unit of signaling speed or modulation rate or the rate of symbol transmission?
Data rate
Bit rate
Signal to Noise Ratio
Baud rate
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
In ………… paging we make copy of the current page table.
physical
logical
shadow
duplicate
Which of the following are the properties of entities?
Groups
Table
Attributes
Switchboards
View never contains derived columns.
True
False
Cant say
none
Which of the following normalization is needed, if an attribute of a composite key is dependent on an attribute of the other composite key?
BCNF
Second
Third
Fourth
Multivalued dependency is removed in
4 NF
3 NF
2 NF
1 NF
The exists construct returns the value true, if the argument subquery is
empty
nonempty
contains null values
none of the above
…………… is responsible for using that the database remains in a consistent state despite system failure.
Storage manager
Admin
Transaction manager
none of the above
The database environment has all of the following components except:
users.
separate files.
database.
database administrator.
In which of the following SET concept is used ?
Network Model
Hierarchical Model
Relational Model
None of these
DBMS utility which allows to reconstruct the correct state of database from the backup and history of transactions
Backup
Recovery
Grant
Troubleshooting
In an Entity-Relationship Diagram Ellipses represents
Attributes
Weak entity set
Relationship sets
Multi-valued attributes