The Best Practice Test Preparation for the 1Z0-082 Certification Exam

1Z0-082 Exam Dumps, Practice Test Questions BUNDLE PACK

NEW QUESTION # 65
You execute this command:

Sufficient storage is available in filesystem /u01.
Which two statements are true about the BIG_TBStablespace? (Choose two.)

• A. It will always have a 32K blocksize
• B. It must be bigger than the largest SMALLFILE tablespace
• C. It will be a dictionary-managed tablespace by default
• D. Additional data files may not be added
• E. AUTOEXTEND is possible for the datafile

Answer: B,E

NEW QUESTION # 66
Which two statements are true about space-saving features in an Oracle Database? (Choose two.)

• A. Private Temporary Tables (PTTS) store metadata in memory only
• B. An index that is altered to be UNUSABLE will retain its segment
• C. A table that is truncated will always have its segment removed
• D. An index created with the UNUSABLE attribute has no segment
• E. If they exist for a session, Private Temporary Tables (PTTs) are always dropped at the next COMMIT OR ROLLBACK statement

Answer: D,E

NEW QUESTION # 67
Which two statements are true about User Authentication in an Oracle Database?

• A. Operating System authentication may be used for system-privileged administrative users.
• B. Password authentication must be used for system-privileged administrative users.
• C. Password File authentication is supported for any type of database user.
• D. REKOTE_LOGIN_PASSMOREFiLE must be set to exclusive to permit password changes for system-privileged administrative users.
• E. Password File authentication must be used for system-privileged administrative users.

Answer: A,B

NEW QUESTION # 68
In one of your databases, user KING is:
1. Not a DBA user
2. An operating system (OS) user
Examine this command and its output:

What must you do so that KING is authenticated by the OS when connecting to the database instance?

• A. Grant DBA to KING
• B. Set OS_AUTHEN_PREFIX to OPS$
• C. Unset REMOTE_LOGIN_PASSWORDFILE
• D. Alter user KING to be IDENTIFIED EXTERNALLY
• E. Have the OS administrator add KING to the OSDBA group

Answer: C

NEW QUESTION # 69
Which compression method is recommended for Direct-Path Insert operations?

• A. ROW STORE COMPRESS ADVANCED
• B. COLUMN STORE COMPRESS ADVANCED
• C. RON STORE COMPRESS BASIC
• D. COLUMN STORE COMPRESS BASIC

Answer: C

NEW QUESTION # 70
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. GLOBAL TEMPORARY TABLE space allocation occurs at session start.
• C. Any GLOBAL TEMPORARY TABLE rows existing at session termination will be deleted.
• D. A TRUNCATE command issued in a session causes all rows in a GLOBAL TEMPORARY TABLE for the issuing session to be deleted.
• E. A GLOBAL TEMPORARY TABLE'S definition is available to multiple sessions.
• F. A DELETE command on a GLOBAL TEMPORARY TABLE cannot be rolled back.

Answer: C,D,E

Explanation:
https://docs.oracle.com/javadb/10.8.3.0/ref/rrefdeclaretemptable.html

NEW QUESTION # 71
Which two statements are true about views used for viewing tablespace and datafile information? (Choose two.)

• A. V$TABLESPACE displays information about tablespaces contained in the data dictionary
• B. V$TABLESPACE displays information that is contained in the controlfile about tablespaces
• C. 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
• D. Tablespace free space can be viewed in V$TABLESPACE
• E. Tablespace free space can be viewed in DBA_TABLESPACES

Answer: B,C

NEW QUESTION # 72
Examine the description of the members table:

Examine the partial query:
SELECT city, last__name 1NAME FROM members
You want to display all cities that contain the string an. The cities must be returned in ascending order, with the last names further sorted in descending order.
Which two clauses must you add to the query?

• A. WHERE city = =%AN%'
• B. ORDER BY last_narae DESC, city ASC
• C. ORDER BY 1, 2
• D. WHERE city LIKE *%AN%*
• E. WHERE city IN (*%AN%')
• F. ORDER BY 1, LNAME DESC

Answer: D,F

NEW QUESTION # 73
While one of your databases was in mount state, the datafiles were renamed because they had been moved to a new file system. The database was then opened.
Which two statements are true?

• A. DBA_DATA _FILES displays both the new name and the old name for the data files.
• B. DBA_DATA_FILES displays the original name for the data files.
• C. DBA_DATA_FILES must be resynchronized manually with the control file an order to have it display the new file names.
• D. DBA_DATA_FILES displays the new name for the data files.
• E. V$DATAFILE displays the new names for the data files.

Answer: A,B

NEW QUESTION # 74
Which three statements are true about sequences in a single instance Oracle database?

• A. Two or more tables cannot have keys generated from the same sequence.
• B. A sequence number that was allocated can be rolled back if a transaction fails.
• C. A sequence can only be dropped by a DBA.
• D. Sequences can always have gaps.
• E. A sequence can Issue duplicate values.
• F. A sequence's unallocated cached values are lost if the instance shuts down.

Answer: A,E,F

NEW QUESTION # 75
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. SUBTRACT
• C. UNION
• D. MINUS
• E. INTERSECT

Answer: D

NEW QUESTION # 76
In which three situations does a new transaction always start? (Choose three.)

• A. when issuing a TRUNCATE statement after a SELECT statement was issued in the same session
• B. when issuing a CREATE TABLE statement after a SELECT statement was issued in the same session
• C. when issuing the first Data Manipulation Language (DML) statement after a COMMIT OR ROLLBACK statement was issued in the same session
• D. when issuing a CREATE INDEX statement after a CREATE TABLE statement completed successfully in the same session
• E. when issuing a DML statement after a DML statement failed in the same session
• F. when issuing a SELECT FOR UPDATE statement after a CREATE TABLE AS SELECT statement was issued in the same session

Answer: C,D,F

Explanation:
https://docs.oracle.com/en/database/oracle/oracle-database/19/cncpt/transactions.html#GUID-7690181F-8293-47B9-ADC1-905BD9C3AF57

NEW QUESTION # 77
Which two statements are true about trace files produced by the Oracle Database server? (Choose two.)

• A. Trace files are written to the Fast Recovery Area (FRA)
• B. They can be written by server processes
• C. All trace files contain error information that require contacting Oracle Support
• D. Trace file names are based on the database name concatenated with a sequential number
• E. They can be written by background processes

Answer: B,E

Explanation:
Reference:
https://gerardnico.com/db/oracle/trace_file
https://docs.oracle.com/html/E25494_01/monitoring001.htm
Each server and background process can write to an associated trace file. When an internal error is detected by a process, it dumps information about the error to its trace file. Some of the information written to a trace file is intended for the database administrator, and other information is for Oracle Support Services. Trace file information is also used to tune applications and instances.

NEW QUESTION # 78
View the Exhibit and examine the structure of the PRODUCTS table.
Which two tasks require subqueries? (Choose two.)

• A. Display products whose PROD_MIN_PRICE is more than the average PROD_LIST_PRICE of all products, and whose status is orderable
• B. Display the number of products whose PROD_LIST_PRICE is more than the average PROD_LIST_PRICE
• C. Display the total number of products supplied by supplier 102 which have a product status of obsolete
• D. Display the minimum PROD_LIST_PRICE for each product status
• E. Display suppliers whose PROD_LIST_PRICE is less than 1000

Answer: A,B

NEW QUESTION # 79
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. Any data files added to the tablespace must have a size of 5 gigabytes
• C. It is a locally managed tablespace
• D. It uses the database default blocksize
• E. It must be smaller than the smallest BIGFILE tablespace

Answer: C,D

Explanation:
Explanation/Reference:

NEW QUESTION # 80
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 database instance, and the abc.sql script will be executed
• B. The command succeeds and HR will be connected to the orcl and abc.sql databases
• 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

Answer: A

NEW QUESTION # 81
......

Prepare for the Actual Oracle Database 19c 1Z0-082 Exam Practice Materials Collection: https://www.testsimulate.com/1Z0-082-study-materials.html