Class 10 Info Tech RDBMS Basic
Session 2 : Create and Edit Tables Using Wizard and SQL Commands
Multiple Choice Questions
1. Data in a relational database management system (RDBMS) is organized in the form of _________.
a. tables
b. fields
c. rows
d. Information
Answer : a. tables
2. A relational database is a collective set of multiple data sets organized by __________.
a. tables
b. records
c. columns
d. All of these
Answer: d. All of these
3. Relational database establish a well-defined relationship between database _________.
a. tables
b. records
c. columns
d. All of these
Answer : a. tables
4. ___________ communicate and share information, which facilitates data searchability, organization and reporting.
a. Tables
b. Columns
c. Records
d. All of these
Answer: a. Tables
5. Relational database uses __________ language.
a. Hypertext Markup Language (HTML)
b. Structured Query Language (SQL)
c. RDBMS
d. eXtensible Markup Language (XML)
Answer: b. Structured Markup Language (SQL)
6. ____________ is a standard user application that provides an easy programming interface for database interaction.
a. SQL
b. HTML
c. XML
d. None of these
Answer : a. SQL
7. Which of followings are the Database Objects.
a. Tables
b. Columns
c. Rows
d. All of these
Answer: d. All of these
8. A ________ is a set of data elements (values) that is organized using a model of vertical columns (which are identified by their name) and horizontal rows.
a. Database
b. Table
c. Record
d. None of these
Answer: b. Table
9. A table has a _______ number of columns, but can have _______ number of rows.
a. Defined (Finite) , Any (Infinite)
b. Any (Infinite), Defined (Finite)
c. Defined (Finite) , Defined (Finite)
d. Any (Infinite) , Any (Infinite)
Answer: a. Defined (Finite) , Any (Infinite)
10. Each ______ is identified by the values appearing in a particular column identified as a unique key index or the key field.
a. table
b. row
c. column
d. database
Answer: b. row
11. In RDBMS table is also known as __________.
a. Relation
b. Spreadsheet
c. Tabular Data
d. None of these
Answer : a. Relation
12. A column is also known as __________.
a. Field
b. Attribute
c. Data Item
d. Both a and b
Answer: d. Both a and b
13. A _______ is a set of data values of a particular simple type, one for each row of the table.
a. column
b. row
c. tuple
d. data item
Answer: a. column
14. The ________ provide the structure according to which the rows are composed.
a. Rows
b. Columns
c. Tables
d. None of these
Answer: b. Columns
15. A row is also called a __________.
a. Record
b. Tuple
c. Both a and b
d. None of these
Answer : c. Both a and b
16. A row represents a single, _________ in a table.
a. Data Item
b. Value
c. Attributes
d. None of these
Answer: a. Data Item
17. A database _________ can be visualized as consisting of rows and columns or fields.
a. table
b. row
c. column
d. None of these
Answer: a. table
18. Each _______ in a table represents a set of related data.
a. column / attribute / field
b. row / tuple / record
c. table / relation
d. None of these
Answer: b. row / tuple / record
19. Every _________ in the table has the same structure.
a. row
b. column
c. table
d. None of these
Answer: a. row
20. An open source RDBMS available in OpenOffce.org is known as ________.
a. Writer
b. Calc
c. Base
d. Access
Answer: c. Base
21. You can create a database in Openomce.org using ________.
a. Table Wizard
b. Database Wizard
c. File Wizard
d. None of these
Answer: b. Database Wizard
22. You can use OpenOffice Database Wizard to _______.
a. Create a new database
b. Open an existing database file
c. Connect to a database stored on a server
d. All of these
Answer: d. All of these
23. _________ are the basic building blocks of a database.
a. Columns
b. Rows
c. Tables
d. All of the above
Answer: c. Tables
24. You can store the data in the database in the form of _________.
a. Columns
b. Rows
c. Tables
d. All of the above
Answer: c. Tables
25. In how many ways you can crate table in OpenOffice.org?
a. 1
b. 2
c. 3
d. 4
Answer: b. 2
