Questions
The normal form in DBMS which states that every determinant in the database is a candidate key is
- 1 NF
- 2 NF
- BCNF
- 3 NF
- 4 NF
The rule of database software, which states that every transaction must preserve the integrity constraints is called
- atomicity
- isolation
- consistency
- durability
- rollback
The data models like PICK aka MultiValue and MUMPS aka M is a/an _______________ type of database model.
- object
- post relational
- dimensional model
- domain/key normal form
- SQL
The replication is the result of read and write requests calculated by querying a majority of replicas is __________ type of replication.
- master/slave replication
- multimaster
- quorum
- schema
- data dictionary
The first step in executing a SQL query in DBMS is
- scanning and parsing
- query optimiser
- query code generator
- runtime database processor
- subquery
The set of steps used to access information is a SQL relational database management system is called
- query optimiser
- DML precompiler
- selection operation
- query plan
- projection operation
Which type of queries use a term based specification of the desired images that can be matched to textual image descriptors?
- Attribute based queries
- Textual queries
- Visual queries
- Metadata descriptors
- Visual descriptors
Which of the entity types in DBMS represents the central objects of the system?
- Weak
- Subclass
- Base
- Shared subclass
- Category
Which of the following systems are used for management of the semi-structured spatial data represented in maps?
- RDBMS
- Information Retrieval Systems
- Geographic Information Systems
- Media Retrieval Systems
- Management Information Systems
The data model in DBMS, which organises data into a structure that appears as a tree is called
- network
- hierarchical
- relational
- object relational
- object model
The integrity constraint in DBMS which is also called as attribute integrity in which a column is assigned the possible value only is
- entity integrity
- Referential integrity
- Domain integrity
- DDL
- DML
The denormalisation technique in DBMS in which the database table is split by rows that reduces the number of records per table and hence, drives the performance is
- vertical fragmentation
- horizontal fragmentation
- summary data
- duplicate data
- functional dependency
The methodology of optimising a group of SQL queries altogether with the help of common sub-expressions to save cost and time is
- greedy algorithm
- mobile database system
- multi query optimisation
- query optimisation
- query tree
The standard in DBMS environment that specifies the process of storing the data into network database and retrieving the data from network database is
- centralised database
- data model
- CODASYL
- database server
- IMS
The condition where one attribute is functionally dependent on another non-key attribute of the same relation is
- normalisation
- transitive dependency
- denormalisation
- functional dependency
- BCNF