Home
Current Affairs January 2024

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

Correct Answer :

A. Relations


Related Questions

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

A transaction is in state after the final statement has been executed.

A. partially committed

B. active

C. committed

D. none of the above

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

Dependency preservation is not guaranteed in

A. BCNF

B. 3NF

C. PJNF

D. DKNF

What is the correct answer?

4

In an ER diagram the ___shape specifies the Attibute and a ____ shape specifies the primary key attribute.

A. Oval; An oval with an underlined attribute

B. Circle; A circle with bolded attribute inside it

C. Diamond; A bolded attribute

D. Square; An attribute within the square

What is the correct answer?

4

Which of the following is not comparison operator?

A. <>

B. <

C. =<

D. >=

What is the correct answer?

4

Relationships among relationships can be represented in an-E-R model using

A. Aggregation

B. Association

C. Weak entity sets

D. Weak relationship sets

What is the correct answer?

4

In 2NF

A. No functional dependencies (FDs) exist.

B. No multivalued dependencies (MVDs) exist.

C. No partial FDs exist.

D. No partial MVDs exist.

What is the correct answer?

4

Which of the following relational algebra operations do not require the participating tables to be union-compatible?

A. Union

B. Intersection

C. Difference

D. Join

What is the correct answer?

4

Precedence graphs help to find a

A. Serializable schedule.

B. Recoverable schedule.

C. Deadlock free schedule.

D. Cascadeless schedule.

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

_____is a full form of SQL.

A. Standard query language

B. Sequential query language

C. Structured query language

D. Server side query language

What is the correct answer?

4

What are the desirable properties of a decomposition

A. Partition constraint.

B. Dependency preservation.

C. Redundancy.

D. Security.

What is the correct answer?

4

Which of the following is not a recovery technique?

A. Deferred update

B. Immediate update

C. Two-phase commit

D. Shadow paging

What is the correct answer?

4

A top-to-bottom relationship among the items in a database is established by a

A. Hierarchical schema

B. Network schema

C. Relational Schema

D. All of the above

What is the correct answer?

4

In SQL the statement select * from R, S is equivalent to

A. Select * from R natural join S.

B. Select * from R cross join S.

C. Select * from R union join S.

D. Select * from R inner join S.

What is the correct answer?

4

What is a disjoint less constraint?

A. It requires that an entity belongs to no more than one level entity set.

B. The same entity may belong to more than one level.

C. The database must contain an unmatched foreign key value.

D. An entity can be joined with another entity in the same level entity set.

What is the correct answer?

4

The ______ indexes are forced to store only record IDs in the data structure and require at least one additional I/O Operation to retrieve the actual record.

A. Clustered

B. Hashed

C. Un-clustered

D. Collision

What is the correct answer?

4

Which of the following is a reason to model data?

A. Understand each user's perspective of data

B. Understand the data itself irrespective of the physical representation

C. Understand the use of data across application areas

D. All of the above

What is the correct answer?

4

………………… approach reduces time and effort required for design and lesser risk in database management.

A. Single global database

B. Multiple databases

C. Top-down approach

D. None of the above

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

A list consists of last names, first names, addresses and pin codes. If all people in the list have the same last name and same pin code a useful key would be

A. the pin code

B. the last name

C. the compound key first name and last name

D. Tr from next page

What is the correct answer?

4

operator is used to compare a value to a list of literals values that have been specified.

A. Like

B. COMPARE

C. BETWEEN

D. IN

What is the correct answer?

4

______is a special type of integrity constraint that relates two relations & maintains consistency across the relations.

A. Domain Integrity Constraints

B. Referential Integrity Constraints

C. Domain Constraints

D. Entity Integrity Constraints

What is the correct answer?

4

Data items grouped together for storage purposes are called a

A. record

B. string

C. title

D. list

What is the correct answer?

4

Which of the following relational algebraic operations is not from set theory?

A. Union

B. Intersection

C. Cartesian Product

D. Select

What is the correct answer?

4

The values of the attribute describes a particular

A. Entity set

B. File

C. Entity instance

D. Organization

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 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

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.