Correct Answer:- Option-D

Question47:-Consider the table "Sales" with columns: id(INTEGER), data (DATE),
and total (DECIMAL). Which of the following queries will return the average total for
each year?

A:-SELECT YEAR (date), AVG(total) FROM sales

B:-SELECT AVG (total) FROM sales GROUP BY YEAR (date)

C:-SELECT YEAR (date), AVG (total) FROM sales GROUP BY YEAR (date);
D:-SELECT AVG (total) FROM sales GROUP BY data ;

Correct Answer:- Option-C

Question48:-Which of the following statements is true regarding the CASCADE
option in a FOREIGN KEY constraint?

A:- It prevents any modifications to the foreign key column
B:-it allows NULL values in the foreign key column

C:-lt automatically creates a new primary key value when a referenced
primary key is deleted or updated

D:-It deletes or updates the dependent rows in the referencing table when a
referenced primary key is deleted or updated

Correct Answer:- Option-D
Question49:-'Q' in a five tuple DFA definition represents
A:-The finite set of states
B:-Finite set of outputs
C:-The set of all inputs
D:-None of the above
Correct Answer:- Option-A
Question50:-A linked list is a/an linear data structure.
A:-Asymptotic
B:-Primitive
C:-Non-primitive
D:-Absolute
Correct Answer:- Option-C

Question51:-A parent process executing system call will be suspended
until its child process terminates

A:-Create()

B:-Exec()

C:-Wait()

D:-Run()

Correct Answer:- Option-C

Question52:-A context free language is called ambiguous if there exists a string