A script abc.sql must be executed to perform a job.
A database user HR, who is defined in this database, executes this command:
$ sqlplus hr/hr@orcl @abc.sql
What will happen upon execution?
A. The command succeeds and HR will be connected to the orcl and abc.sql databases
B. The command succeeds and HR will be connected to the orcl database instance, and the abc.sql script will be executed
C. The command fails because the script must refer to the full path name
D. The command fails and reports an error because @ is used twice
Which two are true about a SQL statement using SET operators such as UNION? (Choose two.)
A. The data type group of each column returned by the second query must match the data type of the corresponding column returned by the first query.
B. The number, but not names, of columns must be identical for all SELECT statements in the query.
C. The data type of each column returned by the second query must exactly match the data type of the corresponding column returned by the first query.
D. The names and number of columns must be identical for all SELECT statements in the query.
E. The data type of each column returned by the second query must be implicitly convertible to the data type of the corresponding column returned by the first query.
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 all privileges used by all users including administrative users in the database
B. analysis of all privileges used by all users but excluding administrative users in the database
C. analysis of privileges that a user has on their own schema objects that they did not use
D. analysis of privileges that a user has on their own schema objects that they did 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 privileges granted indirectly to a role that are then used by a user who has been granted that role
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 generated undo is stored in SYSTEM.
B. It fails and returns the error message "ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS1'".
C. It succeeds and the least recently written undo block of UNDOTBS1 is overwritten by the generated undo.
D. It succeeds and the generated undo is stored in SYSAUX.
E. It succeeds and the least recently read undo block of UNDOTBS1 is overwritten by the generated undo.
The orders table has a column ORDER_DATE of data type DATE.
The default display format for a date is DD-MON-RR.
Which two WHERE conditions demonstrate the correct usage of conversion functions? (Choose two.)
A. WHERE order_date > TO_DATE(ADD_MONTHS(SYSDATE, 6), 'MON DD YYYY')
B. WHERE order dare > TO DATE('JUL 10 2018', 'MON DD YYYY')
C. WHERE TO_CHAR(order date, 'MON DD YYYY') = 'JAN 20 2019'
D. WHERE order_date > TO_CHAR(ADD_MONTHS(SYSDATE, 6), 'MON DD YYYY')
E. WHERE order_date IN (TO_DATE('Oct 21 2018', 'Mon DD YYYY'), TO_CHAR('Nov 21 2018', 'Mon DD YYYY'))
Which two statements are true about the Oracle join and ANSI join syntax? (Choose two.)
A. The Oracle join syntax performs less well than the SQL:1999 compliant ANSI join syntax.
B. The Oracle join syntax lacks the ability to do outer joins.
C. The SQL:1999 compliant ANSI join syntax supports creation of a Cartesian product of two tables.
D. The Oracle join syntax supports creation of a Cartesian product of two tables.
E. The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax.
Which two tasks can you perform using DBCA for databases? (Choose two.)
A. Configure a nonstandard block size for a new database
B. Register a new database with an available Enterprise Manager Management server
C. Change the standard block size of an existing database
D. Configure incremental backups for a new database
E. Enable flashback database for an existing database
Which three statements are true concerning logical and physical database structures? (Choose three.)
A. All tablespaces may have one or more data files
B. The extents of a segment must always reside in the same datafile
C. A smallfile tablespace might be bigger than a bigfile tablespace
D. A segment can span multiple data files in some tablespaces
E. A segment's blocks can be of different sizes
F. A segment might have only one extent
G. Segments can span multiple tablespaces
Which three statements are true about the DESCRIBE command? (Choose three.)
A. It displays the PRIMARY KEY constraint for any column or columns that have that constraint
B. It can be used from SQL Developer
C. It displays the NOT NULL constraint for any columns that have that constraint
D. It can be used to display the structure of an existing view
E. It displays all constraints that are defined for each column
F. It can be used only from SQL*Plus
Which compression method is recommended for Direct-Path Insert operations?
A. COLUMN STORE COMPRESS BASIC
B. COLUMN STORE COMPRESS ADVANCED
C. ROW STORE COMPRESS BASIC
D. ROW STORE COMPRESS ADVANCED
Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only Oracle exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your 1Z0-082 exam preparations and Oracle certification application, do not hesitate to visit our Vcedump.com to find your solutions here.