Oracle 1Z1-082 Practice Test Pdf Exam Material
1Z1-082 Answers 1Z1-082 Free Demo Are Based On The Real Exam
NEW QUESTION 80
Which two statements are true about the ORDER BY clause when used with a SQL statement containing a SET operator such as UNION? (Choose two.)
- A. Each SELECT statement in the compound query can have its own ORDER BY clause
- B. Each SELECT statement in the compound query must have its own ORDER BY clause
- C. Only column names from the first SELECT statement in the compound query are recognized
- D. Column positions must be used in the ORDER BY clause
- E. The first column in the first SELECT of the compound query with the UNION operator is used by default to sort output in the absence of an ORDER BY clause
Answer: A,C
NEW QUESTION 81
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 SYSAUX.
- C. It succeeds and the generated undo is stored in SYSTEM.
- D. It succeeds and the least recently written undo block of UNDOTBS1 is overwritten by the generated undo.
- E. It fails and returns the error message "ORA-30036: unable to extend segment by 8 in undo tablespace
'UNDOTBS1' ".
Answer: D
Explanation:
Explanation
NEW QUESTION 82
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. Dynamic service registration cannot be used for this database instance
- C. LISTENER_1 must also be defined in the LISTENER.ORA file to enable dynamic service registration
- D. There are two listeners named LISTENER and LISTENER_1 running simultaneously using port
1521 on the same host as the database instances - E. The definition for LISTENER_1 requires a CONNECT_DATA section to enable dynamic service registration
Answer: C
Explanation:
https://docs.oracle.com/database/121/NETAG/listenercfg.htm#NETAG292
NEW QUESTION 83
Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.)
- A. It is held inside an Oracle database schema
- B. It supports diagnostics for Oracle Clusterware
- C. The ADR base defaults to $ORACLE_HOME/rdbms/admin ifneither DIAGNOSTIC_DEST nor ORACLE_BASE is set
- D. It supports diagnostics for Automatic Storage Management (ASM)
- E. The ADR base defaults to $ORACLE_HOME/dbs if the DIAGNOSTIC_DEST parameter and the ORACLE_BASE environment variable are not set
Answer: A,C
NEW QUESTION 84
Which three statements are true about table data storage in an Oracle Database? (Choose three.)
- A. Data block headers contain their own Data Block Address (DBA)
- 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 different database blocks
- E. Multiple row pieces from the same row may be stored in the same block
- F. Data block free space is always contiguous in the middle of the block
Answer: B,D,F
Explanation:
Explanation/Reference: https://books.google.com.pk/books?id=lNtVjrmbzckC&pg=PA267&lpg=PA267&dq=Multiple+row
+pieces+from+the+same+row+may+be+stored+in+different+database
+blocks&source=bl&ots=lEIhFe2Q52&sig=ACfU3U1TETJPy194pARxfIJ5ROaQdySCMQ&hl=en&sa=X&ved=2 ahUKEwivveLa97_mAhWOzaQKHahYAVEQ6AEwAnoECAoQAQ#v=onepage&q=Multiple%20row%20pieces
%20from%20the%20same%20row%20may%20be%20stored%20in%20different%20database%
20blocks&f=false
NEW QUESTION 85
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_WAIT_CLASS
- B. V$SESSION_EVENT
- C. V$SESSION_WAIT
- D. V$SYSTEM_EVENT
- E. V$SESSION
Answer: B,C
NEW QUESTION 86
Which two statements are true about the DUAL table? (Choose two.)
- A. It can be accessed only by the SYS user
- B. It can be used to display only constants or pseudo columns
- C. It can display multiple rows and columns
- D. It can be accessed by any user who has the SELECT privilege in any schema
- E. It consists of a single row and single column of VARCHAR2 data type
- F. It can display multiple rows but only a single column
Answer: C,E
NEW QUESTION 87
Examine this description of the TRANSACTIONS table:
Which two SQL statements execute successfully? (Choose two.)
- A. SELECT customer_id AS 'CUSTOMER-ID', transaction_date AS DATE, amount + 100 'DUES AMOUNT' FROM transactions;
- B. SELECT customer_id CUSTID, transaction_date TRANS_DATE, amount + 100 DUES FROM transactions;
- C. SELECT customer_id AS "CUSTOMER-ID", transaction_date AS "DATE", amount + 100 DUES 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: B,C
NEW QUESTION 88
Which three statements are true about Deferred Segment Creation in Oracle databases?
- A. It Is the default behavior for tables and indexes.
- B. It Is supported for Index Organized Tables (IOTs) contained in locally managed tablespaces.
- C. It is supported for SYS-owned tables contained in locally managed tablespaces.
- D. Sessions may dynamically switch back and forth from deferred to immediate segment creation.
- E. Indexes inherit the deferred or immediate segment creation attribute from their parent table
Answer: A,D,E
NEW QUESTION 89
Examine these commands:
Which two statements are true about the sqlldrexecution? (Choose two.)
- A. It generates a log that contains control file entries, which can be used with normal SQL*Loader operations
- B. It appends data from EMP.DAT to EMP
- C. It overwrites data in EMP with data in EMP.DAT
- D. It generates a sql script that it uses to load data from EMP.DAT to EMP
- E. It uses the database buffer cache to load data
Answer: D,E
NEW QUESTION 90
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. INTERVAL YEAR TO MONTH
- B. TIMESTAMP WITH LOCAL TIMEZONE
- C. INTERVAL DAY TO SECOND
- D. TIMESTAMP WITH TIMEZONE
- E. TIMESTAMP
Answer: C
NEW QUESTION 91
Which two queries execute successfully?
- A. SELECT 2TOLLIF(100, 'A') FROM DUAL;
- B. SELECT COALESCE (100, 'AM FROM DUAL;
- C. SELECT COALESCE(100, NULL, 200) FROM DUAL;
- D. SELECT NULLIF(NULL, 100) FROM DUAL;
- E. SELECT NULLIF(100,100) FROM DUAL;
Answer: C
NEW QUESTION 92
A database is configured to use automatic undo management with temporary undo enabled.
An UPDATE is executed on a temporary table.
Where is the UNDO stored?
- A. in the SGA
- B. in the temporary tablespace
- C. in the PGA
- D. in the SYSAUX tablespace
- E. in the undo tablespace
Answer: B
Explanation:
http://www.dba-oracle.com/t_temp_undo_enabled.htm
NEW QUESTION 93
The SALES_Q1 and USERS tablespaces exist in one of your databases and TEMP is a temporary tablespace.
Segment creation is not deferred.
You execute this command:
Which three statements must be true so that the SALES user can create tables in SALES_Q1? (Choose three.)
- A. The sales user must have a quota on the TEMP tablespace
- B. The sales user must have a quota on the SALES_Q1 tablespace to hold all the rows to be inserted into any table in their schema
- C. The sales user must have been granted the CREATE TABLE privilege
- D. The sales user must have been granted the CREATE SESSION privilege
- E. The sales user must have their quota on the users tablespace removed
- F. The sales user must have a quota on the SALES_Q1 tablespace to hold the initial extends of all tables they plan to create in their schema
Answer: C,E,F
NEW QUESTION 94
Examine these commands:
Which two statements are true about the sqlldr execution? (Choose two.)
- A. It overwrites data in EMP with data in EMP.DAT
- B. It generates a sql script that it uses to load data from EMP.DAT to EMP
- C. It appends data from EMP.DAT to EMP
- D. It generates a log that contains control file entries, which can be used with normal SQL*Loader operations
- E. It uses the database buffer cache to load data
Answer: C,D
NEW QUESTION 95
Which three are types of segments in an Oracle Database? (Choose three.)
- A. clusters
- B. sequences
- C. stored procedures
- D. index
- E. undo
- F. tables
Answer: A,D,F
Explanation:
Explanation/Reference: http://www.adp-gmbh.ch/ora/concepts/segments.html
NEW QUESTION 96
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. LISTENER_1 must also be defined in the LISTENER.ORA file to enable dynamic service registration
- B. Dynamic service registration cannot be used for this database instance
- C. There are two listeners named LISTENER and LISTENER_1 running simultaneously using port 1521 on the same host as the database instances
- D. The LREG process registers services dynamically with the LISTENER_1 listener
- E. The definition for LISTENER_1 requires a CONNECT_DATA section to enable dynamic service registration
Answer: D
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 97
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-03-06T12:15:17.183438+05:30
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. Grant UNLIMITED TABLESPACE to U1
- D. Set DEFERRED_SEGMENT_CREATION to TRUE
- E. Add a data file to DATA
- F. Drop other U1 objects in DATA
Answer: A,B,D
NEW QUESTION 98
Which two statements are true about Enterprise Manager (EM) Express?
- A. You cannot start up a database instance using EM Express.
- B. You can shut down a database instance using EM Express.
- C. EM Express uses a separate repository database to store target database metadata.
- D. You can use a single instance of EM Express to manage multiple database running on the same server.
- E. By default, EM express is available for a database after database creation using DBCA.
Answer: A,E
NEW QUESTION 99
Examine the description of the EMPLOYEES table:
Which query is valid?
- A. SELECT dept_id, AVG(MAX(salary)) FROM employees GROUP BY dept_id;
- B. SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id;
- C. SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id, join_date;
- D. SELECT dept_id, MAX(AVG(salary)) FROM employees GROUP BY dept_id;
Answer: B
NEW QUESTION 100
Which three failures do not require intervention for recovery? (Choose three.)
- A. statement failure
- B. network interface card (NIC) failure
- C. media failure
- D. user process failure
- E. transaction failure
Answer: A,D,E
NEW QUESTION 101
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 200 will have JOB_ID set to the same value as the JOB_ID of employee 100
- B. Employees 100 and 200 will have the same JOB_ID as before the update command
- C. Employee 100 will have SALARY set to the same value as the SALARY of employee 200
- D. Employee 100 will have JOB_ID set to the same value as the JOB_ID of employee 200
- E. Employee 200 will have SALARY set to the same value as the SALARY of employee 100
- F. Employees 100 and 200 will have the same SALARY as before the update command
Answer: A,C
NEW QUESTION 102
Which three statements are true about the Oracle Data Dictionary? (Choose three.)
- A. Data dictionary views are created by joins of dictionary base tables and DBA-defined tables
- B. It is owned by the SYSTEM user
- C. The data dictionary is created and maintained by the database administrator
- D. Usernames of all users including database administrators are stored in the data dictionary
- E. Base tables can be queried directly
- F. Views with the same name but different prefixes, such as CDB, DBA, ALL and USER, reference the same base tables from the data dictionary
Answer: D,E,F
NEW QUESTION 103
Which two statements are true about the results of using the INTERSECT operator in compound queries? (Choose two.)
- A. The number of columns in each SELECT in the compound query can be different
- B. Reversing the order of the intersected tables can sometimes affect the output
- C. INTERSECT returns rows common to both sides of the compound query
- D. Column names in each SELECT in the compound query can be different
- E. INTERSECT ignores NULLs
Answer: C,D
Explanation:
https://www.oracletutorial.com/oracle-basics/oracle-intersect/
NEW QUESTION 104
......
1Z1-082 [Sep-2022] Newly Released] Exam Questions For You To Pass: https://pass4sure.trainingquiz.com/1Z1-082-training-materials.html
