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
Which three instance situations are possible with the Oracle Database server without multi-tenant? (Choose three.)
Answer: ABD
A: RAC 2,3 or 4 nodes B: Single instance (standalone) with database C: one instance running multiple INDEPENDENT databases!! D: Single instance (standalone) without database E: absurd configuration! corrects are A, B and D
Source: Adapted from community discussion — ama
Which statement is true about the INTERSECT operator used in compound queries?
Answer: B
SELECT 1, 2 FROM DUAL UNION SELECT 2, 3 FROM DUAL INTERSECT SELECT NULL, NULL FROM DUAL INTERSECT SELECT NULL, NULL FROM DUAL; returns "no data found".
Source: Adapted from community discussion — ora404
Which two statements are true about the ORDER BY clause when used with a SQL statement containing a SET operator such as UNION? (Choose two.)
Answer: BC
Which four account management capabilities can be configured using Oracle profiles? (Choose four.)
Answer: BDEF
A D E F A. the number of hours for which an account is locked after the configured number of login attempts has been reached -- [it accepts in days,you can enter fraction of days to achieve hours]. B. the number of days for which an account may be inactive before it is locked [Inactive is not a state for an account] C. the maximum amount of CPU time allowed for a user's sessions before their account is locked [account never get locked in such settings] D. the ability to prevent a password from ever being reused [PASSWORD_REUSE_MAX] E. the number of password changes required within a period of time before a password can be reused [PASSWORD_REUSE_TIME] F. the number of days for which an account is locked after the configured number of login attempts has been reached [PASSWORD_LOCK_TIME] G. the maximum number of sessions permitted for a user before the account is locked [account never get locked in such settings]
Source: Adapted from community discussion — avanand
Which three statements are true about single-row functions? (Choose three.)
Answer: BCD
B,C,D A - Incorrect -> Documentation: "can appear in select lists, WHERE clauses, START WITH and CONNECT BY clauses, and HAVING clauses." B - Correct -> EXAMPLE: select lower(&data), lower(DUMMY), lower('TABLE'),LOWER(TO_DATE('12-JAN-08','DD-MONTH-RR')) from dual; RESULT: 12-jan-21 x table 12-jan-08 C - Correct -> Like in length or months_between D - Correct -> there's no limit in documentation. EXAMPLE: select instr(substr(decode(mod(6,4),4,'abcabcabc',1,'bcabcabca','cabcabcab'),4),'abc') from dual; RESULT: 2 E - Incorrect -> Functions like substr, accepts more than one parameter F - Incorrect -> Here's a catch, documentation: "Single-row functions return a single result row for every row of a queried table or view" NOT "...return a single result row per table"
Source: Adapted from community discussion — dbaclaudio
You want to use table compression suitable for OLTP that will: 1. Compress rows for all DML statements on that table 2. Minimize the overheads associated with compression Which compression option is best suited for this?
Answer: E
https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-TABLE.html#GUID-F9CE0CC3-13AE-4744-A43C-EAC7A71AAAB6 When you enable table compression by specifying ROW STORE COMPRESS ADVANCED, you enable Advanced Row Compression. Oracle Database compresses data during all DML operations on the table. This form of compression is recommended for OLTP environments.
Source: Adapted from community discussion — nautil2
Which two statements are true about space-saving features in an Oracle Database? (Choose two.)
Answer: AB
i agree with AB A - https://oracle-base.com/articles/18c/private-temporary-tables-18c Oracle 18c introduced the concept of a private temporary table, a memory-based temporary table that is dropped at the end of the session or transaction depending on the setup. B - https://docs.oracle.com/html/E25494_01/indexes003.htm#CIHFIGDG Beginning with Oracle Database 11g Release 2, the database does not create an index segment when creating an unusable index. C - not always, depends on the setup of the table creation
Source: Adapted from community discussion — NowOrNever
In which three situations does a new transaction always start? (Choose three.)
Answer: ADF
ADE should be correct https://docs.oracle.com/en/database/oracle/oracle-database/19/cncpt/transactions.html#GUID-7690181F-8293-47B9-ADC1-905BD9C3AF57 • A transaction begins when the first executable SQL statement is encountered. An executable SQL statement is a SQL statement that generates calls to a database instance, including DML and DDL statements and the SET TRANSACTION statement. • A transaction ends when any of the following actions occurs: o A user issues a COMMIT or ROLLBACK statement without a SAVEPOINT clause. Answer D o A user runs a DDL command such as CREATE, DROP, RENAME, or ALTER. The database issues an implicit COMMIT statement before and after every DDL statement. If the current transaction contains DML statements, then Oracle Database first commits the transaction and then runs and commits the DDL statement as a new, single-statement transaction. o SELECT do not have a transaction start/end. Check by command: SELECT XID AS "txn id", XIDUSN AS "undo seg", XIDSLOT AS "slot", XIDSQN AS "seq", STATUS AS "txn status" FROM V$TRANSACTION;
Source: Adapted from community discussion — dotruonghan
Examine the description of the SALES1 table:
SALES2 is a table with the same description as SALES1. Some sales data is duplicated in both tables. You want to display the rows from the SALES1 table which are not present in the SALES2 table. Which set operator generates the required output?
Answer: E
Your database instance is started with a PFILE. Examine these parameters:
You want to increase the size of the buffer cache. Free memory is available to increase the size of the buffer cache. You execute the command: SQL> ALTER SYSTEM SET DB_CACHE_SIZE=1024M; What is the outcome?
Answer: D
Correct Answer: D, the change is applied in memory only, the change does not persist as the database can't write to the pfile The default SCOPE option, when you start the instance using a PFILE, is MEMORY (as well as the only scope option you can use with a pfile). If scope is omitted the default scope option is used instead. The SCOPE clause is optional and not mandatory when changing the value of a parameter! A is wrong, as the pfile is a read only file for the database so it can't write to it. Changes to the pfile have to be done manually by changing it directly using f.e. vi on unix systems. B is wrong, same reason as for why answer A is wrong C is wrong, as mentioned above, when omitted the scope clause defaults to MEMORY when using a pfile. Not related to that question but the more you know: When starting the database using a spfile you have three options for the scope (MEMORY, SPFILE and BOTH). Default value is BOTH.
Source: Adapted from community discussion — adoptc94
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
1Z0-082 practice, question 81. 167 questions available.
Version 1.0.0. How we source questions