CS409 Practical Quiz Jan 2026

VU QUIZ REPORT

Subject: CS409P

Quiz Completed: 1/8/2026, 12:04:45 PM Total Questions: 10

Which of the following language code is executed on server without any network overhead?

1. C++
2. Python
3. PHP
4. PL/SQL

Correct answer: PL/SQL

Front end programming can be changed without affecting ____________ programming. A. SQL B. Server and client C. Client

D. Server

To alter an index, your schema must contain the index or you must have the ______________ system privilege. A. ANY INDEX ALTER B. ALTER PRIVILEGE

C. ALTER ANY INDEX

D. ALTER INDEX Making an index ____________ is an alternative method to make it unusable or dropping it.

A. INVISIBLE

B. MUTE C. UNREADABLE D. VISIBLE

How many types of views are utilized to control table-related information?

1. 4
2. 3
3. 2
4. 5

Correct answer: 3

Selected Answer: B

_______________ statement is used to change or rebuild an existing index. A. CHANGE INDEX

B. ALTER INDEX

C. REBUILD INDEX D. UPDATE INDEX

Selected Answer: B

EMP.sal%TYPE is an example of __________ data type. A. Complex B. Scalar

C. Subtype

D. Composite Which of the following table statement is used to delete only the table structure from the database? A. Delete B. Update C. Create

D. Drop

A/an _________________ is a schema object that contains an entry for each value that appears in the column of the table or cluster and provides direct, fast access to rows. A. Cluster Table B. View C. Join

D. Index

Which of the following option is not a characteristic of PL/SQL?

1. Performed on client Machine
2. Embedded structured programming
3. Centrally accessible from single database
4. Executed on server without any network overhead

Correct answer: Performed on client Machine