1Z0-082 Free Update With 100% Exam Passing Guarantee [2021]
[Aug-2021] Verified Oracle Exam Dumps with 1Z0-082 Exam Study Guide
NEW QUESTION 66
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 DEFERRED_SEGMENT_CREATION to TRUE
- B. Grant UNLIMITED TABLESPACE to U1
- C. Set AUTOEXTEND ON for data files in DATA
- D. Increase U1's quota sufficiently in DATA
- E. Drop other U1 objects in DATA
- F. Add a data file to DATA
Answer: A,C,D
NEW QUESTION 67
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, an index segment for the primary key, and a LOB segment only
- B. no segments are created
- C. T1 only
- D. T1, an index segment for the primary key, a LOB segment, and a lobindex segment
- E. T1 and an index segment created for the primary key only
Answer: B
NEW QUESTION 68
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. invoice_date = '15-march-2019' : uses implicit conversion
- B. CONCAT (qty_sold, invoice_date) : requires explicit conversion
- C. invoie_date > '01-02-2019' : uses implicit conversion
- D. qty_sold BETWEEN `101' AND '110' : uses implicit conversion
- E. qty_sold = `0554982' uses implicit conversion
Answer: A,D
NEW QUESTION 69
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. It uses the database default blocksize
- B. Free space is managed using freelists
- C. Any data files added to the tablespace must have a size of 5 gigabytes
- D. It is a locally managed tablespace
- E. It must be smaller than the smallest BIGFILE tablespace
Answer: A,D
NEW QUESTION 70
Which four statements are true regarding primary and foreign key constraints and the effect they can have on table data? (Choose four.)
- A. It is possible for child rows that have a foreign key to be deleted automatically from the child table at the time the parent row is deleted
- B. Primary key and foreign key constraints can be defined at both the column and table level
- C. A table can have only one primary key but multiple foreign keys
- D. The foreign key columns and parent table primary key columns must have the same names
- E. Only the primary key can be defined at the column and table level
- F. A table can have only one primary key and foreign key
- G. It is possible for child rows that have a foreign key to remain in the child table at the time the parent row is deleted
Answer: A,B,C,D
NEW QUESTION 71
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 been granted the CREATE TABLE privilege
- C. The sales user must have been granted the CREATE SESSION privilege
- D. The sales user must have their quota on the users tablespace removed
- E. 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
- 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: B,D,F
NEW QUESTION 72
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 SYSAUX tablespace
- C. in the PGA
- D. in the undo tablespace
- E. in the temporary tablespace
Answer: D
NEW QUESTION 73
Which three are types of segments in an Oracle Database? (Choose three.)
- A. clusters
- B. undo
- C. tables
- D. sequences
- E. index
- F. stored procedures
Answer: A,C,E
Explanation:
Reference:
http://www.adp-gmbh.ch/ora/concepts/segments.html
NEW QUESTION 74
Which two statements are true about Enterprise Manager (EM) Express?
- A. EM Express uses a separate repository database to store target database metadata.
- B. You cannot start up a database instance using EM Express.
- C. You can shut down a database instance using EM Express.
- 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: B,E
NEW QUESTION 75
Which three Oracle database space management features will work with both Dictionary and Locally managed tablespaces? (Choose three.)
- A. Oracle Managed Files (OMF)
- B. Capacity planning growth reports based on historical data in the Automatic Workload Repository (AWR)
- C. Online index segment shrink
- D. Online table segment shrink
- E. Automatic data file extension (AUTOEXTEND)
Answer: A,B,E
NEW QUESTION 76
Which two statements are true about the PMON background process? (Choose two.)
- A. It frees unused temporary segments
- B. It kills sessions that exceed idle time
- C. It registers database services with all local and remote listeners known to the database instance
- D. It frees resources held by abnormally terminated processes
- E. It records checkpoint information in the control file
Answer: B,D
Explanation:
Reference:
https://docs.oracle.com/cd/B19306_01/server.102/b14220/process.htm
* Performs process recovery when a user process fails - Cleans up the database buffer cache - Frees resources that are used by the user process * Monitors sessions for idle session timeout
NEW QUESTION 77
Which three statements are true about dropping and unused columns in an Oracle database? (Choose three.)
- A. Partition key columns cannot be dropped.
- B. A column that is set to UNUSED still counts towards the limit of 1000 columns per table
- C. An UNUSED column's space is reclaimed automatically when the block containing that column is next queried.
- D. A DROP COLUMN command can be rolled back
- E. A primary key column referenced by another column as a foreign key can be dropped if using the CASCADE option.
- F. An UNUSED column's space is reclaimed automatically when the row containing that column is next queried.
Answer: B,C,E
NEW QUESTION 78
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. SYSDATE and CURRENT_DATE return the current date and time set for the operating system of the database server
- 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 used in expressions only if the default date format is DD-MON-RR
- E. CURRENT_DATE returns the current date and time as per the session time zone
- F. SYSDATE can be queried only from the DUAL table
Answer: C,E
Explanation:
https://www.w3resource.com/oracle/datetime-functions/oracle-current_timestamp-function.php
NEW QUESTION 79
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. The same port number can be used for multiple Database Express configurations for multiple databases on the same host
- C. It can be used to perform database recovery
- D. It is available only when the database is open
- E. It can be used to switch a database into ARCHIVELOGMODE
Answer: B,E
Explanation:
Explanation/Reference: https://docs.oracle.com/en/database/oracle/oracle-database/19/admqs/getting-started-with- database-administration.html#GUID-EB851101-07BE-4038-BB9D-06E01CC7F5D5
NEW QUESTION 80
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$SYSTEM_EVENT
- B. V$SESSION_WAIT
- C. V$SESSION
- D. V$SESSION_EVENT
- E. V$SESSION_WAIT_CLASS
Answer: B,D
NEW QUESTION 81
View the Exhibits and examine the structure of the COSTS and PROMOTIONS tables.
You want to display PROD_IDS whose promotion cost is less than the highest cost PROD_ID in a promotion time interval.
Examine this SQL statement:
Exhibit 1.
Exhibit 2.
What will be the result?
- A. It gives an error because the GROUP BY clause is not valid
- B. It gives an error because the ALL keyword is not valid
- C. It executes successfully but does not give the required result
- D. It executes successfully and gives the required result
Answer: D
NEW QUESTION 82
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. COLUMN STORE COMPRESS FOR ARCHIVE HIGH
- B. ROW STORE COMPRESS BASIC
- C. COLUMN STORE COMPRESS FOR ARCHIVE LOW
- D. COLUMN STORE COMPRESS FOR QUERY LOW
- 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 83
Which three statements are true about inner and outer joins? (Choose three.)
- A. A left or right outer join returns only unmatched rows
- B. A full outer join returns matched and unmatched rows
- C. An inner join returns matched rows
- D. Outer joins can only be used between two tables per query
- E. A full outer join must use Oracle syntax
- F. Outer joins can be used when there are multiple join conditions on two tables
Answer: A,B,C
Explanation:
Explanation/Reference: https://www.studytonight.com/dbms/joining-in-sql.php
NEW QUESTION 84
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. SYSDATE and CURRENT_DATE return the current date and time set for the operating system of the database server
- B. CURRENT_TIMESTAMP returns the same date as CURRENT_DATE
- C. SYSDATE can be queried only from the DUAL table
- D. CURRENT_TIMESTAMP returns the same date and time as SYSDATE with additional details of fractional seconds
- E. SYSDATE can be used in expressions only if the default date format is DD-MON-RR
- F. CURRENT_DATE returns the current date and time as per the session time zone
Answer: C,F
NEW QUESTION 85
......
Authentic Best resources for 1Z0-082 Online Practice Exam: https://www.testpdf.com/1Z0-082-exam-braindumps.html
1Z0-082 Test Engine Practice Exam: https://drive.google.com/open?id=1YGWP3YVbnzh6xa3Yih7_uZ9VtUA-32mE
