Oracle Database and JDBC Fundamentals

The REUSE STORAGE clause in TRUNCATE specifies that the space freed by deleting rows remains allocated to the table (kept in its tablespace). The default DROP STORAGE would return that space to the tablespace for other tables to use. TRUNCATE cannot be rolled back.

In Oracle SQL, rowid (the unique physical address of a row) and rownum (the sequential order number of a retrieved row) are valid built-in pseudocolumns. row_num, sl_no, and sid are not standard pseudocolumns.

When you create a Primary Key constraint, the database automatically creates a unique index to enforce the uniqueness requirement. Similarly, a Unique constraint also creates a unique index to ensure no duplicate values. Check constraints only validate data integrity rules, Not Null enforces presence of values, and Foreign Key creates relationships but not unique indexes.

JDBC stands for Java Database Connectivity, so option B is correct. JDBC is primarily an API for accessing relational databases, but it can also work with tabular data sources like spreadsheets and flat files through the JDBC-ODBC bridge or specific drivers, making option C correct. Option A is incorrect because JDBC is specifically designed for relational and tabular data, not XML or arbitrary object databases. Option D describes ORM tools like Hibernate, not JDBC itself.

The standard JDBC classes and interfaces are located in the core Java SE packages java.sql (for basic database access) and javax.sql (for advanced features like data sources and connection pooling).

JDBC-ODBC Bridge Driver (Type 1) provides JDBC access through one or more ODBC drivers. It acts as a bridge between JDBC calls and ODBC drivers, essentially converting JDBC calls to ODBC calls. Type 2 uses native libraries, Type 3 is a middleware driver, and Type 4 is pure Java direct to database.

Type 4 driver converts JDBC calls directly into the database's native network protocol, requiring no middleware or native libraries. It's a pure Java driver that communicates directly with the database. Type 1 uses ODBC, Type 2 uses native libraries, and Type 3 uses middleware.

PreparedStatement is the JDBC Statement type designed for executing parameterized queries with placeholders (?). It precompiles SQL statements, allowing efficient reuse with different parameter values. Statement (basic) doesn't support parameters, and CallableStatement is for stored procedures. ParameterizedStatement is not a valid JDBC interface.

A DataSource in JDBC is a factory object that provides connections to a physical data source. It offers advantages over DriverManager: connection pooling, distributed transaction support, and easier deployment configuration. It represents (is) the factory, not the source itself, a driver manager, or a JNDI registry point.

When converting data between databases with different character sets, ensuring CHAR data consists of well-formed strings is crucial because malformed strings can cause conversion errors or data corruption. ASCII capitalization has nothing to do with character set conversion, INT data type constraints are unrelated, and nil strings are a specific case, not a general requirement.

Oracle LONG columns are used to store variable-length character strings containing up to 2 gigabytes of text. They share many characteristics with VARCHAR2 columns, although they have many more restrictions on usage.

Oracle supports several datetime datatypes, including DATE, TIMESTAMP, TIMESTAMP WITH TIME ZONE, and TIMESTAMP WITH LOCAL TIME ZONE. All four options represent valid built-in datetime types in Oracle SQL.

Oracle bitmap index restrictions include that you cannot specify BITMAP for a domain index, you cannot combine UNIQUE and BITMAP, and you cannot create a global partitioned bitmap index. Local partitioned bitmap indexes are allowed.

Text literals in SQL have properties of both CHAR (fixed-length character strings) and VARCHAR2 (variable-length character strings) datatypes. CLOB is for large character objects, and Float is a numeric datatype unrelated to text. Text literals can be assigned to either CHAR or VARCHAR2 columns.

Database sequences generate unique numeric values often used for primary keys and unique keys to provide automatically incrementing identifiers. Sequences are not typically used for sales figures (which are data values, not identifiers) or foreign keys (which reference existing primary keys). The generated values ensure uniqueness across rows.

The emctl utility is Oracle Enterprise Manager's command-line interface for managing the DB Console service. The correct syntax is 'emctl start dbconsole' which starts the web-based Enterprise Manager console for a specific database. Options B and C are incomplete commands missing the emctl prefix, while D has incorrect parameter order.

Oracle comparison operators return three possible values: TRUE, FALSE, or UNKNOWN. UNKNOWN is returned when any operand in the comparison is NULL (not the same as NULL itself). ERROR is not a valid result for comparison conditions - errors occur from invalid operations, not comparisons. NULL is a value, not a comparison result.

In Oracle Database installations, the default location for the portlist.ini file, which lists the ports assigned to various Oracle components, is the $ORACLE_HOME/install directory.

The correct Oracle SQL syntax to reclaim unused space from a table is ALTER TABLE <table_name> SHRINK SPACE;. The other options use incorrect keywords like SHRINK, SHRINK UNUSED, or SHRINK ROWs which are syntactically invalid.

Single-row functions can be used in almost any clause of a SQL query. This includes the SELECT list, the WHERE clause, the START WITH and CONNECT BY hierarchical clauses, and the HAVING clause, as they operate on individual rows.