801.Which of the following most certainly implies the need for an entire table to implement?
- A binary relationship
- A recursive relationship
- A ternary relationship
- An identifying relationship
802.Which of the following constraints enforces entity integrity?
- PRIMARY KEY
- FOREIGN KEY
- CHECK
- NOT NULL
803.Which of the following is not true about relational tables?
- Column values are of the same kind.
- Each row is unique.
- Each column must have a unique name.
- The sequence of rows is significant.
804..In a conceptual model for a university, what type of relationship exists between Grade and Student entities?
- 1:M
- M:M
- Ternary
805.Controlling redundancy in a database management system DOES NOT help to
- avoid duplication
- avoid unauthorized access to data
- avoid unnecessary wastage of storage space
- avoid inconsistency among data
806.Which of the following is INCORRECT with respect to file systems?
- At the physical level, pointer or hashed address scheme may be employed to provide a certain degree
- of data independence at the user level.
- Some physical organizations use pointers to record blocks to locate records on disk.
- A logical record is concerned with efficient storage of information in the secondary storage devices.
- The efficiency of a file system depends on how efficiently operations such as retrieve, insert, update, delete may be performed on the information stored in the file. –
807.Which of the following functions are NOT performed by a database administrator?
- Planning, designing and implementing database systems
- Establishing standards and procedures for database systems
- Communicating with database users
- Allocation of storage locations and data structure
808.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.
- The internal level in a database system will definitely be relational.
- Any given database has many conceptual schemas and one physical schema, but it has only one external schemas.
- The external level is not concerned with individual user perceptions, while the conceptual level is concerned with a community user perception.
809.Which of the following is a correct way to implement one-to-many relationship while designing tables?
- by splitting the data into two tables with primary key and foreign key relationships
- using a junction table with the keys from both the tables forming the composite primary key of the
- junction table.
- by splitting each table into three
- as a single table and rarely as two tables with primary and foreign key relationship
810.Which of the following is not a benefit of normalization?
- Minimize insertion anomalies
- Minimize deletion anomalies
- Minimize updating anomalies
- Maximize redundancy
811.Consider the following relation R and its sample data. Consider that these are the only rows for the given relation
![](https://mcqsfoundry.com/wp-content/uploads/2021/05/asasasa.jpg)
Which of the following statements is NOT correct?
A. The functional dependency Employee No, Project No -> Department No holds over R.
B. The functional dependency Employee No, Department No -> Project No holds overR.
C. The functional dependency Employ -> Department No holds over R.
D. The functional dependency Project No -> Department No holds over R
812.The Entity Relation Model?
- Entities, Relationships and Process
- Entities and Relationships
- Relationships
- Entities
813.As part of database naming conventions, attribute names should use suffixes such as ID, NUMBER or CODE ?
- foreign key
- index
- primary key
- determinant
814.User rights information is stored in
- Physical database
- Logical database
- Catalog
- Buffer
815.The data model which describes how the data is actually stored is :
- external model
- internal model
- logical model
- none of these
816.Data about data is normally termed as :
- Directory
- meta data
- data bank
- none
817.The scheme for hierarchical database is :
- a graph
- a tree
- a B-tree
818.none which one is an example for network database ?
- Unify
- Ingress
- IDMS
- None
819.One of the following is a valid record-based data model :
- Object-oriented model
- Entity-relationship model
- None
- Relational model
820.In an object-oriented model, one object can access data of another object by passing :
- Message
- Instance variable
- Variable
- None of these
821.SET concept is used in :
- Hierarchical model
- Network model
- Relational model
- None
822.A view of database that appears to an application program is known as :
- schema
- subschema
- virtual table
- none
823.Choose the DBMS, which supports full-fledged client server application development ?
- Oracle 7.1
- DBASEIV
- FoxPro 2.1
- Ingress
824.A top-to-bottom relationship among the items in a database is established by a :
- Network schema
- Relational schema
- Hierarchical schema
- All
825.The level of data abstraction which describes how the data is actually stored is :
- conceptual level
- physical level
- file level
- none of these
826.Collection of information stored in a database at a particular moment is :
- View
- instance
- schema
- none
828.The syntax of a user query is verified by :
- query optimizer
- DBA
- parser
- none
829.A data model is :
- Used to describe structure of a database
- Both [A] and [B]
- Set of basic operations on the database
- None
830. In a hierarchical database, a hashing function is used to locate the :
- Root
- Collisions
- Primary key
- Duplicate records
831.Between the users and the database itself, a DBMS will act as :
- barrier
- interface
- referee
- obstacle
832.Which of these is not a database object ?
- index
- sequence
- cursor
- trigger
833. Which one of the following is not an object-based logical model ?
- The binary model
- The info logical model
- The entity-relational model
- None of these
834.Which one of the following design is both software and hardware independent ?
- Logical
- Physical
- Conceptual
- None
835.Object based data models are used in describing the abstraction of the following level :
- Only physical
- Conceptual and view
- Physical and conceptual
- None
836.A schema describes :
- All
- Record Relationship
- Data Elements
- Record and files
837.An abstraction concept for building composite object from their component object is called :
- Specialization
- Normalization
- Aggregation
- Generalization
838.Manager’s salary details are hidden from the employee. This is :
- Physical level data hiding
- External level data hiding
- None of these
- Conceptual level data hiding
839. Which one is an incorrect statement about a view ?
- All
- view is derived from other tables
- It can be updated like a table
- DROP VIEW is used to dispose it
840.Which one is lowest level data model ?
- A physical data model
- logical data model
- external data model
- none
841.Which of these is not TRUE in case of responsibilities of Database Administrator (DBA) ?
- Acquiring hardware and software resources
- Authorizing access to database
- Data entry in to the database
- All
842. In order to use a DBMS, it is important to understand :
- the physical schema
- all subschema that the system supports
- one subschema
- both [A] and [B]
843.Data items grouped together for storage purposes are called a :
- record
- title
- list
- string
844.A computer file contains several records. What does each record contain ?
- Bytes
- Words
- Fields
- Database
845.A report generator is used to :
- update files
- print files on paper
- data entry
- all
846.Data are :
- Raw facts and figures
- Information
- Electronic representation of facts
- None
847.Data processing cycle consists of :
- Input cycle and output cycle
- Input cycle, output cycle and processing cycle
- Output cycle and processing cycle
- None
848.Top level manager uses :
- A Internal information only
- External information only
- Both [A] and [B]
- None
849.DBMS is used to :
- Eliminate data redundancy
- Maintain data integrity
- Establish relationships among different files
- All
850.A large computer information system maintains many different computer files. Which amongst them is called a perpetual file ?
- A Specialized file B
- Log file
- Master file
- Update file