Home
Current Affairs January 2024

What is the correct answer?

4

DBMS is a collection of _____ that enables user to create and maintain a database.

A. Keys

B. Program

C. Translators

D. Language Activity

Correct Answer :

B. Program


Related Questions

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

A relational database developer refers to a record as

A. an attribute

B. a tuple

C. a criteria

D. a relation

What is the correct answer?

4

The rule that a value of a foreign key must appear as a value of some specific table is called a

A. Referential constraint.

B. Index.

C. Integrity constraint.

D. Functional dependency.

What is the correct answer?

4

Employees in a company are each assigned their own office, i.e. for each employee there exists a unique office and for each office there exists a unique employee; This statement is an example of ____ type of relation.

A. 1:1

B. 1: Many

C. Many: One

D. Many : Many

What is the correct answer?

4

The _______ is a set of programs to use and / or modify this data.

A. DBMS

B. System

C. Program

D. Software

What is the correct answer?

4

What will be the number of columns and rows respectively obtained for the operation, A- B, if A B are Base union compatible and all the rows of a are common to B? Assume A has 4 columns and 10 rows; and B has 4 columns and 15 rows

A. 4,0

B. 0,0

C. 4,5

D. 8,5

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

The keyword to eliminate duplicate rows from the query result in SQL is

A. DISTINCT

B. NO DUPLICATE

C. UNIQUE

D. None of the above

What is the correct answer?

4

In an E-R, Y is the dominant entity and X is a subordinate entity. Then which of the following is incorrect :

A. Operationally, if Y is deleted, so is X

B. existence is dependent on Y.

C. Operationally, if X is deleted, so is Y.

D. Operationally, if X is deleted, & remains the same.

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

Protection of data from unauthorized Disclosure results in loss of _______

A. Integrity

B. Availability

C. Confidentiality

D. Discretionary Security

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

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

Union operator is a :

A. Unary Operator

B. Ternary Operator

C. Binary Operator

D. Not an operator

What is the correct answer?

4

The default level of consistency in SQL is

A. repeatable read

B. read committed

C. read uncommitted

D. serializable

What is the correct answer?

4

Which of the following aggregate functions does not ignore nulls in its results?.

A. COUNT .

B. COUNT (*)

C. MAX

D. MIN

What is the correct answer?

4

What is data integrity?

A. It is the data contained in database that is non redundant.

B. It is the data contained in database that is accurate and consistent.

C. It is the data contained in database that is secured.

D. It is the data contained in database that is shared.

What is the correct answer?

4

A _____ is used to define overall design of the database

A. code

B. data definition language

C. application program

D. schema

What is the correct answer?

4

In E-R Diagram total participation is represented by

A. Double lines

B. Single line

C. Dashed lines

D. Triangle

What is the correct answer?

4

The part of a database management system which ensures that the data remains in a consistent state is

A. authorization and integrity manager

B. buffer manager

C. transaction manager

D. file manager

What is the correct answer?

4

The set of all values that can be taken by the attribute is called as _______ of the attribute.

A. Tuple

B. Cardinality

C. Degree

D. Domain

What is the correct answer?

4

_______ product was acquired by Informix, integrated into its RDBMS and introduced as the Informix Universal Server an ORDBMS.

A. Star

B. llustar

C. SQL

D. Cygnus

What is the correct answer?

4

Which of the following is not a logical database structure?

A. Chain

B. Network

C. Tree

D. Relational

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

A ____ key specifies a uniqueness constraint that no two distinct tuples in any state r of relation R can have the same value for super key.

A. Sub

B. Parent

C. Candidate

D. Super

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

Relational Algebra does not have

A. Selection operator.

B. Projection operator.

C. Aggregation operators.

D. Division operator.

What is the correct answer?

4

Grant and revoke are _____ statements.

A. TCL

B. DCL

C. DDL

D. DML

What is the correct answer?

4

The ____ operator joins two or more conditions and displays rows only if that rows data satisfies all conditions specified.

A. OR

B. AND

C. NOT

D. ALL

What is the correct answer?

4

Dependency preservation is not guaranteed in

A. BCNF

B. 3NF

C. PJNF

D. DKNF