Get 1Z0-082 Products Practice Material for 1Z0-082 Exam Question Preparation [Q53-Q71]

4.3/5 - (3 votes)

Get 1Z0-082 Products Practice Material for 1Z0-082 Exam Question Preparation

Most Reliable Oracle 1Z0-082 Training Materials

NO.53 Which three statements are true about dropping and unused columns in an Oracle database? (Choose three.)

A primary key column referenced by another column as a foreign key can be dropped if using the CASCADE option.

An UNUSED column’s space is reclaimed automatically when the block containing that column is next queried.

An UNUSED column’s space is reclaimed automatically when the row containing that column is next queried.

Partition key columns cannot be dropped.

A DROP COLUMN command can be rolled back

A column that is set to UNUSED still counts towards the limit of 1000 columns per table

NO.54 Examine the description of the EMPLOYEES table:

Which query is valid?

SELECT dept_id, AVG(MAX(salary)) FROM employees GROUP BY dept_id;

SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id;

SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id, join_date;

SELECT dept_id, MAX(AVG(salary)) FROM employees GROUP BY dept_id;

NO.55 Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.)

The ADR base defaults to $ORACLE_HOME/rdbms/admin if neither DIAGNOSTIC_DEST nor ORACLE_BASE is set

The ADR base defaults to $ORACLE_HOME/dbs if the DIAGNOSTIC_DEST parameter and the ORACLE_BASE environment variable are not set

It supports diagnostics for Automatic Storage Management (ASM)

It supports diagnostics for Oracle Clusterware

It is held inside an Oracle database schema

https://docs.oracle.com/cd/E11882_01/install.112/e27508/admin.htm

NO.56 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?

It succeeds and the generated undo is stored in SYSTEM.

It fails and returns the error message “ORA-30036: unable to extend segment by 8 in undo tablespace ‘UNDOTBS1′”.

It succeeds and the least recently written undo block of UNDOTBS1 is overwritten by the generated undo.

It succeeds and the generated undo is stored in SYSAUX.

It succeeds and the least recently read undo block of UNDOTBS1 is overwritten by the generated undo.

To guarantee the success of long-running queries or Oracle Flashback operations, you can enable retention guarantee. If retention guarantee is enabled, the specified minimum undo retention is guaranteed; the database never overwrites unexpired undo data even if it means that transactions fail due to lack of space in the undo tablespace. If retention guarantee is not enabled, the database can overwrite unexpired undo when space is low, thus lowering the undo retention for the system. This option is disabled by default.

NO.57 Which statement is true about smallfile tablespaces?

Extent location metadata is stored in the data dictionary by default.

The number of data files is constrained only by the size of the storage array.

Maximum file size can be set to unlimited only if the logical volume manager supports striping.

Segments can span multiple tablespaces.

Segments can span multiple data files.

NO.58 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.)

The second ROLLBACK command does nothing

The second ROLLBACK command replays the delete

The first ROLLBACK command restores the 101 rows that were deleted, leaving the inserted row still to be committed

The second ROLLBACK command undoes the insert

The first ROLLBACK command restores the 101 rows that were deleted and commits the inserted row

NO.59 Examine the description of the PRODUCT_STATUS table:

The status column contains the values ‘in stock’ or ‘out of stock’ for each row.
Which two queries will execute successfully?

SELECT prod_id Il q”‘s not available” FROM product_status where status = ‘OUT OF STOCK’;

SELECT prod_id II q’l’s not available)’ FROM product_status WHERE status = ‘OUT OF STOCK’;

SELECT prod_id “CURRENT AVAILABILITY” II q'<‘s not available)’ FROM product_status WHERE status = ‘OUT OF STOCK

SELECT prod_id I I q’ (*s not available)’ “CURRENT AVAILABILITY” FROM product_status WHERE status = ‘OUT OF STOCK

SELECT prod_id I I q’ (‘s not available) * ‘CURRENT AVAILABILITY’ FROM product_status WHERE status = ‘OUT OF STOCK

SELECT prod_id q’s not available” FROM product_status WHERE status = ‘OUT OF STOCK*;

NO.60 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?

Set OS_AUTHENT_PREFIX to OPS$

Have the OS administrator add KING to the OSDBA group

Grant DBA to KING

Unset REMOTE_LOGIN_PASSWORDFILE

Alter user KING to be IDENTIFIED EXTERNALLY

NO.61 You execute this query:
SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE), `MON’), `dd “Monday for”
fmMonth rrrr’)
What is the result?

It executes successfully but does not return any result

It returns the date for the first Monday of the next month

It generates an error

It returns the date for the last Monday of the current month

NO.62 View the Exhibit and examine the description of the tables.
You execute this SQL statement:

Which three statements are true?

The statement will fall if a row already exists in the sales table for product 23.

The sales table has five foreign keys.

A product can have a different unit price at different times.

A customer can exist in many countries.

The statement will execute successfully and a new row will be inserted into the sales table.

The statement will fail because a subquery may not be contained in a values clause.

NO.63 Which three statements are true about advanced connection options supported by Oracle Net for connection to Oracle Database instances? (Choose three.)

Connect Time Failover requires the use of Transparent Application Failover (TAF)

Source Routing requires the use of a name server

Source Routing enables the use of Connection Manager (CMAN) which enables network traffic to be routed through a firewall

Load Balancing can balance the number of connections to dispatchers when using a Shared Server configuration

Load Balancing requires the use of a name server

Connect Time Failover requires the connect string to have two or more listener addresses configured

https://docs.oracle.com/cd/E11882_01/network.112/e41945/advcfg.htm#NETAG013

NO.64 In which three situations does a new transaction always start? (Choose three.)

when issuing a SELECT FOR UPDATE statement after a CREATE TABLE AS SELECT statement was issued in the same session

when issuing a TRUNCATE statement after a SELECT statement was issued in the same session

when issuing a CREATE TABLE statement after a SELECT statement was issued in the same session

when issuing the first Data Manipulation Language (DML) statement after a COMMIT OR ROLLBACK statement was issued in the same session

when issuing a CREATE INDEX statement after a CREATE TABLE statement completed successfully in the same session

when issuing a DML statement after a DML statement failed in the same session

NO.65 Examine the description of the EMPLOYEES table:

Which query is valid?

SELECT dept_id, AVG(MAX(salary)) FROM employees GROUP BY dept_id;

SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id;

SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id, join_date;

SELECT dept_id, MAX(AVG(salary)) FROM employees GROUP BY dept_id;

NO.66 Which two statements are true about trace files produced by the Oracle Database server?
(Choose two.)

They can be written by server processes

Trace files are written to the Fast Recovery Area (FRA)

They can be written by background processes

All trace files contain error information that require contacting Oracle Support

Trace file names are based on the database name concatenated with a sequential number

https://gerardnico.com/db/oracle/trace_file

NO.67 Which statement is true about aggregate functions?

Aggregate functions can be nested to any number of levels

The AVG function implicitly converts NULLS to zero

Aggregate functions can be used in any clause of a SELECT statement

The MAX and MIN functions can be used on columns with character data types

NO.68 Which two are true about a SQL statement using SET operators such as UNION? (Choose two.)

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.

The number, but not names, of columns must be identical for all SELECT statements in the query.

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.

The names and number of columns must be identical for all SELECT statements in the query.

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.

NO.69 Examine these commands:

Which two statements are true about the sqiidr execution?

It generates a sqi script that it uses to load data from EMP.DAT TO EMP.

It overwrites the data for Alan and adds data for Curl and Bob

It appends data from EMP.DAT TO EMP.

It overwrites all data in emp with data from emp.dat.

It generates a log that contains control file entries, which can be used with normal SQL’Loader operations.

NO.70 Which two statements are true about substitution variables?

A substitution variable prefixed with & always prompts only once for a value in a session.

A substitution variable prefixed with to prompts only once for a value in a session unless it is set to undefined in the session

A substitution variable can be used only in a select statement.

A substitution variable used to prompt for a column name must be enclosed in single quotation marks.

A substitution variable can be used with any clause in a select statement.

A substitution variable used to prompt for a column name must be enclosed in double quotation marks.

NO.71 The CUSTOMERS table has a CUST_CREDIT_LIMIT column of data type NUMBER.
Which two queries execute successfully? (Choose two.)

SELECT NVL(cust_credit_linit * .15, ‘Not Available’) FROM customers;

SELECT NVL2(cust_credit_linit * .15, ‘Not Available’) FROM customers;

SELECT NVL(TO_CHAR(cust_credit_limit * .15), ‘Not Available’) FROM customers;

SELECT TO_CHAR(NVL(cust_credit_limit * .15, ‘Not Available’)) FROM customers;

SELECT NVL2(cust_credit_limit, TO_CHAR(cust_credit_limit * .15), ‘Not Available’) FROM customers;

Loading …

LATEST 1Z0-082 Exam Practice Material: https://www.trainingquiz.com/1Z0-082-practice-quiz.html

Previous Article Pass 220-1001 Exam – Real Test Engine PDF with 752 Questions [Q265-Q283]

Next Article [Aug 09, 2023] Get New C_IBP_2305 Certification – Valid Exam Dumps Questions [Q26-Q42]

Download Oracle 1z0-071 Mock Test Study Material [Q151-Q173]

1z0-071, Oracle October 27, 2022

Download Oracle 1z0-071 Mock Test Study Material 1z0-071 Questions Prepare with Learning Information Oracle 1z0-071 Exam Syllabus Topics: Topic Details

Latest Oracle 1Z0-1055-21 Exam questions and answers [Q78-Q101]

1Z0-1055-21, Oracle September 11, 2022

Latest Oracle 1Z0-1055-21 Exam questions and answers TrainingQuiz 1Z0-1055-21 Exam Practice Test Questions (Updated 142 Questions) Oracle 1Z0-1055-21 Exam Syllabus

Quiz Training Materials

Get 1Z0-082 Products Practice Material for 1Z0-082 Exam Question Preparation [Q53-Q71]

Download Oracle 1z0-071 Mock Test Study Material [Q151-Q173]

Latest Oracle 1Z0-1055-21 Exam questions and answers [Q78-Q101]

Leave a Reply Cancel reply

Quiz Training Materials

Get 1Z0-082 Products Practice Material for 1Z0-082 Exam Question Preparation [Q53-Q71]

You May Also Like...

Download Oracle 1z0-071 Mock Test Study Material [Q151-Q173]

Latest Oracle 1Z0-1055-21 Exam questions and answers [Q78-Q101]

Leave a Reply Cancel reply