CS409 Quiz 2 Nov 2025

Question:

If you prefer to exercise more direct control over the sizes of individual memory components, you can disable __________________ and configure the database for manual memory management.

A. Automatic memory management B. Data views C. Data dictionary D. Meta data Copied: 11/24/2025, 10:55:45 AM

Question:

In ORACLE schema, the basic storage unit for storing data in a structured form is ___________.

A. Index B. View C. Table D. Sequence Copied: 11/24/2025, 10:56:20 AM

Question:

V$SESSION, V$DATAFILE are examples of __________________ performance views.

A. Dynamic

B. Fixed C. DBA D. Dynamic and fixed Copied: 11/24/2025, 10:56:39 AM

Question:

A bigfile tablespace with 8K blocks can contain a _____________ data file.

A. 32 terabyte B. 34 terabyte C. 32 hexabyte D. 32 megabyte Copied: 11/24/2025, 10:56:56 AM

Question:

_______________ Edition of MS SQL Server has all features of Enterprise Edition.

A. Express B. Developer C. Enterprise D. Standard Copied: 11/24/2025, 10:57:14 AM

Question:

If the ORACLE transaction is not done, then it must be ____________.

A. Rolled back B. Done C. Partially done D. Paused Copied: 11/24/2025, 10:57:43 AM

Question:

Catalogue and repository are alternate names of _________________________.

A. Data Definition B. Data C. Meta data D. Database Copied: 11/24/2025, 10:57:56 AM

Question:

A log switch occurs when ______ stops writing to one redo log group and starts writing to another.

A. LGR