CH-11: Retrieving Data Using Tables (GSEB Computer Textbook Solutions Class 11)

Computer Textbook MCQ Solutions Class 11 

CH-11: Retrieving Data Using Tables

1.       The result of a select query is generally represented as which of the following components?

a.       Table

b.      Query

c.       Constraint

d.      Relation

 

2.       Which of the following feature of Base is used to retrieve specific information from the database?

a.       Table

b.      Query

c.       Form

d.      Report

 

3.       Which of the following is not an aggregate function?

a.       Square root

b.      Sum

c.       Min

d.      Max

 

4.       Which of the following is used to group the result of a query?

a.       Order by

b.      Group by

c.       Arrange by

d.      Set of

 

5.       Which of the following statement is false?

a.       Query can be stored as an object in database and reused.

b.      Query is written to be used only once.

c.       Query cannot be created using wizard.

d.      Query cannot be written on a query.

 

6.       What is an alias?

a.       Alias is creation of duplicate query.

b.      Alias is used to give meaningful name to fields selected in a query.

c.       Alias is used to print query.

d.      Alias is nowhere related to query.

 

7.       Which delimiter is used to surround the text in a query criterion?

a.       “ (double quote)

b.      ‘(single quote)

c.       $ (dollar)

d.      # (hash)

 

8.       Which of the following operator is used with wild card character?

a.       Like

b.      is

c.       equal

d.      =

 

9.       Which of the following operator is used as wild card character in Base?

a.       &

b.      +

c.       –

d.      * 


10.   Which query, when run, displays a dialog box asking to enter the value to match the criteria for retrieving the data?

a.       Select Query

b.      Insert Query

c.       Parameter Query

d.      Update query

 

11.   The Parameter name in parameter query is preceded by which symbol?

a.       Comma

b.      Colon

c.       Question mark

d.      Explanation mark

 

12.   SQL stands for?

a.       Simple Query Language

b.      Structured Query Language

c.       Simple Question for large databases

d.      Structured queries for large databases

 

CH-10: Working with Tables (GSEB Computer Textbook Solutions Class 11)

Computer Textbook MCQ Solutions Class 11

CH-10: Working with Tables

1.       Which of the following operations cannot be performed on a record in database?

a.       Insert

b.      Delete

c.       Hide

d.      Update

 

2.       Which of the following represents maximum levels of sorting provided by Base Wizard?

a.       3

b.      4

c.       5

d.      6

 

3.       Which of the following refers to data redundancy?

a.       Deletion of data

b.      Repetition of data

c.       Decomposition of tables

d.      Relationships of tables

 

4.       Given a relation, TeacherSubject (Tcode, Scode, Standard), which of the following fields can be an appropriate foreign key field?

a.       Tcode

b.      Scode

c.       Tcode,Standard

d.      Tcode,Scode

 

5.       Which of the following statement is incorrect?

a.       Every table must have a primary key.

b.      Primary key can be combination of fields.

c.       Data type of Primary key and foreign key should be same.

d.      Names of Primary key and foreign key should be same.

 

6.       Which of the following type of relationship exists between Student and Teacher in a school?

a.       One to One

b.      One to Many

c.       Many to Many

d.      No relationship exists

 

7.       Which of the following type of relationship exists between Student and Class Teacher in a school?

a.       One to One

b.      One to Many

c.       Many to Many

d.      No relationship exists

 

8.       Which of the following options are possible to implement referential integrity?

a.       No Action

b.      Set Null

c.       Delete table

d.      Update Cascade

 

9.       AutoValue property can be set for field with which of the following datatype?

a.       Text

b.      Image

c.       Integer

d.      Boolean

 

10.   Which of the following statement is true for Default field property in Base?

a.       Default value can be numeric value only.

b.      Default value once set can be changed later.

c.       Default value cannot be greater than 500.

d.      Default value should be greater than value set in Length.

 

11.   Which of the following property is equivalent to NOT NULL?

a.       Length

b.      Default

c.       Required

d.      Format