[Apr 23, 2023] Valid 1Z1-082 Test Answers & Oracle 1Z1-082 Exam PDF
Realistic 1Z1-082 Exam Dumps with Accurate & Updated Questions
NEW QUESTION # 21
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. Change is applied to the current instance, but does not persist after instance restart
- B. The value is changed for the current instance and in the PFILE
- C. It fails because the SCOPE clause is missing
- D. The value is changed only in the PFILE and takes effect at the next instance startup
Answer: A
Explanation:
https://docs.oracle.com/database/121/SQLRF/statements_2017.htm#SQLRF00902
NEW QUESTION # 22
Evaluate these commands which execute successfully:
Which two statements are true about the ORD_ITEMS table and the ORD_SEQ sequence? (Choose two.)
- A. Column ORD_NO gets the next number from sequence ORD_SEQ whenever a row is inserted into ORD_ITEMS and no explicit value is given for ORD_NO
- B. Sequence ORD_SEQ cycles back to 1 after every 5000 numbers and can cycle 20 times
- C. Sequence ORD_SEQ is guaranteed not to generate duplicate numbers
- D. If sequence ORD_SEQ is dropped then the default value for column ORD_NO will be NULL for rows inserted into ORD_ITEMS
- E. Any user inserting rows into table ORD_ITEMS must have been granted access to sequence ORD_SEQ
Answer: A,E
NEW QUESTION # 23
Which two are true about RETENTION GUARANTEE? (Choose two.)
- A. It is a static parameter.
- B. It is a tablespace attribute.
- C. It prevents FLASHBACK DATABASE operation failure.
- D. It prevents "Snapshot too old" errors.
- E. It prevents out-of-space errors.
Answer: B,C
NEW QUESTION # 24
In one of your databases, user KING is:
1. Not a DBA user
2. An operating system (OS) user
Examine this command and its output:
What must you do so that KING is authenticated by the OS when connecting to the database instance?
- A. Unset REMOTE_LOGIN_PASSWORDFILE
- B. Alter user KING to be IDENTIFIED EXTERNALLY
- C. Grant DBA to KING
- D. Set OS_AUTHENT_PREFIX to OPS$
- E. Have the OS administrator add KING to the OSDBA group
Answer: D
Explanation:
https://oracle-base.com/articles/misc/os-authentication
NEW QUESTION # 25
Which two statements are true about interval data types?
- A. INTERVAL day to second columns support fractions of seconds.
- B. The value in an interval day to SECOND column can be copied into an interval year to month column.
- C. INTERVAL year TO month columns support yearly intervals.
- D. INTERVAL year to month columns only support monthly intervals within a range of years.
- E. The year field in an interval year to month column must be a positive value.
- F. INTERVAL year to month columns only support monthly Intervals within a single year.
Answer: A,C
NEW QUESTION # 26
Which two statements are true about the DUAL table? (Choose two.)
- A. It can be used to display only constants or pseudo columns
- B. It can be accessed by any user who has the SELECT privilege in any schema
- C. It can be accessed only by the SYS user
- D. It can display multiple rows and columns
- E. It can display multiple rows but only a single column
- F. It consists of a single row and single column of VARCHAR2 data type
Answer: C,F
NEW QUESTION # 27
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.)
- A. analysis of privileges granted indirectly to a role that are then used by a user who has been granted that role
- B. analysis of privileges granted directly to a role that are then used by a user who has been granted that role
- C. analysis of all privileges used by all users but excluding administrative users in the database
- D. analysis of all privileges used by all users including administrative users in the database
- E. analysis of privileges that a user has on their own schema objects that they did use
- F. analysis of privileges that a user has on their own schema objects that they did not use
Answer: A,D,F
NEW QUESTION # 28
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 with at least 50 Mb of available space.
- B. Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify locations with at least 50 Mb of available space.
- C. Add the AUTOEXTEND ON clause with NEXT set to 100M.
- D. Specify a path in the DATAFILE clause of the command specifying a location with at least 100M of available space.
- E. Ensure that DB_CREATE_FILE_DEST specifies a location with at least 100 Mb of available space.
Answer: C,D
NEW QUESTION # 29
Which two statements are true about trace files produced by the Oracle Database server? (Choose two.)
- A. Trace file names are based on the database name concatenated with a sequential number
- B. All trace files contain error information that require contacting Oracle Support
- C. They can be written by server processes
- D. They can be written by background processes
- E. Trace files are written to the Fast Recovery Area (FRA)
Answer: C,D
Explanation:
Reference:
https://gerardnico.com/db/oracle/trace_file
https://docs.oracle.com/html/E25494_01/monitoring001.htm
Each server and background process can write to an associated trace file. When an internal error is detected by a process, it dumps information about the error to its trace file. Some of the information written to a trace file is intended for the database administrator, and other information is for Oracle Support Services. Trace file information is also used to tune applications and instances.
NEW QUESTION # 30
The SCOTT/TIGER user exists in two databases, BOSTON_DB and DALLAS_DB, in two different locations.
Each database has a tnsnames.ora file defining DALLAS_DB as a service name.
Examine this command:
CREATE DATABASE LINK dblink1 CONNECT TO scott IDENTIFIED BY tiger USING 'dallas_db'; How do you execute the command so that only SCOTT in BOSTON_DB can access the SCOTT schema in DALLAS_DB?
- A. as SCOTT in DALLAS_DB
- B. as SCOTT in BOSTON_DB and SYS in DALLAS_DB
- C. as SCOTT in both the databases
- D. as SCOTT in BOSTON_DB
- E. as SYS in both the databases
Answer: D
Explanation:
https://docs.oracle.com/cd/B28359_01/server.111/b28310/ds_concepts002.htm#ADMIN12085 Database links are either private or public. If they are private, then only the user who created the link has access; if they are public, then all database users have access.
https://docs.oracle.com/database/121/SQLRF/statements_5006.htm#SQLRF01205
NEW QUESTION # 31
Which two statements are true about the WHERE and HAVING clauses in a SELECT statement?
(Choose two.)
- A. The WHERE clause can be used to exclude rows after dividing them into groups
- B. The HAVING clause can be used with aggregating functions in subqueries
- C. WHERE and HAVING clauses can be used in the same statement only if applied to different table columns
- D. The WHERE clause can be used to exclude rows before dividing them into groups
- E. Aggregating functions and columns used in HAVING clauses must be specified in the SELECT list of a query
Answer: B,D
NEW QUESTION # 32
Which two are true about shrinking a segment online? (Choose two.)
- A. To shrink a table it must have row movement enabled
- B. To shrink a table it must have a PRIMARY KEY constraint
- C. It always eliminates all migrated rows if any exist in the table
- D. It is not possible to shrink either indexes or Index Organized Tables (IOTs)
- E. It must be in a tablespace that uses Automatic Segment Space Management (ASSM)
- F. To shrink a table it must have a UNIQUE KEY constraint
Answer: A,E
NEW QUESTION # 33
Examine the description of the employees table:
Which query requires explicit data type conversion?
- A. SELECT join_date + '20' FROM employees; SELECT salary * '120.50' FROM employees;
- B. SELECT join_date FROM employees WHERE join_date > '10-02-2018';
- C. SELECT SUBSTR<join_date, 1, 2) - 10 FROM employees;
- D. SELECT join_date I I ' ' II salary FROM employees;
Answer: B
NEW QUESTION # 34
A user complains about poor database performance. You suspect that the user's session is waiting for an event to complete.
You want to verify this.
Which two views may reveal for what the user's session is currently waiting? (Choose two.)
- A. V$SESSION_EVENT
- B. V$SYSTEM_EVENT
- C. V$SESSION_WAIT
- D. V$SESSION
- E. V$SESSION_WAIT_CLASS
Answer: A,C
NEW QUESTION # 35
Which three functions are performed by dispatchers in a shared server configuration? (Choose three.)
- A. writing inbound request to the common request queue from all shared server connections
- B. sending shared server session responses back to requesters on the appropriate connection
- C. receiving inbound requests from processes using shared server connections
- D. broadcasting shared server session responses back to requesters on all connections
- E. sending each connection input request to the appropriate shared server input queue
- F. checking for outbound shared server responses on the common outbound response queue
Answer: A,B,C
Explanation:
https://docs.oracle.com/cd/B28359_01/server.111/b28310/manproc001.htm#ADMIN11168
NEW QUESTION # 36
Which two tasks can be performed in the NOMOUNT state? (Choose two.)
- A. full database recovery
- B. renaming data files
- C. creating a database
- D. re-creating control files
- E. enabling online redo log archiving
Answer: C,D
NEW QUESTION # 37
Examine the description of the CUSTOMERS table:
For customers whose income level has a value, you want to display the first name and due amount as 5% of their credit limit. Customers whose due amount is null should not be displayed.
Which query should be used?
- A. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT
FROM customers
WHERE cust_income_level <> NULL
AND due_amount <> NULL; - B. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT
FROM customers
WHERE cust_income_level IS NOT NULL
AND due_amount IS NOT NULL; - C. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT
FROM customers
WHERE cust_income_level IS NOT NULL
AND cust_credit_limit IS NOT NULL; - D. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT
FROM customers
WHERE cust_income_level != NULL
AND cust_credit_level !=NULL; - E. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT
FROM customers
WHERE cust_income_level != NULL
AND due_amount != NULL;
Answer: C
NEW QUESTION # 38
The INVOICE table has a QTY_SOLD column of data type NUMBER and an INVOICE_DATE column of data type DATE.
NLS_DATE_FORMAT is set to DD-MON-RR.
Which two are true about data type conversions involving these columns in query expressions?
(Choose two.)
- A. invoie_date > '01-02-2019' : uses implicit conversion
- B. qty_sold = `0554982' uses implicit conversion
- C. CONCAT (qty_sold, invoice_date) : requires explicit conversion
- D. invoice_date = '15-march-2019' : uses implicit conversion
- E. qty_sold BETWEEN `101' AND '110' : uses implicit conversion
Answer: D,E
NEW QUESTION # 39
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?
- A. UNION
- B. UNION ALL
- C. MINUS
- D. INTERSECT
- E. SUBTRACT
Answer: C
NEW QUESTION # 40
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. DBA_DATA _FILES displays both the new name and the old name for the data files.
- B. DBA_DATA_FILES must be resynchronized manually with the control file an order to have it display the new file names.
- C. DBA_DATA_FILES displays the original name for the data files.
- D. DBA_DATA_FILES displays the new name for the data files.
- E. V$DATAFILE displays the new names for the data files.
Answer: A,C
NEW QUESTION # 41
Which three statements are true regarding single row subqueries?
- A. They must return a row to prevent errors in the SQL statement.
- B. They can be used in the where clause.
- C. They must be placed on the right side of the comparison operator or condition.
- D. They can be used in the having clause.
- E. They must be placed on the left side of the comparison operator or condition.
- F. A SQL statement may have multiple single row subquery blocks.
Answer: B,D,F
NEW QUESTION # 42
You execute this command:
CREATE SMALLFILE TABLESPACE sales
DATAFILE '/u01/app/oracle/sales01.dbf
SIZE 5G
SEGMENT SPACE MANAGEMENT AUTO;
Which two actions must you take to ensure UNDOTBS01 is used as the default UNDO tablespace? (Choose two.)
- A. Any data files added to the tablespace must have a size of 5 gigabytes
- B. It uses the database default blocksize
- C. It must be smaller than the smallest BIGFILE tablespace
- D. It is a locally managed tablespace
- E. Free space is managed using freelists
Answer: B,D
Explanation:
Explanation/Reference:
NEW QUESTION # 43
......
1Z1-082 Exam Dumps - PDF Questions and Testing Engine: https://testking.realvce.com/1Z1-082-VCE-file.html