Update 1z0-082 Tutorials 2020

Examcollection offers free demo for 1z0-082 exam. "Oracle Database Administration I", also known as 1z0-082 exam, is a Oracle Certification. This set of posts, Passing the Oracle 1z0-082 exam, will help you answer those questions. The 1z0-082 Questions & Answers covers all the knowledge points of the real exam. 100% real Oracle 1z0-082 exams and revised by experts!

Also have 1z0-082 free dumps questions for you:

NEW QUESTION 1
Your database instance is started with a PFILE.
Examine these parameters:
1Z0-082 dumps exhibit
You want to increase the size of the buffer cache.
Free memory is available to increase the size of the buffer cache. You execute the command:
SQL> ALTER SYSTEM SET DB_CACHE_SIZE=1024M;
What is the outcome?

  • A. The value is changed only in the PFILE and takes effect at the next instance startup
  • B. The value is changed for the current instance and in the PFILE
  • C. It fails because the SCOPE clause is missing
  • D. Change is applied to the current instance, but does not persist after instance restart

Answer: D

NEW QUESTION 2
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.

Answer: C

NEW QUESTION 3
You execute this command:
1Z0-082 dumps exhibit
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. You can no longer monitor it
  • B. You can reattach to it and monitor it
  • C. It is paused and can be resumed
  • D. It continues to run in the background
  • E. It terminates

Answer: AE

NEW QUESTION 4
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:
1Z0-082 dumps exhibit
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 5
In which three situations does a new transaction always start? (Choose three.)

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

Answer: ADF

NEW QUESTION 6
Which three functions are performed by dispatchers in a shared server configuration? (Choose three.)

  • A. writing inbound request to the common request queue from all shared server connections
  • B. checking for outbound shared server responses on the common outbound response queue
  • C. receiving inbound requests from processes using shared server connections
  • D. sending each connection input request to the appropriate shared server input queue
  • E. broadcasting shared server session responses back to requesters on all connections
  • F. sending shared server session responses back to requesters on the appropriate connection

Answer: ACD

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

  • A. Connect Time Failover requires the use of Transparent Application Failover (TAF)
  • B. Source Routing requires the use of a name server
  • C. Source Routing enables the use of Connection Manager (CMAN) which enables network traffic to be routed through a firewall
  • D. Load Balancing can balance the number of connections to dispatchers when using a Shared Server configuration
  • E. Load Balancing requires the use of a name server
  • F. Connect Time Failover requires the connect string to have two or more listener addresses configured

Answer: BCF

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

Answer: BC

NEW QUESTION 9
Which two statements are true about Enterprise Manager Database Express? (Choose two.)

  • A. It is available only when the database is open
  • B. It can be used to perform database recovery
  • C. The same port number can be used for Database Express configurations for databases on different hosts
  • D. It can be used to switch a database into ARCHIVELOGMODE
  • E. The same port number can be used for multiple Database Express configurations for multiple databases on the same host

Answer: DE

NEW QUESTION 10
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 11
You need to calculate the number of days from 1st January 2019 until today. Dates are stored in the default format of DD-MON-RR.
Which two queries give the required output? (Choose two.)

  • A. SELECT TO_CHAR(SYSDATE, ‘DD-MON-YYYY’) – ’01-JAN-2019’ FROM DUAL;
  • B. SELECT ROUND(SYSDATE – ’01-JAN-2019’) FROM DUAL;
  • C. SELECT ROUND(SYSDATE – TO_DATE(‘01/JANUARY/2019’)) FROM DUAL;
  • D. SELECT TO_DATE(SYSDATE, ‘DD/MONTH/YYYY’) – ‘01/JANUARY/2019’ FROM DUAL;
  • E. SELECT SYSDATE – TO_DATE(’01-JANUARY-2019’) FROM DUAL;

Answer: AB

NEW QUESTION 12
Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.)

  • A. The ADR base defaults to $ORACLE_HOME/rdbms/admin ifneither DIAGNOSTIC_DEST nor ORACLE_BASE is set
  • B. The ADR base defaults to $ORACLE_HOME/dbs if the DIAGNOSTIC_DEST parameter and the ORACLE_BASE environment variable are not set
  • C. It supports diagnostics for Automatic Storage Management (ASM)
  • D. It supports diagnostics for Oracle Clusterware
  • E. It is held inside an Oracle database schema

Answer: AE

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

  • A. SELECT NVL(cust_credit_linit * .15, ‘Not Available’) FROM customers;
  • B. SELECT NVL2(cust_credit_linit * .15, ‘Not Available’) FROM customers;
  • C. SELECT NVL(TO_CHAR(cust_credit_limit * .15), ‘Not Available’) FROM customers;
  • D. SELECT TO_CHAR(NVL(cust_credit_limit * .15, ‘Not Available’)) FROM customers;
  • E. SELECT NVL2(cust_credit_limit, TO_CHAR(cust_credit_limit * .15), ‘Not Available’) FROM customers;

Answer: BC

NEW QUESTION 14
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 15
Examine this command:
CREATE UNDO TABLESPACE undotbs01
DATAFILE ‘undotbs_01.dbf’ SIZE 100M
AUTOEXTEND ON;
Which two actions must you take to ensure UNDOTBS01 is used as the default UNDO tablespace? (Choose two.)

  • A. Add the SEGMENT SPACE MANAGEMENT AUTO clause
  • B. Set UNDO_TABLESPACE to UNDOTBS01
  • C. Add the NOLOGGING clause
  • D. Make certain that the database operates in automatic undo management mode
  • E. Add the ONLINE clause

Answer: BD

NEW QUESTION 16
Examine this description of the TRANSACTIONS table:
1Z0-082 dumps exhibit
Which two SQL statements execute successfully? (Choose two.)

  • A. SELECT customer_id AS “CUSTOMER-ID”, transaction_date AS DATE, amount + 100 “DUES” FROM transactions;
  • B. SELECT customer_id AS “CUSTOMER-ID”, transaction_date AS “DATE”, amount + 100 DUES FROM transactions;
  • C. SELECT customer_id AS CUSTOMER-ID, transaction_date AS TRANS_DATE, amount + 100 “DUES AMOUNT” FROM transactions;
  • D. SELECT customer_id CUSTID, transaction_date TRANS_DATE, amount + 100 DUES FROM transactions;
  • E. SELECT customer_id AS ‘CUSTOMER-ID’, transaction_date AS DATE, amount + 100 ‘DUES AMOUNT’ FROM transactions;

Answer: BD

NEW QUESTION 17
In one of your databases, the user HR has the password HRMGR.
You want to connect to a database instance whose listener listens on port 1531 by using this statement: CONNECT HR/HRMGR@orcl
No name server is used.
Which statement is true about ORCL?

  • A. It must be the value of the SERVICE_NAMES parameter on the client side
  • B. It must resolve to a valid connect descriptor in the server’s tnsnames.ora file
  • C. It must resolve to a valid connect descriptor in the client’s tnsnames.ora file
  • D. It must be the name of the database to whose instance HR wishes to connect
  • E. It must be the name of the server running the database to whose instance HR wishes to connect

Answer: E

NEW QUESTION 18
You execute this query:
SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE), ‘MON’), ‘dd “Monday for” fmMonth rrrr’) What is the result?

  • A. It executes successfully but does not return any result
  • B. It returns the date for the first Monday of the next month
  • C. It generates an error
  • D. It returns the date for the last Monday of the current month

Answer: B

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

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

Answer: BE

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

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

Answer: AC

NEW QUESTION 21
The SALES_Q1 and USERS tablespaces exist in one of your databases and TEMP is a temporary tablespace. Segment creation is not deferred.
You execute this command:
1Z0-082 dumps exhibit
Which three statements must be true so that the SALES user can create tables in SALES_Q1? (Choose three.)

  • A. The sales user must have a quota on the TEMP tablespace
  • B. The sales user must have a quota on the SALES_Q1 tablespace to hold the initial extends of all tables they plan to create in their schema
  • C. The sales user must have been granted the CREATE SESSION privilege
  • D. The sales user must have their quota on the users tablespace removed
  • E. The sales user must have a quota on the SALES_Q1 tablespace to hold all the rows to be inserted into any table in their schema
  • F. The sales user must have been granted the CREATE TABLE privilege

Answer: BDF

NEW QUESTION 22
Which two statements are true about single row functions? (Choose two.)

  • A. MOD : returns the quotient of a division operation
  • B. FLOOR : returns the smallest integer greater than or equal to a specified number
  • C. TRUNC : can be used to combine any number of values
  • D. CONCAT : can be used to combine any number of values
  • E. CEIL : can be used for positive and negative numbers

Answer: AC

NEW QUESTION 23
Which two statements are true about date/time functions in a session where NLS_DATE_FORMAT is set to DD-MON-YYYY HH24:MI:SS? (Choose two.)

  • A. CURRENT_TIMESTAMP returns the same date and time as SYSDATE with additional details of fractional seconds
  • B. SYSDATE can be queried only from the DUAL table
  • C. CURRENT_DATE returns the current date and time as per the session time zone
  • D. SYSDATE can be used in expressions only if the default date format is DD-MON-RR
  • E. SYSDATE and CURRENT_DATE return the current date and time set for the operating system of the database server
  • F. CURRENT_TIMESTAMP returns the same date as CURRENT_DATE

Answer: BC

NEW QUESTION 24
......

Recommend!! Get the Full 1z0-082 dumps in VCE and PDF From Certshared, Welcome to Download: https://www.certshared.com/exam/1z0-082/ (New 90 Q&As Version)