Yathirajsolutions.com
HOME      EDUCATION      NEWS      SHOPING 

2nd PUC computer science
Chapter-13: DATABASE CONCEPTS MCQs-2024

Q1.The processed data is
    a. file
    b.information
    c.data
    d.raw facts
    view Answer
    ans:b.information

Q2.Basic unit of storage in a computer is
    a.database
    b.file
    c.field
    d.domain
    view Answer
    ans:b.file

Q3.large collection of related data
    a.database
    b.file
    c.information
    d.domain
    view Answer
    ans:b.file

Q4.single entry in a table is called as
    a.rocord
    b.information
    c.field
    d.domain
    view Answer
    ans:a.record

Q5.collections of logically related data
    a.information
    b.tuple
    c.database
    d.file
    view Answer
    ans:c.database

Q6.each column is identified by a distinct header is called
    a.entry
    b.field
    c.domain
    d.record
    view Answer
    ans:b.field

Q7.set of values for an atribute in that column
    a.field
    b.domain
    c.entity
    d.none of the above

view Answer
ans:b.domain

Q8.it describe how data in the database is viewed by the user

    a.data abstraction
    b.DBMS architecture
    c.data model
    d.None of these
    view Answer
    ans:b.DBMS architecture

Q9.lowest level of data abstraction is

    a.logical level
    b.conceptual level
    c.external level
    d.physical level
    view Answer
    ans:d.physical level

Q10.which level deals with the logical structure of the entire database
    a.external level
    b.internal level
    c.conceptual level
    d.physical level
    view Answer
    ans:c.conceptual level

Q11.Highest level of abstraction that deals with the users view of the database
    a.Internal laevel
    b.Physical level
    c.logical level
    d.external level
    view Answer
    ans:d.external level

Q12.An ability of a database to modify a schema defination at one level without affecting a schema in the next higher level
    a.Data abstraction
    b.Database architecture
    c.Data independence
    d.Data model
    view Answer
    ans:c.data independence

Q13.expand ISAM
    a.Indexd sequential access module
    b.indexed sequential access method
    c.Internet sequence sequential access module
    d.internet sequence sequential access method
    view Answer
    ans:b.indexed sequential access method

Q14.An absract model that describes how the data is represented and used
    a.data encapsulation
    b.data model
    c.data abstraction
    d.none of the above

view Answer
ans:b.data model

Q15.which data model organizes the data in a tree like structure
    a.hierarchical model
    b.relational model
    c.network model
    d.none of the above
view Answer
ans:a.heirachical model

Q16.in which data model data is maintained in the form of tables
    a.heirarchical model
    b.relationl model
    c.network model
    d.none of the above
    view Answer
    ans:b.relational model

Q17.A visual representation of data that describes how data is related to each other
    a.flow diagram
    b.static diagram
    c.E R-diagram
    d.none of the above
    view Answer
    ans:c.E R-diagram

Q18.it specifies how many instance of an entity relate to one instance of another entity
    a.ordinality
    b.cardinality
    c.relation
    d.attribute

view Answer
ans:b.cardinality

Q19.is a bottom yp approach in which two lower level entities combine to from a higher level entity
    a.generalization
    b.spelization
    c.Normalization
    d.none of the above

view Answer
ans: a.genaralization

Q20.which of the following is not example for DBMS software
    a.mysql
    b.oracle
    c.ms-access
    d.google
    view Answer
    ans:d.google

Q21.the primary goal of a dbms is to provide a way to
    a.store the data
    b.retrived the data
    c.storing and retriving the data
    d.none of the above
    view Answer
    ans:c.storing and retriving the data

Q22.in a E-R diagram the main components are
    a.entity,relationship
    b.attribute,entity
    c.entity,relationship,attribute
    d.relationship,attribite
    view Answer
    ans:c.entity,relationship,attribute

Q23.the collection of the information stored in a database at a particular moment is called_______________ of a database
    a.instance
    b.attribute
    c.relationship
    d.field
    view Answer
    ans:a.instance

Q24.oracle,sql server and mysql are example of _________software
    a.dbms
    b. m s world
    c.power point
    d.none of the above
    view Answer
    ans:a.dbms

Q25.It is a top-downapproach in which one higher level entity can be broken down into two lower level entity.
    a.normalization
    b. Specialization
    c.Generalization
    d.none of the above
    view Answer
    ans:b.Specialization

Q26.is a repository of an organization’s electronically stored data.
    a.Data warehouse
    b. data file
    c.data book
    d.none of the above
    view Answer
    ans:a.Data warehouse

Q27.“Data about data” is
    a.raw facts
    b.record
    c.metadata
    d.file
    view Answer
    ans:c.metadata

Q28.analysis and picking out relevant information is called
    a.Data Mining
    b.Data Management
    c.Data searching
    d.Data storing
    view Answer
    ans:a.Data Mining

Q29.it is the stage concerned with the extraction of patterns from the data.
    a.Transformation
    b.Preprocessing
    c.Data Mining
    d.Interpretation
    view Answer
    ans:c.Data Mining

Q30.This is the data cleaning stage where certain information is removed which deemed unnecessary and may slow down queries
    a.Transformation
    b. Data Mining
    c.Interpretation
    d.Preprocessing
    view Answer
    ans:d.Preprocessing



Author: yathirajsolutions.com designed by Sathisha M

yathirajsolutions.com

Contact Us

Fill up the form below to send us a message.