Home
Current Affairs January 2024

What is the correct answer?

4

The division operator divides a dividend A of degree m+n by a divisor relation B of degree n and produces a result of degree

A. m - 1

B. m + 1

C. m * m

D. m

Correct Answer :

D. m


Related Questions

What is the correct answer?

4

____specifies a search condition for a group or an aggregate.

A. GROUP BY Clause

B. HAVING Clause

C. FROM Clause

D. WHERE Clause

What is the correct answer?

4

In an E-R diagram double lines indicate

A. Total participation.

B. Multiple participation.

C. Cardinality N.

D. None of the above.

What is the correct answer?

4

In SQL, testing whether a subquery is empty is done using

A. DISTINCT

B. UNIQUE

C. NULL

D. EXISTS

What is the correct answer?

4

An advantage of the database management approach is

A. data redundancy increases

B. data is dependent on programs

C. data is integrated and can be accessed by multiple programs

D. none of the above

What is the correct answer?

4

The clause alter table in SQL can be used to

A. add an attribute

B. delete an attribute

C. alter the default values of an attribute

D. all of the above

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

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

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

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

Which of the following is not comparison operator?

A. <>

B. <

C. =<

D. >=

What is the correct answer?

4

Data independence means

A. data is defined separately and not included in programs.

B. programs are not dependent on the physical attributes of data

C. programs are not dependent on the logical attributes of data

D. both B and C

What is the correct answer?

4

Use of UNIQUE while defining an attribute of a table in SQL means that the attribute values are

A. distinct values

B. cannot have NULL

C. both (A) & (B)

D. same as primary key

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

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

Immediate database modification technique uses

A. Both undo and redo.

B. Undo but no redo.

C. Redo but no undo.

D. Neither undo nor redo.

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 table can have only one

A. Secondary key

B. Alternate key

C. Unique key

D. Primary key

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

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

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

_____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

Which of the following is not a consequence of concurrent operations?

A. Lost update problem.

B. Update anomaly.

C. Unrepeatable read.

D. Dirty read.

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

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

The size of a data item is called its _______, which can be a field of some record or may be a larger unit such as a record.

A. Similarity

B. Granularity

C. Dimensionality

D. Arity

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

Checkpoints are a part of

A. Recovery measures.

B. Security measures.

C. Concurrency measures.

D. uthorization measures.

What is the correct answer?

4

The data in the database at a particular moment of time is called the _______

A. Snapshot

B. Dynaset

C. Stateless

D. Stateful

What is the correct answer?

4

E-R Modeling is achieved by using ____ diagrams

A. DFD

B. Flowcharts

C. Gantt Charts

D. E-R

What is the correct answer?

4

Create a table with the following attributes: Employee(EMPNO integer, EMPNAME of 10 characters)

A. Create table Employee(EMPNO int, EMPNAME char(10));

B. Create table Employee(EMPNO integer, EMPNAME String(10));

C. Create table Emplo(EMPNO number, EMPNAME string);

D. Create table Emp(EMPNO int, EMPNAME char(10));