1410+ DataBase Management System (DBMS) Solved MCQs

Chapters

85
15.2k
Take a Test Download as PDF
More MCQs
501.

Data integrity constraints are used to:

A. control who is allowed access to the data
B. ensure that duplicate records are not entered into the table
C. improve the quality of data entered for a specific property
D. prevent users from changing the values stored in the table
Answer» C. improve the quality of data entered for a specific property
discuss
502.

Establishing limits on allowable property values, and specifying a set of acceptable, predefined options that can be assigned to a property are examples of:

A. attributes
B. data integrity constraints
C. method constraints
D. referential integrity constraints
Answer» B. data integrity constraints
discuss
503.

Which of the following can be addressed by enforcing a referential integrity constraint?

A. all phone numbers must include the area code
B. certain fields are required (such as the email address, or phone number) before the record is accepted
C. information on the customer must be known before anything can be sold to that customer
D. then entering an order quantity, the user must input a number and not some text (i.e., 12 rather than ‘a dozen’)
Answer» C. information on the customer must be known before anything can be sold to that customer
discuss
504.

             is a special type of integrity constraint that relates two relations & maintains consistency across the relations.

A. entity integrity constraints
B. referential integrity constraints
C. domain integrity constraints
D. domain constraints
Answer» B. referential integrity constraints
discuss
505.

Which one of the following uniquely identifies the elements in the relation?

A. secondary key
B. primary key
C. foreign key
D. composite key
Answer» B. primary key
discuss
506.

Drop Table cannot be used to drop a table referenced by a                    constraint.

A. local key
B. primary key
C. composite key
D. foreign key
Answer» D. foreign key
discuss
507.

                         is preferred method for enforcing data integrity

A. constraints
B. stored procedure
C. triggers
D. cursors
Answer» A. constraints
discuss
508.

The entity relationship set is represented in E-R diagram as

A. double diamonds
B. undivided rectangles
C. dashed lines
D. diamond
Answer» D. diamond
discuss
509.

The Rectangles divided into two parts represents

A. entity set
B. relationship set
C. attributes of a relationship set
D. primary key
Answer» A. entity set
discuss
510.

We indicate roles in E-R diagrams by labeling the lines that connect                         to                      

A. diamond , diamond
B. rectangle, diamond
C. rectangle, rectangle
D. diamond, rectangle
Answer» D. diamond, rectangle
discuss
511.

An entity set that does not have sufficient attributes to form a primary key is termed a

A. strong entity set
B. variant set
C. weak entity set
D. variable set
Answer» C. weak entity set
discuss
512.

For a weak entity set to be meaningful, it must be associated with another entity set, called the

A. identifying set
B. owner set
C. neighbour set
D. strong entity set
Answer» A. identifying set
discuss
513.

Weak entity set is represented as

A. underline
B. double line
C. double diamond
D. double rectangle
Answer» C. double diamond
discuss (1)
514.

If you were collecting and storing information about your music collection, an album would be considered a(n)            

A. relation
B. entity
C. instance
D. attribute
Answer» B. entity
discuss
515.

What term is used to refer to a specific record in your music database; for instance; information stored about a specific album?

A. relation
B. instance
C. table
D. column
Answer» B. instance
discuss
516.

Which one of the following can be treated as a primary key in teaches relation?

A. id
B. semester
C. sec_id
D. year
Answer» A. id
discuss
517.

The primary key in the section relation is

A. course_id
B. sec_id
C. both course_id and sec_id
D. all the attributes
Answer» C. both course_id and sec_id
discuss
518.

The relation with primary key can be created using

A. create table instructor (id, name)
B. create table instructor (id, name, primary key(name))
C. create table instructor (id, name, primary key (id))
D. create table instructor ( id unique, name )
Answer» C. create table instructor (id, name, primary key (id))
discuss
519.

How can the values in the relation teaches be deleted?

A. drop table teaches;
B. delete from teaches;
C. purge table teaches;
D. delete from teaches where id =’null’;
Answer» B. delete from teaches;
discuss
520.

In the above teaches relation ” Select * from teaches where Year = ‘2010’” displays how many rows?

A. 2
B. 4
C. 5
D. 1
Answer» A. 2
discuss
521.

The relation changes can be got back using                  command

A. flashback
B. purge
C. delete
D. getback
Answer» A. flashback
discuss
522.

Let us consider phone_number ,which can take single or several values . Treating phone_numberas an                    permits instructors to have several phone numbers (including zero) associated with them.

A. entity
B. attribute
C. relation
D. value
Answer» A. entity
discuss
523.

The total participation by entities is represented in E-R diagram as

A. dashed line
B. double line
C. double rectangle
D. circle
Answer» B. double line
discuss
524.

Given the basic ER and relational models, which of the following is INCORRECT?

A. an attribute of an entity can have more than one value
B. an attribute of an entity can be composite
C. in a row of a relational table, an attribute can have more than one value
D. in a row of a relational table, an attribute can have exactly one value or a null value
Answer» C. in a row of a relational table, an attribute can have more than one value
discuss
525.

Which of the following indicates the maximum number of entities that can be involved in a relationship?

A. minimum cardinality
B. maximum cardinality
C. erd
D. greater entity count
Answer» B. maximum cardinality
discuss
526.

In E-R diagram generalization is represented by

A. ellipse
B. dashed ellipse
C. rectangle
D. triangle
Answer» D. triangle
discuss
527.

What is a relationship called when it is maintained between two entities?

A. unary
B. binary
C. ternary
D. quaternary
Answer» B. binary
discuss
528.

Which of the following is a low level operator?

A. insert
B. update
C. delete
D. directory
Answer» D. directory
discuss
529.

Key to represent relationship between tables is called

A. primary key
B. secondary key
C. foreign key
D. none of the mentioned
Answer» C. foreign key
discuss
530.

A window into a portion of a database is

A. schema
B. view
C. query
D. data dictionary
Answer» B. view
discuss
531.

A primary key is combined with a foreign key creates

A. parent-child relation ship between the tables that connect them
B. many to many relationship between the tables that connect them
C. network model between the tables that connect them
D. none of the mentioned
Answer» A. parent-child relation ship between the tables that connect them
discuss
532.

The entity set person is classified as student and employee. This process is called

A. generalization
B. specialization
C. inheritance
D. constraint generalization
Answer» B. specialization
discuss
533.

Which relationship is used to represent a specialization entity?

A. isa
B. ais
C. onis
D. whois
Answer» A. isa
discuss
534.

The refinement from an initial entity set into successive levels of entity subgroupings represents a                  design process in which distinctions are made explicit.

A. hierarchy
B. bottom-up
C. top-down
D. radical
Answer» C. top-down
discuss
535.

There are similarities between the instructor entity set and the secretary entity set in the sense that they have several attributes that are conceptually the same across the two entity sets: namely, the identifier, name, and salary attributes. This process is called

A. commonality
B. specialization
C. generalization
D. similarity
Answer» C. generalization
discuss
536.

If an entity set is a lower-level entity set in more than one ISA relationship, then the entity set has

A. hierarchy
B. multilevel inheritance
C. single inheritance
D. multiple inheritance
Answer» D. multiple inheritance
discuss
537.

A                            constraint requires that an entity belong to no more than one lower- level entity set.

A. disjointness
B. uniqueness
C. special
D. relational
Answer» A. disjointness
discuss
538.

Consider the employee work-team example, and assume that certain employees participate in more than one work team. A given employee may therefore appear in more than one of the team entity sets that are lower level entity sets of employee. Thus, the generalization is                            

A. overlapping
B. disjointness
C. uniqueness
D. relational
Answer» A. overlapping
discuss
539.

The completeness constraint may be one of the following: Total generalization or specialization, Partial generalization or specialization. Which is the default?

A. total
B. partial
C. should be specified
D. cannot be determined
Answer» B. partial
discuss
540.

Functional dependencies are a generalization of

A. key dependencies
B. relation dependencies
C. database dependencies
D. none of the mentioned
Answer» A. key dependencies
discuss
541.

Which of the following is another name for a weak entity?

A. child
B. owner
C. dominant
D. all of the mentioned
Answer» A. child
discuss
542.

Which is the main relation which is used in the university database which is referenced by all other relation of the university?

A. teaches
B. course
C. department
D. section
Answer» C. department
discuss
543.

The department relation has the an entry budget whose type has to be replaced by

A. varchar (20)
B. varchar2 (20)
C. numeric (12,2)
D. numeric
Answer» C. numeric (12,2)
discuss
544.

In the above DDL command the foreign key entries are got by using the keyword

A. references
B. key reference
C. relating
D. none of the mentioned
Answer» A. references
discuss
545.

Identify the error in the section relation

A. no error
B. year numeric (4,0)
C. building varchar (15)
D. sec_id varchar (8)
Answer» A. no error
discuss
546.

Which of the following can be used as a primary key entry of the instructor relation.

A. dept_name
B. name
C. id
D. all of the mentioned
Answer» C. id
discuss
547.

In the section relation which of the following is used as a foreign key?

A. course_id
B. course_id,sec_id
C. room_number
D. course_id,sec_id,room_number
Answer» A. course_id
discuss
548.

To replace the relation section with some other relation the initial step to be carried out is

A. delete section;
B. drop section;
C. delete from section;
D. replace section new_table ;
Answer» B. drop section;
discuss
549.

Select distinct Dept_name from instructor ; How many row(s) are displayed ?

A. 4
B. 3
C. 5
D. error
Answer» A. 4
discuss
550.

Which function is used to find the count of distinct departments?

A. dist
B. distinct
C. count
D. count,dist
Answer» A. dist
discuss
551.

Which function is used to identify the title with Least scope?

A. min(credits)
B. max(credits)
C. min(title)
D. min(salary)
Answer» A. min(credits)
discuss
552.

A domain is              if elements of the domain are considered to be indivisible units.

A. atomic
B. subatomic
C. substructure
D. subset
Answer» A. atomic
discuss
553.

Identify the composite attributes

A. salary
B. credits
C. section_id
D. none of the mentioned
Answer» D. none of the mentioned
discuss
554.

Which one is based on multi-valued dependency:

A. first
B. second
C. third
D. fourth
Answer» D. fourth
discuss
555.

If a relation is in BCNF, then it is also in

A. 1 nf
B. 2 nf
C. 3 nf
D. all of the mentioned
Answer» D. all of the mentioned
discuss
556.

If every non-key attribute is functionally dependent primary key, then the relation will be in

A. first normal form
B. second normal form
C. third form
D. fourth normal form
Answer» B. second normal form
discuss
557.

The term for information that describes what type of data is available in a database is:

A. data dictionary
B. data repository
C. index data
D. metadata
Answer» D. metadata
discuss
558.

A data type that creates unique numbers for key columns in Microsoft Access is:

A. autonumber
B. boolean
C. sequential key
D. sequential number
Answer» A. autonumber
discuss
559.

A dependency exist between two columns when

A. together they constitute a composite key for the table
B. knowing the value in one column determines the value stored in another column
C. the table is in 3nf
D. together they constitute a foreign key
Answer» A. together they constitute a composite key for the table
discuss
560.

In the                      normal form, a composite attribute is converted to individual attributes.

A. first
B. second
C. third
D. fourth
Answer» A. first
discuss
561.

A table on the many side of a one to many or many to many relationship must:

A. be in second normal form (2nf)
B. be in third normal form (3nf)
C. have a single attribute key
D. have a composite key
Answer» D. have a composite key
discuss
562.

Tables in second normal form (2NF):

A. eliminate all hidden dependencies
B. eliminate the possibility of a insertion anomalies
C. have a composite key
D. have all non key fields depend on the whole primary key
Answer» A. eliminate all hidden dependencies
discuss
563.

Functional Dependencies are the types of constraints that are based on             

A. key
B. key revisited
C. superset key
D. none of the mentioned
Answer» A. key
discuss
564.

Which is a bottom-up approach to database design that design by examining the relationship between attributes:

A. functional dependency
B. database modeling
C. normalization
D. decomposition
Answer» C. normalization
discuss
565.

A relation is in                          if an attribute of a composite key is dependent on an attribute of other composite key.

A. 2nf
B. 3nf
C. bcnf
D. 1nf
Answer» B. 3nf
discuss
566.

What are the desirable properties of a decomposition

A. partition constraint
B. dependency preservation
C. redundancy
D. security
Answer» B. dependency preservation
discuss
567.

R (A,B,C,D) is a relation. Which of the following does not have a lossless join dependency preserving BCNF decomposition?

A. a->b, b->cd
B. a->b, b->c, c->d
C. ab->c, c->ad
D. a->bcd
Answer» D. a->bcd
discuss
568.

The algorithm that takes a set of dependencies and adds one schema at a time, instead of decomposing the initial schema repeatedly is

A. bcnf algorithm
B. 2nf algorithm
C. 3nf synthesis algorithm
D. 1nf algorithm
Answer» C. 3nf synthesis algorithm
discuss
569.

Which normal form is considered adequate for normal relational database design?

A. 2nf
B. 5nf
C. 4nf
D. 3nf
Answer» D. 3nf
discuss
570.

Relation R with an associated set of functional dependencies, F, is decomposed into BCNF. The redundancy (arising out of functional dependencies) in the resulting set of relations is

A. zero
B. more than zero but less than that of an equivalent 3nf decomposition
C. proportional to the size of f+
D. indeterminate
Answer» B. more than zero but less than that of an equivalent 3nf decomposition
discuss
571.

Which of the normal form is based on multivalued dependencies?

A. first
B. second
C. third
D. fourth
Answer» D. fourth
discuss
572.

Which forms has a relation that possesses data about an individual entity?

A. 2nf
B. 3nf
C. 4nf
D. 5nf
Answer» C. 4nf
discuss
573.

If a multivalued dependency holds and is not implied by the corresponding functional dependency, it usually arises from one of the following sources.

A. a many-to-many relationship set
B. a multivalued attribute of an entity set
C. a one-to-many relationship set
D. both a many-to-many relationship set and a multivalued attribute of an entity set
Answer» D. both a many-to-many relationship set and a multivalued attribute of an entity set
discuss
574.

Which of the following has each related entity set has its own schema and there is an additional schema for the relationship set?

A. a many-to-many relationship set
B. a multivalued attribute of an entity set
C. a one-to-many relationship set
D. none of the mentioned
Answer» A. a many-to-many relationship set
discuss
575.

Fifth Normal form is concerned with

A. functional dependency
B. multivalued dependency
C. join dependency
D. domain-key
Answer» C. join dependency
discuss
576.

In 2NF

A. no functional dependencies (fds) exist
B. no multivalued dependencies (mvds) exist
C. no partial fds exist
D. no partial mvds exist
Answer» C. no partial fds exist
discuss
577.

                           can help us detect poor E- R design.

A. database design process
B. e-r design process
C. relational scheme
D. functional dependencies
Answer» D. functional dependencies
discuss
578.

Which of the following has each related entity set has its own schema and there is an additional schema for the relationship set.

A. a many-to-many relationship set
B. a multivalued attribute of an entity set
C. a one-to-many relationship set
D. all of the mentioned
Answer» A. a many-to-many relationship set
discuss
579.

In which of the following, a separate schema is created consisting of that attribute and the primary key of the entity set.

A. a many-to-many relationship set
B. a multivalued attribute of an entity set
C. a one-to-many relationship set
D. all of the mentioned
Answer» B. a multivalued attribute of an entity set
discuss
580.

What is the best way to represent the attributes in a large database?

A. relational-and
B. concatenation
C. dot representation
D. all of the mentioned
Answer» B. concatenation
discuss
581.

Designers use which of the following to tune the performance of systems to support time-critical operations?

A. denormalization
B. redundant optimization
C. optimization
D. realization
Answer» A. denormalization
discuss
582.

Relation dept year(dept name, total inst 2007, total inst 2008, total inst 2009). Here the only functional dependencies are from dept name to the other attributes. This relation is in

A. fourth nf
B. bcnf
C. third nf
D. second nf
Answer» B. bcnf
discuss
583.

Thus a                of course data gives the values of all attributes, such as title and department, of all courses at a particular point in time.

A. instance
B. snapshot
C. both instance and snapshot
D. all of the mentioned
Answer» B. snapshot
discuss
584.

Representations such as the in the dept year relation, with one column for each value of an attribute, are called                they are widely used in spreadsheets and reports and in data analysis tools.

A. cross-tabs
B. snapshot
C. both cross-tabs and snapshot
D. all of the mentioned
Answer» A. cross-tabs
discuss
585.

An approach to website design with the emphasis on converting visitors to outcomes required by the owner is referred to as:

A. web usability
B. persuasion
C. web accessibility
D. none of the mentioned
Answer» B. persuasion
discuss
586.

A method of modelling and describing user tasks for an interactive application is referred to as:

A. customer journey
B. primary persona
C. use case
D. web design persona
Answer» C. use case
discuss
587.

Information architecture influences:

A. answer choice
B. site structure
C. labeling
D. navigation design
Answer» B. site structure
discuss
588.

Also known as schematics, a way of illustrating the layout of an individual webpage is a:

A. wireframe
B. sitemap
C. card sorting
D. blueprint
Answer» A. wireframe
discuss
589.

A graphical or text depiction of the relationship between different groups of content on a website is referred to as a:

A. wireframe
B. blueprint
C. sitemap
D. card sorting
Answer» C. sitemap
discuss
590.

Blueprints are intended to:

A. prototype of the screen layout showing navigation and main design elements
B. show the grouping of pages and user journeys
C. indicate the structure of a site during site design and as a user feature
D. prototype typical customer journeys or clickstreams through a website
Answer» C. indicate the structure of a site during site design and as a user feature
discuss
591.

Storyboards are intended to:

A. indicate the structure of a site during site design and as a user feature
B. prototype of the screen layout showing navigation and main design elements
C. integrate consistently available components on the webpage (e.g. navigation, search boxes)
D. prototype typical customer journeys or click streams through a website
Answer» D. prototype typical customer journeys or click streams through a website
discuss
592.

Which of the following occupies boot record of hard and floppy disks and activated during computer startup?

A. worm
B. boot sector virus
C. macro virus
D. virus
Answer» B. boot sector virus
discuss
593.

A graphical or text depiction of the relationship between different groups of content on a website is a:

A. page template
B. wireframe
C. site map
D. cascading style sheet (css)
Answer» C. site map
discuss
594.

Which of the following is a valid uniform resource locator?

A. http://www.acm.org/sigmod
B. www.google.com
C. www.ann.in
D. http:/www.acm.org/sigmod/
Answer» A. http://www.acm.org/sigmod
discuss
595.

HTTP defines two ways in which values entered by a user at the browser can be sent to the Web server. The            method encodes the values as part of the URL.

A. post
B. get
C. read
D. argument
Answer» B. get
discuss
596.

A                      is a program running on the server machine, which accepts requests from a Web browser and sends back results in the form of HTML documents.

A. html
B. http
C. web server
D. web browser
Answer» C. web server
discuss
597.

The application program typically communicates with a database server, through                        or other protocols, in order to get or store data.

A. jdbc
B. odbc
C. all of the mentioned
D. none of the mentioned
Answer» C. all of the mentioned
discuss
598.

This extra information is usually maintained in the form of a                    at the client.

A. cookie
B. history
C. remainder
D. none of the mentioned
Answer» A. cookie
discuss
599.

Which of the following is not true about HTML ?

A. <meta>…</meta>
B. <meta…./>
C. <metadata>…</metadata>
D. <metadata name=”” />
Answer» B. <meta…./>
discuss
600.

Html code contains:

A. tags
B. attributes
C. elements
D. all of the mentioned
Answer» D. all of the mentioned
discuss

Done Reading?

Take a Test Download as PDF
Tags
Question and answers in DataBase Management System (DBMS), DataBase Management System (DBMS) multiple choice questions and answers, DataBase Management System (DBMS) Important MCQs, Solved MCQs for DataBase Management System (DBMS), DataBase Management System (DBMS) MCQs with answers PDF download