Conceptual design

DBMS - DATA MODELS MCQ

• Which of the following is not a level of data abstraction?
• Which of the following is not an Schema?
• Which of the following is a Data Model?
• Logical design of database is called
• Snapshot of the dta in the database at a given instant of time is called
• Which of the following is the structure of the Database?
• A logical description of some portion of database that is required by a user to perform task is called as
• _____________ is a classical approach to database design?
• Which of the following is the oldest database model?
• Which of the following indicates the maximum number of entities that can be involved in a relationship?
• Which of the following data constraints would be used to specify that the value of cells in a column must be one of a specific set of possible values?
• In a 1:N relationship, the foreign key is placed in:
• Which of the following column properties specifies whether or not cells in a column must contain a data value?
• A primary key should be defined as:
• Which of the following column properties would be used to specify that cells in a column must contain a monetary value?
• If a denormalization situation exists with a one-to-one binary relationship, which of the following is true?
• Selecting a data type involves which of the following?
• What is the best data type definition for Oracle when a field is alphanumeric and has a length that can vary?
• A multidimensional database model is used most often in which of the following models?
• Which of the following is not a factor to consider when switching from small to large block size?
• The view of total database content is
• Architecture of the database can be viewed as
• In the architecture of a database system external level is the
• In a Hierarchical model records are organized as
• A logical schema
• Conceptual design
• A subschema expresses
• SET concept is used in :
• The conceptual model is
• Which of the following is record based logical model?
• Hierarchical model is also called
• A main purpose of DBMS is to provide ____________ view of data to user
• ____________ means to hide certain details of how data is stored and maintain
• There are _________ levels of data abstraction
• In data abstraction which is lowest level of abstraction ?
• _______ of abstraction explains how data is actually stored and describes the Data Structure and Access methods used by database
• "What data is stored ?" is described by __________ level of abstraction in DBMS
• Part of entire database is shown by ________ level of abstraction
• If user doesn't know anything about the complexity of database application then that user is called as _____________
• Data Model is collection of conceptual tools for describing
• Data Models in DBMS are classified into ______ categories
• Which of the following is example of Object based logical model ?
• Entity Relationship model consists of collection of basic objects called _________ and relationship among these objects
• Object which is distinguishable from other objects by specific set of attributes is called as ___________
• Association among several entities is called as _____________
• ______________ express the number of entities to which another entity can be associated via a relationship set
• In Object Oriented Model values are stored into __________ variables
• Collection of tables to represent both data and relationship is described by _____________
• Ability to modify schema of database in one level without affecting the schema definition in higher level is called as __________
• There are _________ levels of data independence
• Physical Data Independence is ability to modify _____________ without causing application program to rewrite
• Logical Data independence is ability to modify ____________ without causing application program to rewrite
• In enterprise data modeling, which is incorrect?
• Which is not a relevant feature of CASE tools?
• CASE tools do not include which of the following features?
• The three-schema components include all, but:
• Which is not a type of data management technology?
• Which of the following database activities determines the entities, attributes, and relationships of data?
• Which of the following database activities require a specific knowledge of a DBMS?
• Which of the following database activities allow for the actual retrieval and use of a database?
• An entity type is which of the following?
• The first step in database development is which of the following?
• Strategic Planning factors do not include which of the following?
• The use of packaged data models can offer which of the following benefits?
• Whose role is it to determine the requirements and design for a database?
• User views are included as part of which schema?
• The Enterprise tier of the three-tiered database architecture includes:
• Which of the following statement is true concerning objects and/or classes?
• A UML diagram includes which of the following?
• A constructor operation does which of the following?
• An object can have which of the following multiplicities?
• Multiplicity is the same as what concept for an ERD?
• An abstract class is which of the following?
• The term Incomplete for a UML has the same meaning as which of the following for an EER diagram?
• The fact that the same operation may apply to two or more classes is called what?
• Aggregation is which of the following?
• Composition is a stronger form of which of the following?
• Which of the following applies to a class rather than an object?
• The object-oriented development life cycle is which of the following?
• The benefits of object-oriented modeling are which of the following?
• Which of the following is a technique for hiding the internal implementation details of an object?
• The term Complete for a UML has the same meaning as which of the following for an EER diagram?
• Which of the following is an unordered collection of elements that may contain duplicates?
• Which of the following is an ordered collection of elements of the same type?
• The object definition language (ODL) is which of the following?
• Using ODL, you can define which of the following?
• A relationship should be specified how in the ODL?
• The Object Query Language is which of the following\"?
• Using OQL, you may do which of the following?
• Identify the class name for the following code:
• Which of the following is true concerning the following statement:
• The reserved word enum is used for which of the following?
• ODL supports which of the following types of association relationships?
• An atomic literal is which of the following?
• The keyword "inverse" is used in which of the following?
• An extent is which of the following?
• Which of the following is true concerning an ODBMS?
• Which of the following is not a logical data-base structure?
• The relational model uses some unfamiliar terminology. A tuple is equivalent to a:
• A top-to-bottom relationship among the items in a database is established by a
• In a _____ a parent record type can be linked to one or more "child" record types, but a child record type can have only one parent
• Which of the following is true of a network structure?
• Internal auditors should review data system design before they are
• If you want your database to include methods, you should use a _____ database
• The model for a _____ resembles the hierarchical model in many respects
• The model for a record management system might be
• A data dictionary is a special file that contains
• A data dictionary doesn't provide information about:
• In order to use a record management system
• Goals for the design of the logical schema include
• Subschema can be used to
• The process of reading a database schema and producing a data model from that schema is known as:
• The data model that is produced from reverse engineering is:
• A tool that can help designers understand the dependencies of database structures is a:
• In the three-tier architecture, the intermediate layer between database and client servers is classified as
• The form of data model in which the concepts provided are useful for end users and are also close to the way it is stored in computer system is called
• The architecture of database in which the characteristics such as program insulations, multiple user support and the use of catalogs are achieved is classified as
• The form of data model which focuses the concepts in the same way as the data stored in computer system is classified as
• The type of legacy data model in which data is represented as record types and limited one to many relationships is called
• The type of server in two-tier architectures which provides the data to client stored on disk pages is called
• In categories of data modeling, the low level data models are also called
• The concepts of data models that are only useful to computer specialists rather than end users of programs are classified as
• The hierarchical models and network models are considered as types of
• The process of converting the requests into results between three-schema architecture internal, external and conceptual levels is called
• The type of legacy data model in which related records are represented by each hierarchy in the tree structure is classified as
• The type of data model which provide concepts in a way users of data recognize data models is considered as
• For a three-schema architecture, there is strict partition between external, internal and conceptual level and the language used in this structure is
• The levels in which the three schema architecture can be defined includes
• The type of data independence in which the schema can be altered on conceptual level without altering external level is classified as
• The middle computer system which is accessed to access database server is classified as
• The process of suppression of details regarding storage and data type to highlight important features for better understanding is called
• In two-tier client -„ server architecture, the running of application programs and the user interface programs is in control of
• In database schema, the database snapshot is also called
• The Conference on Data Systems Languages Database Task Group is a committee to
• In client -„ server architecture, the system which consists of software's and peripheral devices for archiving, printing and accessing files is called
• The behavior which allows the database designer to specify user defined operations for databases is called
• The association between two or more entities in a database system is classified as
• The capacity to alter the database schema at one level without altering any other schema level is classified as
• The database management architecture in which there is middle level between database server and client server is classified as
• While designing the database management system, if the performance is the main issue to be considered then the DBMS designed is called
• The handling of user interface, data dictionary, concurrency control and global query optimization are tasks of
• The objects in database description is called
• The collection of all the concepts that must be used to describe database structure is called
• In two-tier client -„ server architecture, the functions of transaction server and query server are controlled by
• The data model, access path and number of users of database management system are the criteria for
• The computing model in which the large number of printers, PCs, Web servers and database servers are connected to each other with the help of network is classified as
• The type of database management system in which all the application programs are executed and processes with one machine is classified as
• In a database of company, if the employees are classified as entity then the name of employees is called
• All the information about usage standards, decision of designs, user information and description of application programs is stored in
• In Three-Schema Architecture, the schema which gives the description about physical data model, access path and details of storage of data is called
• The local concurrency control, storage of data on disk pages and the buffering of disk pages are considered as tasks of
• The features which allows users to update the database and specifying retrievals are part of
• In the network model, the one to many relationship is denoted by
• The data model which uses the concepts such as attributes, relationships and entities is classified as
• In categories of data modeling, the high level data models are also called
• In database management system, the current set of instance or database snapshot is also called
• In Three-Schema Architecture, the schema in which the part of database is described to the user group who is interested and other details are kept hide is called
• If the high level data manipulation language is used in standalone interface manner then this language is considered as
• In data modeling, the data constraints, data relationships and data types for the stored data are classified as
• The type of relational database which incorporate the concepts of object database is classified as
• In client / server architecture, the machine that have capability of providing user interface and local processing is called
• In DBMS, the property of interest which further describes the entity is classified as
• The type of data manipulation language which is used to describe the complex operations in more precise way is classified as
• In DBMS, the set-at-a-time manipulation language is also called
• The system which schedules the inputs or outputs of the disk in database is classified as
• The hierarchical models and network models are classified as
• In Three-Schema Architecture, the schema which gives details about data types, constraints and entities is classified as
• The complete description of database which is described in design phase and is changed rarely is called
• If here are no strict separation between internal and conceptual levels, the language used by database designer is
• If the commands of data manipulation language are embedded in general programming language then that programming language is called
• The type of data independence in which the internal schema can be modified without modifying the conceptual schema is classified as
• The types of architectures of DBMS are
• The graphical representation of database description is called
• The program interface which provides the feature to client side programs to call the database management system is classified as
• In hierarchical structures, the can be nested to create
• In DBMS, the description of database in the form of schema is also called
• In the two-tier architecture, the server is considered as
• The type data abstraction which allows the conceptual representation of data in database management system is considered as
• The characteristic of database management system which allows the program operation independence and program data independence is classified as
• The database catalog or dictionary defining the descriptive information which is stored in database is called
• The phase considering documentation of analyzed requirements and can be represented with the help of computerized tools is considered as

This question belongs to these collections

• DBMS - DATA MODELS MCQ

Similar questions