Get 100% Authentic Oracle 1Z0-082 Dumps with Correct Answers
New Training Course 1Z0-082 Tutorial Preparation Guide
NEW QUESTION # 63
Which two statements are true about the WHERE and HAVING clauses in a SELECT statement?
(Choose two.)
- A. The WHERE clause can be used to exclude rows after dividing them into groups
- B. Aggregating functions and columns used in HAVING clauses must be specified in the SELECT list of a query
- C. The WHERE clause can be used to exclude rows before dividing them into groups
- D. The HAVING clause can be used with aggregating functions in subqueries
- E. WHERE and HAVING clauses can be used in the same statement only if applied to different table columns
Answer: C,D
NEW QUESTION # 64
Which two statements are true about the SET VERIFY ON command? (Choose two.)
- A. It displays values for variables prefixed with &&
- B. It displays values for variables used only in the WHERE clause of a query
- C. It displays values for variables created by the DEFINE command
- D. It can be used in SQL Developer and SQL*Plus
- E. It can be used only in SQL*Plus
Answer: A,D
NEW QUESTION # 65
Examine the description of the EMPLOYEES table:
Which query is valid?
- A. SELECT dept_id, MAX(AVG(salary)) FROM employees GROUP BY dept_id;
- B. SELECT dept_id, AVG(MAX(salary)) FROM employees GROUP BY dept_id;
- C. SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id;
- D. SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id, join_date;
Answer: C
NEW QUESTION # 66
Table ORDER_ITEMS contains columns ORDER_ID, UNIT_PRICE and QUANTITY, of data type NUMBER.
Examine these SQL statements:
Statement 1:
SELECT MAX(unit_price * quantity) "Maximum Order"
FROM order_items;
Statement 2:
SELECT MAX(unit_price * quantity) "Maximum Order"
FROM order_items
GROUP BY order_id;
Which two statements are true?
- A. Statement 2 returns only one row of output.
- B. Statement 1 returns only one row of output.
- C. Statement 2 may return multiple rows of output.
- D. Both statements will return NULL if either UNIT_PRICE or QUANTITY contains NULL.
- E. Both the statements give the same output.
Answer: B,C
Explanation:
https://docs.oracle.com/javadb/10.8.3.0/ref/rrefsqlj27781.html
The Expression can contain multiple column references or expressions, but it cannot contain another aggregate or subquery. It must evaluate to a built-in data type. You can therefore call methods that evaluate to built-in data types. (For example, a method that returns a java.lang.Integer or int evaluates to an INTEGER.) If an expression evaluates to NULL, the aggregate skips that value.
NEW QUESTION # 67
Evaluate these commands which execute successfully:
Which two statements are true about the ORD_ITEMS table and the ORD_SEQ sequence? (Choose two.)
- A. Sequence ORD_SEQ cycles back to 1 after every 5000 numbers and can cycle 20 times
- B. If sequence ORD_SEQ is dropped then the default value for column ORD_NO will be NULL for rows inserted into ORD_ITEMS
- C. Any user inserting rows into table ORD_ITEMS must have been granted access to sequence ORD_SEQ
- D. 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
- E. Sequence ORD_SEQ is guaranteed not to generate duplicate numbers
Answer: C,E
NEW QUESTION # 68
Which two statements are true about the DUAL table? (Choose two.)
- A. It can display multiple rows and columns
- B. It can display multiple rows but only a single column
- C. It consists of a single row and single column of VARCHAR2 data type
- D. It can be accessed only by the SYS user
- E. It can be used to display only constants or pseudo columns
- F. It can be accessed by any user who has the SELECT privilege in any schema
Answer: C,D
Explanation:
Explanation/Reference: https://en.wikipedia.org/wiki/DUAL_table
NEW QUESTION # 69
Which is the default column or columns for sorting output from compound queries using SET operators such as intersect In a SQL statement?
- A. the first column in the last select of the compound query
- B. the first number column in the first select of the compound query
- C. the first number or varchar2 column in the last select of the compound query
- D. the first column in the first select of the compound query
- E. the first varchab2 column in the first select of the compound query
Answer: D
NEW QUESTION # 70
Which statement is true about smallfile tablespaces?
- A. The number of data files is constrained only by the size of the storage array.
- B. Maximum file size can be set to unlimited only if the logical volume manager supports striping.
- C. Segments can span multiple tablespaces.
- D. Segments can span multiple data files.
- E. Extent location metadata is stored in the data dictionary by default.
Answer: D
NEW QUESTION # 71
Which two are true about shrinking a segment online? (Choose two.)
- A. To shrink a table it must have a UNIQUE KEY constraint
- B. It is not possible to shrink either indexes or Index Organized Tables (IOTs)
- C. It must be in a tablespace that uses Automatic Segment Space Management (ASSM)
- D. To shrink a table it must have a PRIMARY KEY constraint
- E. It always eliminates all migrated rows if any exist in the table
- F. To shrink a table it must have row movement enabled
Answer: C,F
Explanation:
Reference:
https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_3001.htm
NEW QUESTION # 72
Which is true about security rules on a compute node?
- A. The port used for HTTPS connections is enabled by default based on a predefined security rule.
- B. A compute node port can be enabled only if it is associated with an existing security rule.
- C. New security rules can be defined to use only the TCP protocol but multiple port numbers.
- D. A new database deployment on a compute node automatically enables a set of predefined security rules.
- E. A security rule can restrict IP addresses that can connect to a database instance on a compute node.
Answer: D
NEW QUESTION # 73
Examine the description of the employees table:
Which query requires explicit data type conversion?
- A. SELECT join_date + '20' FROM employees; SELECT salary * '120.50' FROM employees;
- B. SELECT join_date I I ' ' II salary FROM employees;
- C. SELECT SUBSTR<join_date, 1, 2) - 10 FROM employees;
- D. SELECT join_date FROM employees WHERE join_date > '10-02-2018';
Answer: D
NEW QUESTION # 74
Which three statements are true about table data storage in an Oracle Database? (Choose three.)
- A. Data block free space is always contiguous in the middle of the block
- B. Index block free space is always contiguous in the middle of the block
- C. Multiple row pieces from the same row may be stored in different database blocks
- D. Data block headers contain their own Data Block Address (DBA)
- E. Multiple row pieces from the same row may be stored in the same block
- F. A table row piece can be chained across several database blocks
Answer: A,C,F
Explanation:
Explanation/Reference: https://books.google.com.pk/books?id=lNtVjrmbzckC&pg=PA267&lpg=PA267&dq=Multiple+row
+pieces+from+the+same+row+may+be+stored+in+different+database
+blocks&source=bl&ots=lEIhFe2Q52&sig=ACfU3U1TETJPy194pARxfIJ5ROaQdySCMQ&hl=en&sa=X&ved=2 ahUKEwivveLa97_mAhWOzaQKHahYAVEQ6AEwAnoECAoQAQ#v=onepage&q=Multiple%20row%20pieces
%20from%20the%20same%20row%20may%20be%20stored%20in%20different%20database%
20blocks&f=false
NEW QUESTION # 75
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?
- A. Set OS_AUTHENT_PREFIX to OPS$
- B. Unset REMOTE_LOGIN_PASSWORDFILE
- C. Grant DBA to KING
- D. Alter user KING to be IDENTIFIED EXTERNALLY
- E. Have the OS administrator add KING to the OSDBA group
Answer: B
NEW QUESTION # 76
Which three are types of segments in an Oracle Database? (Choose three.)
- A. clusters
- B. stored procedures
- C. tables
- D. sequences
- E. undo
- F. index
Answer: A,C,F
Explanation:
http://www.adp-gmbh.ch/ora/concepts/segments.html
NEW QUESTION # 77
You want to apply the principle of Least Privilege in all your live databases.
One of your requirements is to revoke unnecessary privileges from all users who have them using Privilege Analysis.
Which three types of analyses can be done using the DBMS_PRIVILEGE_CAPTURE package? (Choose three.)
- A. analysis of privileges that a user has on their own schema objects that they did not use
- B. analysis of privileges granted indirectly to a role that are then used by a user who has been granted that role
- C. analysis of all privileges used by all users including administrative users in the database
- D. analysis of all privileges used by all users but excluding administrative users in the database
- E. analysis of privileges that a user has on their own schema objects that they did use
- F. analysis of privileges granted directly to a role that are then used by a user who has been granted that role
Answer: A,B,C
Explanation:
Explanation/Reference: https://docs.oracle.com/database/121/ARPLS/d_priv_prof.htm#ARPLS74328
NEW QUESTION # 78
In the promotions table, the PROMO_BEGIN_DATE column is of data type date and the default date format Is DD-MON-RR.
h two statements are true about expressions using PROMO_BEGIN_DATE contained In a query?
- A. TO_date(PROMO_ BEGIN_DATE * 5| will return a date.
- B. PROMO_ BEGIN_DATE - sysdate will return an error.
- C. PROMO_ BEGIN_DATE - sysdate will return a number.
- D. to_numberipromo_begin_date) - s will return a number.
- E. PROMO_ BEGIN_DATE - 5 will return a date.
Answer: B,E
NEW QUESTION # 79
Which two are true about shrinking a segment online? (Choose two.)
- A. To shrink a table it must have a UNIQUE KEY constraint
- B. It is not possible to shrink either indexes or Index Organized Tables (IOTs)
- C. It must be in a tablespace that uses Automatic Segment Space Management (ASSM)
- D. To shrink a table it must have a PRIMARY KEY constraint
- E. It always eliminates all migrated rows if any exist in the table
- F. To shrink a table it must have row movement enabled
Answer: D,F
Explanation:
https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_3001.htm
NEW QUESTION # 80
Which two statements are true about Enterprise Manager Database Express? (Choose two.)
- A. The same port number can be used for Database Express configurations for databases on different hosts
- B. It can be used to perform database recovery
- C. It is available only when the database is open
- D. The same port number can be used for multiple Database Express configurations for multiple databases on the same host
- E. It can be used to switch a database into ARCHIVELOGMODE
Answer: D,E
NEW QUESTION # 81
Examine the description of the EMPLOYEES table:
Which query is valid?
- A. SELECT dept_id, MAX(AVG(salary)) FROM employees GROUP BY dept_id;
- B. SELECT dept_id, AVG(MAX(salary)) FROM employees GROUP BY dept_id;
- C. SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id;
- D. SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id, join_date;
Answer: C
NEW QUESTION # 82
Which two tasks can you perform using DBCA for databases? (Choose two.)
- A. Configure incremental backups for a new database
- B. Change the standard block size of an existing database
- C. Configure a nonstandard block size for a new database
- D. Register a new database with an available Enterprise Manager Management server
- E. Enable flashback database for an existing database
Answer: C,D
NEW QUESTION # 83
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. Add the ONLINE clause
- C. Add the SEGMENT SPACE MANAGEMENT AUTO clause
- D. Set UNDO_TABLESPACE to UNDOTBS01
- E. Make certain that the database operates in automatic undo management mode
Answer: D,E
NEW QUESTION # 84
Which two statements are true about trace files produced by the Oracle Database server? (Choose two.)
- A. Trace files are written to the Fast Recovery Area (FRA)
- B. They can be written by server processes
- C. All trace files contain error information that require contacting Oracle Support
- D. Trace file names are based on the database name concatenated with a sequential number
- E. They can be written by background processes
Answer: B,E
Explanation:
Explanation/Reference: https://gerardnico.com/db/oracle/trace_file
NEW QUESTION # 85
Which three statements are true about single-row functions? (Choose three.)
- A. They return a single result row per table
- B. They can accept only one argument
- C. The argument can be a column name, variable, literal or an expression
- D. The data type returned can be different from the data type of the argument
- E. They can be used only in the WHERE clause of a SELECT statement
- F. They can be nested to any level
Answer: A,C,D
Explanation:
Explanation/Reference: https://www.folkstalk.com/2012/01/oracle-single-row-functions-examples.html
NEW QUESTION # 86
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
Which compression option is best suited for this?
- A. COLUMN STORE COMPRESS FOR ARCHIVE LOW
- B. ROW STORE COMPRESS ADVANCED
- C. ROW STORE COMPRESS BASIC
- D. COLUMN STORE COMPRESS FOR ARCHIVE HIGH
- E. COLUMN STORE COMPRESS FOR QUERY LOW
Answer: B
Explanation:
Explanation/Reference: https://www.oracle.com/technetwork/database/options/compression/advanced-compression-wp-
12c-1896128.pdf
NEW QUESTION # 87
......
Dumps of 1Z0-082 Cover all the requirements of the Real Exam: https://realexamcollection.examslabs.com/Oracle/Oracle-Database-19c/best-1Z0-082-exam-dumps.html