You have been tasked to create a table for a banking application.
One of the columns must meet three requirements:
1. Be stored in a format supporting date arithmetic without using conversion functions
2. Store a loan period of up to 10 years
3. Be used for calculating interest for the number of days the loan remains unpaid
Which data type should you use?
To meet the three requirements for the banking application: storing date arithmetic without conversion, supporting a loan period of up to 10 years, and calculating interest based on the number of days the loan remains unpaid, the best-suited data type is INTERVAL DAY TO SECOND. This data type enables storage and arithmetic operations on periods of days, hours, minutes, and seconds, directly fulfilling the need to calculate the duration the loan remains unpaid in days.
In the spfile of a single instance database, LOCAL_LISTENER is set to LISTENER_1.
The TNSNAMES.ORA file in $ORACLE_HOME/network/admin in the database home contains:
Which statement is true?
The LREG process dynamically registers services with the listener specified by the LOCAL_LISTENER parameter. Dynamic service registration does not require manual configuration in the listener.ora file. Instead, it relies on the local_listener parameter and the corresponding address in the TNSNAMES.ORA file. Hence, the correct explanation aligns with how dynamic service registration is intended to work without additional manual configurations in the listener.ora file.
Which three statements are true concerning logical and physical database structures? (Choose three.)
A smallfile tablespace might be larger than a bigfile tablespace because a smallfile tablespace can contain many datafiles, whereas a bigfile tablespace contains only one datafile. A segment can span multiple data files in some tablespaces; this is allowed because tablespaces can consist of multiple data files. A segment might have only one extent if its data fits within the allocated space of that extent.
Which two statements are true regarding a SAVEPOINT? (Choose two.)
A SAVEPOINT allows you to set a point within a transaction to which you can later roll back. Rolling back to a SAVEPOINT can undo Data Manipulation Language (DML) statements like DELETE, making statement E correct. A SAVEPOINT itself does not issue a COMMIT, which means that changes before the SAVEPOINT can still be rolled back if needed; therefore, statement D is correct. Other options mentioned actions like CREATE INDEX (a Data Definition Language (DDL) statement), TRUNCATE (also DDL), and restrictions on the number of SAVEPOINTs, none of which align with the fundamental functionalities of SAVEPOINT in SQL.
Which three functions are performed by dispatchers in a shared server configuration? (Choose three.)
In a shared server configuration, dispatchers perform several crucial roles. They write inbound requests to the common request queue from all shared server connections. This allows the shared servers to pick up these requests for processing. Dispatchers also receive inbound requests from processes using shared server connections, which is their primary function in the architecture. Finally, dispatchers are responsible for sending shared server session responses back to the requesters on the appropriate connection, ensuring that the client receives the correct output from their input request. This mechanism facilitates effective load distribution and resource utilization in a shared server environment.