Validate your 1Z0-082 Exam Preparation with 1Z0-082 Practice Test (Online & Offline)
Get all the Information About Oracle 1Z0-082 Exam 2024 Practice Test Questions
NEW QUESTION # 44
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. Load Balancing can balance the number of connections to dispatchers when using a Shared Server configuration
- C. Load Balancing requires the use of a name server
- D. Connect Time Failover requires the connect string to have two or more listener addresses configured
- E. Source Routing requires the use of a name server
- F. Source Routing enables the use of Connection Manager (CMAN) which enables network traffic to be routed through a firewall
Answer: D,E,F
NEW QUESTION # 45
You execute this command:
During the export operation, you detach from the job by using CTRL+C and then execute this command:
Export> STOP_JOB=immediate
Are you sure you wish to stop the job ([yes]/no): yes
Which two statements are true about the job? (Choose two.)
- A. You can reattach to it and monitor it
- B. You can no longer monitor it
- C. It terminates
- D. It continues to run in the background
- E. It is paused and can be resumed
Answer: B,C
Explanation:
https://blog.oracle48.nl/killing-and-resuming-datapump-expdp-and-impdp-jobs/
NEW QUESTION # 46
Which two are true about a SQL statement using SET operators such as UNION? (Choose two.)
- A. The data type of each column returned by the second query must be implicitly convertible to the data type of the corresponding column returned by the first query.
- B. The number, but not names, of columns must be identical for all SELECT statements in the query.
- C. The names and number of columns must be identical for all SELECT statements in the query.
- D. The data type of each column returned by the second query must exactly match the data type of the corresponding column returned by the first query.
- E. The data type group of each column returned by the second query must match the data type of the corresponding column returned by the first query.
Answer: D,E
NEW QUESTION # 47
Which three statements are true about the tools used to configure Oracle Net Services? (Choose three.)
- A. Oracle Net Manager can be used to centrally configure listeners on any database server target
- B. Enterprise Manager Cloud Control can be used to centrally configure listeners on any managed database server
- C. Oracle Net Manager can be used to locally configure naming methods on a database server
- D. The Oracle Net Configuration Assistant is only used when running the Oracle installer
- E. Enterprise Manager Cloud Control can be used to centrally configure net service names for any database server target
- F. The lsnrctl utility requires a listener.ora file to exist before it is started
Answer: A,B,C
NEW QUESTION # 48
Which three statements are true about Oracle synonyms? (Choose three.)
- A. A synonym cannot be created for a PL/SQL package
- B. A synonym can be available to all users
- C. A SEQUENCE can have a synonym
- D. Any user can drop a PUBLIC synonym
- E. A synonym created by one user can refer to an object belonging to another user
Answer: B,C,E
Explanation:
Explanation/Reference: https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_7001.htm
NEW QUESTION # 49
Which two statements are true about Enterprise Manager Database Express? (Choose two.)
- A. The same port number can be used for Database Express configurations for databases on different hosts
- B. It can be used to switch a database into ARCHIVELOGMODE
- C. It can be used to perform database recovery
- D. The same port number can be used for multiple Database Express configurations for multiple databases on the same host
- E. It is available only when the database is open
Answer: B,D
NEW QUESTION # 50
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. Specify a path in the DATAFILE clause of the command specifying a location with at least 100M of available space.
- C. Add the AUTOEXTEND ON clause with NEXT set to 100M.
- D. Ensure that DB_CREATE_FILE_DEST specifies a location with at least 100 Mb of available space.
- E. Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify with at least 50 Mb of available space.
Answer: B,C
NEW QUESTION # 51
Examine the description of the employees table:
Which query requires explicit data type conversion?
- A. SELECT join_date I I ' ' II salary FROM employees;
- B. SELECT SUBSTR<join_date, 1, 2) - 10 FROM employees;
- C. SELECT join_date FROM employees WHERE join_date > '10-02-2018';
- D. SELECT join_date + '20' FROM employees; SELECT salary * '120.50' FROM employees;
Answer: C
NEW QUESTION # 52
Which two statements are true about interval data types?
- A. INTERVAL day to second columns support fractions of seconds.
- B. INTERVAL year to month columns only support monthly Intervals within a single year.
- C. The year field in an interval year to month column must be a positive value.
- D. INTERVAL year TO month columns support yearly intervals.
- E. INTERVAL year to month columns only support monthly intervals within a range of years.
- F. The value in an interval day to SECOND column can be copied into an interval year to month column.
Answer: A,D
NEW QUESTION # 53
Which two statements are true about the DUAL table? (Choose two.)
- A. It can display multiple rows and columns
- B. It can be accessed only by the SYS user
- C. It can be accessed by any user who has the SELECT privilege in any schema
- D. It consists of a single row and single column of VARCHAR2 data type
- E. It can be used to display only constants or pseudo columns
- F. It can display multiple rows but only a single column
Answer: B,D
Explanation:
https://en.wikipedia.org/wiki/DUAL_table
NEW QUESTION # 54
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. Make certain that the database operates in automatic undo management mode
- B. Add the SEGMENT SPACE MANAGEMENT AUTO clause
- C. Add the ONLINE clause
- D. Add the NOLOGGING clause
- E. Set UNDO_TABLESPACE to UNDOTBS01
Answer: A,E
NEW QUESTION # 55
Examine this command:
Which two statements are true?
- A. It overwrites any existing file with the name SALES02.DBF.dbf in /u02 by default.
- B. Tables with one or more extents in this data file may be queried during the execution of this command.
- C. The "to" clause containing the new file name must be specified even if Oracle Managed Files (OMF) is used.
- D. Compressed objects in SALES01.DBF will be uncompressed In SALES02.DBF after the move.
- E. DML may be performed on tables with one or more extents in this data file during the execution of this command.
Answer: B,E
NEW QUESTION # 56
Which two statements are true about single row functions? (Choose two.)
- A. TRUNC : can be used to combine any number of values
- B. MOD : returns the quotient of a division operation
- C. CEIL : can be used for positive and negative numbers
- D. CONCAT : can be used to combine any number of values
- E. FLOOR : returns the smallest integer greater than or equal to a specified number
Answer: A,B
NEW QUESTION # 57
Table ORDER_ITEMS contains columns ORDER_ID, UNIT_PRICE and QUANTITY, of data type NUMBER.
Examine these SQL statements:
Statement 1:
SELECT MAX(unit_price * quantity) "Maximum Order"
FROM order_items;
Statement 2:
SELECT MAX(unit_price * quantity) "Maximum Order"
FROM order_items
GROUP BY order_id;
Which two statements are true?
- A. Both statements will return NULL if either UNIT_PRICE or QUANTITY contains NULL.
- B. Statement 2 may return multiple rows of output.
- C. Statement 2 returns only one row of output.
- D. Statement 1 returns only one row of output.
- E. Both the statements give the same output.
Answer: B,D
Explanation:
https://docs.oracle.com/javadb/10.8.3.0/ref/rrefsqlj27781.html
The Expression can contain multiple column references or expressions, but it cannot contain another aggregate or subquery. It must evaluate to a built-in data type. You can therefore call methods that evaluate to built-in data types. (For example, a method that returns a java.lang.Integer or int evaluates to an INTEGER.) If an expression evaluates to NULL, the aggregate skips that value.
NEW QUESTION # 58
Which three statements are true about a self join? (Choose three.)
- A. It must be an inner join
- B. The ON clause must be used
- C. It can be an outer join
- D. The ON clause can be used
- E. The query must use two different aliases for the table
- F. It must be an equijoin
Answer: A,D,E
Explanation:
Explanation
NEW QUESTION # 59
Examine these SQL statements which execute successfully:
Which two statements are true after execution?
- A. The foreign key constraint will be disabled.
- B. The primary key constraint will be enabled and immediate.
- C. The foreign key constraint will be enabled and deferred.
- D. The foreign key constraint will be enabled and immediate.
- E. The primary key constraint will be enabled and deferred.
Answer: A
NEW QUESTION # 60
Which three statements are true about inner and outer joins? (Choose three.)
- A. A left or right outer join returns only unmatched rows
- B. An inner join returns matched rows
- C. A full outer join must use Oracle syntax
- D. Outer joins can be used when there are multiple join conditions on two tables
- E. Outer joins can only be used between two tables per query
- F. A full outer join returns matched and unmatched rows
Answer: A,B,F
Explanation:
Reference:
https://www.studytonight.com/dbms/joining-in-sql.php
NEW QUESTION # 61
Which three statements are true about time zones, date data types, and timestamp data types in an Oracle database? (Choose three.)
- A. The SESSIONTIMEZONE function can return an offset from Universal Coordinated Time (UTC)
- B. The DBTIMEZONE function can return an offset from Universal Coordinated Time (UTC)
- C. The CURRENT_TIMESTAMP function returns data without time zone information
- D. A TIMESTAMP data type column contains information about year, month, and day
- E. A TIMESTAMP WITH LOCAL TIMEZONE data type column is stored in the database using the time zone of the session that inserted the row
Answer: A,B,C
NEW QUESTION # 62
Which two are true about Oracle recovery and data protection solutions? (Choose two.)
- A. Data Recovery Advisor can be used to validate backup strategies.
- B. RMAN can be used to FLASHBACK a database.
- C. Oracle Data Guard can prevent data loss caused by a site failure.
- D. RMAN can be used to roll back committed transactions.
- E. Data Recovery Advisor can be used to restore a single file from an RMAN backupset.
Answer: B,C
NEW QUESTION # 63
Which two statements are true about single row functions? (Choose two.)
- A. MOD : returns the quotient of a division operation
- 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 with NUMBERand DATEvalues
- E. FLOOR : returns the smallest integer greater than or equal to a specified number
Answer: A,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 # 64
Which two statements are true about the WHERE and HAVING clauses in a SELECT statement? (Choose two.)
- A. The HAVING clause can be used with aggregating functions in subqueries
- B. Aggregating functions and columns used in HAVING clauses must be specified in the SELECT list of a query
- C. The WHERE clause can be used to exclude rows before dividing them into groups
- D. The WHERE clause can be used to exclude rows after dividing them into groups
- E. WHERE and HAVING clauses can be used in the same statement only if applied to different table columns
Answer: A,C
NEW QUESTION # 65
......
Check Real Oracle 1Z0-082 Exam Question for Free (2024): https://actualtests.passsureexam.com/1Z0-082-pass4sure-exam-dumps.html