All nodes have _________ parent node/nodes.

• A) exactly four
• B) exactly two
• C) exactly one
• D) exactly three

During a server request, the readyState changes from ____ to ____ .

• A) 1,3
• B) 1,4
• C) 0 , 4
• D) 2,2

All modern browsers support the ______ specification.

• A) W3C DOM
• B) W2C DOM
• C) W1C DOM
• D) W4C DOM

If the node type is _______ it is an element node

• A) 1
• B) 0
• C) 3
• D) 2

The ____________ method can also be used to remove a text node.

• A) textChild()
• B) updateText()
• C) removeChild()
• D) childText()

replaceData() method has __________ parameters :

• A) 1
• B) 3
• C) 4
• D) 2

In which type of Database relationship, foreign key can be added in any participating table?

• A) One to Many
• B) Many to Many
• C) One to One
• D) None

____________ is an artificial key which is not a part of the system. The purpose of the key is to avoid the complexity of the composite primary keys.

• A) Surrogate Key
• B) Unique Key
• C) Candidate Key
• D) Foreign Key

Which one is relevant for Primary key - foreign key relationship?

• A) Partial Constraints
• B) Referential Integrity Constraints
• C) Integrity constraints
• D) Completeness Constraints

The correct syntax of insert statement is:

• A) Insert into database values(value1, value2, ……)
• B) Insert into tablename values(value1, value2, ….)
• C) Insert values(value1, value2, ……..) into tablename
• D) Insert values(value1, value2,…) into database

Suppose your company has hired a new employee Ahmad and you are required to add his information in the emp table. Which of the following SQL command will you use for this purpose?

• A) Update
• B) Add
• C) Insert
• D) New

Which one is not a type of Anomalies?

• A) Insertion Anomaly
• B) Select Anomaly
• C) Deletion Anomaly
• D) Update Anomaly

Cascading defines the behavior of _______ when the record from the parent table is deleted or updated.

• A) Super key
• B) Foreign key
• C) Secondary key
• D) Primary key

Deletion Anomaly occurs due to __________.

• A) Poor design decision
• B) Poor application program
• C) Poor maintenance
• D) Poor codding decision

First normal forma removes _________

• A) Transitive dependency
• B) Multiple value of an attribute
• C) Functional dependency
• D) Single value of an attribute

In E-R Diagram which one is not possible to show?

• A) Relationships
• B) Attributes
• C) Entities
• D) Foreign key relationships

____________________ combine two or more conditions into a compound condition in order to get the specific required results.

• A) Conditional Operators
• B) Logical Operators
• C) Boolean Operators
• D) Arithmetic Operators

Which clause is used only with Group functions?

• A) WHERE
• B) HAVING
• C) GROUP BY
• D) SELECT

__________________ statement is used to view the data from database.

• A) Create
• B) View
• C) Select
• D) Join

The _____________operator in SQL works like OR operator and allows to search for a value from given list of values.

• A) LIKE
• B) BETWEEN
• C) IN
• D) ANY