ERASED TEST, YOU MAY BE INTERESTED ON 082-1a10
COMMENTS |
STATISTICS |
RECORDS
|
|---|
TAKE THE TEST
|
Title of test:
082-1a10 Description: Test pt1 Author:
Creation Date: 03/04/2025 Category: Others Number of questions: 10 |
Share the Test:
New Comment
No comments about this test.
Content:
|
AUTOEXTEND is possible for the datafile It must be bigger than the largest SMALLFILE tablespace Additional data files may not be added It will be a dictionary-managed tablespace by default It will always have a 32K blocksize. Which statement is true about the INTERSECT operator used in compound queries? Multiple INTERSECT operators are not possible in the same SQL statement It processes NULLs in the selected columns INTERSECT is of lower precedence than UNION or UNION ALL It ignores NULLs. Which two statements are true about the SET VERIFY ON command? (Choose two.) It can be used only in SQL*Plus It displays values for variables used only in the WHERE clause of a query It can be used in SQL Developer and SQL*Plus It displays values for variables created by the DEFINE command It displays values for variables prefixed with && . Which two statements are true about date/time functions in a session where NLS_DATE_FORMAT is set to DD-MON-YYYY HH24:MI:SS? (Choose two.) CURRENT_TIMESTAMP returns the same date and time as SYSDATE with additional details of fractional seconds SYSDATE can be queried only from the DUAL table CURRENT_DATE returns the current date and time as per the session time zone SYSDATE can be used in expressions only if the default date format is DD-MON-RR SYSDATE and CURRENT_DATE return the current date and time set for the operating system of the database server CURRENT_TIMESTAMP returns the same date as CURRENT_DATE. A database is configured to use automatic undo management with temporary undo enabled. An UPDATE is executed on a temporary table. Where is the UNDO stored? in the undo tablespace in the SYSAUX tablespace in the SGA in the PGA in the temporary tablespace . 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? INTERVAL YEAR TO MONTH INTERVAL DAY TO SECOND TIMESTAMP WITH LOCAL TIMEZONE TIMESTAMP TIMESTAMP WITH TIMEZONE . Dynamic service registration cannot be used for this database instance The LREG process registers services dynamically with the LISTENER_1 listener LISTENER_1 must also be defined in the LISTENER.ORA file to enable dynamic service registration There are two listeners named LISTENER and LISTENER_1 running simultaneously using port 1521 on the same host as the database instances The definition for LISTENER_1 requires a CONNECT_DATA section to enable dynamic service registration. Which three statements are true concerning logical and physical database structures? (Choose three.) All tablespaces may have one or more data files The extents of a segment must always reside in the same datafile A smallfile tablespace might be bigger than a bigfile tablespace A segment can span multiple data files in some tablespaces A segment's blocks can be of different sizes A segment might have only one extent Segments can span multiple tablespaces. Which two statements are true regarding a SAVEPOINT? (Choose two.) Rolling back to a SAVEPOINT can undo a CREATE INDEX statement Rolling back to a SAVEPOINT can undo a TRUNCATE statement Only one SAVEPOINT may be issued in a transaction A SAVEPOINT does not issue a COMMIT Rolling back to a SAVEPOINT can undo a DELETE statement. Which three functions are performed by dispatchers in a shared server configuration? (Choose three.) writing inbound request to the common request queue from all shared server connections checking for outbound shared server responses on the common outbound response queue receiving inbound requests from processes using shared server connections sending each connection input request to the appropriate shared server input queue broadcasting shared server session responses back to requesters on all connections sending shared server session responses back to requesters on the appropriate connection. |
Report abuse