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 Answer2. The model for a record management system might be
handwritten list
a Rolodex card file
a business form
all of above
View Answer / Hide Answer3. The most open source DBMS.
Microsoft SQL Server
Microsoft Access
MySQL
Oracle
View Answer / Hide Answer4. The most popular commercial DBMS.
Microsoft SQL Server
Microsoft Access
MySQL
Oracle
View Answer / Hide Answer5. The relational database environment has all of the following components except
users
separate files
database
query languages
View Answer / Hide Answer6. 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 AnswerANSWER: 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 Answer8. The view of total database content is
Conceptual view.
Internal view.
External view.
Physical View.
View Answer / Hide Answer9. This is not a date type in Sql
char
string
Long int
decimal
View Answer / Hide Answer10. 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
