Database Management System – Set 1 January 28, 2025 by aasi Home › Computer Operator › DBMS DBMS Database Management System – Set 1 📝 Model Practice Set ⚡ Instant Answers & Explanation 🎯 Exam Oriented 0% Report a question What’s wrong with this question? You cannot submit an empty report. Please add some details. 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950 Database Management System – Set 1 Dear ! This is Database Management System – Set 1 Quiz and it contains 50 questions. Keep Learning! 1 / 50 1) Which field type can store photos ? Hyperlink OLE Both of these can be used None 2 / 50 2) It is a database object to view, change and analyze data in different ways Query Form Report None 3 / 50 3) An access database object that is used to enter, view or edit records Table Form Query Report 4 / 50 4) Which one of the following is a procedural language ? Domain relational calculus Tuple relational calculus Relational algebra Query language 5 / 50 5) To achieve and Effect when you entering criteria in a query design window Write criteria values vertically one in a row Write criteria values horizontally Write criteria values in same field separated with AND Write criteria values in same field separated with & 6 / 50 6) Which of the following creates drop down list of values to choose form a list ? OLE object Hyperlink Memo Lookup Wizard 7 / 50 7) A search value can be an exact value or it can be Logical operator Relationship Wild card Character Comparison Operation 8 / 50 8) We can remove a relationship defined between two tables by From edit menu choose delete relationship Select the relationship line and press delete Choose Delete option from relationship Menu All of these 9 / 50 9) The task of arranging data in order is called Searching Sorting Ordering shorting 10 / 50 10) If you write criteria values vertically(one in a row) it will mean OR conditions AND conditions NOT conditions None 11 / 50 11) Database Management Systems are features with: The facilities to easy editing, spelling check, auto pagination , layout, print store large amount of data to facilities easy update , sort and retrieval The ability to calculate efficiently built-in functions and analyze All of these 12 / 50 12) Which of the following expresses correct order ? Character, fields, records, tables, files, Database Character, Field Records , Tables, database, Files Database, Tables, Files, records, Field character Files, Database, Tables, records, Fields, Character 13 / 50 13) When a picture or other graphic image is placed in the report header section it will appear___ Once in the beginning of the report At the top of every page Every after record break On the 1st and last page of the report 14 / 50 14) A ——– is a property of the entire relation, rather than of the individual tuples in which each tuple is unique Rows Key Attribute Field 15 / 50 15) Collection of related records in a File Bench Table Relationship 16 / 50 16) What is the column in a Microsoft access table called ? Rows Records Fields Columns 17 / 50 17) Which of the following may not be a database ? Data presented in table MS Word document Data entered in Excel Spreadsheet A presentation created in power point A telephone diary 18 / 50 18) It is used to calculate and restructure data for easies analysis of your data . it calculates the sum, Parameter Select Crosstab Append 19 / 50 19) This data type allows alphanumeric characters and special symbols. text memo auto number None of these 20 / 50 20) Which one of the following is set of one or more attributes taken collectively to uniquely identify a record ? Candidate key Sub key Super key Foreign key 21 / 50 21) Which of the following can be an example of a database ? Address book of all the supplies of a company Salary sheet of all the employees of a company Records of daily sales transaction of a company All of these 22 / 50 22) It is the most common type of query , It retrieves records from one or more tables and then display the Parameter Select Crosstab All of these 23 / 50 23) A part of database that stores only one type of data is Report Field Query Record 24 / 50 24) Every table in relational database contain a field or combination of fields that can uniquely identify each records it is called Foreign key Native Key Composite key primary key 25 / 50 25) Which of the following is not a field type in Access Memo Hyperlink OLE Object Lookup Wizard 26 / 50 26) Using which language can a user request information from a database ? Query Relational Structural Compiler 27 / 50 27) If you need to edit a relationship Right click the relationship line and choose edit Relationship Double click the relationship line Both of these None of these 28 / 50 28) Which denote one to many relationship between student and class table ? One student can have many classes One class may have many students Many classes may have many students Many students have many classes 29 / 50 29) A composite key is Required when a table does not have any unique field in it The primary key with auto number as the field type Made up of two or more fields to uniquely identifies records Is a foreign key that uniquely identifies records 30 / 50 30) Which of the following term is leas related to database ? Attributes Tuples Relationship Column 31 / 50 31) Each record is constituted by a number of individual data item which are called Field Data types Relations Tables 32 / 50 32) When entering field name, how many character you can type in maximum ? 60 64 68 Any Number 33 / 50 33) Unlike text data type , this can store up to maximum of 65,535 characters. Memo Date/Time Number All 34 / 50 34) Both conditions display on the same row in the design grid when ___ operator in use OR IN AND LIKE 35 / 50 35) The ___operator will cause a record to be selected only if two or more conditions are satisfied OR If or between AND 36 / 50 36) Which one of the following attribute can be taken as a primary key ? Name Street Id Department 37 / 50 37) A small button with three dots usually displayed at the right of field properties box Make button Expression button Build button None of these 38 / 50 38) This option allows you to build a new table by entering data directly into the datasheet datasheet view design view link table None of these 39 / 50 39) The size of a field with Number data type cannot be 2 4 8 16 40 / 50 40) An Attribute in a relation is a foreign key if the ————-key from one relation is used as an attribute in that relation Candidate Primary Super Sub 41 / 50 41) A database can be best described as Organized collection of data useful presentation of data Graphical representation of data All of these 42 / 50 42) It is an association established between common fields of two tables . line relationship primary key records 43 / 50 43) you can automatically include all of the field in a table in a query by ____ a strike that appear list box in query design view clicking Right Clicking Double clicking None of these 44 / 50 44) What do you mean by one to many relationships between student and class table ? One student can have many classes One class may have many students Many classes may have many students Many students have many classes 45 / 50 45) It is a sign or symbol that specifies, operator, and values that produce a result Operator query Expression None of these 46 / 50 46) It is a query that when run display its own dialog box prompting you for information such as Select Crosstab Parameter Append 47 / 50 47) The database language concerned with the definition of the whole database structure and schema is ________ DCL DML DDL All of these 48 / 50 48) Query design window has two parts. The upper part shows Name of field , field type and size Table with field and relationships between tables Criteria Sorting check boxes 49 / 50 49) The size of yes No field is always 1 bit 1 byte 1 character 1 GB 50 / 50 50) A database object in MS access that stores a question about the data in database ? Table Information Field Record Your score isThe average score is 0%🎉 Challenge alert! 💡 Share this quiz with your friends and see who scores the highest! 🏆🤩🔥 LinkedIn Facebook Follow Us @ 0% Restart quiz Exit We’d love to hear your thoughts! 📝 Share your valuable review with us. 🙌 🌟 Thank you for your support! Your feedback means the world to us. 🙏💖 Send feedback
