Pass Oracle 1Z0-082 Exam Quickly With Prep4sureGuide
Prepare 1Z0-082 Question Answers - 1Z0-082 Exam Dumps
Difficulty in Writing of Oracle 1z0-082: Oracle Database Administration I Exam
Oracle Certified Expert, Oracle Database 12c: RAC and Grid Infrastructure Administrator Certification is not the most difficult Oracle certification test but taking it without any preparation is likely to fail. Therefore, it is highly recommended that candidates should prepare well by taking 1Z0-068 practice exams. Any questions that are left unanswered will be treated as incorrect therefore you should answer all the questions after the examination of 1Z0-068 exam dumps even if you are unsure that which is the correct option, mark the most suitable option as your answer so that any question shouldn't be left as unanswered in 1Z0-068 exam dumps pdf.
NEW QUESTION 45
The ORCL database has RESUMABLE__TIMEOUT = 7200 and DEFERRED_SEGMENT_CREATION = FALSE User U1 has a 1 MB quota in tablespace DATA.
U1 executes this command:
SQL> CREATE TABLE t1 AS
(SELECT object_name, sharing, created
FROM dba_objects);
U1 complains that the command is taking too long to execute.
In the alert log, the database administrator (DBA) finds this:
2017/3/6 14:45:17
statement in resumable session 'User U1(136), Session 1, Instance 1' was suspended due to ORA-01536: space quota exceeded for tablespace 'DATA' Which are three actions any one of which the DBA could take to resume the session? (Choose three.)
- A. Set AUTOEXTEND ON for data files in DATA
- B. Increase U1's quota sufficiently in DATA
- C. Add a data file to DATA
- D. Grant UNLIMITED TABLESPACE to U1
- E. Drop other U1 objects in DATA
- F. Set DEFERRED_SEGMENT_CREATION to TRUE
Answer: B,D,E
NEW QUESTION 46
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?
SELECT &&col1, &&col2
- A. FROM &&table
WHERE &condition;
SELECT &col1, &col2 - B. FROM &table
WHERE '&&condition' = '&cond';
SELECT &&col1, &&col2 - C. FROM &table
WHERE &&condition = &&cond;
SELECT &col1, &col2 - D. FROM "&table"
WHERE &condition;
SELECT '&&col1', '&&col2' - E. FROM &table
WHERE &&condition;
Answer: A
NEW QUESTION 47
Which four account management capabilities can be configured using Oracle profiles? (Choose four.)
- A. the number of hours for which an account is locked after the configured number of login attempts has been reached
- B. the ability to prevent a password from ever being reused
- C. the number of days for which an account is locked after the configured number of login attempts has been reached
- D. the number of password changes required within a period of time before a password can be reused
- E. the maximum amount of CPU time allowed for a user's sessions before their account is locked
- F. the number of days for which an account may be inactive before it is locked
- G. the maximum number of sessions permitted for a user before the account is locked
Answer: B,C,D,G
NEW QUESTION 48
The ORCL database has RESUMABLE__TIMEOUT = 7200 and DEFERRED_SEGMENT_CREATION = FALSE User U1 has a 1 MB quota in tablespace DATA.
U1 executes this command:
SQL> CREATE TABLE t1 AS
(SELECT object_name, sharing, created
FROM dba_objects);
U1 complains that the command is taking too long to execute.
In the alert log, the database administrator (DBA) finds this:
2017/3/6 14:45:17
statement in resumable session 'User U1(136), Session 1, Instance 1' was suspended due to ORA-01536: space quota exceeded for tablespace 'DATA' Which are three actions any one of which the DBA could take to resume the session? (Choose three.)
- A. Increase U1's quota sufficiently in DATA
- B. Add a data file to DATA
- C. Drop other U1 objects in DATA
- D. Set DEFERRED_SEGMENT_CREATION to TRUE
- E. Set AUTOEXTEND ON for data files in DATA
- F. Grant UNLIMITED TABLESPACE to U1
Answer: A,D,E
NEW QUESTION 49
Which three object types support deferred segment creation? (Choose three.)
- A. external tables
- B. clustered tables
- C. index organized tables
- D. heap organized tables
- E. partitioned tables
- F. temporary tables
Answer: C,D,E
NEW QUESTION 50
The CUSTOMERS table has a CUST_CREDIT_LIMIT column of data type NUMBER.
Which two queries execute successfully? (Choose two.)
- A. SELECT NVL(cust_credit_limit * .15, `Not Available') FROM customers;
- B. SELECT NVL(TO_CHAR(cust_credit_limit * .15), `Not Available') FROM customers;
- C. SELECT TO_CHAR(NVL(cust_credit_limit * .15, `Not Available')) FROM customers;
- D. SELECT NVL2(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: B,D
NEW QUESTION 51
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 ALL
- B. INTERSECT
- C. UNION
- D. SUBTRACT
- E. MINUS
Answer: E
NEW QUESTION 52
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. It is paused and can be resumed
- B. It continues to run in the background
- C. You can no longer monitor it
- D. It terminates
- E. You can reattach to it and monitor it
Answer: A,E
Explanation:
Reference:
https://blog.oracle48.nl/killing-and-resuming-datapump-expdp-and-impdp-jobs/
NEW QUESTION 53
Which three statements are true about the Oracle join and ANSI join syntax? (Choose three.)
- A. The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax
- B. The SQL:1999 compliant ANSI join syntax supports natural joins
- C. The Oracle join syntax performs less well than the SQL:1999 compliant ANSI join syntax
- D. The SQL:1999 compliant ANSI join syntax supports creation of a Cartesian product of two tables
- E. The Oracle join syntax supports creation of a Cartesian product of two tables
- F. The Oracle join syntax only supports right outer joins
- G. The Oracle join syntax supports natural joins
Answer: B,D,G
NEW QUESTION 54
You have been tasked to create a table for a banking application.
One of the columns must meet three requirements:
* Be stored in a format supporting date arithmetic without using conversion functions
* Store a loan period of up to 10 years
* Be used for calculating interest for the number of days the loan remains unpaid Which data type should you use?
- A. TIMESTAMP WITH TIMEZONE
- B. TIMESTAMP WITH LOCAL TIMEZONE
- C. TIMESTAMP
- D. INTERVAL DAY TO SECOND
- E. INTERVAL YEAR TO MONTH
Answer: D
NEW QUESTION 55
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. It fails because the SCOPE clause is missing
- B. The value is changed for the current instance and in the PFILE
- C. The value is changed only in the PFILE and takes effect at the next instance startup
- D. Change is applied to the current instance, but does not persist after instance restart
Answer: D
NEW QUESTION 56
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 alert log records the execution details
- B. The Oracle background processes are started
- C. The control file is read
- D. The online data files are opened
- E. The online redo logs are opened
- F. The initialization parameter file is read
Answer: A,C
Explanation:
http://facedba.blogspot.com/2014/07/oracle-database-startup-stages-and.html
NEW QUESTION 57
Which three statements are true about undo segments and the use of undo by transactions in an Oracle database instance? (Choose three.)
- A. Undo segments must be stored in a SMALLFILE tablespace
- B. Undo segments can extend when a transaction fills the last extent of the undo segment
- C. An undo segment may be used by multiple transactions simultaneously
- D. Undo segments must be stored in a BIGFILE tablespace
- E. A single transaction may use multiple undo segments simultaneously
- F. Undo segments can wrap around to the first extent when a transaction fills the last extend of the undo segment
- G. Undo segments have a minimum of three extents
Answer: A,B,C
NEW QUESTION 58
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 cust_credit_level !=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 IS NOT NULL AND due_amount IS NOT NULL;
- D. 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;
- E. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT FROM customers WHERE cust_income_level <> NULL AND due_amount <> NULL;
Answer: D
NEW QUESTION 59
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 be the name of the database to whose instance HR wishes to connect
- 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 resolve to a valid connect descriptor in the server's tnsnames.ora file
Answer: A
NEW QUESTION 60
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. Multiple row pieces from the same row may be stored in different database blocks
- C. Multiple row pieces from the same row may be stored in the same block
- D. A table row piece can be chained across several database blocks
- 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: B,D,F
NEW QUESTION 61
Which two statements are true about date/time functions in a session where NLS_DATE_FORMAT is set to DD-MON-YYYY HH24:MI:SS? (Choose two.)
- A. CURRENT_DATE returns the current date and time as per the session time zone
- B. CURRENT_TIMESTAMP returns the same date and time as SYSDATE with additional details of fractional seconds
- C. CURRENT_TIMESTAMP returns the same date as CURRENT_DATE
- D. SYSDATE can be queried only from the DUAL table
- E. SYSDATE can be used in expressions only if the default date format is DD-MON-RR
- F. SYSDATE and CURRENT_DATE return the current date and time set for the operating system of the database server
Answer: A,D
NEW QUESTION 62
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 - '01-JAN-2019') FROM DUAL;
- B. SELECT TO_DATE(SYSDATE, 'DD/MONTH/YYYY') - '01/JANUARY/2019' FROM DUAL;
- C. SELECT ROUND(SYSDATE - TO_DATE('01/JANUARY/2019')) FROM DUAL;
- D. SELECT SYSDATE - TO_DATE('01-JANUARY-2019') FROM DUAL;
- E. SELECT TO_CHAR(SYSDATE,'DD-MON-YYYY') - '01-JAN-2019' FROM DUAL;
Answer: C,D
NEW QUESTION 63
Evaluate these commands which execute successfully:
Which two statements are true about the ORD_ITEMS table and the ORD_SEQ sequence? (Choose two.)
- A. Sequence ORD_SEQ is guaranteed not to generate duplicate numbers
- B. Sequence ORD_SEQ cycles back to 1 after every 5000 numbers and can cycle 20 times
- C. Any user inserting rows into table ORD_ITEMS must have been granted access to sequence ORD_SEQ
- 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. 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
Answer: A,C
NEW QUESTION 64
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 and an index segment created for the primary key only
- B. T1, an index segment for the primary key, a LOB segment, and a lobindex segment
- C. no segments are created
- D. T1, an index segment for the primary key, and a LOB segment only
- E. T1 only
Answer: E
Explanation:
Explanation/Reference:
NEW QUESTION 65
You want to use table compression suitable for OLTP that will:
Compress rows for all DML statements on that table
Minimize the overheads associated with compression
Which compression option is best suited for this?
- A. ROW STORE COMPRESS BASIC
- B. COLUMN STORE COMPRESS FOR QUERY LOW
- C. COLUMN STORE COMPRESS FOR ARCHIVE LOW
- D. COLUMN STORE COMPRESS FOR ARCHIVE HIGH
- E. ROW STORE COMPRESS ADVANCED
Answer: E
Explanation:
Reference:
https://www.oracle.com/technetwork/database/options/compression/advanced-compression-wp-12c-1896128.pdf
NEW QUESTION 66
Which three activities are recorded in the database alert log? (Choose three.)
- A. non-default database parameters
- B. Data Definition Language (DDL) statements
- C. block corruption errors
- D. session logins and logouts
- E. deadlock errors
Answer: A,C,E
Explanation:
https://docs.oracle.com/cd/B28359_01/server.111/b28310/monitoring001.htm#ADMIN11247
NEW QUESTION 67
Which three statements are true about GLOBAL TEMPORARY TABLES? (Choose three.)
- A. GLOBAL TEMPORARY TABLE rows inserted by a session are available to any other session whose user has been granted select on the table.
- B. A GLOBAL TEMPORARY TABLE'S definition is available to multiple sessions.
- C. A DELETE command on a GLOBAL TEMPORARY TABLE cannot be rolled back.
- D. Any GLOBAL TEMPORARY TABLE rows existing at session termination will be deleted.
- E. GLOBAL TEMPORARY TABLE space allocation occurs at session start.
- F. A TRUNCATE command issued in a session causes all rows in a GLOBAL TEMPORARY TABLE for the issuing session to be deleted.
Answer: B,D,F
Explanation:
https://docs.oracle.com/javadb/10.8.3.0/ref/rrefdeclaretemptable.html
NEW QUESTION 68
......
Real Oracle 1Z0-082 Exam Questions [Updated 2022]: https://examcollection.prep4sureguide.com/1Z0-082-prep4sure-exam-guide.html