Get Real 1Z0-082 Quesions Pass Oracle Certification Exams Easily
1Z0-082 Dumps are Available for Instant Access
NEW QUESTION # 77
You have been tasked to create a table for a banking application.
One of the columns must meet three requirements:
* Be stored in a format supporting date arithmetic without using conversion functions
* Store a loan period of up to 10 years
* Be used for calculating interest for the number of days the loan remains unpaid Which data type should you use?
- A. INTERVAL YEAR TO MONTH
- B. INTERVAL DAY TO SECOND
- C. TIMESTAMP WITH TIMEZONE
- D. TIMESTAMP
- E. TIMESTAMP WITH LOCAL TIMEZONE
Answer: B
NEW QUESTION # 78
Which two statements are true about Enterprise Manager Database Express? (Choose two.)
- A. It can be used to perform database recovery
- B. The same port number can be used for multiple Database Express configurations for multiple databases on the same host
- C. The same port number can be used for Database Express configurations for databases on different hosts
- D. It is available only when the database is open
- E. It can be used to switch a database into ARCHIVELOGMODE
Answer: B,E
NEW QUESTION # 79
Which statement is true about aggregate functions?
- A. The MAX and MIN functions can be used on columns with character data types
- B. Aggregate functions can be nested to any number of levels
- C. The AVG function implicitly converts NULLS to zero
- D. Aggregate functions can be used in any clause of a SELECT statement
Answer: A
NEW QUESTION # 80
Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.)
- A. It supports diagnostics for Automatic Storage Management (ASM)
- B. It supports diagnostics for Oracle Clusterware
- C. The ADR base defaults to $ORACLE_HOME/dbs if the DIAGNOSTIC_DEST parameter and the ORACLE_BASE environment variable are not set
- D. It is held inside an Oracle database schema
- E. The ADR base defaults to $ORACLE_HOME/rdbms/admin ifneither DIAGNOSTIC_DEST nor ORACLE_BASE is set
Answer: D,E
NEW QUESTION # 81
Which two are true about shrinking a segment online? (Choose two.)
- A. It is not possible to shrink either indexes or Index Organized Tables (IOTs)
- B. It always eliminates all migrated rows if any exist in the table
- C. To shrink a table it must have row movement enabled
- D. To shrink a table it must have a PRIMARY KEY constraint
- E. It must be in a tablespace that uses Automatic Segment Space Management (ASSM)
- F. To shrink a table it must have a UNIQUE KEY constraint
Answer: C,E
Explanation:
Reference:
https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_3001.htm
NEW QUESTION # 82
Examine the description of the customers table:
You need to display last names and credit limits of all customers whose last name starts with A or B in lower or upper case, and whose credit limit Is below 1000.
Examine this partial query:
SELECT cust_last_name, cust_credit_limit FROM customers
Which two where conditions give the required result?
A)
C)
D)
E)
- A. Option C
- B. Option B
- C. Option A
- D. Option D
- E. Option E
Answer: A,E
NEW QUESTION # 83
You have been tasked to create a table for a banking application.
One of the columns must meet three requirements:
1. Be stored in a format supporting date arithmetic without using
conversion functions
2. Store a loan period of up to 10 years
3. Be used for calculating interest for the number of days the loan
remains unpaid
Which data type should you use?
- A. INTERVAL YEAR TO MONTH
- B. INTERVAL DAY TO SECOND
- C. TIMESTAMP WITH TIMEZONE
- D. TIMESTAMP
- E. TIMESTAMP WITH LOCAL TIMEZONE
Answer: B
NEW QUESTION # 84
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 fails and returns the error message "ORA-30036: unable to extend segment by 8 in undo tablespace
'UNDOTBS1'". - B. It succeeds and the least recently read undo block of UNDOTBS1 is overwritten by the generated undo.
- C. It succeeds and the generated undo is stored in SYSAUX.
- D. It succeeds and the generated undo is stored in SYSTEM.
- E. It succeeds and the least recently written undo block of UNDOTBS1 is overwritten by the generated undo.
Answer: E
NEW QUESTION # 85
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. SYSDATE can be queried only from the DUAL table
- B. CURRENT_TIMESTAMP returns the same date as CURRENT_DATE
- C. SYSDATE can be used in expressions only if the default date format is DD-MON-RR
- D. CURRENT_DATE returns the current date and time as per the session time zone
- E. CURRENT_TIMESTAMP returns the same date and time as SYSDATE with additional details of fractional seconds
- F. SYSDATE and CURRENT_DATE return the current date and time set for the operating system of the database server
Answer: A,D
NEW QUESTION # 86
Which is true about roles?
- A. Roles containing object privileges can be created only by the object owner.
- B. Roles can be created only by SYS or SYSTEM.
- C. A role can be granted to other roles.
- D. All roles belong to the SYSTEM schema.
- E. A role can be password-protected only if it has been granted system privileges.
Answer: E
NEW QUESTION # 87
Which three statements are true about Deferred Segment Creation in Oracle databases?
- A. It is supported for SYS-owned tables contained in locally managed tablespaces.
- B. Indexes inherit the deferred or immediate segment creation attribute from their parent table
- C. Sessions may dynamically switch back and forth from deferred to immediate segment creation.
- D. It Is supported for Index Organized Tables (IOTs) contained in locally managed tablespaces.
- E. It Is the default behavior for tables and indexes.
Answer: B,C,E
NEW QUESTION # 88
Which two statements are true about the DUAL table? (Choose two.)
- A. It can be used to display only constants or pseudo columns
- B. It can be accessed by any user who has the SELECT privilege in any schema
- C. It can display multiple rows but only a single column
- D. It can be accessed only by the SYS user
- E. It consists of a single row and single column of VARCHAR2 data type
- F. It can display multiple rows and columns
Answer: E,F
Explanation:
Reference:
https://en.wikipedia.org/wiki/DUAL_table
NEW QUESTION # 89
The orders table has a column ORDER_DATE of data type date.
The default display format for a date Is DD-MON-RR.
Which two where conditions demonstrate the correct usage of conversion functions?
- A. WHERE order_date > TO_CHAR(ADD_MONTHS(SYSDATE, 6), 'MON DD YYYY')
- B. WHERE order_date IN (TO_DATE ('Oct 21 2018', 'Mon DD YYYY'), TC_CHAR('Nov 21 2018', 'Mon DD YYYY'))
- C. WHERE order date > TO DATE('JUL 10 2018', *MON DD YYYY')
- D. WHERE TO_CHAR(order_date, 'MON DD YYYY') = 'JAN 20 2019'
- E. WHERE order_date > TO_DATE<ADD_MONTHS(SYSDATE, c) , 'MON DD YYYY')
Answer: C,D
NEW QUESTION # 90
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 records checkpoint information in the control file
- C. It frees resources held by abnormally terminated processes
- D. It kills sessions that exceed idle time
- E. It frees unused temporary segments
Answer: C,D
Explanation:
Reference:
* Performs process recovery when a user process fails - Cleans up the database buffer cache - Frees resources that are used by the user process * Monitors sessions for idle session timeout
NEW QUESTION # 91
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 1 returns only one row of output.
- B. Statement 2 returns only one row of output.
- C. Both statements will return NULL if either UNIT_PRICE or QUANTITY contains NULL.
- D. Both the statements give the same output.
- E. Statement 2 may return multiple rows of output.
Answer: A,E
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 # 92
Which three statements are true concerning logical and physical database structures? (Choose three.)
- A. A segment can span multiple data files in some tablespaces
- B. Segments can span multiple tablespsaces
- C. The extents of a segment must always reside in the same datafile
- D. A segment's blocks can be of different sizes
- E. A segment might have only one extent
- F. A smallfile tablespace might be bigger than a bigfile tablespace
- G. All tablespaces may have one or more data files
Answer: B,E,F
NEW QUESTION # 93
Which two statements are true about Enterprise Manager Database Express? (Choose two.)
- A. It can be used to perform database recovery
- B. It can be used to switch a database into ARCHIVELOGMODE
- C. The same port number can be used for multiple Database Express configurations for multiple databases on the same host
- D. It is available only when the database is open
- E. The same port number can be used for Database Express configurations for databases on different hosts
Answer: D,E
NEW QUESTION # 94
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 value of the SERVICE_NAMES parameter on the client side
- C. It must resolve to a valid connect descriptor in the server's tnsnames.ora file
- D. It must be the name of the database to whose instance HR wishes to connect
- E. It must resolve to a valid connect descriptor in the client's tnsnames.ora file
Answer: E
NEW QUESTION # 95
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. The WITH CHECK clause prevents certain rows from being updated or inserted
- F. Deleting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error
- G. Inserting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error
Answer: B,D,G
NEW QUESTION # 96
......
Get Instant Access REAL 1Z0-082 DUMP Pass Your Exam Easily: https://www.passsureexam.com/1Z0-082-pass4sure-exam-dumps.html
Practice with these 1Z0-082 dumps Certification Sample Questions: https://drive.google.com/open?id=1jr3iCjB-5U2fYGNnwEBkmqTbmdfSW9wp