[Jan-2024] Pass Oracle 1Z0-082 Tests Engine pdf - All Free Dumps
Oracle Database Administration I Practice Tests 2024 | Pass 1Z0-082 with confidence!
NEW QUESTION # 79
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?
- A. The LREG process registers services dynamically with the LISTENER_1 listener
- B. LISTENER_1 must also be defined in the LISTENER.ORA file to enable dynamic service registration
- C. The definition for LISTENER_1 requires a CONNECT_DATA section to enable dynamic service registration
- D. Dynamic service registration cannot be used for this database instance
- E. There are two listeners named LISTENER and LISTENER_1 running simultaneously using port 1521 on the same host as the database instances
Answer: A
Explanation:
The listener forwards client requests to supported services. These services are dynamically registered with the listener. This dynamic registration feature is called service registration. The registration is performed by the Listener Registration (LREG) process. Dynamic service registration does not require any manual configuration in the listener.ora file.
NEW QUESTION # 80
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.)
- A. Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify locations with at least 50 Mb of available space.
- B. Add the AUTOEXTEND ON clause with NEXT set to 100M.
- C. Ensure that DB_CREATE_FILE_DEST specifies a location with at least 100 Mb of available space.
- D. Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify with at least 50 Mb of available space.
- E. Specify a path in the DATAFILE clause of the command specifying a location with at least 100M of available space.
Answer: C,E
NEW QUESTION # 81
The EMPLOYEES table contains columns EMP_ID of data type NUMBER and HIRE_DATE of data type DATE.
You want to display the date of the first Monday after the completion of six months since hiring.
The NLS_TERRITORY parameter is set to AMERICA in the session and, therefore, Sunday is the first day on the wee.
Which query can be used?
- A. SELECT emp_id, NEXT_DAY(ADD_MONTHS(hire_date, 6), 'MONDAY') FROM employees;
- B. SELECT emp_id, NEXT_DAY(ADD_MONTHS(hire_date, 6), 1) FROM employees;
- C. SELECT emp_id, ADD_MONTHS(hire_date, 6), NEXT_DAY('MONDAY') FROM employees;
- D. SELECT emp_id, NEXT_DAY(MONTHS_BETWEEN(hire_date, SYSDATE), 6) FROM employees;
Answer: A
NEW QUESTION # 82
Which two statements are true about the configuration and use of UNDO_RETENTION with GURANTEED ? (Choose two.) RETENTION
- A. UNDO_RETENTION specifies for how long Oracle attempts to keep expired and unexpired UNDO.
- B. UNDO_RETENTION specifies for how long Oracle attempts to keep unexpired UNDO.
- C. UNDO_RETENTION specifies how long all types of UNDO are retained.
- D. Active UNDO is always retained.
- E. Unexpired UNDO is always retained.
Answer: C,E
NEW QUESTION # 83
Which two statements are true about the rules of precedence for operators? (Choose two.)
- A. Arithmetic operators with equal precedence are evaluated from left to right within an expression
- B. The + binary operator has the highest precedence in an expression in a SQL statement
- C. NULLS influence the precedence of operators in an expression
- D. The concatenation operator | | is always evaluated before addition and subtraction in an expression
- E. Multiple parentheses can be used to override the default precedence of operators in an expression
Answer: A,E
Explanation:
Reference:
https://docs.oracle.com/cd/A87860_01/doc/server.817/a85397/operator.htm Precedence is the order in which Oracle evaluates different operators in the same expression. When evaluating an expression containing multiple operators, Oracle evaluates operators with higher precedence before evaluating those with lower precedence. Oracle evaluates operators with equal precedence from left to right within an expression.
NEW QUESTION # 84
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?
- A. ROW STORE COMPRESS ADVANCED
- B. ROW STORE COMPRESS BASIC
- C. COLUMN STORE COMPRESS FOR ARCHIVE LOW
- D. COLUMN STORE COMPRESS FOR QUERY LOW
- E. COLUMN STORE COMPRESS FOR ARCHIVE HIGH
Answer: A
Explanation:
Explanation/Reference: https://www.oracle.com/technetwork/database/options/compression/advanced-compression-wp-
12c-1896128.pdf
NEW QUESTION # 85
Which three functions are performed by dispatchers in a shared server configuration? (Choose three.)
- A. sending each connection input request to the appropriate shared server input queue
- B. broadcasting shared server session responses back to requesters on all connections
- C. checking for outbound shared server responses on the common outbound response queue
- D. receiving inbound requests from processes using shared server connections
- E. writing inbound request to the common request queue from all shared server connections
- F. sending shared server session responses back to requesters on the appropriate connection
Answer: A,D,E
NEW QUESTION # 86
Which two statements are true about undo and undo tablespaces?
- A. An undo tablespace may be owned by only one instance.
- B. undo segments are owned by SYSTEM.
- C. An instance will crash if the active undo tablespace is lost.
- D. There can be only one undo tablespace created in a database.
- E. undo segments are owned by SYSBACKUP.
Answer: A,C
NEW QUESTION # 87
You need to calculate the number of days from 1st January 2019 until today.
Dates are stored in the default format of DD-MON-RR.
Which two queries give the required output? (Choose two.)
- A. SELECT ROUND(SYSDATE - TO_DATE('01/JANUARY/2019')) FROM DUAL;
- B. SELECT ROUND(SYSDATE - '01-JAN-2019') FROM DUAL;
- C. SELECT TO_DATE(SYSDATE, 'DD/MONTH/YYYY') - '01/JANUARY/2019' FROM DUAL;
- D. SELECT TO_CHAR(SYSDATE, 'DD-MON-YYYY') - '01-JAN-2019' FROM DUAL;
- E. SELECT SYSDATE - TO_DATE('01-JANUARY-2019') FROM DUAL;
Answer: B,D
NEW QUESTION # 88
Which two statements are true about the DUAL table? (Choose two.)
- A. It can be accessed by any user who has the SELECT privilege in any schema
- B. It can display multiple rows but only a single column
- C. It can display multiple rows and columns
- D. It can be used to display only constants or pseudo columns
- E. It consists of a single row and single column of VARCHAR2 data type
- F. It can be accessed only by the SYS user
Answer: E,F
Explanation:
https://en.wikipedia.org/wiki/DUAL_table
NEW QUESTION # 89
Examine the description of the members table:
Examine the partial query:
SELECT city, last__name 1NAME FROM members
You want to display all cities that contain the string an. The cities must be returned in ascending order, with the last names further sorted in descending order.
Which two clauses must you add to the query?
- A. ORDER BY 1, LNAME DESC
- B. WHERE city = =%AN%'
- C. WHERE city IN (*%AN%')
- D. ORDER BY last_narae DESC, city ASC
- E. ORDER BY 1, 2
- F. WHERE city LIKE *%AN%*
Answer: A,F
NEW QUESTION # 90
Which three statements are true about sequences in a single instance Oracle database?
- A. Sequences can always have gaps.
- B. A sequence's unallocated cached values are lost if the instance shuts down.
- C. A sequence can Issue duplicate values.
- D. A sequence can only be dropped by a DBA.
- E. A sequence number that was allocated can be rolled back if a transaction fails.
- F. Two or more tables cannot have keys generated from the same sequence.
Answer: B,C,F
NEW QUESTION # 91
Which two statements are true about single row functions? (Choose two.)
- A. CEIL : can be used for positive and negative numbers
- B. FLOOR : returns the smallest integer greater than or equal to a specified number
- C. MOD : returns the quotient of a division operation
- D. TRUNC : can be used with NUMBERand DATEvalues
- E. CONCAT : can be used to combine any number of values
Answer: C,D
Explanation:
Explanation/Reference: https://docs.oracle.com/en/database/oracle/oracle-database/18/sqlrf/Single-Row- Functions.html#GUID-B93F789D-B486-49FF-B0CD-0C6181C5D85C
NEW QUESTION # 92
Which two statements are true about Oracle synonyms?
- A. All private synonym names must be unique in the database.
- B. Any user can create a PUBLIC synonym.
- C. A synonym can have a synonym.
- D. A synonym can be created on an object in a package.
- E. A synonym has an object number.
Answer: C,E
NEW QUESTION # 93
Examine the description of the EMPLOYEES table:
Which query is valid?
- A. SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id;
- B. SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id, join_date;
- C. SELECT dept_id, AVG(MAX(salary)) FROM employees GROUP BY dept_id;
- D. SELECT dept_id, MAX(AVG(salary)) FROM employees GROUP BY dept_id;
Answer: A
NEW QUESTION # 94
Examine the description of the BOOKS table:
The table has 100 rows.
Examine this sequence of statements issued in a new session:
INSERT INTO books VALUES ('ADV112', 'Adventures of Tom Sawyer', NULL,
NULL);
SAVEPOINT a;
DELETE FROM books;
ROLLBACK TO SAVEPOINT a;
ROLLBACK;
Which two statements are true? (Choose two.)
- A. The second ROLLBACK command undoes the insert
- B. The first ROLLBACK command restores the 101 rows that were deleted and commits the inserted row
- C. The second ROLLBACK command replays the delete
- D. The second ROLLBACK command does nothing
- E. The first ROLLBACK command restores the 101 rows that were deleted, leaving the inserted row still to be committed
Answer: A,B
NEW QUESTION # 95
You want to write a query that prompts for two column names and the WHERE condition each time it is executed in a session but only prompts for the table name the first time it is executed.
The variables used in your query are never undefined in your session.
Which query can be used?
- A. SELECT '&&col1', '&&col2'FROM &tableWHERE '&&condition' = '&cond';
- B. SELECT &col1, &col2FROM "&table"WHERE &condition;
- C. SELECT &col1, &col2FROM &&tableWHERE &condition;
- D. SELECT &&col1, &&col2FROM &tableWHERE &&condition;
- E. SELECT &&col1, &&col2FROM &tableWHERE &&condition = &&cond;
Answer: C
NEW QUESTION # 96
Which three statements are true about table data storage in an Oracle Database? (Choose three.)
- A. Multiple row pieces from the same row may be stored in different database blocks
- B. A table row piece can be chained across several database blocks
- C. Index block free space is always contiguous in the middle of the block
- D. Multiple row pieces from the same row may be stored in the same block
- E. Data block headers contain their own Data Block Address (DBA)
- F. Data block free space is always contiguous in the middle of the block
Answer: A,B,F
NEW QUESTION # 97
While one of your databases was in mount state, the datafiles were renamed because they had been moved to a new file system. The database was then opened.
Which two statements are true?
- A. V$DATAFILE displays the new names for the data files.
- B. DBA_DATA_FILES displays the original name for the data files.
- C. DBA_DATA_FILES displays the new name for the data files.
- D. DBA_DATA _FILES displays both the new name and the old name for the data files.
- E. DBA_DATA_FILES must be resynchronized manually with the control file an order to have it display the new file names.
Answer: B,D
NEW QUESTION # 98
Which three statements are true about Oracle synonyms? (Choose three.)
- A. Any user can drop a PUBLIC synonym
- B. A synonym can be available to all users
- C. A SEQUENCE can have a synonym
- D. A synonym cannot be created for a PL/SQL package
- E. A synonym created by one user can refer to an object belonging to another user
Answer: B,C,E
Explanation:
Reference:
https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_7001.htm
NEW QUESTION # 99
Which three statements are true about dropping and unused columns in an Oracle database?
(Choose three.)
- A. A column that is set to UNUSED still counts towards the limit of 1000 columns per table
- B. A DROP COLUMN command can be rolled back
- C. An UNUSED column's space is reclaimed automatically when the block containing that column is next queried.
- D. Partition key columns cannot be dropped.
- E. A primary key column referenced by another column as a foreign key can be dropped if using the CASCADE option.
- F. An UNUSED column's space is reclaimed automatically when the row containing that column is next queried.
Answer: A,C,E
NEW QUESTION # 100
You execute this command:
Sufficient storage is available in filesystem /u01.
Which two statements are true about the BIG_TBS tablespace? (Choose two.)
- A. It will be a dictionary-managed tablespace by default
- B. It must be bigger than the largest SMALLFILE tablespace
- C. It will always have a 32K blocksize
- D. Additional data files may not be added
- E. AUTOEXTEND is possible for the datafile
Answer: B,E
NEW QUESTION # 101
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?
- A. The value is changed only in the PFILE and takes effect at the next instance startup
- B. Change is applied to the current instance, but does not persist after instance restart
- C. The value is changed for the current instance and in the PFILE
- D. It fails because the SCOPE clause is missing
Answer: B
NEW QUESTION # 102
Examine these SQL statements which execute successfully:
Which two statements are true after execution?
- A. The foreign key constraint will be enabled and immediate.
- B. The foreign key constraint will be disabled.
- C. The primary key constraint will be enabled and deferred.
- D. The foreign key constraint will be enabled and deferred.
- E. The primary key constraint will be enabled and immediate.
Answer: B
NEW QUESTION # 103
View the Exhibits and examine the structure of the COSTS and PROMOTIONS tables.
You want to display PROD_IDS whose promotion cost is less than the highest cost PROD_ID in a promotion time interval.
Examine this SQL statement:
Exhibit 1.
Exhibit 2.
What will be the result?
- A. It executes successfully and gives the required result
- B. It gives an error because the GROUP BY clause is not valid
- C. It gives an error because the ALL keyword is not valid
- D. It executes successfully but does not give the required result
Answer: A
NEW QUESTION # 104
......
Online Exam Practice Tests with detailed explanations!: https://examkiller.itexamreview.com/1Z0-082-valid-exam-braindumps.html
