Oracle Database Administration I167 questions across 17 pages are complete and free, with no account or card.
167 questions in this bank
Free access · progress saved on this device
What is true about non-equijoin statement performance? (Choose two.)
Answer: AC
Dear all, AC is correct answer for sure i faced this question in 1z0-071 exam and i select AC and got correct answers :) Regards.
Source: Adapted from community discussion — khalilshahin01
In your data center, Oracle Managed Files (OMF) is used for all databases. All tablespaces are smallfile tablespaces. SALES_Q1 is a permanent user-defined tablespace in the SALES database. Examine this command which is about to be issued by a DBA logged in to the SALES database: ALTER TABLESPACE sales_q1 ADD DATAFILE; Which are two actions, either one of which you could take to ensure that the command executes successfully? (Choose two.)
Answer: BC
BC are the correct one https://oracle-base.com/articles/9i/oracle-managed-files - Files typically have a default size of 100M - if OMF is used you do not need to specify a path for the new created datafile BUT we have to "ensure that the command executes successfully" so we need a location with at least 100 MB free space and we can ensure that with B or C
Source: Adapted from community discussion — NowOrNever
Examine this command and some partial output:
Why does the DB01.abc.com service show unknown status?
Answer: C
59 A - false; if a service is registered dynamically, its status handler is either READY, RESTRICTED or BLOCKED. UNKNOWN handler refers to static service registration B - false; LOCAL_LISTENER parameter can be set regardless static or dynamic registration is used C - true; service is registered statically using SID_LIST keyword in the config file listener.ora D - false; listener port does not affect status handler E - false; when SID_LIST_LISTENER is contained in listener.ora file, statical service registration is configured
Source: Adapted from community discussion — nautil2
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?
Answer: B
A - false; does not meet condition 3, because this interval does not store days B - true; this interval can store days C - false; cannot store period D - false; cannot store period E - false; cannot store period
Source: Adapted from community discussion — nautil2
Which three statements are true about the tools used to configure Oracle Net Services? (Choose three.)
Answer: DEF
Answer: D,E,F Explanation: https://docs.oracle.com/en/database/oracle/oracle-database/19/netag/introducing-oracle-net-services.html#GUID-6B1F0584-887D-4D2A-B982-40ACF15DF985 • Oracle Enterprise Manager Cloud Control combines configuration functionality across multiple file systems, along with listener administrative control to provide an integrated environment for configuring and managing Oracle Net Services. • Oracle Net Manager provides configuration functionality for an Oracle home on a local client or server host.
Source: Adapted from community discussion — dotruonghan
Which two statements are true regarding the UNION and UNION ALL operators? (Choose two.)
Answer: BE
A - false B - true C - false D - false E - true Sources: Oracle Documentation: Database > Oracle > Oracle Database > Release 19 > SQL Language Reference > 9 SQL Queries and Subqueries > a) The UNION [ALL], INTERSECT, MINUS Operators, b) Sorting Query Results A The UNION ALL operator does not eliminate duplicate selected rows B,C The corresponding expressions in the select lists of the component queries of a compound query must match in number and must be in the same data type group (such as numeric or character). D For compound queries containing set operators UNION, INTERSECT, MINUS, or UNION ALL, the ORDER BY clause must specify positions or aliases rather than explicit expressions. Also, the ORDER BY clause can appear only in the last component query. The ORDER BY clause orders all rows returned by the entire compound query.
Source: Adapted from community discussion — nautil2
Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.)
Answer: CD
I think C D. The database, Oracle Automatic Storage Management (Oracle ASM), the listener, Oracle Clusterware, and other Oracle products or components store all diagnostic data in the ADR. https://docs.oracle.com/database/121/ADMIN/diag.htm#ADMIN11260
Source: Adapted from community discussion — elcaso34
You want to apply the principle of Least Privilege in all your live databases. One of your requirements is to revoke unnecessary privileges from all users who have them using Privilege Analysis. Which three types of analyses can be done using the DBMS_PRIVILEGE_CAPTURE package? (Choose three.)
Answer: CDF
Reference: https://docs.oracle.com/database/121/ARPLS/d_priv_prof.htm#ARPLS74328
Source: Adapted from community discussion — Guhborges
Which three statements are true about undo segments and the use of undo by transactions in an Oracle database instance? (Choose three.)
Answer: ABD
F and G are both false! While the default is smallfile you can also create a bigfile undo tablespace which means both smallfile and bigfile are possible for undo tablespaces E is also false as each transaction is assigned to only one undo segment, but an undo segment can service more than one transaction at a time -> A is right Which leaves us with B,C,D as possible answers. B and D are true -> taken from the Oracle Administrator Workshop Studyguide: Transactions and Undo Data (14 - 5): If an extent fills up and more space is needed, the transaction acquires that space from the next extent in the segment. After all extents have been consumed, the transaction either wraps around back into the first extent or requests a new extent to be allocated to the undo segment (supporting answers B and D) The right answers for this question are: A,B,D I would also say that C is false as I am pretty sure that UNDO segments have a minimum of 2 extents (and not 3 extents) to support the circular use of undo segments and this can be achieved by a minimum of 2 extents
Source: Adapted from community discussion — adoptc94
Table EMPLOYEES contains columns including EMPLOYEE_ID, JOB_ID and SALARY. Only the EMPLOYEE_ID column is indexed. Rows exist for employees 100 and 200. Examine this statement:
Which two statements are true? (Choose two.)
Answer: AD
AD The correct options Example : CREATE TABLE EMPLOYES (EMP_ID NUMBER NOT NULL, EMP_NAME VARCHAR2(40), DEPT_ID NUMBER(2), SALARY NUMBER(8,2), JOIN_DATE DATE); insert into employes VALUES (1,'RICARDO',01,1200,'01/03/2024'); insert into employes values (2,'FERNANDO',02,1500,'01/02/2024'); update employes set (dept_id,salary)= (select dept_id,salary from employes where emp_id=2) where emp_id=1; This has updated the value of the salary and dept_id (equivalent to job_id) of employee 1 (equivalent to 100) by the value of employee 2 (equivalent to 200)
Source: Adapted from community discussion — Oracle2020
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
1Z0-082 practice, question 121. 167 questions available.
Version 1.0.0. How we source questions