Database Management Systems Mcqs

Page No. 84

A subschema expresses


athe logical view.


bthe physical view.


cthe external view.


dall of the above.


View Answer the external view.

The method in which records are physically stored in a specified order according to a key field in each record is


ahash


bdirect


csequential


dall of the above.


View Answer hash

Conceptual design


ais a documentation technique.


bneeds data volume and processing frequencies to determine the size of the database.


cinvolves modelling independent of the DBMS.


dis designing the relational model.



The relational model feature is that there


ais no need for primary key data.


bis much more data independence than some other database models.


care explicit relationships among records.


dare tables with many dimensions.



A relational database developer refers to a record as


aa criteria.


ba relation.


ca tuple.


dan attribute.


View Answer a tuple.

The DBMS language component which can be embedded in a program is


aThe data definition language (DDL).


bThe data manipulation language (DML).


cThe database administrator (DBA).


dA query language.



The property / properties of a database is / are :


aIt is an integrated collection of logically related records.


bIt consolidates separate files into a common pool of data records.


cData stored in a database is independent of the application programs using it.


dAll of the above.


View Answer All of the above.

In an E-R diagram an entity set is represent by a


arectangle


bellipse


cdiamond box.


dcircle


View Answer rectangle

The way a particular application views the data from the database that the application uses is a


amodule


brelational model.


cschema


dsub schema.


View Answer sub schema.

In an E-R diagram attributes are represented by


arectangle


bsquare


cellipse


dtriangle


View Answer ellipse

Goto Page No.

Page 84 of 101

Alphabetical MCQs Categories

Here below You find all kind of categories of MCQs in alphabetical order.


"Comprehensive Collection of MCQs: Alphabetically Organized by Subject"

"Discover an extensive collection of multiple-choice questions (MCQs) neatly categorized by subject from A to Z. This resource is designed for anyone eager to explore various topics in a straightforward and organized manner. Whether you're a student preparing for exams, an educator seeking supplementary materials, or simply curious about different subjects, this compilation offers a convenient way to learn and assess your knowledge. With questions arranged alphabetically, navigation is effortless, allowing you to delve into subjects of interest at your own pace. Engage, learn, and expand your understanding with this accessible and comprehensive repository of MCQs!"


BolPakistan

bolpakistan.com.pk includes Job Mcqs and Pak Mcqs is the Top Largest Mcqs Forum in World, in which you can read Mcqs of All Subjects, PPSC test preparation, FPSC, NTS and PPSC PAST PAPERS, PPSC PAST MCQS. A Collection of Repeated MCQs for JOBs seekers.

Copyright © 2024, Designed & Developed by BolPakistan