[Mar-2022] Oracle 1Z0-082 Actual Questions and Braindumps
Pass 1Z0-082 Exam with Updated 1Z0-082 Exam Dumps PDF 2022
NEW QUESTION 16
Which two statements are true about views used for viewing tablespace and datafile information? (Choose two.)
- A. A datafile can be renamed when the database is in MOUNT state and the new file name is displayed when querying DBA_DATA_FILES after the database is opened
- B. V$TABLESPACE displays information that is contained in the controlfile about tablespaces
- C. Tablespace free space can be viewed in DBA_TABLESPACES
- D. V$TABLESPACE displays information about tablespaces contained in the data dictionary
- E. Tablespace free space can be viewed in V$TABLESPACE
Answer: A,B
NEW QUESTION 17
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 &tableWHERE '&&condition' = '&cond';
- B. SELECT &&col1, &&col2FROM &tableWHERE &&condition;
- C. SELECT &col1, &col2FROM "&table"WHERE &condition;
- D. SELECT &&col1, &&col2FROM &tableWHERE &&condition = &&cond;
- E. SELECT &col1, &col2FROM &&tableWHERE &condition;
Answer: E
NEW QUESTION 18
Which three statements are true about Oracle synonyms? (Choose three.)
- A. Any user can drop a PUBLIC synonym
- B. A synonym cannot be created for a PL/SQL package
- C. A synonym created by one user can refer to an object belonging to another user
- D. A SEQUENCE can have a synonym
- E. A synonym can be available to all users
Answer: C,D,E
Explanation:
https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_7001.htm
NEW QUESTION 19
Which three Oracle database space management features will work with both Dictionary and Locally managed tablespaces? (Choose three.)
- A. Online table segment shrink
- B. Oracle Managed Files (OMF)
- C. Capacity planning growth reports based on historical data in the Automatic Workload Repository (AWR)
- D. Automatic data file extension (AUTOEXTEND)
- E. Online index segment shrink
Answer: B,C,D
Explanation:
Explanation
NEW QUESTION 20
Which three statements are true about inner and outer joins? (Choose three.)
- A. A full outer join returns matched and unmatched rows
- B. A full outer join must use Oracle syntax
- C. A left or right outer join returns only unmatched rows
- D. Outer joins can be used when there are multiple join conditions on two tables
- E. Outer joins can only be used between two tables per query
- F. An inner join returns matched rows
Answer: A,C,F
Explanation:
Explanation/Reference: https://www.studytonight.com/dbms/joining-in-sql.php
NEW QUESTION 21
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 online redo logs are opened
- C. The online data files are opened
- D. The control file is read
- E. The initialization parameter file is read
- F. The Oracle background processes are started
Answer: D,F
NEW QUESTION 22
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. Only column names from the first SELECT statement in the compound query are recognized
- B. Each SELECT statement in the compound query must have its own ORDER BY clause
- C. Column positions must be used in the ORDER BY clause
- D. Each SELECT statement in the compound query can have its own 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,D
NEW QUESTION 23
Which four statements are true regarding primary and foreign key constraints and the effect they can have on table data? (Choose four.)
- A. Primary key and foreign key constraints can be defined at both the column and table level
- B. A table can have only one primary key but multiple foreign keys
- C. The foreign key columns and parent table primary key columns must have the same names
- D. A table can have only one primary key and foreign key
- E. 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
- F. Only the primary key can be defined at the column and table level
- G. 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
Answer: A,B,C,G
NEW QUESTION 24
Which two are true about conventional path SQL load? (Choose two.)
- A. It always generates redo.
- B. It locks objects being processed.
- C. It does not generate UNDO.
- D. It cannot load data into clustered tables.
- E. It enforces referential integrity constraints.
Answer: C,E
NEW QUESTION 25
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 first ROLLBACK command restores the 101 rows that were deleted, leaving the inserted row still to be committed
- B. The second ROLLBACK command replays the delete
- C. The second ROLLBACK command undoes the insert
- D. The second ROLLBACK command does nothing
- E. The first ROLLBACK command restores the 101 rows that were deleted and commits the inserted row
Answer: C,E
Explanation:
Explanation/Reference:
NEW QUESTION 26
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. Add a data file to DATA
- B. Drop other U1 objects in DATA
- C. Set AUTOEXTEND ON for data files in DATA
- D. Increase U1's quota sufficiently in DATA
- E. Grant UNLIMITED TABLESPACE to U1
- F. Set DEFERRED_SEGMENT_CREATION to TRUE
Answer: B,D,E
NEW QUESTION 27
Which two tasks can you perform using DBCA for databases? (Choose two.)
- A. Configure incremental backups for a new database
- B. Change the standard block size of an existing database
- C. Register a new database with an available Enterprise Manager Management server
- D. Enable flashback database for an existing database
- E. Configure a nonstandard block size for a new database
Answer: B,C
Explanation:
Explanation/Reference: https://docs.oracle.com/cd/B16254_01/doc/server.102/b14196/install003.htm
NEW QUESTION 28
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. It terminates
- D. You can reattach to it and monitor it
- E. You can no longer monitor it
Answer: C,E
Explanation:
https://blog.oracle48.nl/killing-and-resuming-datapump-expdp-and-impdp-jobs/
NEW QUESTION 29
Which two are true about complete and incomplete recovery? (Choose two.)
- A. Incomplete recovery is possible only when the database is open.
- B. Uncommitted transactions will be rolled back after incomplete recovery completes.
- C. Only incremental backups can be used to roll forward the database while performing complete recovery.
- D. The database must have FLASHBACK enabled in order to perform incomplete recovery.
- E. Uncommitted transactions will be rolled back after complete recovery completes.
Answer: C,E
NEW QUESTION 30
You execute this command:
CREATE SMALLFILE TABLESPACE sales
DATAFILE '/u01/app/oracle/sales01.dbf
SIZE 5G
SEGMENT SPACE MANAGEMENT AUTO;
Which two actions must you take to ensure UNDOTBS01 is used as the default UNDO tablespace? (Choose two.)
- A. Free space is managed using freelists
- B. It uses the database default blocksize
- C. It is a locally managed tablespace
- D. It must be smaller than the smallest BIGFILE tablespace
- E. Any data files added to the tablespace must have a size of 5 gigabytes
Answer: B,C
Explanation:
Explanation/Reference:
NEW QUESTION 31
Which two are true about a SQL statement using SET operators such as UNION? (Choose two.)
- A. 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.
- B. 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.
- C. The names and number of columns must be identical for all SELECT statements in the query.
- D. The data type group of each column returned by the second query must match the data type group of the corresponding column returned by the first query.
- E. The number, but not names, of columns must be identical for all SELECT statements in the query.
Answer: B,D
NEW QUESTION 32
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; - D. FROM &table
WHERE '&&condition' = '&cond';
SELECT &&col1, &&col2 - E. FROM &&table
WHERE &condition;
SELECT &col1, &col2
Answer: E
NEW QUESTION 33
Examine these commands:
Which two statements are true about the sqlldr execution? (Choose two.)
- A. It generates a sql script that it uses to load data from EMP.DAT to EMP
- B. It appends data from EMP.DAT to EMP
- C. It overwrites data in EMP with data in EMP.DAT
- D. It uses the database buffer cache to load data
- E. It generates a log that contains control file entries, which can be used with normal SQL*Loader operations
Answer: A,D
NEW QUESTION 34
You have been tasked to create a table for a banking application.
One of the columns must meet three requirements:
1. Be stored in a format supporting date arithmetic without using conversion functions
2. Store a loan period of up to 10 years
3. Be used for calculating interest for the number of days the loan remains unpaid Which data type should you use?
- A. TIMESTAMP
- B. TIMESTAMP WITH TIMEZONE
- C. INTERVAL YEAR TO MONTH
- D. INTERVAL DAY TO SECOND
- E. TIMESTAMP WITH LOCAL TIMEZONE
Answer: D
NEW QUESTION 35
Which two statements are true about the PMON background process? (Choose two.)
- A. It kills sessions that exceed idle time
- B. It records checkpoint information in the control file
- C. It frees unused temporary segments
- D. It registers database services with all local and remote listeners known to the database instance
- E. It frees resources held by abnormally terminated processes
Answer: D,E
NEW QUESTION 36
Which two can you use to recover a dropped table? (Choose two.)
- A. FLASHBACK TRANSACTION
- B. FLASHBACK DROP
- C. FLASHBACK TABLE TO SCN
- D. FLASHBACK DATABASE
- E. FLASHBACK QUERY
Answer: B,C
NEW QUESTION 37
Which three statements are true regarding indexes? (Choose three.)
- A. When a table is dropped and is moved to the RECYCLE BIN, all indexes built on that table are permanently dropped
- B. A SELECT statement can access one or more indices without accessing any tables
- C. A table belonging to one user can have an index that belongs to a different user
- D. An update to a table can result in no updates to any of the table's indexes
- E. A UNIQUE index can be altered to be non-unique
- F. An update to a table can result in updates to any or all of the table's indexes
Answer: A,E,F
NEW QUESTION 38
What two are benefits of Data Pump? (Choose two.)
- A. It makes use of client system resources.
- B. It can restart failed export jobs.
- C. It can execute in parallel.
- D. It can export data into sequential media, such as tapes.
- E. It represents database metadata information as DDL statements in the dump file.
Answer: B,C
NEW QUESTION 39
Which two statements are true about the results of using the INTERSECT operator in compound queries? (Choose two.)
- A. INTERSECT ignores NULLs
- B. Reversing the order of the intersected tables can sometimes affect the output
- C. Column names in each SELECT in the compound query can be different
- D. INTERSECT returns rows common to both sides of the compound query
- E. The number of columns in each SELECT in the compound query can be different
Answer: C,D
Explanation:
https://www.oracletutorial.com/oracle-basics/oracle-intersect/
NEW QUESTION 40
Examine this command:
Which two statements are true? (Choose two.)
- A. The file is renamed and stored in the same location
- B. The tablespace containing SALES1.DBF must be altered OFFLINE before executing the command.
- C. If Oracle Managed Files (OMF) is used, then the file is renamed but moved to DB_CREATE_FILE_DEST.
- D. The tablespace containing SALES1.DBF must be altered READ ONLY before executing the command.
- E. DML may be performed on tables with one or more extents in this data file during the execution of this command.
Answer: A,E
NEW QUESTION 41
......
Latest 1Z0-082 Pass Guaranteed Exam Dumps with Accurate & Updated Questions: https://www.troytecdumps.com/1Z0-082-troytec-exam-dumps.html
1Z0-082 Exam Brain Dumps - Study Notes and Theory: https://drive.google.com/open?id=1feBMBp658_f_zCLlN6WyIAcfjJu3f4yJ