MCQ on RDBMS Class 10 IT 402 UNIT -3 a.

Container
Q1. A database is an organized collection of b. Back End
_______________. c. End
a. data d. None of the above
b. Attributes
c. Record Ans. b. Back End
d. None of the above Q7. Duplication of data is called _________.
a. Inconsistency
Ans. a (data) b. Consistency
Q2. Which of the following software is c. Redundancy
appropriate to store data about school d. Foreign Key
students?
Ans. c. Redundancy
a. MS-Access Q8. Which of the following is not the
b. Writer advantage of database?
c. Calc
d. Impress a. Sharing of Data
b. Reduce Data Redundancy
Ans. a. MS-Access c. Increase Data Inconsistency
Q3. Which of the following is not a database d. Data Security
programs?
Ans. c. Increase Data Inconsistency
a. MySQL Q9. Data Integrity means that data is
b. Oracle accurate and consistent in the database.(T/F)
c. Writer
d. OObase a. True
b. False
Ans. c. Writer
Q4. __________ store data in Single table. Ans. a. True
a. Flat File Q10. A database can have only one
b. Relational table.(T/F)
c. Single File
d. One File a. True
b. False
Ans. a. Flat File
Q5. ___________ are dedicated computers Ans. b. False
that hold the actual databases and run only Q11. Which of the following will help to
DBMS and related Software. maintain unique record in the table?
a. Main Server
b. Web Server a. Foreign Key
c. Database Server b. Primary Key
d. Non Database Server c. Composite Key
d. Alternate Key
Ans. c. Database Server
Q6. GUI act as front end and database server Ans. b. Primary Key
act as _____
Q12. Which of the following field of table b. RDBMS
“Book” can act as primary key? c. Special DBMS
d. All of the above
a. Book_number
b. Subject Ans. b. RDBMS
c. price Q18. Identify the Foreign Key from table
d. Author_name “Sales”

Ans. a. Book_number Table Client:

Q13. When primary key is made up of two ClientID (primary Key)
or more columns then it is called __ primary clientname
key. clientphone
a. Mixed
b. Reference Table : Sales
c. Composite SalesID (Primary Key)
d. Compost ClientID
Profit
Ans. c. Composite a. SalesID
Q14. Duplicate values can be entered in b. Profit
primary key.(T/F) c. Clientphone
d. ClientID
a. True
b. False Ans. d. ClientID
Q19. Which of the following is not valid
Ans. False field of table “Student”
Q15. A key which is referring to the primary
key of another table is called _______ a. admno
a. Alternate Key b.name
b. Primary Key c. fees
c. First Primary Key d. salary
d. Foreign Key
Ans. d. salary
Ans. d. Foreign Key Q20. There can be multiple primary key in a
Q16. A field which is ______ for each and table.(T/F)
every record is called Primary key.
a. Common a. True
b. Same b. False
c. Unique
d. None of the above Ans. False

Ans. c. Unique
Q17. When data is stored, maintained and
retrieved from multiple tables then special
database software are required
called ______
a. DBMS
Q21. In RDBMS, data is organized in the Q27. Open Office base is not an open source
form of __________________ software.(T/F)

a. Table a. True
b. Record b. False
c. Field
d. None of the above Ans. False
Q28. _______________ are the basic
Ans. a. Table building blocks of a database.
Q22. SQL stands for _________________ a. Tables
a. Structured Queue Language b. Record
b. Structured Query Language c. Fields
c. Structured Query Lang d. All of the above
d. None of the above
Ans. a. Tables
Ans. b. Structured Query Language Q29. We can create table :
Q23. All the values in ________ are of same
type. a. in design view
a. Records b. use Wizard
b. Table c. Both of the above
c. Database d. None of the above
d. Fields
Ans. c. Both of the above
Ans. d. Fields Q30. By default data type of fields is.
Q24. ___________ represent a single data
item in a table. a. Text[Varchar]
a. Tuples b. Text[Char]
b. Attributes c. Int
c. Relation d. Long
d. All of the above
Ans. a. Text[Varchar]
Ans. a. Tuples
Q25. In tables, data is organized in the form
of rows and columns.(T/F) Q31. Base automatically adds the column as
Primary Key if we don’t add.(T/F)
a. True
b. False a. True
b. False
Ans. True
Q26. Every row in a table has the same Ans. True
structure.(T/F)

a. True
b. False

Ans. True
Q32. By default the length of Varchar data a. Decimal
type is __ b. Real
a. 20 c. Numeric
b. 30 d. Boolean
c. 40
d. 50 Ans d. Boolean
Q38. Which of the following will occupy
Ans d. 50 more space in computer memory?
Q33. By default the name of the table
is ______ a. Bigint
a. Tab 1 b. Integer
b. Table 1 c. Smallint
c. First Table d. Boolean
d. Untitled 1
Ans a. Bigint
Ans b. Table 1 Q39. _______ data types are used for storing
Q34. __________ are used to identify which photos, music files etc
type of data we are going to store in the a. Binary
database. b. Alphanumeric
c. Numeric
a. Datatype d. Special
b. Record
c. Table Ans a. Binary
d. Attributes
Q40. Char is a ______ length data type and
Ans. a. Datatype varchar is a ______ length data type.
Q35. Which data type will be appropriate to a. Fixed, Variable
store information as Salary, Fees, Price etc b. Variable, Fixed
c. Variable, Variable
b. Alphanumeric Data types d. Fixed, Fixed
a. Numeric Data type
c. Binary Data types Ans. a. Fixed, Variable
d. Date Time

Ans a. Numeric Data type

Q36. Which of the following is not a
numeric data type?

a. Tinyint
b. Smallint
c. Boolean
d. Date

Ans d. Date
Q37. Which of the following data types can
not store decimal values?