[2021] 1Z0-082 PDF Questions - Perfect Prospect To Go With Test4Sure Practice Exam
Oracle 1Z0-082 Pdf Questions - Outstanding Practice To your Exam
NEW QUESTION 32
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 online redo logs are opened
- B. The alert log records the execution details
- C. The control file is read
- D. The Oracle background processes are started
- E. The initialization parameter file is read
- F. The online data files are opened
Answer: B,C
Explanation:
http://facedba.blogspot.com/2014/07/oracle-database-startup-stages-and.html
NEW QUESTION 33
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 SGA
- B. in the SYSAUX tablespace
- C. in the PGA
- D. in the undo tablespace
- E. in the temporary tablespace
Answer: D
NEW QUESTION 34
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 temporary tablespace
- B. in the SGA
- C. in the SYSAUX tablespace
- D. in the PGA
- E. in the undo tablespace
Answer: A
Explanation:
http://www.dba-oracle.com/t_temp_undo_enabled.htm
NEW QUESTION 35
Which three statements are true concerning logical and physical database structures? (Choose three.)
- A. All tablespaces may have one or more data files
- B. Segments can span multiple tablespaces
- C. The extents of a segment must always reside in the same datafile
- D. A segment might have only one extent
- E. A segment can span multiple data files in some tablespaces
- F. A smallfile tablespace might be bigger than a bigfile tablespace
- G. A segment's blocks can be of different sizes
Answer: C,D,F
NEW QUESTION 36
Examine the description of the CUSTOMERS table:
You want to display details of all customers who reside in cities starting with the letter D followed by at least two characters.
Which query can be used?
- A. SELECT * FROM customers WHERE city = `D_%';
- B. SELECT * FROM customers WHERE city LIKE `D_';
- C. SELECT * FROM customers WHERE city LIKE `D_%';
- D. SELECT * FROM customers WHERE city = `%D_';
Answer: C
NEW QUESTION 37
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 200 will have SALARY set to the same value as the SALARY of employee 100
- B. Employee 100 will have SALARY set to the same value as the SALARY of employee 200
- C. Employee 100 will have JOB_ID set to the same value as the JOB_ID of employee 200
- D. Employee 200 will have JOB_ID set to the same value as the JOB_ID of employee 100
- 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: B,D
NEW QUESTION 38
Which three are true about the Oracle Optimizer? (Choose three.)
- A. It can re-optimize execution plans after previous executions detect suboptimal plans.
- B. It updates stale object statistics in the Data Dictionary.
- C. It can optimize only SELECT statements.
- D. It generates execution plans for SQL statements based on relevant schema objects, system and session parameters, and information found in the Data Dictionary.
- E. It determines the optimal table join order and method.
- F. It will only generate SQL Plan Directives specific to a given SQL statement.
Answer: C,D,E
NEW QUESTION 39
In your data center, Oracle Managed Files (OMF) is used for all databases.
All tablespaces are smallfile tablespaces.
SALES_Q1 is a permanent user-defined tablespace in the SALES database.
Examine this command which is about to be issued by a DBA logged in to the SALES database:
ALTER TABLESPACE sales_q1 ADD DATAFILE;
Which are two actions, either one of which you could take to ensure that the command executes successfully? (Choose two.)
- A. Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify locations with at least 50 Mb of available space.
- B. Specify a path in the DATAFILE clause of the command specifying a location with at least 100M of available space.
- C. Ensure that DB_CREATE_FILE_DEST specifies a location with at least 100 Mb of available space.
- D. Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify with at least 50 Mb of available space.
- E. Add the AUTOEXTEND ON clause with NEXT set to 100M.
Answer: B,E
NEW QUESTION 40
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 &table
WHERE `&&condition' = `&cond'; - B. SELECT &col1, &col2
FROM "&table"
WHERE &condition; - C. SELECT &&col1, &&col2
FROM &table
WHERE &&condition = &&cond; - D. SELECT &col1, &col2
FROM &&table
WHERE &condition; - E. SELECT &&col1, &&col2
FROM &table
WHERE &&condition;
Answer: D
NEW QUESTION 41
Which two statements are true about trace files produced by the Oracle Database server?
(Choose two.)
- A. All trace files contain error information that require contacting Oracle Support
- B. They can be written by server processes
- C. They can be written by background processes
- D. Trace file names are based on the database name concatenated with a sequential number
- E. Trace files are written to the Fast Recovery Area (FRA)
Answer: B,C
Explanation:
https://gerardnico.com/db/oracle/trace_file
NEW QUESTION 42
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 name of the server running the database to whose instance HR wishes to connect
- B. It must be the name of the database to whose instance HR wishes to connect
- C. It must resolve to a valid connect descriptor in the server's tnsnames.ora file
- D. It must be the value of the SERVICE_NAMES parameter on the client side
- E. It must resolve to a valid connect descriptor in the client's tnsnames.ora file
Answer: A
NEW QUESTION 43
Which two statements are true about space-saving features in an Oracle Database? (Choose two.)
- A. A table that is truncated will always have its segment removed
- B. Private Temporary Tables (PTTS) store metadata in memory only
- C. An index that is altered to be UNUSABLE will retain its segment
- 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 44
Examine this description of the TRANSACTIONS table:
Which two SQL statements execute successfully? (Choose two.)
SELECT customer_id AS "CUSTOMER-ID", transaction_date AS DATE, amount + 100
- A. transactions;
SELECT customer_id AS 'CUSTOMER-ID', transaction_date AS DATE, amount + 100 - B. 100 "DUES AMOUNT" FROM transactions;
SELECT customer_id CUSTID, transaction_date TRANS_DATE, amount + 100 DUES FROM - C. DUES FROM transactions;
SELECT customer_id AS CUSTOMER-ID, transaction_date AS TRANS_DATE, amount + - D. "DUES" FROM transactions;
SELECT customer_id AS "CUSTOMER-ID", transaction_date AS "DATE", amount + 100 - E. 'DUES AMOUNT' FROM transactions;
Answer: A,C
NEW QUESTION 45
Which three statements are true regarding indexes? (Choose three.)
- A. A SELECT statement can access one or more indices without accessing any tables
- B. An update to a table can result in updates to any or all of the table's indexes
- C. When a table is dropped and is moved to the RECYCLE BIN, all indexes built on that table are permanently dropped
- D. An update to a table can result in no updates to any of the table's indexes
- E. A table belonging to one user can have an index that belongs to a different user
- F. A UNIQUE index can be altered to be non-unique
Answer: C,E,F
Explanation:
https://docs.oracle.com/cd/A87860_01/doc/server.817/a76956/indexes.htm
https://docs.oracle.com/cd/B10501_01/server.920/a96521/indexes.htm
NEW QUESTION 46
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: B,D
NEW QUESTION 47
Which three are types of segments in an Oracle Database? (Choose three.)
- A. clusters
- B. undo
- C. tables
- D. sequences
- E. index
- F. stored procedures
Answer: A,C,E
Explanation:
Explanation/Reference: http://www.adp-gmbh.ch/ora/concepts/segments.html
NEW QUESTION 48
Which two statements are true about the results of using the INTERSECT operator in compound queries? (Choose two.)
- A. The number of columns in each SELECT in the compound query can be different
- 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 ignores NULLs
- E. INTERSECT returns rows common to both sides of the compound query
Answer: C,D
NEW QUESTION 49
Which three statements are true about advanced connection options supported by Oracle Net for connection to Oracle Database instances? (Choose three.)
- A. Source Routing enables the use of Connection Manager (CMAN) which enables network traffic to be routed through a firewall
- B. Load Balancing requires the use of a name server
- C. Load Balancing can balance the number of connections to dispatchers when using a Shared Server configuration
- D. Source Routing requires the use of a name server
- E. Connect Time Failover requires the use of Transparent Application Failover (TAF)
- F. Connect Time Failover requires the connect string to have two or more listener addresses configured
Answer: A,D,F
Explanation:
https://docs.oracle.com/cd/E11882_01/network.112/e41945/advcfg.htm#NETAG013
NEW QUESTION 50
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_AMOUNT
FROM customers
WHERE cust_income_level != NULL
AND due_amount !=NULL; - B. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT
FROM customers
WHERE cust_income_level != NULL
AND cust_credit_level !=NULL; - C. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT
FROM customers
WHERE cust_incoms_level IS NOT NULL
AND due_amount IS NOT NULL; - D. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT
FROM customers
WHERE cust_income_level <> NULL
AND due_amount <> NULL; - E. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT
FROM customers
WHERE cust_income_level IS NOT NULL
AND cust_credit_limit IS NOT NULL;
Answer: E
NEW QUESTION 51
Your database instance is started with a PFILE.
Examine these parameters:
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 for the current instance and in the PFILE
- B. It fails because the SCOPE clause is missing
- C. Change is applied to the current instance, but does not persist after instance restart
- D. The value is changed only in the PFILE and takes effect at the next instance startup
Answer: C
Explanation:
https://docs.oracle.com/database/121/SQLRF/statements_2017.htm#SQLRF00902
NEW QUESTION 52
Which two statements are true about the DUAL table? (Choose two.)
- A. It can be accessed only by the SYS user
- B. It can be used to display only constants or pseudo columns
- C. It can display multiple rows and columns
- D. It consists of a single row and single column of VARCHAR2 data type
- E. It can be accessed by any user who has the SELECT privilege in any schema
- F. It can display multiple rows but only a single column
Answer: A,D
Explanation:
https://en.wikipedia.org/wiki/DUAL_table
NEW QUESTION 53
The SCOTT/TIGER user exists in two databases, BOSTON_DB and DALLAS_DB, in two different locations.
Each database has a tnsnames.ora file defining DALLAS_DB as a service name.
Examine this command:
CREATE DATABASE LINK dblink1 CONNECT TO scott IDENTIFIED BY tiger USING 'dallas_db'; How do you execute the command so that only SCOTT in BOSTON_DB can access the SCOTT schema in DALLAS_DB?
- A. as SCOTT in BOSTON_DB and SYS in DALLAS_DB
- B. as SCOTT in BOSTON_DB
- C. as SCOTT in DALLAS_DB
- D. as SYS in both the databases
- E. as SCOTT in both the databases
Answer: D
NEW QUESTION 54
Examine this command and some partial output:
Why does the DB01.abc.com service show unknown status?
- A. The LOCAL_LISTENER database parameter is not set to a service name that refers to LISTENER_1
- B. The service DB01.abc.com is statically registered
- C. The service DB01.abc.com is dynamically registered
- D. The SID_LIST_LISTENER section is not contained in the LISTENER.ORA file
- E. The listener is not listening on the default port 1521
Answer: B
NEW QUESTION 55
Which two statements are true about views used for viewing tablespace and datafile information?
(Choose two.)
- A. Tablespace free space can be viewed in V$TABLESPACE
- 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. 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: B,E
NEW QUESTION 56
......
Online Questions - Outstanding Practice To your 1Z0-082 Exam: https://www.test4sure.com/1Z0-082-pass4sure-vce.html
Practice To 1Z0-082 - Test4Sure Remarkable Practice On your Oracle Database Administration I Exam: https://drive.google.com/open?id=1XsFiwUIuBjPh5tS8MukNhcrqOPpX0au-