Regenerate 1z0-082 Practice Exam 2021

NEW QUESTION 1
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 undo tablespace
• B. in the SYSAUX tablespace
• C. in the SGA
• D. in the PGA
• E. in the temporary tablespace

Answer: A

NEW QUESTION 2
Examine the description of the CUSTOMERS table:

For customers whose income level has a value, you want to display the first name and due amount as 5% of their credit limit. Customers whose due amount is null should not be displayed.
Which query should be used?

• A. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHEREcust_incoms_level IS NOT NULLAND due_amount IS NOT NULL;
• B. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level != NULLAND cust_credit_level !=NULL;
• C. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level <> NULLAND due_amount <> NULL;
• D. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level != NULLAND due_amount !=NULL;
• E. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level IS NOT NULLAND cust_credit_limit IS NOT NULL;

Answer: E

NEW QUESTION 3
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. Column positions must be used in the ORDER BY clause
• B. Only column names from the first SELECT statement in the compound query are recognized
• C. 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
• D. Each SELECT statement in the compound query must have its own ORDER BY clause
• E. Each SELECT statement in the compound query can have its own ORDER BY clause

Answer: BE

NEW QUESTION 4
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. Dynamic service registration cannot be used for this database instance
• B. The LREG process registers services dynamically with the LISTENER_1 listener
• 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

NEW QUESTION 5
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 second ROLLBACK command does nothing
• B. The second ROLLBACK command replays the delete
• C. The first ROLLBACK command restores the 101 rows that were deleted, leaving the inserted row still to be committed
• D. The second ROLLBACK command undoes the insert
• E. The first ROLLBACK command restores the 101 rows that were deleted and commits the inserted row

Answer: DE

NEW QUESTION 6
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

Answer: B

NEW QUESTION 7
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 uses the database buffer cache to load data
• C. It generates a log that contains control file entries, which can be used with normal SQL*Loader operations
• D. It generates a sql script that it uses to load data from EMP.DAT to EMP
• E. It appends data from EMP.DAT to EMP

Answer: BD

NEW QUESTION 8
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 group 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.

Answer: AC

NEW QUESTION 9
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. Set OS_AUTHEN_PREFIX to OPS$
• B. Have the OS administrator add KING to the OSDBA group
• C. Grant DBA to KING
• D. Unset REMOTE_LOGIN_PASSWORDFILE
• E. Alter user KING to be IDENTIFIED EXTERNALLY

Answer: D

NEW QUESTION 10
Which four account management capabilities can be configured using Oracle profiles? (Choose four.)

• A. the number of hours for which an account is locked after the configured number of login attempts has been reached
• B. the number of days for which an account may be inactive before it is locked
• C. the maximum amount of CPU time allowed for a user’s sessions before their account is locked
• D. the ability to prevent a password from ever being reused
• E. the number of password changes required within a period of time before a password can be reused
• F. the number of days for which an account is locked after the configured number of login attempts has been reached
• G. the maximum number of sessions permitted for a user before the account is locked

Answer: DEFG

NEW QUESTION 11
Which three statements are true about views in an Oracle database? (Choose three.)

• A. Views can be updated without the need to re-grant privileges on the view
• B. Tables in the defining query of a view must always exist in order to create the view
• C. The WITH CHECK clause prevents certain rows from being displayed when querying the view
• D. Data Manipulation Language (DML) can always be used on views
• E. Inserting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error
• F. Deleting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error
• G. The WITH CHECK clause prevents certain rows from being updated or inserted

Answer: BDE

NEW QUESTION 12
Which two statements are true about the PMON background process? (Choose two.)

• A. It registers database services with all local and remote listeners known to the database instance
• B. It frees resources held by abnormally terminated processes
• C. It records checkpoint information in the control file
• D. It frees unused temporary segments
• E. It kills sessions that exceed idle time

Answer: AB

NEW QUESTION 13
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, &&col2FROM &tableWHERE &&condition = &&cond;
• B. SELECT &col1, &col2FROM &&tableWHERE &condition;
• C. SELECT &col1, &col2FROM “&table”WHERE &condition;
• D. SELECT ‘&&col1’, ‘&&col2’FROM &tableWHERE ‘&&condition’ = ‘&cond’;
• E. SELECT &&col1, &&col2FROM &tableWHERE &&condition;

Answer: B

NEW QUESTION 14
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 created with the UNUSABLE attribute has no segment
• C. If they exist for a session, Private Temporary Tables (PTTs) are always dropped at the next COMMIT OR ROLLBACK statement
• D. An index that is altered to be UNUSABLE will retain its segment
• E. A table that is truncated will always have its segment removed

Answer: BC

NEW QUESTION 15
Which three statements are true about Oracle synonyms? (Choose three.)

• A. A synonym cannot be created for a PL/SQL package
• B. A synonym can be available to all users
• C. A SEQUENCE can have a synonym
• D. A synonym created by one user can refer to an object belonging to another user
• E. Any user can drop a PUBLIC synonym

Answer: BCD

NEW QUESTION 16
Evaluate these commands which execute successfully:

Which two statements are true about the ORD_ITEMS table and the ORD_SEQ sequence? (Choose two.)

• A. If sequence ORD_SEQ is dropped then the default value for column ORD_NO will be NULL for rows inserted into ORD_ITEMS
• B. Any user inserting rows into table ORD_ITEMS must have been granted access to sequence ORD_SEQ
• C. Column ORD_NO gets the next number from sequence ORD_SEQ whenever a row is inserted into ORD_ITEMS and no explicit value is given for ORD_NO
• D. Sequence ORD_SEQ cycles back to 1 after every 5000 numbers and can cycle 20 times
• E. Sequence ORD_SEQ is guaranteed not to generate duplicate numbers

Answer: BE

NEW QUESTION 17
Which two statements are true about the DUAL table? (Choose two.)

• A. It can be accessed only by the SYS user
• B. It consists of a single row and single column of VARCHAR2 data type
• C. It can display multiple rows but only a single column
• D. It can be used to display only constants or pseudo columns
• E. It can be accessed by any user who has the SELECT privilege in any schema
• F. It can display multiple rows and columns

Answer: AB

NEW QUESTION 18
Which four statements are true regarding primary and foreign key constraints and the effect they can have on table data? (Choose four.)

• A. A table can have only one primary key but multiple foreign keys
• B. A table can have only one primary key and foreign key
• C. The foreign key columns and parent table primary key columns must have the same names
• D. 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
• E. 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
• F. Only the primary key can be defined at the column and table level
• G. Primary key and foreign key constraints can be defined at both the column and table level

Answer: ACEG

NEW QUESTION 19
Which two statements are true regarding Oracle database space management within blocks managed by Automatic Segment Space Management (ASSM)? (Choose two.)

• A. PCTFREE defaults to 10% for all blocks in all segments for all compression methods
• B. ASSM assigns blocks to one of four fullness categories based on what percentage of the block is allocated for rows
• C. Update operations always attempt to find blocks with free space appropriate to the length of the row being updated
• D. Insert operations always attempt to find blocks with free space appropriate to the length of the row being inserted
• E. A block will always be eligible for inserts if the row is short enough to fit into the block

Answer: CE

NEW QUESTION 20
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 100 will have SALARY set to the same value as the SALARY of employee 200
• B. Employee 200 will have JOB_ID set to the same value as the JOB_ID of employee 100
• C. Employee 200 will have SALARY set to the same value as the SALARY of employee 100
• D. Employee 100 will have JOB_ID set to the same value as the JOB_ID of employee 200
• E. Employees 100 and 200 will have the same JOB_ID as before the update command
• F. Employees 100 and 200 will have the same SALARY as before the update command

Answer: AB

NEW QUESTION 21
......