question_answer1) Devices that could be used to input data into a database are
A) keyboard, fax roller ball done clear
B) mouse, keyboard, monitor done clear
C) mouse, keyboard, touch screen done clear
D) All of the above done clear
E) None of the above done clear
View Solution play_arrowA) fields, records done clear
B) records, fields done clear
C) address, fields done clear
D) ranges, sheet done clear
E) records, ranges done clear
View Solution play_arrowquestion_answer3) A database that contains tables linked by common fields is called a
A) centralised database done clear
B) flat file database done clear
C) relational database done clear
D) All of these done clear
E) None of these done clear
View Solution play_arrowA) Character, File, Record, Field, Database done clear
B) Character, Record, Field, File, Database done clear
C) Character, Field, Record, File, Database done clear
D) Bit, Byte, Character, Record, Field, File, Database done clear
E) None of the above done clear
View Solution play_arrowquestion_answer5) The primary key must be
A) numeric done clear
B) unique done clear
C) multiple done clear
D) related done clear
E) object done clear
View Solution play_arrowquestion_answer6) Periodically adding, changing and deleting file records is called ......... file.
A) updating done clear
B) upgrading done clear
C) restructuring done clear
D) renewing done clear
E) None of these done clear
View Solution play_arrowquestion_answer7) Items such as names and addresses are considered as
A) input done clear
B) data done clear
C) output done clear
D) records done clear
E) information done clear
View Solution play_arrowquestion_answer8) Which of the following objects is/are contained in database?
A) Table done clear
B) Query done clear
C) Form done clear
D) All of these done clear
E) None of these done clear
View Solution play_arrowA) spreadsheet done clear
B) presentation done clear
C) database done clear
D) Web page done clear
E) None of the above done clear
View Solution play_arrowA) unique key done clear
B) prime attribute done clear
C) index key done clear
D) primary key done clear
E) null key done clear
View Solution play_arrowquestion_answer11) Rows of a relation are called
A) relation done clear
B) tuples done clear
C) data structure done clear
D) an entity done clear
E) None of these done clear
View Solution play_arrowA) Primary key done clear
B) Unique done clear
C) Null done clear
D) Foreign key done clear
E) None of these done clear
View Solution play_arrowquestion_answer13) The dBASE III Plus is mostly used for
A) office automation done clear
B) database management problems done clear
C) scientific problems done clear
D) calculations only done clear
E) None of the above done clear
View Solution play_arrowquestion_answer14) Which out of the following is not a DBMS software?
A) dBASE done clear
B) FoxPro done clear
C) Oracle done clear
D) SyBase done clear
E) Database 2000 done clear
View Solution play_arrowquestion_answer15) The primary key must be a (n)......... field.
A) numeric done clear
B) object done clear
C) unique done clear
D) related done clear
E) None of these done clear
View Solution play_arrowquestion_answer16) Architecture of database can be viewed as
A) two levels done clear
B) four levels done clear
C) three levels done clear
D) one level done clear
E) None of these done clear
View Solution play_arrowquestion_answer17) In an ER diagram, attributes are represented by
A) rectangle done clear
B) square done clear
C) ellipse done clear
D) triangle done clear
E) circle done clear
View Solution play_arrowquestion_answer18) In case of entity integrity, the primary key may be
A) not null done clear
B) null done clear
C) Both a and b done clear
D) any value done clear
E) None of these done clear
View Solution play_arrowquestion_answer19) In an ER diagram, an entity set is represented by a
A) rectangle done clear
B) ellipse done clear
C) diamond box done clear
D) circle done clear
E) None of these done clear
View Solution play_arrowquestion_answer20) An advantage of the database management approach is
A) data is dependent on programs done clear
B) data redundancy increases done clear
C) data is integrated and can be accessed by multiple programs done clear
D) All of the above done clear
E) None of the above done clear
View Solution play_arrowquestion_answer21) DBMS helps to achieve
A) data independence done clear
B) centralised control of data done clear
C) selection of data done clear
D) Both a and b done clear
E) None of the above done clear
View Solution play_arrowquestion_answer22) A set of possible data values is called
A) attribute done clear
B) degree done clear
C) tuple done clear
D) domain done clear
E) None of these done clear
View Solution play_arrowquestion_answer23) Which type of database, organised the data in the form of tree with nodes?
A) Network Database done clear
B) Hierarchical Database done clear
C) Relational Database done clear
D) Multiple Database done clear
E) None of these done clear
View Solution play_arrowA) QBE done clear
B) SQL done clear
C) OLAP done clear
D) Sequel Server done clear
E) None of these done clear
View Solution play_arrowA) Backup done clear
B) Recovery done clear
C) Redundancy done clear
D) Security done clear
E) None of these done clear
View Solution play_arrowquestion_answer26) The cardinality property of a relation, refers to the
A) number of database done clear
B) number of columns done clear
C) number of rows done clear
D) number of tables done clear
E) None of these done clear
View Solution play_arrowquestion_answer27) The smallest unit of information about a record in a database is called a
A) cell done clear
B) field done clear
C) record done clear
D) query done clear
E) None of these done clear
View Solution play_arrowquestion_answer28) ......... means that the data contained in a database is accurate and reliable.
A) Data redundancy done clear
B) Data integrity done clear
C) Data reliability done clear
D) Data consistency done clear
E) None of these done clear
View Solution play_arrowA) Query done clear
B) Form done clear
C) Record done clear
D) Table done clear
E) None of these done clear
View Solution play_arrowquestion_answer30) A program that generally has more user-friendly interface than a DBMS is called a
A) front end done clear
B) repository done clear
C) back end done clear
D) form done clear
E) None of these done clear
View Solution play_arrowquestion_answer31) The database stores information in [SBI PO 2010]
A) rows and columns done clear
B) blocks done clear
C) tracks and sectors done clear
D) All of these done clear
E) None of these done clear
View Solution play_arrowquestion_answer32) The database administrator's function in an organization is [SBI PO 2010]
A) to be responsible for the technical aspects of managing the information contained in organizational databases done clear
B) to be responsible for the executive level aspects of decision regarding the information management done clear
C) to show the relationship among entity classes in a data warehouse done clear
D) to define which data mining tools must be used to extract data done clear
E) None of the above done clear
View Solution play_arrowquestion_answer33) Key to represent relationship between tables is called [SBI Clerk 2010]
A) primary key done clear
B) secondary key done clear
C) foreign key done clear
D) composite key done clear
E) None of these done clear
View Solution play_arrowquestion_answer34) A collection of related files is called a [SBI PO 2011]
A) character done clear
B) field done clear
C) database done clear
D) record done clear
E) None of these done clear
View Solution play_arrowquestion_answer35) A logical schema [SBI PO 2011]
A) is the entire database done clear
B) is a standard way of organising information into accessable part done clear
C) describes how data is actually stored on disk done clear
D) All of the above done clear
E) None of the above done clear
View Solution play_arrowquestion_answer36) In the relational modes, cardinality is termed as [IBPS Clerk 2011]
A) number of tuples done clear
B) number of attributes done clear
C) number of tables done clear
D) number of constraints done clear
E) None of the above done clear
View Solution play_arrowquestion_answer37) An E-R diagram is a graphic method of presenting [IBPS Clerk 2011]
A) primary keys and their relationships done clear
B) primary keys and their relationships to instances done clear
C) entity classes and their relationships done clear
D) entity classes and their relationships to primary keys done clear
E) None of the above done clear
View Solution play_arrowA) Website done clear
B) network done clear
C) backup file done clear
D) database done clear
E) None of these done clear
View Solution play_arrowA) strong entity set done clear
B) weak entity set done clear
C) simple entity set done clear
D) primary entity set done clear
E) None of the above done clear
View Solution play_arrowA) block done clear
B) record done clear
C) tuple done clear
D) table done clear
E) None of these done clear
View Solution play_arrowquestion_answer41) In ER diagram, relationship type is represented by [IBPS Clerk 2012]
A) ellipse done clear
B) dashed ellipse done clear
C) rectangle done clear
D) diamond done clear
E) None of these done clear
View Solution play_arrowquestion_answer42) To locate a data item for storage is [IBPS PO 2012]
A) field done clear
B) feed done clear
C) database done clear
D) fetch done clear
E) None of these done clear
View Solution play_arrowA) Fields done clear
B) Data done clear
C) Queries done clear
D) Properties done clear
E) None of these done clear
View Solution play_arrowA) key field done clear
B) primary field done clear
C) master field done clear
D) order field done clear
E) None of these done clear
View Solution play_arrowA) DBMS done clear
B) Tables done clear
C) Database done clear
D) Protection password done clear
E) Centralisation of data done clear
View Solution play_arrowquestion_answer46) ......... is one reason for problems of data integrity. [IBPS Clerk 2012]
A) Data availability constraints done clear
B) Data inconsistency done clear
C) Security constraints done clear
D) Unauthorised access of data done clear
E) Data redundancy done clear
View Solution play_arrowA) 10 done clear
B) 8 done clear
C) 12 done clear
D) 6 done clear
E) 5 done clear
View Solution play_arrowA) ER model done clear
B) database done clear
C) data model done clear
D) DBMS done clear
E) None of these done clear
View Solution play_arrowA) Word processing done clear
B) Spreadsheet design done clear
C) Web design done clear
D) Database management done clear
E) Presentation generation done clear
View Solution play_arrowA) Data redundancy done clear
B) Information overload done clear
C) Duplicate data done clear
D) Data consistency done clear
E) Data inconsistency done clear
View Solution play_arrowquestion_answer51) A collection of interrelated records is called a [RBI Grade B 2012]
A) utility file done clear
B) management information system done clear
C) database done clear
D) spreadsheet done clear
E) datasheet done clear
View Solution play_arrowA) Physical key done clear
B) Primary key done clear
C) Foreign key done clear
D) Logical key done clear
E) None of these done clear
View Solution play_arrowquestion_answer53) ......... is an invalid type of database key. [IBPS Clerk 2013]
A) Structured primary key done clear
B) Atomic primary key done clear
C) Primary key done clear
D) Composite primary key done clear
E) None of the above done clear
View Solution play_arrowA) Start, exe done clear
B) Auto.exec done clear
C) Mocro.exe done clear
D) Any of these done clear
E) None of these done clear
View Solution play_arrowquestion_answer55) A field is a related group of.......... [IBPS Clerk 2013]
A) cables done clear
B) records done clear
C) files done clear
D) characters done clear
E) None of these done clear
View Solution play_arrowquestion_answer56) Oracle is a (n) [IBPS Clerk 2014]
A) hardware done clear
B) high level language done clear
C) operating system done clear
D) system software done clear
E) RDBMS done clear
View Solution play_arrowA) POS done clear
B) RFID done clear
C) PPS done clear
D) GPS done clear
E) Other than those given as options done clear
View Solution play_arrowquestion_answer58) What is a stored question about information in a database? [SBI Clerk 2015]
A) Query done clear
B) Sort done clear
C) Report done clear
D) Record done clear
E) Field done clear
View Solution play_arrowA) isolated called done clear
B) data inconsistency done clear
C) other than those given as: options done clear
D) program dependency done clear
E) separated data done clear
View Solution play_arrowquestion_answer60) The purpose of the primary key in a database is to [IBPS Clerk 2015]
A) unlock the database done clear
B) provide a map of the data done clear
C) uniquely identity a record done clear
D) establish constraints on database operations done clear
E) None of the above done clear
View Solution play_arrowA) Data dictionary done clear
B) Data table done clear
C) Data record done clear
D) Data field done clear
E) None of these done clear
View Solution play_arrowquestion_answer62) A range checks [IBPS Clerk 2015]
A) that only the correct data type is entered into a field done clear
B) that all required data are present done clear
C) whether a number is within a specified limit done clear
D) if the data in two or more associated fields is logical done clear
E) None of the above done clear
View Solution play_arrowA) Define the attribute as required done clear
B) Define subtypes done clear
C) Define each attribute as having an initial value that is recognised as blank done clear
D) Define super types done clear
E) None of the above done clear
View Solution play_arrowquestion_answer64) Which of the following statements is true? [IBPS Clerk 2015]
A) Logical design is software dependent. done clear
B) In a distributed database, database is stored in one physical location done clear
C) Conceptual design translates the logical design into internal model. done clear
D) Logical design is software independent. done clear
E) None of the above done clear
View Solution play_arrowYou need to login to perform this action.
You will be redirected in
3 sec