Practice Test

Q1) Information means all kinds of facts, figures and details related to people, places, things or events. Show Answer

Q2) Data must be processed in a proper way to generate the useful and meaning information. Show Answer

Q3) Data is required result obtained from processing of the data. Show Answer

Q4) Information is the output generated through processing of raw data. Show Answer

Q5) Query is important because it forms the foundation for decision making. Show Answer

Q6) Database is a collection of related data items stored in an organised manner. Show Answer

Q7) A database consist of different objects like table, query, form and report. Show Answer

Q8) Table is a collection of related data. Show Answer

Q9) Information is used to retrieve information from database. Show Answer

Q10) Form is used to collect the information from user. Show Answer

Q11) Report is used to represent the data in printed form. Show Answer

Q12) ___ means all kinds of facts, figures and details related to people, places, things or events. Show Answer

Q13) ___ must be processed in a proper way to generate the useful and meaning information. Show Answer

Q14) ___ is the required result obtained from processing of the data. Show Answer

Q15) ___ is the output generated through processing of raw data. Show Answer

Q16) ___ is important because it forms the foundation for decision making. Show Answer

Q17) ___ is a collection of related data items stored in an organised manner. Show Answer

Q18) A ___ consist of different objects like table, query, form and report. Show Answer

Q19) ___ is a collection of related data. Show Answer

Q20) ___ is used to retrieve information from database. Show Answer

Q21) ___ is used to collect the information from user. Show Answer

Q22) ___ is used to represent the data in printed form. Show Answer

Q23) Data must be processed in a proper way to generate the ___ and ___ information.
(Choose two correct answers) Show Answer

Q24) Data means all kinds of ___, ___ and ___ related to people, places, things or events.
(Choose three correct answers) Show Answer

Q25) DMBS stands for Database Management System Software. Show Answer

Q26) A database Management System is a software designed to define, manipulate, retrieve and manage data in a database. Show Answer

Q27) Database Management System provides various functions that allow entry, storage and retrieval of large quantities of information and provide ways to manage that information. Show Answer

Q28) Database Management System also defines rules to validate and manipulate the data. Show Answer

Q29) DMBS stands for ___ Show Answer

Q30) A ___ is a software designed to define, manipulate, retrieve and manage data in a database. Show Answer

Q31) ___ provides various functions that allow entry, storage and retrieval of large quantities of information and provide ways to manage that information. Show Answer

Q32) ___ also defines rules to validate and manipulate the data. Show Answer

Q33) Database Management System also defines rules to ___ and ___ the data.
(Choose two correct answers) Show Answer

Q34) Database Management System provides various functions that allows ___, ___ and ___ of large quantities of information and provide ways to manage that information.
(Choose three correct answers) Show Answer

Q35) Base is an open source database management system software. Show Answer

Q36) Data Model designed to allow users to easily create, access modify and view database. Show Answer

Q37) RDBMS stands for Relational Database Management Software. Show Answer

Q38) Base is a Relational Database Management Software (RDBMS). Show Answer

Q39) A DBMS that is based on relational data model is called as Relational Database Management Software. Show Answer

Q40) A Base is the internal structure of database which describe way of storing and retrieving of data. Show Answer

Q41) Base is one of the most popular data model because it is very simple to understand and to manipulate. Show Answer

Q42) In Relational Database Management Software data is stored in the most simple and versatile structure i.e. table. Show Answer

Q43) Relational data model is collection of related data objects known as Tables, Forms, Queries and Reports. Show Answer

Q44) ___ is an open source database management system software. Show Answer

Q45) ___ designed to allow users to easily create, access, modify and view database. Show Answer

Q46) RDBMS stands for ___. Show Answer

Q47) ___ is a relational Database Management SOftware (RDBMS). Show Answer

Q48) A DBMS that is based on relational data model is called as ___. Show Answer

Q49) A ___ is the internal structure of database which describes way of storing and retrieving of data. Show Answer

Q50) ___ is one of the most popular data model because it is very simple to understand and to manipulate. Show Answer

Q51) In ___ data is stored in the most simple and versatile structure i.e. table. Show Answer

Q52) ___ is collection of related data objects known as Tables, Forms, Queries and Reports. Show Answer

Q53) A data model is the internal structure of database which describes way of ___ and ___ of data.
(Choose two correct answers) Show Answer

Q54) Relational data model is one of the most popular data model because it is very simple to ___ and to ___.
(Choose two correct answers) Show Answer

Q55) In RDBMS data is stored in the most ___ and ___ structure i.e. table.
(Choose two correct answers) Show Answer

Q56) Title Bar is the topmost bar present on the screen of Base. Show Answer

Q57) Title Bar displays icon of the application, name of the file and name of the application. Show Answer

Q58) Title Bar consist of three buttons on right corner as minimize, maximize / restore and close. Show Answer

Q59) Standard tool bar is present below Title Bar. Show Answer

Q60) Menu Bar displays names of different menus as File, Edit, View, Insert, Tools, Windows, Help etc. Show Answer

Q61) Menu Bar consist of different icons which are used for standard operations. Show Answer

Q62) Rest of the part below standard tool bar is called as Working Area. Show Answer

Q63) Working Area is divided into two panes-Left pane and Right Pane. Show Answer

Q64) Right pane displays name of database objects like tables, queries, forms and reports. Show Answer

Q65) Left pane displays activities related to that particular object. Show Answer

Q66) ___ is the topmost bar present on the screen of Base. Show Answer

Q67) ___ displays icon of the application, name of the file and name of the application. Show Answer

Q68) ___consist of three buttons on right corner as minimize, maximize / restore and close. Show Answer

Q69) ___ is present below Title Bar. Show Answer

Q70) ___ displays names of different menus as File, Edit, View, Insert, Tools, Windows, Help etc. Show Answer

Q71) ___ consist of different icons which are used for standard operations. Show Answer

Q72) Rest of the part below standard tool bar is called as ___. Show Answer

Q73) ___ is divided into two panes- Left pane and Right Pane. Show Answer

Q74) ___ displays name of database objects like tables, queries, forms and reports. Show Answer

Q75) ___ displays activities related to that particular object. Show Answer

Q76) Working Area is divided into two panes ___ and ___.
(Choose two correct answers) Show Answer

Q77) Title Bar displays ___, ___ and ___.
(Choose three correct answers) Show Answer

Q78) Title Bar consist of three buttons on right corner as ___, ___ & ___. Show Answer

Q79) Entity is a basic unit for storing data in database. Show Answer

Q80) Tables are organised in the form of columns and rows. Show Answer

Q81) Before creating a table user should first decide the Table. Show Answer

Q82) Entity is any real world object about which data is to be stored. Show Answer

Q83) Each entity has collection of attributes associated with it. Show Answer

Q84) Record or Tuple of an entity are stored in the form of columns. Show Answer

Q85) The information stored under each column forms a row which is called as Attributes. Show Answer

Q86) ___ is a basic unit for storing data in database. Show Answer

Q87) ___ are organised in the form of columns and rows. Show Answer

Q88) Before creating a table use should first decide the ___. Show Answer

Q89) ___ is any real world object about which data is to be stored. Show Answer

Q90) Each ___ has collection of attributes associated with it. Show Answer

Q91) ___ of an entity are stored in the form of columns. Show Answer

Q92) The information stored under each column forms a row which is called as ___. Show Answer

Q93) Tables are organised in the form of ___ and ___.
(Choose two correct answers) Show Answer

Q94) Tiny Integer available in Base can be divided into three categories as alphanumeric, numeric, calender (Date and time) and binary type. Show Answer

Q95) Char types data type name stores small Integer. Show Answer

Q96) BigInt data type name stores Big Integer. Show Answer

Q97) Number data type name stores Image. Show Answer

Q98) Memo data type name stores descriptive type of information. Show Answer

Q99) Image data type name stores a number with or without decimal point. Show Answer

Q100) Decimal Data type name stores original length and allow to set decimal. Show Answer

Q101) Float data type name stores a number with decimal point. Show Answer

Q102) Real data type name stores boolean type of data. Show Answer

Q103) Date Data type name stores date in mm/dd/yy format. Show Answer

Q104) Other data type name stores time in hh:mm:ss format. Show Answer

Q105) Date / time data type name stores date as well as time. Show Answer

Q106) Time data type name stores any other object. Show Answer

Q107) ___ available in base can be divided into three categories as a alphanumeric, numeric, calender (Date and time) and binary type. Show Answer

Q108) ___ data type name stores small Integer. Show Answer

Q109) __ data type name stores Big Integer. Show Answer

Q110) ___ data type name stores Image. Show Answer

Q111) ___ data type name stores descriptive type of information. Show Answer

Q112) ___ data type name stores a number with or without decimal point. Show Answer

Q113) ___ data type name stores original length and allow to set decimal. Show Answer

Q114) ___ data type name stores a number with decimal point. Show Answer

Q115) ___ data type name stores a number with or without decimal point. It is used when approximate result required. Show Answer

Q116) ___ data type name stores boolean type of data. Show Answer

Q117) ___ data type name stores date in mm/dd/yy format. Show Answer

Q118) ___ data type name stores time in hh:mm:ss format. Show Answer

Q119) ___ data type name stores date as well as time. Show Answer

Q120) ___ data type name stores any other object. Show Answer

Q121) A Query is a question asked within the database environment. Show Answer

Q122) Query displays subset of data contained in various tables of database. Show Answer

Q123) Query is used to retrieve records from the table. Show Answer

Q124) A ___ is a question asked withing the database environment. Show Answer

Q125) ___ displays subset of data contained in various tables of database. Show Answer

Q126) ___ is used to retrieve records from the table. Show Answer

Q127) Form is an object which allows entering the data and editing or deleting existing data in the table. Show Answer

Q128) Table is used to collect the data from the user. Show Answer

Q129) ___ is an object which allows entering the data and editing or deleting existing data in the table. Show Answer

Q130) ___ is used to collect the data from the user. Show Answer

Q131) Form is an object which allows ___ the data and ___ or ___ existing data in the table.
(Choose three correct answers) Show Answer

Q132) The presentation of information in an organised and readable format as per the user's requirement is known as Report. Show Answer

Q133) Various complex forms can be generated that can help in taking decisions by the management. Show Answer

Q134) Report is the representation of data in printed form. Show Answer

Q135) The presentation of information in an organised and readable format as per the user's requirement is known as ___. Show Answer

Q136) Various complex ___ can be generated that can help in taking decisions by the management. Show Answer

Q137) ___ is the representation of data in printed form. Show Answer

Q138) Relational Database Management System defines how the logical structure of a database is modelled. Show Answer

Q139) Data model defines how data is connected to each other and how they are processed and stored inside the system. Show Answer

Q140) Different types of DBMS are available and their classification is done based on the underlying Data Model. Show Answer

Q141) The DBMS following relational data model is called as Data model. Show Answer

Q142) Attributes refers to a database that stores data in a structured format, using rows and columns. Show Answer

Q143) In Relational model, tables are called relations that store data for different columns. Show Answer

Q144) The columns of a relation are the Relational Database which are also referred as fields. Show Answer

Q145) Each row of data in a relation (table) is called a Domain. Show Answer

Q146) In a table with a columna, a Tuple is a relationship between the n related values. Show Answer

Q147) Tuple is a set of values from which an attribute can take a value in each row. Show Answer

Q148) A data type is used to specify Domain for an attribute. Show Answer

Q149) Every attribute has some pre-defined value scope, known as Attribute Domain. Show Answer

Q150) The number of attributes in a relation is called the Degree of the relation. Show Answer

Q151) The number of Tuples in a relation is called the Cardinality of the relation. Show Answer

Q152) ___ defines how the logical structure of a database is modelled. Show Answer

Q153) ___ defines how data is connected to each other and how they are processed and stored inside the system. Show Answer

Q154) Different types of DBMS are available and their classification is done based on the underlying ___. Show Answer

Q155) The DBMS following relational data model is called as ___. Show Answer

Q156) A ___ refers to a database that stores data in a structured format, using rows and columns. Show Answer

Q157) In ___, tables are called relations that store data for different columns. Show Answer

Q158) The columns of a relation are the ___ which are also referred as fields. Show Answer

Q159) Each row of data in a relation (table) is called a ___. Show Answer

Q160) In a table with a columns, a ___ is a relationship between the n related values. Show Answer

Q161) ___ is a set of values from which an attribute can take a value in each row. Show Answer

Q162) A data type is used to specify ___ for an attribute. Show Answer

Q163) Every attributes has some pre-defined value scope, known as ___. Show Answer

Q164) The number of attributes in a relation is called the ___ of the relation. Show Answer

Q165) The number of the tuples in a relation is called the ___ of the relation. Show Answer

Q166) A relational database refers to a database that stores data in a structured format, using ___ and ___.
(Choose two correct answers) Show Answer

Q167) A relation can have one or more attributes that takes unique values. Any of these attributes can be used to uniquely identify the tuples in the relation. Such attributes are called Candidate keys. Show Answer

Q168) Out of one or more candidate keys, the attribute used to uniquely identify the tuples in a relation is called the Foreign key of that relation. Show Answer

Q169) Primary key consisting of more than one attribute is called Primary key. Show Answer

Q170) A Foreign key is used to represent the relationship between two relations. Show Answer

Q171) A Composite Primary key is an attribute whose value is derived from the primary key of another relation. Show Answer

Q172) A relation can have one or more attributes that takes unique values. Any of these attributes can be used to uniquely identify the tuples in the relation. Such attributes are called ___. Show Answer

Q173) Out of one or more candidate keys, the attribute used to uniquely identify the tuples in a relation is called the ___ of that relation. Show Answer

Q174) Primary key consisting of more than one attribute is called ___. Show Answer

Q175) A ___ is used to represent the relationship between two relations. Show Answer

Q176) A ___ is an attribute whose value is derived from the primary key of another relation. Show Answer

Q177) A many-to-many relationship can be used for security purpose, to divide a large table, and various other specific purposes. Show Answer

Q178) A One-to-Many relationships can also be viewed as Many-to-One relationships, depending on which way we look at it. Show Answer

Q179) A One-to-One relationship could be thought of as two one-to-many relationships, linked by an intermediary table. Show Answer

Q180) The intermediary table is typically referred to as a "Junction table". Show Answer

Q181) The Relations (tables) with one field common which must be a primary key of first table and the same key is referenced in another relation and called as foreign key in that table. Show Answer

Q182) A ___ can be used for security purposes, to divide a large table, and various other specific purposes. Show Answer

Q183) A ___ can also be viewed as Many-to-One relationships, depending on which way we look at it. Show Answer

Q184) A ___ could be thought of as two one-to-many relationship, linked by an intermediary table. Show Answer

Q185) The intermediary table is typically referred to as a "---". Show Answer

Q186) The ___ (tables) with one field common which must be a primary key of first table and the same key is referenced in another relation and called as foreign key in that table. Show Answer

Q187) Create relations (tables) with one field common which must be a ___ of first table and the same key is referenced in another relation and called as ___ in that table.
(Choose two correct answers) Show Answer

Q188) A One-to-One relationship can be used for ___, __ and ___.
(Choose three correct answers) Show Answer

Q189) Form is used to collect the data from the user. Show Answer

Q190) Menu bar is present below Title bar. Show Answer

Q191) Columns are called as records. Show Answer

Q192) Rows in Base are called as ___. Show Answer

Q193) File extension of Base is ___. Show Answer