Home
Current Affairs January 2024

What is the correct answer?

4

When an E-R diagram is mapped to tables, the representation is redundant for

A. weak entity sets

B. weak relationship sets

C. strong entity sets

D. strong relationship sets

Correct Answer :

B. weak relationship sets


Related Questions

What is the correct answer?

4

The _____ category includes storage media that can be operated on directly by the computers central processing unit.

A. Primary storage

B. Secondary Storage

C. All

D. Tertiary Storage

What is the correct answer?

4

A data type or format is specified for each _________

A. Relation

B. Tuple

C. Database

D. Domain

What is the correct answer?

4

_____ First proposed the process of normalization.

A. Edgar. W

B. Edward Stephen

C. Edgar F. Codd

D. Edward Codd

What is the correct answer?

4

Which two files are used during operation of the DBMS?

A. Query languages and utilities

B. DML and query language

C. Data dictionary and transaction log

D. Data dictionary and query language

What is the correct answer?

4

Processed data is called _____

A. Raw data

B. Source

C. Information

D. Useful data

What is the correct answer?

4

In a relational schema, each tuple is divided into fields called

A. Relations

B. Queries

C. Domains

D. All of the above

What is the correct answer?

4

When an E-R diagram is mapped to tables, the representation is redundant for

A. weak entity sets

B. weak relationship sets

C. strong entity sets

D. strong relationship sets

What is the correct answer?

4

_____clause is an additional filter that is applied to the result.

A. Select

B. Order by

C. Group-by

D. Having

What is the correct answer?

4

DFD stands for

A. Data Flow Document

B. Data File Diagram

C. Data Flow Diagram

D. Non of the above

What is the correct answer?

4

In an ER model,_____ is described in the database by storing its data.

A. Entity

B. Attribute

C. Relationship

D. Notation

What is the correct answer?

4

The statement that is executed automatically by the system as a side effect of the modification of the database is

A. backup

B. assertion

C. recovery

D. trigger

What is the correct answer?

4

The fact that information in the data warehouse changes far less often and may be regarded as non-real-time with periodic updating; This implies that data warehouses are _______

A. Volatile

B. Non - Volatile

C. Logical

D. Physical

What is the correct answer?

4

If both the functional dependencies : X�Y and Y�X hold for two attributes X and Y then the relationship between X and Y is

A. M:N

B. M:1

D. 1:M

What is the correct answer?

4

A logical schema

A. is the entire database

B. Describes how data is actually stored on disk.

C. is a standard way of organizing information into accessible parts.

D. All of the above

What is the correct answer?

4

The middleware databases in which the business rules act are applicable to _______ tier architectures

A. Single

B. Three

C. Two

D. None

What is the correct answer?

4

In SQL the word natural can be used with

A. inner join

B. full outer join

C. right outer join

D. all of the above

What is the correct answer?

4

The language that requires a user to specify the data to be retrieved without specifying exactly how to get it is

A. Procedural DML.

B. Non-Procedural DML.

C. Procedural DDL.

D. Non-Procedural DDL.

What is the correct answer?

4

Assume transaction A holds a shared lock R. If transaction B also requests for a shared lock on R.

A. It will result in a deadlock situation.

B. It will immediately be rejected.

C. It will immediately be granted.

D. It will be granted as soon as it is released by A .

What is the correct answer?

4

An advantage of views is

A. Data security

B. Derived columns

C. Hiding of complex queries

D. All of the above

What is the correct answer?

4

A _____ is a logical unit of database processing that includes one or more data access operations that can include insertion, deletion, modification or retrieval operations.

A. Database

B. Data

C. Transaction

D. Record

What is the correct answer?

4

The drawback of shadow paging technique are

A. Commit overhead

B. Data fragmentation

C. Garbage collection

D. All of these

What is the correct answer?

4

____ table store information about database or about the system.

A. SQL

B. System

C. Nested

D. None of these

What is the correct answer?

4

Relations produced from an E-R model will always be

A. First normal form.

B. Second normal form.

C. Third normal form.

D. Fourth normal form.

What is the correct answer?

4

The transactions like adding an employee, enrolling a student in a course are examples of _______

A. Logical

B. Physical

C. None

D. Theoretical

What is the correct answer?

4

Isolation of the transactions is ensured by

A. Transaction management

B. Application programmer

C. Concurrency control

D. Recovery management

What is the correct answer?

4

HSAM stands for ……….

A. Hierarchic Standard Access Method

B. Hierarchic Sequential Access Method

C. Hierarchic Sequential and Method

D. Hierarchic Standard and Method

What is the correct answer?

4

The normalization was first proposed by .

A. Code

B. Codd

C. Boyce Codd

D. Boyce

What is the correct answer?

4

A DBMS is a ____ user if at most one user can use the system and is mostly restricted to personal computer systems.

A. None

B. Multi

C. Single

D. Concurrent

What is the correct answer?

4

A weak entity has an ______ dependency on its owner entity, which can be used for both ON UPDATE and ON DELETE.

A. Direct

B. Indirect

C. Existence

D. No

What is the correct answer?

4

The data models defined by ANSI/SPARC architecture are

A. Conceptual, physical and internal

B. Conceptual, view and external

C. Logical, physical and internal

D. Logical, physical and view