Oracle Pass4sure 1z0-082 v2020-10-27 by Isaac 53q
Oracle Pass4sure 1z0-082 v2020-10-27 by Isaac 53q
Oracle Pass4sure 1z0-082 v2020-10-27 by Isaac 53q
Number: 1z0-082
Passing Score: 800
Time Limit: 120 min
File Version: 1
1z0-082
https://www.gratisexam.com/
https://www.gratisexam.com/
885CB989129A5F974833949052CFB2F2
Exam A
QUESTION 1
You execute this command:
https://www.gratisexam.com/
Which two statements are true about the BIG_TBS tablespace? (Choose two.)
Correct Answer: AB
Section: (none)
Explanation
Explanation/Reference:
QUESTION 2
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
https://www.gratisexam.com/
885CB989129A5F974833949052CFB2F2
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
Correct Answer: BC
Section: (none)
Explanation
Explanation/Reference:
QUESTION 3
A database is configured to use automatic undo management with temporary undo enabled.
Correct Answer: A
Section: (none)
Explanation
Explanation/Reference:
Reference: https://docs.oracle.com/database/121/ADMIN/undo.htm#ADMIN11478 (16.7)
QUESTION 4
You have been tasked to create a table for a banking application.
https://www.gratisexam.com/
885CB989129A5F974833949052CFB2F2
Which data type should you use?
Correct Answer: B
Section: (none)
Explanation
Explanation/Reference:
QUESTION 5
In the spfile of a single instance database, LOCAL_LISTENER is set to LISTENER_1.
Correct Answer: C
https://www.gratisexam.com/
885CB989129A5F974833949052CFB2F2
Section: (none)
Explanation
Explanation/Reference:
Reference: https://docs.oracle.com/database/121/NETAG/listenercfg.htm#NETAG292
QUESTION 6
Which three statements are true concerning logical and physical database structures? (Choose three.)
Explanation/Reference:
QUESTION 7
Which three statements are true about a self join? (Choose three.)
Explanation/Reference:
https://www.gratisexam.com/
885CB989129A5F974833949052CFB2F2
QUESTION 8
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.
Correct Answer: B
Section: (none)
Explanation
Explanation/Reference:
QUESTION 9
Which three statements are true about dropping and unused columns in an Oracle database? (Choose three.)
A. A primary key column referenced by another column as a foreign key can be dropped if using the CASCADE option.
B. An UNUSED column’s space is reclaimed automatically when the block containing that column is next queried.
C. An UNUSED column’s space is reclaimed automatically when the row containing that column is next queried.
D. Partition key columns cannot be dropped.
E. A DROP COLUMN command can be rolled back
https://www.gratisexam.com/
885CB989129A5F974833949052CFB2F2
F. A column that is set to UNUSED still counts towards the limit of 1000 columns per table
Explanation/Reference:
QUESTION 10
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
Correct Answer: CE
Section: (none)
Explanation
Explanation/Reference:
QUESTION 11
Evaluate these commands which execute successfully:
https://www.gratisexam.com/
885CB989129A5F974833949052CFB2F2
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
Correct Answer: BE
Section: (none)
Explanation
Explanation/Reference:
QUESTION 12
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
https://www.gratisexam.com/
885CB989129A5F974833949052CFB2F2
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
Explanation/Reference:
QUESTION 13
Which three statements are true about single-row functions? (Choose three.)
Explanation/Reference:
QUESTION 14
You want to use table compression suitable for OLTP that will:
1. Compress rows for all DML statements on that table
2. Minimize the overheads associated with compression
https://www.gratisexam.com/
885CB989129A5F974833949052CFB2F2
C. COLUMN STORE COMPRESS FOR ARCHIVE LOW
D. COLUMN STORE COMPRESS FOR ARCHIVE HIGH
E. ROW STORE COMPRESS ADVANCED
Correct Answer: E
Section: (none)
Explanation
Explanation/Reference:
Reference: https://www.oracle.com/technetwork/database/options/compression/advanced-compression-wp-12c-1896128.pdf
QUESTION 15
Which two statements are true about space-saving features in an Oracle Database? (Choose two.)
Correct Answer: BC
Section: (none)
Explanation
Explanation/Reference:
QUESTION 16
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
Correct Answer: AB
Section: (none)
Explanation
https://www.gratisexam.com/
885CB989129A5F974833949052CFB2F2
Explanation/Reference:
Reference: https://docs.oracle.com/cd/B19306_01/server.102/b14220/process.htm
QUESTION 17
Which two statements are true about the WHERE and HAVING clauses in a SELECT statement? (Choose two.)
A. Aggregating functions and columns used in HAVING clauses must be specified in the SELECT list of a query
B. WHERE and HAVING clauses can be used in the same statement only if applied to different table columns
C. The HAVING clause can be used with aggregating functions in subqueries
D. The WHERE clause can be used to exclude rows before dividing them into groups
E. The WHERE clause can be used to exclude rows after dividing them into groups
Correct Answer: CD
Section: (none)
Explanation
Explanation/Reference:
QUESTION 18
Which two statements are true about UNDO and REDO? (Choose two.)
Correct Answer: AC
Section: (none)
Explanation
Explanation/Reference:
QUESTION 19
The SCOTT/TIGER user exists in two databases, BOSTON_DB and DALLAS_DB, in two different locations.
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?
https://www.gratisexam.com/
A. as SCOTT in DALLAS_DB
B. as SCOTT in BOSTON_DB
C. as SCOTT in BOSTON_DB and SYS in DALLAS_DB
D. as SYS in both the databases
E. as SCOTT in both the databases
Correct Answer: D
Section: (none)
Explanation
Explanation/Reference:
QUESTION 20
Which three statements are true about the DESCRIBE command? (Choose three.)
A. It displays the PRIMARY KEY constraint for any column or columns that have that constraint
B. It can be used from SQL Developer
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 displays all constraints that are defined for each column
F. It can be used only from SQL*Plus
https://www.gratisexam.com/
885CB989129A5F974833949052CFB2F2
Explanation
Explanation/Reference:
QUESTION 21
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.
https://www.gratisexam.com/
885CB989129A5F974833949052CFB2F2
WHERE cust_income_level IS NOT NULL
AND cust_credit_limit IS NOT NULL;
Correct Answer: E
Section: (none)
Explanation
Explanation/Reference:
QUESTION 22
The INVOICE table has a QTY_SOLD column of data type NUMBER and an INVOICE_DATE column of data type DATE.
Which two are true about data type conversions involving these columns in query expressions? (Choose two.)
Correct Answer: BD
Section: (none)
Explanation
Explanation/Reference:
QUESTION 23
Which three are types of segments in an Oracle Database? (Choose three.)
A. undo
B. index
C. stored procedures
D. sequences
E. tables
F. clusters
https://www.gratisexam.com/
885CB989129A5F974833949052CFB2F2
Correct Answer: BEF
Section: (none)
Explanation
Explanation/Reference:
Reference: http://www.adp-gmbh.ch/ora/concepts/segments.html
QUESTION 24
Which two statements are true about the results of using the INTERSECT operator in compound queries? (Choose two.)
Correct Answer: AE
Section: (none)
Explanation
Explanation/Reference:
QUESTION 25
The ORCL database has RESUMABLE__TIMEOUT = 7200 and DEFERRED_SEGMENT_CREATION = FALSE
2017-03-06T12:15:17.183438+05:30
statement in resumable session ‘User U1(136), Session 1, Instance 1’ was suspended due to ORA-01536: space quota
https://www.gratisexam.com/
885CB989129A5F974833949052CFB2F2
exceeded for tablespace ‘DATA’
Which are three actions any one of which the DBA could take to resume the session? (Choose three.)
Explanation/Reference:
QUESTION 26
Which three statements are true about the Oracle Data Dictionary? (Choose three.)
A. Data dictionary views are created by joins of dictionary base tables and DBA-defined tables
B. The data dictionary is created and maintained by the database administrator
C. Views with the same name but different prefixes, such as CDB, DBA, ALL and USER, reference the same base tables from the data dictionary
D. Base tables can be queried directly
E. It is owned by the SYSTEM user
F. Usernames of all users including database administrators are stored in the data dictionary
Explanation/Reference:
QUESTION 27
Examine the description of the PROMOTIONS table:
https://www.gratisexam.com/
885CB989129A5F974833949052CFB2F2
You want to display the unique promotion costs in each promotion category.
Correct Answer: DE
Section: (none)
Explanation
Explanation/Reference:
QUESTION 28
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?
https://www.gratisexam.com/
885CB989129A5F974833949052CFB2F2
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.
Correct Answer: C
Section: (none)
Explanation
Explanation/Reference:
QUESTION 29
Which two statements are true about the rules of precedence for operators? (Choose two.)
A. The concatenation operator | | is always evaluated before addition and subtraction in an expression
B. NULLS influence the precedence of operators in an expression
C. The + binary operator has the highest precedence in an expression in a SQL statement
D. Arithmetic operators with equal precedence are evaluated from left to right within an expression
E. Multiple parentheses can be used to override the default precedence of operators in an expression
Correct Answer: CE
Section: (none)
Explanation
Explanation/Reference:
Reference: https://docs.oracle.com/cd/B19306_01/server.102/b14200/operators001.htm
QUESTION 30
View the Exhibits and examine the structure of the COSTS and PROMOTIONS tables.
You want to display PROD_IDS whose promotion cost is less than the highest cost PROD_ID in a promotion time interval.
https://www.gratisexam.com/
885CB989129A5F974833949052CFB2F2
Exhibit 1.
Exhibit 2.
https://www.gratisexam.com/
885CB989129A5F974833949052CFB2F2
What will be the result?
Correct Answer: D
Section: (none)
Explanation
Explanation/Reference:
QUESTION 31
You need to calculate the number of days from 1st January 2019 until today.
https://www.gratisexam.com/
885CB989129A5F974833949052CFB2F2
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;
Correct Answer: CE
Section: (none)
Explanation
Explanation/Reference:
QUESTION 32
Which two statements are true about the DUAL table? (Choose two.)
Correct Answer: AB
Section: (none)
Explanation
Explanation/Reference:
Reference: https://en.wikipedia.org/wiki/DUAL_table
QUESTION 33
In your data center, Oracle Managed Files (OMF) is used for all databases.
Examine this command which is about to be issued by a DBA logged in to the SALES database:
Which are two actions, either one of which you could take to ensure that the command executes successfully? (Choose two.)
https://www.gratisexam.com/
885CB989129A5F974833949052CFB2F2
A. Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify 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. Add the AUTOEXTEND ON clause with NEXT set to 100M.
E. Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify locations with at least 50 Mb of available space.
Correct Answer: BD
Section: (none)
Explanation
Explanation/Reference:
QUESTION 34
Examine this command and some partial output:
Correct Answer: B
Section: (none)
Explanation
https://www.gratisexam.com/
885CB989129A5F974833949052CFB2F2
Explanation/Reference:
QUESTION 35
Which two statements are true regarding the UNION and UNION ALL operators? (Choose two.)
Correct Answer: BE
Section: (none)
Explanation
Explanation/Reference:
QUESTION 36
Which two statements are true about Enterprise Manager Database Express? (Choose two.)
Correct Answer: DE
Section: (none)
Explanation
Explanation/Reference:
Reference: https://docs.oracle.com/en/database/oracle/oracle-database/19/admqs/getting-started-with-database-administration.html#GUID-EB851101-07BE-4038-
BB9D-06E01CC7F5D5
QUESTION 37
Which two are true about a SQL statement using SET operators such as UNION? (Choose two.)
https://www.gratisexam.com/
885CB989129A5F974833949052CFB2F2
A. The data type group of each column returned by the second query must match the data type 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.
Correct Answer: AC
Section: (none)
Explanation
Explanation/Reference:
QUESTION 38
Which three statements are true about inner and outer joins? (Choose three.)
Explanation/Reference:
Reference: https://www.studytonight.com/dbms/joining-in-sql.php
QUESTION 39
The CUSTOMERS table has a CUST_CREDIT_LIMIT column of data type NUMBER.
https://www.gratisexam.com/
885CB989129A5F974833949052CFB2F2
E. SELECT NVL2(cust_credit_limit, TO_CHAR(cust_credit_limit * .15), ‘Not Available’) FROM customers;
Correct Answer: CE
Section: (none)
Explanation
Explanation/Reference:
QUESTION 40
Which statement is true about aggregate functions?
Correct Answer: A
Section: (none)
Explanation
Explanation/Reference:
QUESTION 41
Your database instance was shut down normally and then started in NOMOUNT state. You then execute this command:
Correct Answer: DF
https://www.gratisexam.com/
885CB989129A5F974833949052CFB2F2
Section: (none)
Explanation
Explanation/Reference:
QUESTION 42
Which two are true about shrinking a segment online? (Choose two.)
Correct Answer: CE
Section: (none)
Explanation
Explanation/Reference:
Reference: https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_3001.htm
QUESTION 43
A script abc.sql must be executed to perform a job.
A database user HR, who is defined in this database, executes this command:
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
Correct Answer: B
Section: (none)
Explanation
https://www.gratisexam.com/
885CB989129A5F974833949052CFB2F2
Explanation/Reference:
QUESTION 44
Which three statements are true regarding indexes? (Choose three.)
Explanation/Reference:
QUESTION 45
Which three statements are true about Oracle synonyms? (Choose three.)
Explanation/Reference:
Reference: https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_7001.htm
QUESTION 46
The SALES_Q1 and USERS tablespaces exist in one of your databases and TEMP is a temporary tablespace.
https://www.gratisexam.com/
885CB989129A5F974833949052CFB2F2
Segment creation is not deferred.
Which three statements must be true so that the SALES user can create tables in SALES_Q1? (Choose three.)
Explanation/Reference:
QUESTION 47
Examine the description of the BOOKS table:
https://www.gratisexam.com/
885CB989129A5F974833949052CFB2F2
The table has 100 rows.
INSERT INTO books VALUES (‘ADV112’, ‘Adventures of Tom Sawyer’, NULL, NULL);
SAVEPOINT a;
DELETE FROM books;
ROLLBACK TO SAVEPOINT a;
ROLLBACK;
Correct Answer: DE
Section: (none)
Explanation
Explanation/Reference:
QUESTION 48
Which three statements are true about external tables in Oracle 18c and later releases? (Choose three.)
A. External table files can be used for other external tables in a different database
B. The ORACLE_LOADER access driver can be used to unload data from a database into an external table
https://www.gratisexam.com/
885CB989129A5F974833949052CFB2F2
C. The ORACLE_DATAPUMP access driver can be used to unload data from a database into an external table
D. They cannot be partitioned
E. The ORACLE_DATAPUMP access driver can be used to load data into a database from an external table
F. They support UPDATEs but not INSERTs and DELETEs
Explanation/Reference:
QUESTION 49
Which three statements are true about the Oracle join and ANSI join syntax? (Choose three.)
A. The Oracle join syntax supports creation of a Cartesian product of two tables
B. The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax
C. The SQL:1999 compliant ANSI join syntax supports natural joins
D. The SQL:1999 compliant ANSI join syntax supports creation of a Cartesian product of two tables
E. The Oracle join syntax only supports right outer joins
F. The Oracle join syntax supports natural joins
G. The Oracle join syntax performs less well than the SQL:1999 compliant ANSI join syntax
Explanation/Reference:
QUESTION 50
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
https://www.gratisexam.com/
885CB989129A5F974833949052CFB2F2
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
Explanation/Reference:
QUESTION 51
You execute this command:
Which two statements are true about the SALES tablespace? (Choose two.)
Correct Answer: DE
Section: (none)
Explanation
Explanation/Reference:
QUESTION 52
Which three activities are recorded in the database alert log? (Choose three.)
https://www.gratisexam.com/
885CB989129A5F974833949052CFB2F2
E. session logins and logouts
Explanation/Reference:
Reference: https://docs.oracle.com/cd/B28359_01/server.111/b28310/monitoring001.htm#ADMIN11247
QUESTION 53
Table ORDER_ITEMS contains columns ORDER_ID, UNIT_PRICE and QUANTITY, of data type NUMBER.
Statement 1:
Statement 2:
Correct Answer: AE
Section: (none)
Explanation
Explanation/Reference:
https://www.gratisexam.com/
885CB989129A5F974833949052CFB2F2
https://www.gratisexam.com/
https://www.gratisexam.com/
885CB989129A5F974833949052CFB2F2