HALF YEARLY EXAMINATION = COMPUTERS PART-B Marks: 80 Time: 2.5 hours Multiple Choice Questions 1. wv What do you mean by query with respect to database system? (a) Command that is used to interact with a database. (b) Table which is created but never used. () The element which describes the architecture of DBMS. (d) All of these. Which of the following fields is NOT suitable for a primary key? (a) An auto number field (b) A student's registration number (©) Bank account number (d) Date of birth Which of the following statements is INCORRECT about a database? (a) Fields are organised in columns in a database. (b) Each field may contain serveral records. (0) Itis a collection of fields which represents a complete unit of information. (a) A database is a repository of information needed for running certain functions in an organisation. Creative Kids Digital Home Tutor Apo ae PSUS) computer10 @)4, A database system in which relationships among data are established in such a way that one data item is present as a child of another, is said to be aan .eesessne DBMS. (a) Relational (b) Isolated (0) Hierarchical (d) Virtual 5. Asystem in which database is maintained in the form of tables and all records are stored in rows is called... (a) Relational database (b) Object-oriented database (0) Flat database (d) Varied database 6. Akshat wants to store a huge amount of information about his firm in a database. Which type of table organization would be most suitable for this purpose? (a) Relational (b) Flat File (©) Hierarchical (d) Both (a) and (b) 7. Open Office Base is a software. (a) RDBMS (b) RRMS (c) BDMS (d) RBDMS 8. Acollection of related tables with data in it, is a (a) record (b) data base (0) field (d) none of these 9, Anse i8 located at the intersection of a row and column (a) value (b) record (0) field (d) tuple 10. A... is used to extract records from a table according to a certain condition. (a) form (b) query (6) report (d) table @® computer.1013. 16. In Open Office Base, all objects of a database are stored with an extension (a) .obd (b) .oob (0) .odb (d) .obo The.........0. is a field which uniquely identifies each record in a table. (a) Unique key (b) Impotant key (c) Prime key (d) Primary key uw are set to control the attributes of the data type of a field. (a) field values (b) Properties (0) Field Properties (d) Datatype Properties Akey which refers to the primary key of another table is called.... (a) alternate key (b) primary key (0) first primary key (d) foreign key The field which is........ key. «for each and every record is called Primary (a) common (b)same (6) unique (d) none of these When data is stored, maintained and retrieved from multiple tables then special database software are required. They are called... + (a) DBMS (b) RDBMS (c) special DBMS (d) All of these In RDBMS, data is organised in the form of a ven» (a) Table (b) Record (©) Field (d) None of these Computer10 @)20. 23. 24. 25. SOL stands for (a) Structured Queue Language (b) Structured Query Language (c) Sequential Query Language (d) None of these Alll the values in a... awn are of same type. (a) Record (b) Table (c) Database (d) Field represent a single data item in a table (a) Tuples (b) Attributes (0) Relation (d) Alll of these is the basic building block of a database. (a) Table (b) Record (c) Field (d) Query We can create a Table : (a) in Design view —_—_(b) in Normal view (0) using wizard (d) Both (a) and (c) By default data type of a field is (a) Text [Varchar] (b) Int (6) Text [Char] (d) Long By default the length of Varchar data type iS... (a) 20 (b) 30 (c) 40 (d) 50 By default the name of the table is. (a) Tab 1 (b) First Table (c) Table 1 (d) Untitled 1 @® computer1026. 27. 28. 29. 30. 31 Charisa..... .. length data type and Varchar is a...... ... length data type. (a) fixed, variable (b) variable, fixed (0) variable, variable _(d) fixed, fixed We an ....ecerenne data ina table. (a) modify (b) insert (0) delete (d) all of these Sorting means to arrange data in.... ... order. (a) modified (b) decreasing (0) increasing (d) both (a) and (c) Referential integrity is used to maintain ............... and consistency of data in a relationship. (a) security (b) accuracy () references (d) none of these In Base, data can be linked between two or more tables with the help of... (a) primary key (b) foreign key (©) primary key and foreign key (d) none of these Relationship between tables can be created from ji: MENU (a) View (b) Insert () Windows (d) Tools We can create query in/by (a) design view (b) using wizard (c) both (a) and (b) —_(d) none of these computer1033. 34, 36. 37, 38. 39. 40. ... Statement is used to retrieve data from a table. (a) Delete (b) Update (0) Print (d) Select .. is the most common DML command. (a) Delete (b) Update (0) Select (d) All of these Which of the following clause return specific rows? (a) Order by (b) Where (c) Having (d) Specific Which of the following clause return records in ascending order? (a) Order by (b) Where (c) Order ASC (d) Order Ine Which command is used to create a table? (a) Select (b) Create (c) Open (d) New Shortcut to execute query in Create Query in SQL View is (a) F7 key (b) F5 key (0) F8 key (d) F6 key Which command is used to display the salary of the employees after incrementing by 1000. (a) Select (b) Update (0) Modify (d) Change Select “age” from student; (a) will display the complete Table student (b) will display only one column of roll no. of table student @® computer.1041 42. 43. 44, 46. 47. (0) will display only age of all students from table student (d) will show “age” on screen Which command is used to modify data in a table? (a) Delete (b) Select (©) Modify (d) Update Which command is used to delete data from a table? (a) Select (b) Insert (o) Delete (d) Remove By default data is arranged in order using order by clause. (a) ascending (b) descending (0) primary key (d) none of these Which of the following is a DML command? (a) Insert (b) Update (c) Delete (d) Alll of these A esses provides systematic way of storing information into the data base. (a) Report (b) Query (©) Form (d) None of these A cinssesmhelps to display the data in a summarized way. (a) Report (b) Form (c) Query (d) Table A vessonsatneshelps to collect specific information from the pool of data (a) Query (b) Form (©) Report (d) Table computer10 @)48. Which of the following is to be created first to make a database? (a) Report (b) Form () Query (d) Table 49. Which of the following is not an advantage of database? (a) sharing of Data (b) reduces Data redundancy (0) increases Data consistency (d) Data Security 50. In the client server model, database server is referred to as (a) Back end (b) Front end (c) Inter face tools (d) None of these Answers 14 (d) 27 (a) 40 (©) 15 (c) 28 (d) 41 (d) 16 (b) 29 (b) 42 (c) 17 (a) 30 (c) 43 (a) 18 (b) 31 (a) 44 (d) 19 (d) 32 () 45 (c) 20 (a) 33 (d) 46 (a) 21 (a) 34 (c) 47 (a) 22 (d) 35 (b) 48 (d) 23 (a) 36 (a) 49 (c) 24 (d) 37 (b) 50 (a) 25 (c) 38 (b) 26 (a) 39 (a) Creative Kids Digital Home Tutor App Bie PT TSS) "Sign up for free trial of a chapter. mz dooney Computer-10