Placement papers on Database - Set 1

Placement papers on Database - Set 1


1. The method of access which uses key transformation is known as

Direct
Hash
Random
Sequential
View Answer / Hide Answer

ANSWER: Hash




2. The model for a record management system might be

handwritten list
a Rolodex card file
a business form
all of above
View Answer / Hide Answer

ANSWER: all of above




3. The most open source DBMS.

Microsoft SQL Server
Microsoft Access
MySQL
Oracle
View Answer / Hide Answer

ANSWER: MySQL




4. The most popular commercial DBMS.

Microsoft SQL Server
Microsoft Access
MySQL
Oracle
View Answer / Hide Answer

ANSWER: Oracle




5. The relational database environment has all of the following components except

users
separate files
database
query languages
View Answer / Hide Answer

ANSWER: separate files




6. In second normal form ______________________-

A composite attributes is converted to individual attributes.
Non key attributes are functional dependent on key attributes.
The non key attributes functionally dependent on not a part of key attributes.
All the above.
View Answer / Hide Answer

ANSWER: Non key attributes are functional dependent on key attributes.




7. The statement in SQL which allows to change the definition of a table is

Alter
Update
Delete
Select
View Answer / Hide Answer

ANSWER: Alter




8. The view of total database content is

Conceptual view.
Internal view.
External view.
Physical View.
View Answer / Hide Answer

ANSWER: Conceptual view.




9. This is not a date type in Sql

char
string
Long int
decimal
View Answer / Hide Answer

ANSWER: string




10. To avoid the problem of updating you can take the following principle for A good database design.

Unrelated data should be kept in different table.
Table should not contain any redundancy.
Table should represent constraint.
All the above
View Answer / Hide Answer

ANSWER: All the above


Post your comment