Sabarmati Higher secondary school

Subject: Computer assignment questions

Section - A
‣ Choose the correct option from those given below each question. (Each question carries 1 Marks) (50)
01. Which is an alias?
A. Alias is nowhere related to query
B. Alias is creation of duplicate query.
C. Alias is used to print query.
D. Alias is used to give meaningful name to field selected in a query.
02. Which of the following attribute is not signed type of?
A. Integer B. Big int C. Small int D. Tiny int
03. What does mean unknown or missing value?
A. Lacking value B. Present value C. Absent value D. Null value
04. Which attribute is used to store year, month and day as it is stored in the system?
A. Date Stamp B. Date ID C. Date D. Time
05. In which of the following relationships records has to be stored more than once in both the tables?
A. One to Many B. Many to One C. One to One D. Many to Many
06. Given a relation, Teacher Subject (t code, S code, Standard), Which of the following fields can be an
appropriate foreign key field?
A. T code ,S code B. S code C. T code D. T code, standard
07. Which view is used to display our thoughts in the form of query?
A. Design View B. SQL view C. Both A and B D. Wizard
08. Which generation language is SQL?
A. Fifth B. Second C. Fourth D. Third
09. Which is the predefined value of Text data type for length property?
A. 500 B. 50 C. 40 D. 20
10. Which of the following options are possible to implement referential integrity?
A. Set Null B. Update Cascade C. No Action D. Delete table
11. The results of a select query is generally represented as which of the following components?
A. Relation B. Constraint C. Query D. Tables
12. How many steps are there in Database wizard?
A. Five B. Two C. Four D. Three
13. How many categories of Data types are there in Base?
A. Two B. Five C. Six D. Three
14. Which of the following is called the large group of details?
A. Database B. Presentation C. Table D. Animation
15. For what the Information systems has become strong helping hand?
A. In taking decisions B. Storing information
C. Paying D. Transmitting information
16. Which view can be used to insert additional features in query that may be beyond the capacity of the wizard?
A. Wizard B. SQL view C. Design view D. All of the above
17. Which kind of name will always have to confirm to the conventions imposed by the software that we are
using?
A. Logical B. Physical C. External D. Internal
18. Which software makes database practical and more usable?
A. PHP B. Animation based C. DBMS D. Web based
19. What can be as an entity?
A. Any person, Thing B. Object C. Place D. All of these
20. What is the real world objects about which information is to be stored in database?
A. Row B. Entity C. Column D. Table
21. Which data type is used when the field will contain only numbers, but calculation or sdting is not required
with the values in the field?
A. Text B. Boolean C. Integer D. Small int
22. How can the relationship between two tables be seen?
A. Name of relationship B. Name of the table
C. Line depicting relationship D. Symbol depicting relationship
23. Which of the following is used to create query using single table only?
A. Design View B. Wizard C. Both A and B D. None of these
24. Which of the following field is particularly used for numeric fields designated as primary key?
A. Default Value B. Length C. Format D. Auto value
25. Which of the following is false statement?
A. Primary key cannot contain duplicate values.
B. Primary key can be combination of more than one field.
C. Primary key is always numeric field.
D. Primary key cannot contain null values.
26. Which of the following is an open source database available as part of Open office suite?
A. MS Access B. Oracle C. Ingress D. Base
27. Which is the most common type of relationship between the tables?
A. Many to One B. One to Many C. One to One D. Many to Many
28. How database can be kept precise and meaningful?
A. By deleting incorrect records from the table.
B. By deleting unnecessary records from table.
C. Both A and B
D. None of these
29. Which command is used to create a table using SQL statements?
→ → → →
A. Window SQL B. Tools SQL C. Edit SQL D. Insert SQL
30. What is known as a collection of related data items stored in an organized manner?
A. Table B. Data model C. Database D. Record
31. Which of the following is a command to open base program?
A. Applications — [Link]
B. Applications - Open Office Base
C. Start -4 Office - Openoffice.org3.2 Base
D. Applications - Office — Openoffice.org3.2 Base
32. What is DBMs (Database Management System)?
A. Hardware B. Network C. Software D. Server
33. Which of the following gives output in the form of a table?
A. Report B. Query C. Form D. Macro
34. By using which of the following two tables are related to each other?
 A. Index field B. Common field C. Common record D. Mater filed
35. Which steps are shown in database design?
A. Select database B. Save and proceed C. A and B both D. None of these
36. Information is the output generated through processing of which data?
A. processed data B. relational data C. Raw data D. informative data
37. Which data type is used to store digitized images and sounds?
A. Alpha Numeric B. Numeric C. Binary D. Calendar
38. Which of the following alphanumeric type attribute have maximum length upto 2 GB?
A. Char, Var Char B. Var Char Ignore Case C. Long Varchar D. All of these
39. Whose group is created and added to retrieve the total number of customer residing in each city?
A. Record B. Cell C. Field D. None of these
40. Which option makes table creation easy?
A. Use Wizard to Create Table B. SQL commands
C. Create Table in Design view D. All of these
41. Creating table in which of the following view is more beneficial?
A. Create view B. Template C. Design D. Wizard
42. Using which of the following code Base will store alphanumeric characters?
A. BCD B. EBCDIC C. UTF-8 D. Octal
43. Which feature is used to put a restriction on data entry when there is no related record in the master table to
that of any entry in a table?
A. Redundancy B. Indexing C. Relation D. Validation
44. Which of the following is some possible rules and checkpoints for data to be entered for each field?
A. Field Level Accuracy B. Field Level Validation C. Field Level Message D. Field Level Alertness
45. Generally in which data type First Name or Last Name can be stored?
A. Memo B. Text(Char)
C. Text (varchar Ignore Case) D. Text (varchar)
46. Which are the predefined calculations that Base provides to compute on the group of rords?
A. Addition, Average B. Standard Deviation, Variance
C. Count, Maximum, Minimum D. All of these
47. What do many business houses consider as an important asset of the business?
A. Information B. Decision C. Data D. Process
48. In which of the following query, we need to specify the actual value in the criterion cell?
A. Simple Query B. Parameter Query C. Action Query D. Cross Tab Query
49. Which option states that a user should not be allowed to delete or update any record?
A. No delete B. No Permission C. No action D. No processing
50. What is this tool button (.png) for?
A. Save Query B. Add Table or Query C. Update Query D. Run Query
 ANSWERS

Subject: Computer assignment questions

Section - A

‣ Choose the correct option from those given below each question. (Each question carries 1 Marks) (50)
01. (D) Alias is used to give meaningful name to field selected in a query.
02. (D) Tiny int
03. (D) Null value
04. (C) Date
05. (D) Many to Many
06. (B) S code
07. (D) Wizard
08. (C) Fourth
09. (B) 50
10. (D) Delete table
11. (B) Constraint
12. (B) Two
13. (D) Three
14. (A) Database
15. (C) Paying
16. (C) Design view
17. (B) Physical
18. (C) DBMS
19. (D) All of these
20. (B) Entity
21. (A) Text
22. (C) Line depicting relationship
23. (B) Wizard
24. (D) Auto value
25. (C) Primary key is always numeric field.
26. (D) Base
27. (B) One to Many
28. (C) Both A and B
29. (B) Tools → SQL
30. (C) Database
31. (D) Applications - Office — Openoffice.org3.2 Base
32. (C) Software
33. (B) Query
34. (B) Common field
35. (C) A and B both
36. (C) Raw data
37. (C) Binary
38. (D) All of these
39. (C) Field
40. (A) Use Wizard to Create Table
41. (C) Design
42. (C) UTF-8
43. (C) Relation
44. (B) Field Level Validation
45. (C) Text (varchar Ignore Case)
46. (D) All of these
47. (C) Data
48. (A) Simple Query
49. (C) No action
50. (B) Add Table or Query