1Z0-082 Dumps PDF - 1Z0-082 Real Exam Questions Answers
Get Started: 1Z0-082 Exam [2021] Dumps Oracle PDF Questions
NEW QUESTION 36
Which two tasks can you perform using DBCA for databases? (Choose two.)
- A. Configure incremental backups for a new database
- B. Enable flashback database for an existing database
- C. Configure a nonstandard block size for a new database
- D. Register a new database with an available Enterprise Manager Management server
- E. Change the standard block size of an existing database
Answer: D,E
Explanation:
Explanation/Reference: https://docs.oracle.com/cd/B16254_01/doc/server.102/b14196/install003.htm
NEW QUESTION 37
Which three statements are true about the tools used to configure Oracle Net Services? (Choose three.)
- A. The Oracle Net Configuration Assistant is only used when running the Oracle installer
- B. Oracle Net Manager can be used to centrally configure listeners on any database server target
- C. Enterprise Manager Cloud Control can be used to centrally configure net service names for any database server target
- D. The lsnrctl utility requires a listener.ora file to exist before it is started
- E. Enterprise Manager Cloud Control can be used to centrally configure listeners on any managed database server
- F. Oracle Net Manager can be used to locally configure naming methods on a database server
Answer: B,E,F
NEW QUESTION 38
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 IS NOT NULL AND cust_credit_limit IS NOT NULL;
- B. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT FROM customers WHERE cust_income_level <> NULL AND due_amount <> NULL;
- C. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT FROM customers WHERE cust_income_level != NULL AND due_amount != 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 IS NOT NULL AND due_amount IS NOT NULL;
Answer: A
NEW QUESTION 39
Which two are true about the roles? (Choose two.)
- A. The SET ROLE statement enables as well as disables roles in a session.
- B. A role must be disabled before it can be revoked from a user.
- C. The ALTER USER statement must be used to set specific default roles for a user.
- D. The SET ROLE statement can be used once per session.
- E. All privileges and roles granted to a user are enabled by default when the user logs in.
Answer: A,E
NEW QUESTION 40
Which three statements are true about advanced connection options supported by Oracle Net for connection to Oracle Database instances? (Choose three.)
- A. Source Routing requires the use of a name server
- B. Connect Time Failover requires the use of Transparent Application Failover (TAF)
- C. Source Routing enables the use of Connection Manager (CMAN) which enables network traffic to be routed through a firewall
- D. Connect Time Failover requires the connect string to have two or more listener addresses configured
- E. Load Balancing can balance the number of connections to dispatchers when using a Shared Server configuration
- F. Load Balancing requires the use of a name server
Answer: C,D,E
Explanation:
https://docs.oracle.com/en/database/oracle/oracle-database/12.2/rilin/shared-server-configuration-for-an-oracle-rac-database.html#GUID-2EFBA08D-FEEE-407F-BC42-E548DA946DF9
NEW QUESTION 41
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 42
Examine this SQL statement:
SELECT cust_id, cust_last_name "Last Name"
FROM customers
WHERE country_id = 10
UNION
SELECT cust_id CUST_NO, cust_last_name
FROM customers
WHERE country_id = 30
Identify three ORDER BY clauses, any one of which can complete the query successfully.
(Choose three.)
- A. ORDER BY "CUST_NO"
- B. ORDER BY CUST_NO
- C. ORDER BY "Last Name"
- D. ORDER BY 2, 1
- E. ORDER BY 2, cust_id
Answer: C,D,E
NEW QUESTION 43
Which two statements are true about trace files produced by the Oracle Database server? (Choose two.)
- A. They can be written by background processes
- B. They can be written by server processes
- C. Trace files are written to the Fast Recovery Area (FRA)
- D. All trace files contain error information that require contacting Oracle Support
- E. Trace file names are based on the database name concatenated with a sequential number
Answer: A,B
Explanation:
Explanation/Reference: https://gerardnico.com/db/oracle/trace_file
NEW QUESTION 44
Examine this description of the TRANSACTIONS table:
Which two SQL statements execute successfully? (Choose two.)
- A. SELECT customer_id CUSTID, transaction_date TRANS_DATE, amount + 100 DUES FROM transactions;
- B. SELECT customer_id AS "CUSTOMER-ID", transaction_date AS DATE, amount + 100 "DUES" FROM transactions;
- C. SELECT customer_id AS 'CUSTOMER-ID', transaction_date AS DATE, amount + 100 'DUES AMOUNT' FROM transactions;
- D. SELECT customer_id AS CUSTOMER-ID, transaction_date AS TRANS_DATE, amount + 100 "DUES AMOUNT" FROM transactions;
- E. SELECT customer_id AS "CUSTOMER-ID", transaction_date AS "DATE", amount + 100 DUES FROM transactions;
Answer: A,E
NEW QUESTION 45
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 TO_CHAR(SYSDATE,'DD-MON-YYYY') - '01-JAN-2019' FROM DUAL;
- C. SELECT SYSDATE - TO_DATE('01-JANUARY-2019') FROM DUAL;
- D. SELECT TO_DATE(SYSDATE, 'DD/MONTH/YYYY') - '01/JANUARY/2019' FROM DUAL;
- E. SELECT ROUND(SYSDATE - '01-JAN-2019') FROM DUAL;
Answer: A,C
NEW QUESTION 46
Your database instance was shut down normally and then started in NOMOUNT state. You then execute this command:
ALTER DATABASE MOUNT;
Which two actions are performed? (Choose two.)
- A. The Oracle background processes are started
- B. The initialization parameter file is read
- C. The control file is read
- D. The alert log records the execution details
- E. The online data files are opened
- F. The online redo logs are opened
Answer: C,D
Explanation:
http://facedba.blogspot.com/2014/07/oracle-database-startup-stages-and.html
NEW QUESTION 47
You execute this command:
CREATE SMALLFILE TABLESPACE sales
DATAFILE '/u01/app/oracle/sales01.dbf
SIZE 5G
SEGMENT SPACE MANAGEMENT AUTO;
Which two statements are true about the SALES tablespace? (Choose two.)
- A. Any data files added to the tablespace must have a size of 5 gigabytes
- B. It must be smaller than the smallest BIGFILE tablespace
- C. It uses the database default blocksize
- D. Free space is managed using freelists
- E. It is a locally managed tablespace
Answer: C,E
NEW QUESTION 48
Table ORDER_ITEMScontains columns ORDER_ID, UNIT_PRICEand 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. Statement 2 returns only one row of output.
- B. Statement 2 may return multiple rows of output.
- C. Statement 1 returns only one row of output.
- D. Both statements will return NULL if either UNIT_PRICE or QUANTITY contains NULL.
- E. Both the statements give the same output.
Answer: B,D
NEW QUESTION 49
In the ORCL database, UNDOTBS1 is the active undo tablespace with these properties:
1. A size of 100 MB
2. AUTOEXTEND is off
3. UNDO_RETENTION is set to 15 minutes
4. It has RETENTION GUARANTEE
UNDOTBS1 fills with uncommitted undo 10 minutes after the database opens.
What will happen when the next update is attempted by any transaction?
- A. It succeeds and the least recently read undo block of UNDOTBS1 is overwritten by the generated undo.
- B. It succeeds and the generated undo is stored in SYSTEM.
- C. It fails and returns the error message "ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS1'".
- D. It succeeds and the least recently written undo block of UNDOTBS1 is overwritten by the generated undo.
- E. It succeeds and the generated undo is stored in SYSAUX.
Answer: C
Explanation:
To guarantee the success of long-running queries or Oracle Flashback operations, you can enable retention guarantee. If retention guarantee is enabled, the specified minimum undo retention is guaranteed; the database never overwrites unexpired undo data even if it means that transactions fail due to lack of space in the undo tablespace. If retention guarantee is not enabled, the database can overwrite unexpired undo when space is low, thus lowering the undo retention for the system. This option is disabled by default.
NEW QUESTION 50
Which three are types of segments in an Oracle Database? (Choose three.)
- A. tables
- B. undo
- C. stored procedures
- D. clusters
- E. sequences
- F. index
Answer: A,D,F
Explanation:
Explanation/Reference: http://www.adp-gmbh.ch/ora/concepts/segments.html
NEW QUESTION 51
Examine this description of the TRANSACTIONS table:
Which two SQL statements execute successfully? (Choose two.)
SELECT customer_id AS "CUSTOMER-ID", transaction_date AS DATE, amount + 100
- A. transactions;
SELECT customer_id AS 'CUSTOMER-ID', transaction_date AS DATE, amount + 100 - B. DUES FROM transactions;
SELECT customer_id AS CUSTOMER-ID, transaction_date AS TRANS_DATE, amount + - C. "DUES" FROM transactions;
SELECT customer_id AS "CUSTOMER-ID", transaction_date AS "DATE", amount + 100 - D. 'DUES AMOUNT' FROM transactions;
- E. 100 "DUES AMOUNT" FROM transactions;
SELECT customer_id CUSTID, transaction_date TRANS_DATE, amount + 100 DUES FROM
Answer: A,B
NEW QUESTION 52
Which three statements are true about Oracle synonyms? (Choose three.)
- A. A synonym can be available to all users
- B. A synonym cannot be created for a PL/SQL package
- 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: A,C,E
Explanation:
Explanation/Reference: https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_7001.htm
NEW QUESTION 53
In the SALES database, DEFERRED_SEGMENT_CREATION is TRUE.
Examine this command:
SQL> CREATE TABLE T1(c1 INT PRIMARY KEY, c2 CLOB);
Which segment or segments, if any, are created as a result of executing the command?
- A. T1 only
- B. T1, an index segment for the primary key, and a LOB segment only
- C. T1, an index segment for the primary key, a LOB segment, and a lobindex segment
- D. no segments are created
- E. T1 and an index segment created for the primary key only
Answer: D
NEW QUESTION 54
Which three statements are true about dropping and unused columns in an Oracle database?
(Choose three.)
- A. A primary key column referenced by another column as a foreign key can be dropped if using the CASCADE option.
- B. An UNUSED column's space is reclaimed automatically when the row containing that column is next queried.
- C. An UNUSED column's space is reclaimed automatically when the block containing that column is next queried.
- D. A column that is set to UNUSED still counts towards the limit of 1000 columns per table
- E. A DROP COLUMN command can be rolled back
- F. Partition key columns cannot be dropped.
Answer: A,C,D
NEW QUESTION 55
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 that a user has on their own schema objects that they did use
- C. analysis of all privileges used by all users but excluding administrative users in the database
- D. analysis of privileges that a user has on their own schema objects that they did not use
- E. analysis of privileges granted directly to a role that are then used by a user who has been granted that role
- F. analysis of all privileges used by all users including administrative users in the database
Answer: A,D,F
NEW QUESTION 56
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 &table
WHERE `&&condition' = `&cond'; - B. SELECT &&col1, &&col2
FROM &table
WHERE &&condition; - C. SELECT &col1, &col2
FROM "&table"
WHERE &condition; - D. SELECT &&col1, &&col2
FROM &table
WHERE &&condition = &&cond; - E. SELECT &col1, &col2
FROM &&table
WHERE &condition;
Answer: E
NEW QUESTION 57
Which three statements are true about table data storage in an Oracle Database? (Choose three.)
- A. Index block free space is always contiguous in the middle of the block
- B. Data block free space is always contiguous in the middle of the block
- C. Multiple row pieces from the same row may be stored in the same block
- D. Multiple row pieces from the same row may be stored in different database blocks
- E. A table row piece can be chained across several database blocks
- F. Data block headers contain their own Data Block Address (DBA)
Answer: D,E,F
Explanation:
Reference:
https://antognini.ch/2016/10/whats-the-difference-between-row-migration-and-row-chaining/
NEW QUESTION 58
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.)
- A. Employee 100 will have JOB_ID set to the same value as the JOB_ID of employee 200
- B. Employee 100 will have SALARY set to the same value as the SALARY of employee 200
- C. Employees 100 and 200 will have the same SALARY as before the update command
- D. Employee 200 will have SALARY set to the same value as the SALARY of employee 100
- E. Employee 200 will have JOB_ID set to the same value as the JOB_ID of employee 100
- F. Employees 100 and 200 will have the same JOB_ID as before the update command
Answer: B,E
NEW QUESTION 59
The CUSTOMERS table has a CUST_CREDIT_LIMIT column of data type NUMBER.
Which two queries execute successfully? (Choose two.)
- A. SELECT NVL(TO_CHAR(cust_credit_limit * .15), 'Not Available') FROM customers;
- B. SELECT TO_CHAR(NVL(cust_credit_limit * .15, 'Not Available')) FROM customers;
- C. SELECT NVL2(cust_credit_limit * .15, 'Not Available') FROM customers;
- D. SELECT NVL(cust_credit_limit * .15, 'Not Available') FROM customers;
- E. SELECT NVL2(cust_credit_limit, TO_CHAR(cust_credit_limit * .15), 'Not Available') FROM customers;
Answer: A,E
NEW QUESTION 60
In one of your databases, the user HR has the password HRMGR.
You want to connect to a database instance whose listener listens on port 1531 by using this statement:
CONNECT HR/HRMGR@orcl
No name server is used.
Which statement is true about ORCL?
- A. It must be the name of the server running the database to whose instance HR wishes to connect
- B. It must resolve to a valid connect descriptor in the server's tnsnames.ora file
- C. It must be the value of the SERVICE_NAMES parameter on the client side
- D. It must resolve to a valid connect descriptor in the client's tnsnames.ora file
- E. It must be the name of the database to whose instance HR wishes to connect
Answer: A
NEW QUESTION 61
......
Introduction to Oracle 1z0-082: Oracle Database Adminstration 1 Exam
Oracle Database 12c: RAC and Grid Infrastructure Administration Exam assess the abilities of the Database Administrators and System Administrators who have at least 1 year of experience in RAC and Grid Infrastructure. The candidates should have the ability to install, manage, tracking, tuning and restoring RAC databases, cluster, and Oracle Automatic Storage Management (ASM). They should have a good understanding of the architectures of the ASM, Clusterware, and Oracle RAC databases. They should also know how to install, setup, backup, and recovery monitoring and tuning of these components.
Oracle Real Application Clusters (RAC) in database computing is a choice for Oracle Database software developed by Oracle Corporation, it provides clustering software and high availability in Oracle database environments. With the Enterprise Version, Oracle Corporation includes RAC, provided the nodes are clustered using Oracle Clusterware. Oracle RAC allows several machines when accessing a single database, to run Oracle RDBMS software simultaneously, offering to cluster.
The Oracle Grid Infrastructure for an independent server is the Oracle software that offers system support for a database including the file system, volume management, and automation of the restart process. If you want to utilize the Oracle restart or Oracle Automatic Storage Management (ASM) services, you have to install Oracle grid infrastructure before installing Oracle Database.
1Z0-082 Premium Exam Engine pdf Download: https://www.examcollectionpass.com/Oracle/1Z0-082-practice-exam-dumps.html
Verified 1Z0-082 Bundle Real Exam Dumps PDF: https://drive.google.com/open?id=1eGfMVZQRg7MZ8eJNvHDD3G7PCr5UUufp