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

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