1Z0-082 PDF Dumps | Oct 19, 2021 Recently Updated Questions
1Z0-082 Exam Questions – Valid 1Z0-082 Dumps Pdf
Difficulty in Writing of Oracle 1z0-082: Oracle Database Administration I Exam
Oracle Certified Expert, Oracle Database 12c: RAC and Grid Infrastructure Administrator Certification is not the most difficult Oracle certification test but taking it without any preparation is likely to fail. Therefore, it is highly recommended that candidates should prepare well by taking 1Z0-068 practice exams. Any questions that are left unanswered will be treated as incorrect therefore you should answer all the questions after the examination of 1Z0-068 dumps even if you are unsure that which is the correct option, mark the most suitable option as your answer so that any question shouldn’t be left as unanswered in 1Z0-068 dumps pdf.
NEW QUESTION 45
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 Oracle background processes are started
- B. The initialization parameter file is read
- C. The control file is read
- D. The alert log records the execution details
- E. The online data files are opened
- F. The online redo logs are opened
Answer: C,D
Explanation:
http://facedba.blogspot.com/2014/07/oracle-database-startup-stages-and.html
NEW QUESTION 46
Which two are true about shrinking a segment online? (Choose two.)
- A. To shrink a table it must have a PRIMARY KEY constraint
- B. It must be in a tablespace that uses Automatic Segment Space Management (ASSM)
- C. To shrink a table it must have a UNIQUE KEY constraint
- D. To shrink a table it must have row movement enabled
- E. It is not possible to shrink either indexes or Index Organized Tables (IOTs)
- F. It always eliminates all migrated rows if any exist in the table
Answer: A,D
Explanation:
https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_3001.htm
NEW QUESTION 47
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 both the databases
- B. as SCOTT in DALLAS_DB
- C. as SYS in both the databases
- D. as SCOTT in BOSTON_DB and SYS in DALLAS_DB
- E. as SCOTT in BOSTON_DB
Answer: C
NEW QUESTION 48
Which three activities are recorded in the database alert log? (Choose three.)
- A. non-default database parameters
- B. deadlock errors
- C. session logins and logouts
- D. block corruption errors
- E. Data Definition Language (DDL) statements
Answer: A,B,D
Explanation:
Reference:
https://docs.oracle.com/cd/B28359_01/server.111/b28310/monitoring001.htm#ADMIN11247
NEW QUESTION 49
Examine the description of the PROMOTIONS table:
You want to display the unique promotion costs in each promotion category.
Which two queries can be used? (Choose two.)
- A. SELECT DISTINCT promo_category || ' has ' || promo_cost AS COSTS FROM promotions ORDER BY 1;
- B. SELECT promo_cost, promo_category FROM promotions ORDER BY by 1;
- C. SELECT DISTINCT promo_cost || ' in ' || DISTINCT promo_category FROM promotions ORDER BY 1;
- D. SELECT promo_category, DISTINCT promo_cost FROM promotions ORDER BY 2;
- E. SELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1;
Answer: A,E
NEW QUESTION 50
Which three statements are true about inner and outer joins? (Choose three.)
- A. Outer joins can be used when there are multiple join conditions on two tables
- B. A full outer join returns matched and unmatched rows
- C. A left or right outer join returns only unmatched rows
- D. A full outer join must use Oracle syntax
- E. An inner join returns matched rows
- F. Outer joins can only be used between two tables per query
Answer: B,C,E
Explanation:
Reference:
https://www.studytonight.com/dbms/joining-in-sql.php
NEW QUESTION 51
Which two statements are true about Enterprise Manager (EM) Express?
- A. EM Express uses a separate repository database to store target database metadata.
- B. You can shut down a database instance using EM Express.
- C. You cannot start up a database instance using EM Express.
- D. You can use a single instance of EM Express to manage multiple database running on the same server.
- E. By default, EM express is available for a database after database creation using DBCA.
Answer: C,E
NEW QUESTION 52
Examine this command:
Which two statements are true? (Choose two.)
- A. DML may be performed on tables with one or more extents in this data file during the execution of this command.
- B. The file is renamed and stored in the same location
- C. The tablespace containing SALES1.DBF must be altered OFFLINE before executing the command.
- D. If Oracle Managed Files (OMF) is used, then the file is renamed but moved to DB_CREATE_FILE_DEST.
- E. The tablespace containing SALES1.DBF must be altered READ ONLY before executing the command.
Answer: A,E
NEW QUESTION 53
Which two statements are true regarding a SAVEPOINT? (Choose two.)
- A. Rolling back to a SAVEPOINT can undo a TRUNCATE statement
- B. A SAVEPOINT does not issue a COMMIT
- C. Rolling back to a SAVEPOINT can undo a DELETE statement
- D. Rolling back to a SAVEPOINT can undo a CREATE INDEX statement
- E. Only one SAVEPOINT may be issued in a transaction
Answer: B,C
NEW QUESTION 54
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 NOLOGGING clause
- B. Set UNDO_TABLESPACE to UNDOTBS01
- C. Add the SEGMENT SPACE MANAGEMENT AUTO clause
- D. Add the ONLINE clause
- E. Make certain that the database operates in automatic undo management mode
Answer: B,E
NEW QUESTION 55
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 as CURRENT_DATE
- B. CURRENT_TIMESTAMP returns the same date and time as SYSDATE with additional details of fractional seconds
- C. SYSDATE and CURRENT_DATE return the current date and time set for the operating system of the database server
- D. CURRENT_DATE returns the current date and time as per the session time zone
- E. SYSDATE can be queried only from the DUAL table
- F. SYSDATE can be used in expressions only if the default date format is DD-MON-RR
Answer: D,E
NEW QUESTION 56
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:
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 SALES_Q1 tablespace to hold all the rows to be inserted into any table in their schema
- B. The sales user must have been granted the CREATE SESSION privilege
- C. The sales user must have a quota on the TEMP tablespace
- D. The sales user must have been granted the CREATE TABLE privilege
- E. 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
- F. The sales user must have their quota on the users tablespace removed
Answer: D,E,F
NEW QUESTION 57
You execute this command:
Sufficient storage is available in filesystem /u01.
Which two statements are true about the BIG_TBS tablespace? (Choose two.)
- A. It will always have a 32K blocksize
- B. AUTOEXTEND is possible for the datafile
- C. It must be bigger than the largest SMALLFILE tablespace
- D. It will be a dictionary-managed tablespace by default
- E. Additional data files may not be added
Answer: B,C
NEW QUESTION 58
View the Exhibit and examine the structure of the PRODUCTS table.
Which two tasks require subqueries? (Choose two.)
- A. Display the total number of products supplied by supplier 102 which have a product status of obsolete
- B. Display suppliers whose PROD_LIST_PRICE is less than 1000
- C. Display the minimum PROD_LIST_PRICE for each product status
- D. Display the number of products whose PROD_LIST_PRICE is more than the average PROD_LIST_PRICE
- E. Display products whose PROD_MIN_PRICE is more than the average PROD_LIST_PRICE of all products, and whose status is orderable
Answer: D,E
NEW QUESTION 59
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 enables the use of Connection Manager (CMAN) which enables network traffic to be routed through a firewall
- C. Connect Time Failover requires the connect string to have two or more listener addresses configured
- D. Load Balancing can balance the number of connections to dispatchers when using a Shared Server configuration
- E. Source Routing requires the use of a name server
- F. Load Balancing requires the use of a name server
Answer: B,C,E
NEW QUESTION 60
Which three statements are true about table data storage in an Oracle Database? (Choose three.)
- A. Index block free space is always contiguous in the middle of the block
- B. Data block free space is always contiguous in the middle of the block
- C. Multiple row pieces from the same row may be stored in the same block
- D. Multiple row pieces from the same row may be stored in different database blocks
- E. A table row piece can be chained across several database blocks
- F. Data block headers contain their own Data Block Address (DBA)
Answer: D,E,F
Explanation:
Reference:
https://antognini.ch/2016/10/whats-the-difference-between-row-migration-and-row-chaining/
NEW QUESTION 61
Examine this SQL statement:
SELECT cust_id, cust_last_name "Last Name"
FROM customers
WHERE country_id = 10
UNION
SELECT cust_id CUST_NO, cust_last_name
FROM customers
WHERE country_id = 30
Identify three ORDER BY clauses, any one of which can complete the query successfully. (Choose three.)
- A. ORDER BY "CUST_NO"
- B. ORDER BY CUST_NO
- C. ORDER BY 2, 1
- D. ORDER BY "Last Name"
- E. ORDER BY 2, cust_id
Answer: B,C,E
NEW QUESTION 62
Which three statements are true about the DESCRIBE command? (Choose three.)
- A. It can be used from SQL Developer
- B. It displays the PRIMARY KEY constraint for any column or columns that have that constraint
- C. It displays the NOT NULL constraint for any columns that have that constraint
- D. It can be used to display the structure of an existing view
- E. It can be used only from SQL *Plus
- F. It displays all constraints that are defined for each column
Answer: C,D,E
NEW QUESTION 63
Which three statements are true about advanced connection options supported by Oracle Net for connection to Oracle Database instances? (Choose three.)
- A. Source Routing requires the use of a name server
- B. Connect Time Failover requires the use of Transparent Application Failover (TAF)
- C. Source Routing enables the use of Connection Manager (CMAN) which enables network traffic to be routed through a firewall
- D. Connect Time Failover requires the connect string to have two or more listener addresses configured
- E. Load Balancing can balance the number of connections to dispatchers when using a Shared Server configuration
- F. Load Balancing requires the use of a name server
Answer: C,D,E
Explanation:
https://docs.oracle.com/en/database/oracle/oracle-database/12.2/rilin/shared-server-configuration-for-an-oracle-rac-database.html#GUID-2EFBA08D-FEEE-407F-BC42-E548DA946DF9
NEW QUESTION 64
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. The definition for LISTENER_1 requires a CONNECT_DATA section to enable dynamic service registration
- B. There are two listeners named LISTENER and LISTENER_1 running simultaneously using port 1521 on the same host as the database instances
- C. Dynamic service registration cannot be used for this database instance
- D. The LREG process registers services dynamically with the LISTENER_1 listener
- E. LISTENER_1 must also be defined in the LISTENER.ORA file to enable dynamic service registration
Answer: E
NEW QUESTION 65
In the SALES database, DEFERRED_SEGMENT_CREATION is TRUE.
Examine this command:
SQL> CREATE TABLE T1(c1 INT PRIMARY KEY, c2 CLOB);
Which segment or segments, if any, are created as a result of executing the command?
- A. T1, an index segment for the primary key, and a LOB segment only
- B. T1, an index segment for the primary key, a LOB segment, and a lobindex segment
- C. T1 only
- D. no segments are created
- E. T1 and an index segment created for the primary key only
Answer: C
Explanation:
Explanation/Reference:
NEW QUESTION 66
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. A DELETE command on a GLOBAL TEMPORARY TABLE cannot be rolled back.
- C. A GLOBAL TEMPORARY TABLE'S definition is available to multiple sessions.
- D. Any GLOBAL TEMPORARY TABLE rows existing at session termination will be deleted.
- E. GLOBAL TEMPORARY TABLE space allocation occurs at session start.
- F. A TRUNCATE command issued in a session causes all rows in a GLOBAL TEMPORARY TABLE for the issuing session to be deleted.
Answer: A,B,E
NEW QUESTION 67
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. The definition for LISTENER_1 requires a CONNECT_DATA section to enable dynamic service registration
- B. There are two listeners named LISTENER and LISTENER_1 running simultaneously using port 1521 on the same host as the database instances
- C. Dynamic service registration cannot be used for this database instance
- D. The LREG process registers services dynamically with the LISTENER_1 listener
- E. LISTENER_1 must also be defined in the LISTENER.ORA file to enable dynamic service registration
Answer: E
Explanation:
Explanation/Reference: https://docs.oracle.com/database/121/NETAG/listenercfg.htm#NETAG292
NEW QUESTION 68
Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.)
- A. The ADR base defaults to $ORACLE_HOME/dbs if the DIAGNOSTIC_DEST parameter and the ORACLE_BASE environment variable are not set
- B. The ADR base defaults to $ORACLE_HOME/rdbms/admin if
neither DIAGNOSTIC_DEST nor ORACLE_BASE is set - C. It is held inside an Oracle database schema
- D. It supports diagnostics for Oracle Clusterware
- E. It supports diagnostics for Automatic Storage Management (ASM)
Answer: B,C
Explanation:
Explanation/Reference: https://docs.oracle.com/cd/E11882_01/install.112/e27508/admin.htm
NEW QUESTION 69
Examine this command and some partial output:
Why does the DB01.abc.com service show unknown status?
- A. The service DB01.abc.com is dynamically registered
- B. The listener is not listening on the default port 1521
- C. The LOCAL_LISTENER database parameter is not set to a service name that refers to LISTENER_1
- D. The service DB01.abc.com is statically registered
- E. The SID_LIST_LISTENER section is not contained in the LISTENER.ORA file
Answer: D
NEW QUESTION 70
......
1Z0-082 dumps Sure Practice with 118 Questions: https://www.pass4leader.com/Oracle/1Z0-082-exam.html
1Z0-082 Practice Test Questions Answers Updated 118 Questions: https://drive.google.com/open?id=1gBMhdg_S9FP7FCe5KlsI5Zlwhjb8OTmP