Crowdly

Suppose for a new patient, until and unless the patient opts for a physician in hospital, data of the patient cannot be added, or else we will have to set the physician information as NULL. What type of anomaly is this?

none

Updation anomaly

Deletion anomaly

Insertion anomaly

Granting privileges to users is an example of --------

DML

DCL

DDL

None

Which ONE of the following statements about action potential propagation is TRUE?

Propagation occurs by electrotonic current flow and saltatory conduction in all neurons

Myelinated neurons have to regenerate the action potential at every point along their length

Action Potentials are conducted only by saltatory conduction, followed by electrotonic flow into terminals

Diameter is more important than myelination in determining conduction velocity, except in smaller neurons

Regeneration of the AP at nodes of Ranvier in myelinated neurons is possible because of their high density of voltage-gated Na+ channels

✅

If the condition in WHERE clause of a SELECT INTO statement returns no data, then ______

New table with some random values will be created

New table with default values will be created

New table will not be created

An empty new table will be created

In PL/SQL, a cursor is a pointer to which of the following area?

Contest Area

Contact Area

Context Area

Content Area

Update logs must have both old value and new value in the case of -----------

Deferred Database Modification

Immediate Database Modification

None

Both Deferred and Immediate Database Modification

Which of the following is the main difference between a function and a procedure in PL/SQL?

Function returns a value, Procedure does not return any value

Function is user-defined, Procedure is pre-defined

Function uses only actual parameters, Procedures uses only formal parameters

Function and Procedure do not have any differences

Which of the following types of statement can trigger a trigger execution?

Only DDL statements

Only DCL statements

Both DML & DDL statements

Only DML statements

Which of the following operator is used to match a single character or group of characters (string) to a given string?

SELECT

BETWEEN