Top 1000+ Database Subject Mcqs Pdf Download Set No 20

Print/Downlaod pdf

951. Physical Modeling

  1. Physical modeling involves the actual design of a database according to the requirements that were established during logical modeling.
  2. Logical modeling mainly involves gathering the requirements
  3. all

952. Schema

  1. It is into a relational database model.
  2. When physical modeling occurs, objects are being defined at the schema level.
  3. A schema is a group of related objects in a database.
  4. A database design effort is normally associated with one schema.
  5. modeling..

953.Physical modeling

  1. Physical modeling is database software specific, meaning that the objects defined during physical modeling can vary depending on the relational database software being used.
  2. data is stored, although basic data types are conceptually the same among different implementations.
  3. all

 954.Types of physical modeling

  1. Server model diagrams
  2. User feedback documentation
  3. Database design documentation
  4. Both a, b

955.Which of the following is NOT a feature of Context DFD?

  1. one process (which represents the entire system)  all sources/sinks (external entities)
  2. data flows linking the process to the sources and sinks (external entities)
  3. sub -processes (which explain and decomposed the major process into small processes)  

956.Which of the following is true for the relational model?

  1. Degree of a relation is the number of rows in a relation.
  2. Null value is a blank or zero value given to an attribute value when its value is inapplicable or its value is unknown.
  3. Complex key is a key consisting of more than one attribute.
  4. Constraint is a rule that restricts the values in a database.

957.Which one of the following four E-R diagrams is the typical result you obtain when you initially start with an E-R diagram containing just two entities,

  1. One to one
  2. Many-to-Many relationship
  3.  both
  4. introduce an associative entity

958.Which of the following most certainly implies the need for an entire table to implement?

  1. A binary relationship
  2. A ternary relationship           
  3. An identifying relationship

959.Which of the following constraints enforces entity integrity?

  1. PRIMARY KEY
  2. FOREIGN KEY
  3.  CHECK
  4. NOT NULL                         

960.Which of the following is not true about relational tables?

  1. Column values are of the same kind.
  2. Each row is unique.
  3. Each column must have a unique name.
  4. The sequence of rows is significant.

961.In a conceptual model for a university, what type of relationship exists between Grade and Student entities?

  1. 1M        
  2. MM
  3. Ternary                                

962.Controlling redundancy in a database management system DOES NOT help to

  1. avoid duplication 
  2. avoid unnecessary wastage of storage space

963.Inconsistency?

  1. avoid unauthorized access to data          
  2. avoid inconsistency among data
  3. none                     

964. Which of the following is INCORRECT with respect to file systems?

  1. At the physical level, pointer or hashed address scheme may be employed to provide a certain degree of data independence at the user level.
  2. A logical record is concerned with efficient storage of information in the secondary storage devices.
  3. Some physical organizations use pointers to record blocks to locate records on disk. 
  4. The efficiency of a file system depends on how efficiently operations such as retrieve,
  5. Insert
  6. none

965. Which of the following functions are NOT performed by a database administrator?

  1. Planning, designing and implementing database systems
  2. Establishing standards and procedures for database systems
  3. Communicating with database users  
  4. Allocation of storage locations and data structures

 966. Select the correct statement about the ANSI/SPARC architecture.The conceptual level is a level of indication between the internal level and the external level.

  1. The internal level in a database system will definitely be relational.
  2. Any given database has many conceptual schemas and one physical schema, but it has only one external schemas.
  3. The external level is not concerned with individual user perceptions, while the conceptual level is concerned with a community user perception.

967. Which of the following is a correct way to implement one-to-many relationship while designing tables?

  1. by splitting the data into two tables with primary key and foreign key relationships.
  2. using a junction table with the keys from both the tables forming the composite primary key of the junction table.
  3. by splitting each table into three
  4. as a single table and rarely as two tables with primary and foreign key relationships.     

968. Which of the following is not a benefit of normalization?

  1. Minimize insertion anomalies
  2. Minimize deletion anomalies  Minimize updating anomalies
  3. Maximize redundancy

969. Consider the following relation R and its sample data. (Consider that these are the only topples for the given relation)Which of the following statements is NOT correct?

  1. The functional dependency (Employee No, Department No) -> Project No holds over R. 
  2. The functional dependency Employee No -> Department No holds over R. 
  3. The functional dependency Project No -> Department No holds over R.
  4. The functional dependency (Emptor, Project No) -> Dept No holds over R.                        


970. The Entity Relation Model models

  1. Entities, Relationships and Processes
  2. Entities and Relationships 
  3. Relationships
  4. Entities                                

971. As part of database naming conventions, attribute names should use suffixes such as ID, NUMBER or CODE for the ?

  1. primary key
  2. foreign key  index
  3. determinant
  4. none

972. User rights information is stored in

  1. Physical database
  2. Catalog
  3. Logical
  4. database  Buffer

973.Making a change to the conceptual schema of a database but not affecting the existing external schemas is an example of

  1. Physical data independence
  2. Concurrency control.
  3. Logical data independence.      
  4. Functional dependency                               

974.Which of the following is NOT a feature of Context DFD?

  1. one process (which represents the entire system)  all sources/sinks (external entities)
  2. data flows linking the process to the sources and sinks (external entities)
  3. sub-processes (which explain and decomposed the major process into small processes                               

975. A relation (from the relational database model) consists of a set of tuples  which implies that

  1. all  topless in a relation must be distinct
  2. relational model supports multi-valued attributes whose values can be represented in sets.
  3. any two topless, the values associated with all of their attributes may be the same.
  4. all topless in particular relation may have different attributes.                   

976.Identify the constraint that limits the values that can be placed in a column.

  1. NOT NULL
  2. CHECK              
  3. UNIQUE

978. Consider the following table obtained using Student and Instructor relations.

Which relational algebra operation could have been applied on the pair of relations Student and Instructor to obtain the above data?

  1. Instructor – Student
  2. Student ∩ Instructor  Instructor ÷ Student  Student Instructor   

979.Identify the correct statement with respect to normalization.

  1. Normalization is a formal technique that can be used only at the starting phase of the database design.
  2. Normalization can be used as a top-down standalone database design technique.
  3. The process of normalization through decomposition must achieve the lossless join property at any cost whereas the dependency reservation property is sometimes sacrificed.
  4. The process of normalization through decomposition must achieve the dependency reservation property at any cost whereas the lossless join property is sometimes sacrificed.

980.Consider the relation Interview(Candidate No, Interview Date

 Interview Time, Staff No, Room No

  1. FD1  Candidate No, Interview Date -> Interview Time, Staff No, Room No
  2. FD2  Room No, Interview Date, Interview time -> Staff No, Candidate No
  3. FD3  Staff No, Interview Date -> Room No

981.Which of the following is correct?

  1. The relation Interview is in 3NF       
  2. The FD3 violates 3NF.
  3. The FD2 violates 2NF.

982.Which of the following is not a feature of TRANSACTION?

  1. Users should be able to regard the execution of each transaction as atomic.
  2. Each transaction, run by itself.
  3. the consistency of the database
  4. dependant on other concurrent transactions

 983.Identify the correct statement with respect to normalization.

  1. Normalization is a formal technique that can be used only at the starting phase of the database design.
  2. Normalization can be used as a top-down standalone database design technique. 
  3. The process of normalization through decomposition must achieve the lossless join property at any cost whereas the dependency reservation property is sometimes sacrificed.
  4. The process of normalization through decomposition must achieve the dependency reservation property at any cost whereas the lossless join property is sometimes sacrificed.

984.Which of the following is incorrect with respect to indexed sequential files ? 

  1. New records are added to an overflow file
  2. Record in main file that precedes it is updated to contain a pointer to the new record
  3. The overflow is merged with the main file during a batch update
  4. Multiple indexes for the same key field cannot be setup   

985. DML commands are used for

  1. inserting data into databases  
  2. creating database
  3. destroying databases  
  4. creating DB objects .

 986.Structural constraints of a relationship type refer

  1. to  identifying the owner entity type relevant to a given entity type
  2. whether the existence of an entity depends on it being related to another entity via the relationship type. 
  3. role that a participating entity from the entity type plays in each relationship instance

987.Identify the correct statement.

  1. Entity integrity constraints specify that primary key values can be composite.
  2. Entity integrity constraints are specified on individual relations.  
  3. Entity integrity constraints are specified between weak entities .
  4. When entity integrity rules are enforced, a tuple
  5. in one relation that refers to another relation must refer to a n existing tuple. 

988.what is the impact of setting multiple indexes for the same key, in index sequential files ?

  1. Multiple indexes for the same key can not be set
  2. It increases efficiency
  3. It decreases efficiency
  4. It will increase complexity as the access time will be increased 

989. Which of the following is not true regarding Indexes ?

  1. Index can be defined even when there is no data in the table
  2. It support Range selections
  3. It can be created using ‘Create Index’ statement
  4. It can not be created on composite attributes  

990.While recovering data, which of the following files does a recovery m anger examines at first?

  1. A system file
  2. Log file  
  3. Data dictionary
  4. Metadata

 991. The main memory of a computer system is also known as  ROM

  1. RAM   
  2. PROM
  3. Hard disk

992._______is a control that enables users to select one option from an associated list; users can also type an option.

  1. Combo box  
  2. Button
  3. Text box
  4.   Static area

 993.______ records data by burning microscopic holes in the surface of the disk with a laser.

  1. Hard disk
  2. RAM
  3. Optical disk    
  4. Floppy disk

994.Which of following is NOT generally the aim of data partitioning and placement of data? 

  1. Reduce Workload
  2. Balance Workload
  3. Merging different relations  
  4. Speed up rate of useful works .

995.Which of the following is the correct description of cache hit?

  1. When data is found in the cache  
  2. When data is removed in the cache
  3. The number of times the cache is accessed directly by the processor 
  4. When data is lost from the cache 

996. In which of the following situations?

  1. Relatively static  
  2. Relatively deletion
  3. Relatively dynamic

997. Only one type of constraint can be enforced in any table by CREATE command

  1. True      
  2. false

998.Which of the following is disadvantage of chaining technique to handle the collisions ? 

  1. Unlimited Number of elements
  2. Fast re-hashing
  3. Overhead of multiple linked lists   
  4. Maximum number of elements must be known   

999.An entity can be logically connected to another by defining a ____.  hyperlink

  1. common attribute  
  2. primary key
  3. super key

1000.You can’t modify more than one table at a time through a view. 

  1. True   
  2. False