Q1. A database is an organized collection of ______________.
a. data
b. Attributes
c. Record
d. None of the above
Show Answer
a. dataQ2. Which of the following software is appropriate to store data about school students?
a. MS-Access
b. Writer
c. Calc
d. Impress
Show Answer
Ans- a. MS-AccessQ3. Which of the following is not a database programs?
a. MySQL
b. Oracle
c. Writer
d. OObase
Show Answer
Ans- c. WriterQ4. __________ store data in Single table.
a. Flat File
b. Relational
c. Single File
d. One File
Show Answer
Ans- a. Flat FileQ5. ___________ are dedicated computers that hold the actual databases and run only DBMS and related Software.
a. Main Server
b. Web Server
c. Database Server
d. Non Database Server
Show Answer
Ans- c. Database ServerQ6. GUI act as front end and database server act as _____
a. Container
b. Back End
c. End
d. None of the above
Show Answer
Ans- b. Back EndQ7. Duplication of data is called _________.
a. Inconsistency
b. Consistency
c. Redundancy
d. Foreign Key
Show Answer
Ans- c. RedundancyQ8. Which of the following is not the advantage of database?
a. Sharing of Data
b. Reduce Data Redundancy
c. Increase Data Inconsistency
d. Data Security
Show Answer
Ans- c. Increase Data InconsistencyQ9. Which of the following will help to maintain unique record in the table?
a. Foreign Key
b. Primary Key
c. Composite Key
d. Alternate Key
Show Answer
Ans- b. Primary KeyQ10. Which of the following field of table “Book” can act as primary key?
a. Book_number
b. Subject
c. price
d. Author_name
Show Answer
Ans- a. Book_numberQ11. When primary key is made up of two or more columns then it is called _______primary key.
a. Mixed
b. Reference
c. Composite
d. Compost
Show Answer
Ans- c. CompositeQ12. A key which is referring to the primary key of another table is called _______
a. Alternate Key
b. Primary Key
c. First Primary Key
d. Foreign Key
Show Answer
Ans- d. Foreign KeyQ13. A field which is_______for each and every record is called Primary key.
a. Common
b. Same
c. Unique
d. None of the above
Show Answer
Ans- c. UniqueQ14. When data is stored, maintained and retrieved from multiple tables then special database software are required called ______
a. DBMS
b. RDBMS
c. Special DBMS
d. All of the above
Show Answer
Ans- b. RDBMSQ15. Identify the Foreign Key from table “Subject”
Table STU:
Stu_ID (primary Key)
Stu_Name
Stu_Phone
Table : Subject
Sub_ID (Primary Key)
Stu_ID
Marks
a. Sub_ID
b. Marks
c. Stu_phone
d. Stu_ID
Show Answer
Ans- d. Stu_IDQ16. Which of the following is not valid field of table “Student”
a. admno
b. name
c. fees
d. salary
Show Answer
Ans- d. salaryQ17. In RDBMS, data is organized in the form of __________________
a. Table
b. Record
c. Field
d. None of the above
Show Answer
Ans- a. TableQ18. SQL stands for _________________
a. Structured Queue Language
b. Structured Query Language
c. Structured Query Lang
d. None of the above
Show Answer
Ans- b. Structured Query LanguageQ19. All the values in ________ are of same type.
a. Records
b. Table
c. Database
d. Fields
Show Answer
Ans- d. FieldsQ20. ___________ represent a single data item in a table.
a. Tuples
b. Attributes
c. Relation
d. All of the above
Show Answer
Ans- a. TuplesQ21. _______________ are the basic building blocks of a database.
a. Tables
b. Record
c. Fields
d. All of the above
Show Answer
Ans- a. TablesQ22. We can create table :
a. in design view
b. use Wizard
c. Both of the above
d. None of the above
Show Answer
Ans- c. Both of the aboveQ23. By default data type of fields is.
a. Text[Varchar]
b. Text[Char]
c. Int
d. Long
Show Answer
Ans- a. Text[Varchar]Q24. By default the length of Varchar data type is __
a. 20
b. 30
c. 40
d. 50
Show Answer
Ans- d. 50Q25. By default the name of the table is ______
a. Tab 1
b. Table 1
c. First Table
d. Untitled 1
Show Answer
Ans- b. Table 1Q26. __________ are used to identify which type of data we are going to store in the database.
a. Datatype
b. Record
c. Table
d. Attributes
Show Answer
Ans- a. DatatypeQ27. Which data type will be appropriate to store information as Salary, Fees, Price etc
a. Numeric Data type
b. Alphanumeric Data types
c. Binary Data types
d. Date Time
Show Answer
Ans- a. Numeric Data typeQ28. Which of the following is not a numeric data type?
a. Tinyint
b. Smallint
c. Boolean
d. Date
Show Answer
Ans- d. DateQ29. Which of the following data types can not store decimal values?
a. Decimal
b. Real
c. Numeric
d. Boolean
Show Answer
Ans- d. BooleanQ30. Which of the following will occupy more space in computer memory?
a. Bigint
b. Integer
c. Smallint
d. Boolean
Show Answer
Ans- a. BigintQ31. _______ data types are used for storing photos, music files etc
a. Binary
b. Alphanumeric
c. Numeric
d. Special
Show Answer
Ans- a. BinaryQ32. Char is a ______ length data type and varchar is a ______ length data type.
a. Fixed, Variable
b. Variable, Fixed
c. Variable, Variable
d. Fixed, Fixed
Show Answer
Ans- a. Fixed, VariableQ33. Which field is suitable for storing records of employees?
a. EmpNo
b. Empname
c. Salary
d. All of the above
Show Answer
Ans- d. All of the aboveQ34. Auto Value is a property of __ data type .
a. Numeric
b. Character
c. Binary
d. Date
Show Answer
Ans- a. NumericQ35. Which of the following property help to set the number of characters in Varchar type.
a. Auto value
b. Required
c. Default Value
d. Length
Show Answer
Ans- d. LengthQ36. Which property ensures that field can not be left blank?
a. Entry required
b. Format
c. Required Entry
d. Required
Show Answer
Ans- a. Entry requiredQ37. By default the length of the Integer data type is ______________
a. 10
b. 15
c. 20
d. 25
Show Answer
Ans- a. 10Q38. Which of the following property to be turned “yes” so that value will be auto incremented?
a. Default
b. Format
c. Auto value
d. Length
Show Answer
Ans- c. Auto valueQ39. Which of the following is not the binary data types?
a. Longvarbinary
b. Varbinary
c. Binary
d. Charbinary
Show Answer
Ans- d. CharbinaryQ40. Which of the following is not the date time data types?
a. Date
b. Time
c. Datestamp
d. Timestamp
Show Answer
Ans- c. DatestampQ41. Which data type is used to store value of fields like “Date of Birth”?
a. Date Time
b. Varchar
c. Integer
d. Other
Show Answer
Ans- a. Date TimeQ42. We can ____________________ data in table.
a. modify
b. insert
c. delete
d. all of the above
Show Answer
Ans- d. all of the aboveQ43. In which view data can be entered in table?
a. Datasheet view
b. Design view
c. Both of the above
d. None of the above
Show Answer
Ans- a. Datasheet viewQ44. In which mode we can change the structure of table?
a. Datasheet view
b. Design view
c. Structure view
d. All of the above
Show Answer
Ans- b. Design viewQ45. Sorting means to arrange data in _______________ order.
a. increasing
b. decreasing
c. increasing or decreasing
d. None of the above
Show Answer
Ans- c. increasing or decreasingQ46. In Base data can be linked between two or more tables with the help of _________________
a. primary key
b. foreign key
c. primary and foreign key
d. None of the above
Show Answer
Ans- c. primary and foreign keyQ47. Relationship can be created between
a. two tables only
b. one table only
c. two or more tables
d. none of the above
Show Answer
Ans- c. two or more tablesQ48. Relationship between tables can be created from _____________________ menu.
a. View
b. Insert
c. Windows
d. Tools
Show Answer
Ans- d. ToolsQ49. There are __________________ types of relationship which can be created between tables.
a. three
b. two
c. four
d. infinite