Home
Current Affairs January 2024

What is the correct answer?

4

Which of the syntax is correct for insert statement?
i) insert into values
ii) insert into (column list) values

A. i-only

B. ii-only

C. Both of them

D. None of them

Correct Answer :

C. Both of them


Related Questions

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

Dependency preservation is not guaranteed in

A. BCNF

B. 3NF

C. PJNF

D. DKNF

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

A ______ module is typically designed so that it will run on a user workstation or personal computer.

A. Software

B. Server

C. Program

D. Client

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

In a multi-user database, if two users wish to update the same record at the same time, they are prevented from doing so by

A. jamming

B. password

C. documentation

D. record lock

What is the correct answer?

4

Key to represent relationship between tables is called

A. primary key

B. secondary key

C. foreign key

D. none of the above

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 relational algebraic operations is not from set theory?

A. Union

B. Intersection

C. Cartesian Product

D. Select

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

If an entity can belong to only one lower level entity then the constraint is

A. disjoint

B. partial

C. overlapping

D. single

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

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

What are the desirable properties of a decomposition

A. Partition constraint.

B. Dependency preservation.

C. Redundancy.

D. Security.

What is the correct answer?

4

If a transaction T has obtained an exclusive lock on item Q, then T can

A. read Q

B. write Q

C. both read and write Q

D. write Q but not read Q

What is the correct answer?

4

Which of the following constitutes a basic set of operations for manipulating relational data?

A. Predicate calculus

B. Relational calculus

C. Relational algebra

D. SQL

What is the correct answer?

4

If the closure of an attribute set is the entire relation then the attribute set is a

A. superkey

B. candidate key

C. primary key

D. not a key

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

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

______ keyword is used to find the number of values in a column.

A. TOTAL

B. ADD

C. COUNT

D. SUM

What is the correct answer?

4

Which of the following addressing modes permits relocation without any change over in the code?

A. Indirect addressing

B. Indexed addressing

C. PC relative addressing

D. Base register addressing

What is the correct answer?

4

______is a preferred method for enforcing data integrity

A. Constraints

B. Triggers

C. Stored procedure

D. Cursors

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

In b-tree the number of keys in each node is than the number of its children.

A. one less

B. same

C. one more

D. half

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

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

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

Which of the syntax is correct for insert statement?
i) insert into values
ii) insert into (column list) values

A. i-only

B. ii-only

C. Both of them

D. None of them

What is the correct answer?

4

The collection of information stored in a database at a particular moment is called as ......

A. schema

B. instance of the database

C. data domain

D. independence