Top 1000+ Database Subject Mcqs Pdf Download Set No 07
301.Which of the following is not true regarding DB transactions ?
- A set of database operations that are processed partly
- A database transaction is a logical unit of database operations A database transaction must be atomic
- A database transaction must contains the ACID property
302.Which of the following is not true about input forms ?
- Provide an easy, effective, efficient way to enter data into a table
- Especially useful when the person entering the data is not familiar with the inner workings
- Provide different controls to add data into the tables
303. One input forms can populate one table at a time Which of the following is an example of volatile memory?
- RAM
- ROM
- Flash memory
- CPU
304.Which of following is NOT generally the aim of data partitioning and placement of data?
- Reduce Workload
- Balance Workload
- Merging different relations
- Speed up rate of useful works .
305.Which of the following is Advantage of Re -Hashing technique to handle the collisions?
- Collisions don’t use primary table space
- Unlimited number of elements
- Fast access through use of main table space
- Overhead of multiple linked they can be accessed directly using a SELECT statement
306.Select ‘NORTH’, CUSTOMER From CUST_DTLS Where REGION = ‘N’ Order By CUSTOMER Union Select ‘EAST’, CUSTOMER From CUST_DTLS Where REGION = ‘E’ Order By CUSTOMER
The above statement
- Has an error – the string should be in double quotes .
- Has an error – ORDER BY clause.
- not have an error.
- Has an error – the string in single quotes ‘NORTH’ and ‘SOUTH’.
307. A software package designed to store and manage databases
- DBMS
- Data model
- Data
308.Who is responsible for authorizing access to the database, for coordinating and monitoring its use
- Database Designers
- Database Administrators
- End Users
- Application Programmers
309.A ____ entity has a primary key that is partially or totally derived from the parent entity in the relationship.
- strong
- weak
- business
- relationship
310.Which of the following SQL keywords is not used with DDL statements?
Identify the constraint that limits the values that can be placed in a column.
- NOT NULL
- FOREIGN KEY
- UNIQUE
311.Which of the following enforces a relation into 1st normal form ?
The domain of attribute must include only atomic values.
True
false
312.Every non-key attribute is fully functionally dependent on primary key non-key attribute is non-transitively dependent on primary key.
Every non-key attribute is partially dependent on superkey Which of the following is NOT a feature of HASH ACCESS?
- indexes to search or maintain
- Very fast direct access
- Inefficient sequential access
- Use when direct access is needed, but sequential access is not.
313.Which of the following is NOT a feature of a good interface?
- data structure based
- user friendly consistency
- process based
314. Which of the following is true about application programs ?
- develop before the database design
- Tools selection is made after the development database
- meant to perform different operations by the user
- must to design before the designing and developing database
315.Which of the following is incorrect with respect to indexed sequential files ?
- New records are added to an overflow file
- Record in main file that precedes it is updated to contain a pointer to the new record
- The overflow is merged with the main file during a batch update
Multiple indexes for the same key field cannot be setup
316.Which of the following is one of the purposes of using DDL commands ?
- inserting records into databases
- updating records into databases
- manipulating databases
- creating and destroying databases
317.Which of the following statements creates a database named COMPANY?
- CREATE DATABASE company rep
- CREATE DB company
- ADD DATABASE company
- CREATE company DATABASE
318.What is the impact of setting multiple indexes for the same key, in index sequential files ?
- Multiple indexes for the same key can not be set
- It increases efficiency
- It decreases efficiency
- It will increase complexity as the access time will be increased
- The information regarding ‘views ’ and ‘Integrity constraints’ are found in
- Both Data Dictionary and System Catalog
319.Which of following is not the feature of Indexes ?
- must be refreshed when the data in their master tables changes
- improve the performance of SQL execution when they are used for query rewrites
- can be accessed directly using a SELECT statement
320.Which of the following is not true regarding DB transactions ?
- A set of database operations that are processed partly
- A database transaction is a logical unit of database operations
- A database transaction must be atomic
- A database transaction must contains the ACID property
321.Which of the following are the general are performed during the development of application programs?
- Data input
- Programs
- Editing
- Display
- All of given
323. Which of the following is not a type of user interface?
- Forms
- DB tables
324. Which of the following is not true about input forms ?
- Especially useful when the person entering the data is not familiar with the inner workings
- Provide different controls to add data into the tables
- One input forms can populate one table at a time
325.Which of the following is NOT a feature of Context DFD?
- one process which resents the entire system
- all sources/sinks external entities
- sub-processes which explain and decomposed the major process into small processes
- data flows linking the process to the sources and
326.Which of the following is true for the relational model?
- Constraint is a rule that restricts the values in a database.
- Degree of a relation is the number of rows in a relation.
- Null value is a blank or zero value given to an attribute value
- when its value is inapplicable or its value is unknown.
- Complex key is a key consisting of more than one attribute.
327.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
328.Which of the following constraints enforces entity integrity?
- PRIMARY KEY
- FOREIGN KEY
- CHECK
- NOT NULL
330.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.
331..In a conceptual model for a university, what type of relationship exists between Grade and Student entities?
- 1:M
- M:M
- Ternary
- –
332.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 .
333.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.
334.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
- –
335.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.
- –
336.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
337.Which of the following is not a benefit of normalization?
- Minimize insertion anomalies
- Minimize deletion anomalies
- Minimize updating anomalies
- Maximize redundancy
338.Consider the following relation R and its sample data. Consider that these are the only tuples for the given relation
![](https://mcqsfoundry.com/wp-content/uploads/2021/05/db.jpg)
Which of the following statements is NOT correct?
The functional dependency Employee No, Project No -> Department No holds over R.
A. The functional dependency Employee No, Department No -> Project No holds over R.
B.The functional dependency Employ -> Department No holds over R.
C.The functional dependency Project No -> Department No holds over R
–
339.The Entity Relation Model?
- Entities, Relationships and Process
- Entities and Relationships
- Relationships
- Entities
- –
340.As part of database naming conventions, attribute names should use suffixes such as ID, NUMBER or CODE ?
- foreign key
- index
- primary key
- determinant
341.User rights information is stored in
- Physical database
- Logical database
- Catalog
- Buffer
342.The data model which describes how the data is actually stored is :
- external model
- internal model
- logical model
- none of these
343.Data about data is normally termed as :
- Directory
- meta data
- data bank
- none
344.The scheme for hierarchical database is :
- a graph
- a tree
- a B-tree
345.none which one is an example for network database ?
- Unify
- Ingress
- IDMS
- None
346.One of the following is a valid record-based data model :
- Object-oriented model
- Entity-relationship model
- None
- Relational model
347.In an object-oriented model, one object can access data of another object by passing :
- Message
- Instance variable
- Variable
- None of these
348.SET concept is used in :
- Hierarchical model
- Network model
- Relational model
- None
349.A view of database that appears to an application program is known as :
- schema
- subschema
- virtual table
- none
350.Choose the DBMS, which supports full-fledged client server application development ?
- Oracle 7.1
- DBASEIV
- FoxPro 2.1
- Ingress