Question 1:
Which three statements are true about the naming methods and their features supported by Oracle database used to resolve connection information? (Choose three.)
A. Local Naming requires setting the TNS_ADMIN environment variable on the client side.
B. A client can connect to an Oracle database instance even if no client side network admin has been configured.
C. Directory Naming can be used if Connect-Time Failover is required.
D. Easy Connect supports TCP/IP and SSL.
E. Local naming can be used if Connect-Time Failover is required.
F. Directory Naming requires setting the TNS_ADMIN environment variable on the client side.
BCE
B - Easy Connect requires no client-side configuration.
C - Local Naming supports the advanced connection option Connect-time failover.
E - Directory Naming supports Connect-time failover.
Question 2:
Which three statements are true about the Automatic Diagnostic Repository (ADR)?
A. It Is held Inside an Oracle database schema.
B. The ADR base is specified In the diagnostic_dest database parameter.
C. It is only used for Oracle Database diagnostic information.
D. It is a file-based repository held outside any database.
E. It can be used for problem diagnosis of a database when that database's instance is down.
BDE
Question 3:
Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.)
A. The ADR base defaults to $ORACLE_HOME/rdbms/admin if neither DIAGNOSTIC_DEST nor ORACLE_BASE is set
B. The ADR base defaults to $ORACLE_HOME/dbs if the DIAGNOSTIC_DEST parameter and the ORACLE_BASE environment variable are not set
C. It supports diagnostics for Automatic Storage Management (ASM)
D. It supports diagnostics for Oracle Clusterware
E. It is held inside an Oracle database schema
CD
A - false; default value for DIAGNOSTIC_DEST: If $ORACLE_BASE is not set, then derived from ORACLE_BASE as set by the Oracle Universal Installer. If ORACLE_BASE is not set, then $ORACLE_HOME/rdbms/log is used.
B - false; see answer A
C - true; Beginning with Oracle Database 11g and later releases, Oracle Automatic Storage Management (Oracle ASM), and other Oracle Database products or components store all diagnostic data in the ADR.
D - true; Review this content to understand clusterware-specific aspects of how Oracle Clusterware uses ADR.
E - false; data are not held inside an Oracle database schema
Question 4:
Which two Oracle database space management features require the use of locally managed tablespaces? (Choose two.)
A. Automatic data file extension (AUTOEXTEND)
B. Server-generated tablespace space alerts
C. Online segment shrink
D. Free space management with bitmaps
E. Oracle Managed Files (OMF)
CD
Question 5:
Examine the description of the EMPLOYEES table:
NLS_DATE_FORMAT is set to DD-MON-YY.
Which query requires explicit data type conversion?
A. SELECT join_date FROM employees WHERE join_date > '10-02-2018';
B. SELECT join_date + '20' FROM employees;
C. SELECT salary + '120.50' FROM employees;
D. SELECT SUBSTR(join_date, 1, 2) - 10 FROM employees;
E. SELECT join_date || ' ' || salary FROM employees;
A
Question 6:
Which three statements are true about table data storage in an Oracle Database? (Choose three.)
A. Data block headers contain their own Data Block Address (DBA)
B. A table row piece can be chained across several database blocks
C. Multiple row pieces from the same row may be stored in different database blocks
D. Multiple row pieces from the same row may be stored in the same block
E. Data block free space is always contiguous in the middle of the block
F. Index block free space is always contiguous in the middle of the block
ACD
Question 7:
Which two are benefits of external tables? (Choose two.)
A. They support DELETES which transparently deletes records in the file system as if they were table rows.
B. They can be queried, transformed, and joined with other tables without having to load the data first.
C. They support UPDATES which transparently updates records in the file system as if they were table rows.
D. The results of a complex join or aggregating function or both can be unloaded to a file for transportation to another database.
E. They can be queried while the database is in the MOUNT state like dynamic performance views.
BD
Question 8:
Which two statements are true about views? (Choose two.)
A. The WITH CHECK clause prevents certain rows from being updated or inserted in the underlying table through the view.
B. The WITH CHECK clause prevents certain rows from being displayed when querying the view.
C. Views can be indexed.
D. Views can be updated without the need to re-grant privileges on the view.
E. Tables in the defining query of a view must always exist in order to create the view.
AD
Question 9:
Which two statements are true regarding views? (Choose two.)
A. The WITH CHECK OPTION constraint can be used in a view definition to restrict the columns displayed through the view.
B. The OR REPLACE option is used to change the definition of an existing view without dropping and re-creating it.
C. Rows cannot be deleted through a view if the view definition contains the DISTINCT keyword.
D. Rows added through a view are deleted from the table automatically when the view is dropped.
E. A simple view in which column aliases have been used cannot be updated.
F. A subquery used in a complex view definition cannot contain group functions or joins.
BC
Question 10:
Examine this command:
CREATE UNDO TABLESPACE undotbs01
DATAFILE 'undotbs_01.dbf'
SIZE 100M
AUTOEXTEND ON;
Which two actions must you take to ensure UNDOTBS01 is used as the default UNDO tablespace? (Choose two.)
A. Add the SEGMENT SPACE MANAGEMENT AUTO clause
B. Set UNDO_TABLESPACE to UNDOTBS01
C. Add the NOLOGGING clause
D. Make certain that the database operates in automatic undo management mode
E. Add the ONLINE clause
BD
Question 11:
Which two statements are true regarding indexes? (Choose two.)
A. A UNIQUE index can be altered to be non-unique
B. A SELECT statement can access one or more indices without accessing any tables
C. A table belonging to one user can have an index that belongs to a different user
D. An update to a table can result in updates to any or all of the table's indexes
E. When a table is dropped and is moved to the RECYCLE BIN, all indexes built on that table are permanently dropped
F. An update to a table can result in no updates to any of the table's indexes
CDF
Question 12:
Which three statements are true about connection strings and service names used to connect to an Oracle database instance? (Choose three.)
A. A connection string must include the SID of a database instance.
B. A connection string including a service name must be defined in the tnsnames.ora file.
C. A single database instance can support connections for multiple service names.
D. A single connection string can refer to multiple database instances.
E. A service name is created by a listener.
F. Different connection strings in the same tnsnames.ora file can contain the same service name, host and port parameters.
CDF
Question 13:
Examine this command:
SQL> ALTER TABLE ORDERS SHRINK SPACE COMPACT
Which two statements are true? (Choose two.)
A. The SHRINK operation causes rows to be moved to empty space starting from the beginning of the ORDERS segment.
B. Queries and DML statements are allowed on ORDERS while the SHRINK is executing. Most Voted
C. Dependent indexes become UNUSABLE.
D. Only queries are allowed on ORDERS while the shrink is executing.
E. The high-water mark (HWM) of ORDERS is adjusted.
F. The SHRINK operation causes rows to be moved to empty space starting toward the end of the ORDERS segment.
AB -- if three take E
https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/managing-space-for-schema-objects.html#GUID-047BCDDF-0015-43D6-AF09-294DA42B13CA
This process consolidates fragmented free space below the high water mark and compacts the segment. After compaction, the high water mark is moved, resulting in new free space above the high water mark.
Question 14:
You execute this query:
SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE), 'MON'), 'dd `Monday for` fmMonth rrrr')
What is the result?
What is the result?
A. It executes successfully but does not return any result
B. It returns the date for the first Monday of the next month
C. It generates an error
D. It returns the date for the last Monday of the current month
C
Question 15:
SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE), 'MON'),
'dd "is the first Monday for" fmmonth rrrr')
FROM DUAL;
What is the outcome?
A. In generates an error because rrrr should be replaced by rr in the format string.
B. It executes successfully but does not return the correct result.
C. It executes successfully and returns the correct result.
D. In generates an error because TO_CHAR should be replaced with TO_DATE.
E. In generates an error because fm and double quotation marks should not be used in the format string.
C
Question 16:
Which three statements are true about performing Data Manipulation Language (DML) operations on a view with no INSTEAD OF triggers defined? (Choose three.)
A. Insert statements can always be done on a table through a view.
B. Views cannot be used to add rows to an underlying table if the table has columns with NOT NULL constraints lacking default values which are not referenced in the defining query of the view.
C. Views cannot be used to query rows from an underlying table if the table has a PRIMARY KEY and the PRIMARY KEY columns are not referenced in the defining query of the view.
D. Delete statements can always be done on a table through a view.
E. The WITH CHECK clause has no effect when deleting rows from the underlying table through the view.
F. Views cannot be used to add or modify rows in an underlying table if the defining query of the view contains the DISTINCT keyword.
BEF
Question 17:
You must create a tablespace of non-standard block size in a new file system and plan to use this command:
The standard block size is 8k but other non-standard block sizes will also be used.
Which two are requirements for this command to succeed? (Choose two.)
A. DB_32K_CACHE_SIZE must be less than DB_CACHE_SIZE.
B. DB_32K_CACHE_SIZE must be set to a value that can be accommodated in the SGA.
C. DB_32K_CACHE_SIZE should be set to a value greater than DB_CACHE_SIZE.
D. The /u02 file system must have at least 100g space for the datafile.
E. The operating system must use a 32k block size.
F. DB_CACHE_SIZE must be set to a size that is smaller than DB_32K_CACHE_SIZE.
BD
NEW QUESTION 18.
The customers table has a cust_last_name column of data type varchar2.
The table has two rows whose "jst_last_name values are Anderson and Ausson.
Which query produces output for cust_last_xame containing Oder for the first row and Aus for the second?
A. SELECT REPLACE(REPLACE(cust_last_name, 'son', ''), 'An', 'O') FROM customers;
B. SELECT REPLACE(SUBSTR(cust_last_name, -3), 'An', 'O') FROM customers;
C. SELECT INITCAP (REPLACE(TRIM('son' FROM cust_last_name), 'An', 'O*)) FROM customers;
D. SELECT REPLACE<TRIM<TRAILING 'son* FROM cust_last_name), 'An', *O'> FROM customers;
Answer: A
Question 19.
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?
A. in the undo tablespace
B. in the SYSAUX tablespace
C. in the SGA
D. in the PGA
E. in the temporary tablespace
Correct Answer: E
Question 20.
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.)
A. CURRENT_TIMESTAMP returns the same date and time as SYSDATE with additional details of fractional seconds
B. SYSDATE can be queried only from the DUAL table
C. CURRENT_DATE returns the current date and time as per the session time zone
D. SYSDATE can be used in expressions only if the default date format is DD-MON-RR
E. SYSDATE and CURRENT_DATE return the current date and time set for the operating system of the database server
F. CURRENT_TIMESTAMP returns the same date as CURRENT_DATE
Correct Answer: CF
A - false; it is the same only in case database server operating system uses the same time zone as the operating system of the database client (session time zone)
B - false; can be queried in any table, e.g. SELECT emp_no,ename,salary,mgr_no,sysdate FROM emp;
C - true;
SQL> select sys_extract_utc(systimestamp) from dual;
SYS_EXTRACT_UTC(SYSTIMESTAMP)
---------------------------------------------------------------------------
SQL> SELECT SESSIONTIMEZONE FROM DUAL;
SESSIONTIMEZONE
---------------------------------------------------------------------------
+02:00
SQL> SELECT current_date FROM dual;
CURRENT_DATE
--------------------
11-SEP-2023 15:58:41
D - false; sysdate can be used independently of the setting of the NLS_DATE_FORMAT
E - false; sydate returns date and time of the operating system of the database server, current_date returns date and time in the session time zone (i.e. in the time zone of the client)
F - true; both variables returns current time and date set in the session time zone
Question 21.
Which three statements are true about advanced connection options supported by Oracle Net for connection to Oracle Database instances? (Choose three.)
A. Connect Time Failover requires the use of Transparent Application Failover (TAF)
B. Source Routing requires the use of a name server
C. Source Routing enables the use of Connection Manager (CMAN) which enables network traffic to be routed through a firewall
D. Load Balancing can balance the number of connections to dispatchers when using a Shared Server configuration
E. Load Balancing requires the use of a name server
F. Connect Time Failover requires the connect string to have two or more listener addresses configured
Correct Answer: CDF
Question 22.
Which statement is true about the INTERSECT operator used in compound queries?
A. Multiple INTERSECT operators are not possible in the same SQL statement
B. It processes NULLs in the selected columns
C. INTERSECT is of lower precedence than UNION or UNION ALL
D. It ignores NULLs
Correct Answer: B
Question 23
Which two statements are true about the BIG_TBS tablespace? (Choose two.)
A. AUTOEXTEND is possible for the datafile
B. It must be bigger than the largest SMALLFILE tablespace
C. Additional data files may not be added
D. It will be a dictionary-managed tablespace by default
E. It will always have a 32K blocksize
Correct Answer: AC
Question 24.
Which two statements are true about the PMON background process?
A.It rolls back transactions when a process fails
B.It registers database services with all local and remote listeners known to the database instance
C.It frees unused temporary segments
D.It frees resources held by abnormally terminated processes
E.It records checkpoint information in the control file
AD
Question 25.
Which two are true about reclaiming space used by Flashback logs in Oracle Database 19c and later releases?
A)Space is only reclaimed when there is space pressure in the Fast Recovery Area(FRA)
B)Space is always reclaimed automatically when the retention period for Flashback logs is lowered
C)Space might be reclaimed proactively before space pressure occurs
D)Space is always reclaimed proactively before space pressure occurs
E) Space might be reclaimed automatically when the retention period for Flashback logs is lowered
CE
Question 26.
Which two are true about server-generated alerts?
A)Stateless alerts can be cleared manually
B)Stateless alerts are automatically cleared after one day.
C)Stateful alerts are purged automatically from the alert history after one day
D)Stateless alerts can be purged manually from the alert history.
E) Stateful alerts must be cleared by a DBA to resolve the problem identified in the alert.
AD
Question 27.
Which three are true about upgrading Oracle Grid Infrastructure?
A)The newer version is installed in a separate Oracle Grid Infrastructure home on the same server as the existing version
B)A direct upgrade can be performed only from the immediately preceding Oracle Grid Infrastructure version
C)The upgrade process will automatically install all mandatory patches for the current version of Oracle Grid Infrastructure
D)Only the grid user can perform the upgrade
E)Existing Oracle Database instances must be shut down before starting the upgrade
F）An existing Oracle base can be used.
AEF
Question 28.
Which two are true about the Program Global Area(PGA)and its management in an Oracle database instance?
A)PGA_AGGREGATE_LIMIT is a hard limit on the PGA size for any one session
B)The entire PGA is located in the System Global Area(SGA)when using shared servers
C)The private SQL area(UGA)is located in the System Global Area(SGA)when using shared servers
D)Sorts and Hash Joins use PGA memory.
E) The private SQL area(UGA)is located in the System Global Area(SGA)when using dedicated servers
CD
Question 29.
You plan to perform cross-platform PDB transport using XTTS. Which two are true?
A)A backup of the PDB must exist, taken using the BACKUP command with the TO PLATFORM clause
B) The source PDB can be in MOUNT or OPEN state
C)The source PDB must be in MOUNT state.
D)The source PDB must not be an application root.
E)Automatic conversion of endianess occurs.
F)The source and target platforms must have the same endianess
BF
Question 30.
Which two are true about the automatic execution of operating system scripts when performing silent mode installation starting from Oracle Database 19c?
A) The installer will prompt for the root or sudo password
B) Silent install always runs operating scripts automatically.
C) The response file can specify the root or sudo password
D)The response file must contain the root or sudo password
E) The response file can specify the path of the sudo program
AE
Question 31.
17.Which three statements are true about connection strings and service names used to connect to an Oracle database instance?
A.A connection string must include the SID of a database instance.
B.A single connection string can refer to multiple database instances
C.A connection string including a service name must be defined in the tnsnames.ora file
D.A service name is created by a listener
E.Different connection strings in the same tnsnames. ora file can contain the same service name host and port parameters
F. A single database instance can support connections for multiple service names
BEF
Question 32.
Which two statements are true about substitution variables?
A.A substitution variable used to prompt for a column name must be enclosed in double quotation marks.
B.A substitution variable prefixed with s always prompts only once for a value in a session
C.A substitution variable used to prompt for a column name must be enclosed in single quotation marks
D.A substitution variable prefixed with && prompts only once for a value in a session unless it is set to undefined in the session
E.A substitution variable can be used only in a SELECT statement
F.A substitution variable can be used with any clause in a select statement
DF
Question 33.
Which two statements are true about the configuration and use of UNDO RETENTION with no GUARANTEED RETENTION?
A.Unexpired UNDO is always retained
B.UNDO RETENTION specifies for how long Oracle attempts to keep unexpired UNDO
C.UNDO_RETENTION specifies for how long Oracle attempts to keep expired and unexpired UNDO.
D.UNDO RETENTION specifies how long all types of UNDO are retained
E.Active UNDO is always retained
BE
Question 34.
Which two statements are true about single row functions?
A.FLOOR: retums the smallest integer greater than or equal to a specified number
B.CEIL: can be used for positive and negative numbers
C.CONCAT: can be used to combine any number of values
D.TRUNC: can be used only with NUMBER data types
E.MOD: returns the remainder of a division operation
BE
No comments:
Post a Comment