1Z0-082 Certification Overview - [Jan 02, 2022] Latest 1Z0-082 PDF Dumps
The Best Oracle 1Z0-082 Study Guides and Dumps of 2022
How much Oracle 1z0-082: Oracle Database Administration I Exam Cost
The price of the Oracle 1Z0-068 Exam is USD 245, for more information related to the Oracle 1Z0-068 Exam please visit Oracle website.
NEW QUESTION 42
Which two statements are true about the results of using the INTERSECT operator in compound queries? (Choose two.)
- A. INTERSECT returns rows common to both sides of the compound query
- B. INTERSECT ignores NULLs
- C. Reversing the order of the intersected tables can sometimes affect the output
- D. Column names in each SELECT in the compound query can be different
- E. The number of columns in each SELECT in the compound query can be different
Answer: B,D
NEW QUESTION 43
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 44
Which two statements are true about the PMON background process? (Choose two.)
- A. It kills sessions that exceed idle time
- B. It frees resources held by abnormally terminated processes
- C. It registers database services with all local and remote listeners known to the database instance
- D. It records checkpoint information in the control file
- E. It frees unused temporary segments
Answer: B,C
Explanation:
Explanation/Reference: https://docs.oracle.com/cd/B19306_01/server.102/b14220/process.htm
NEW QUESTION 45
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 promo_cost, promo_category FROM promotions ORDER BY by 1;
- B. SELECT promo_category, DISTINCT promo_cost FROM promotions ORDER BY 2;
- C. SELECT DISTINCT promo_category || ` has ` || promo_cost AS COSTS FROM promotions ORDER BY 1;
- D. SELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1;
- E. SELECT DISTINCT promo_cost || ' in ` || DISTINCT promo_category FROM promotions ORDER BY 1;
Answer: B,D
NEW QUESTION 46
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. TIMESTAMP WITH LOCAL TIMEZONE
- B. TIMESTAMP
- C. INTERVAL DAY TO SECOND
- D. TIMESTAMP WITH TIMEZONE
- E. INTERVAL YEAR TO MONTH
Answer: C
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 statements are true about views in an Oracle database? (Choose three.)
- A. Tables in the defining query of a view must always exist in order to create the view
- B. The WITH CHECK clause prevents certain rows from being displayed when querying the view
- C. Data Manipulation Language (DML) can always be used on views
- D. The WITH CHECK clause prevents certain rows from being updated or inserted
- E. Deleting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error
- F. Inserting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error
- G. Views can be updated without the need to re-grant privileges on the view
Answer: E,F,G
NEW QUESTION 49
Which two statements are true about single row functions? (Choose two.)
- A. CEIL : can be used for positive and negative numbers
- B. CONCAT : can be used to combine any number of values
- C. FLOOR : returns the smallest integer greater than or equal to a specified number
- D. TRUNC : can be used to combine any number of values
- E. MOD : returns the quotient of a division operation
Answer: D,E
NEW QUESTION 50
In one of your databases, you create a user, HR, and then execute this command:
GRANT CREATE SESSION TO hr WITH ADMIN OPTION;
Which three actions can HR perform? (Choose three.)
- A. Revoke the CREATE SESSION privilege from user HR
- B. Execute DML statements in the HR schema
- C. Log in to the database instance
- D. Grant the CREATE SESSION privilege with ADMIN OPTION to other users
- E. Execute DDL statements in the HR schema
- F. Revoke the CREATE SESSION privilege from other users
Answer: C,D,F
Explanation:
Reference:
https://docs.oracle.com/cd/B28359_01/network.111/b28531/authorization.htm#DBSEG224
NEW QUESTION 51
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. DUES FROM transactions;
SELECT customer_id AS CUSTOMER-ID, transaction_date AS TRANS_DATE, amount + - C. "DUES" FROM transactions;
SELECT customer_id AS "CUSTOMER-ID", transaction_date AS "DATE", amount + 100 - D. 'DUES AMOUNT' FROM transactions;
- E. 100 "DUES AMOUNT" FROM transactions;
SELECT customer_id CUSTID, transaction_date TRANS_DATE, amount + 100 DUES FROM
Answer: A,B
NEW QUESTION 52
Which two statements are true about space-saving features in an Oracle Database? (Choose two.)
- A. If they exist for a session, Private Temporary Tables (PTTs) are always dropped at the next COMMIT OR ROLLBACK statement
- B. An index created with the UNUSABLE attribute has no segment
- C. An index that is altered to be UNUSABLE will retain its segment
- D. A table that is truncated will always have its segment removed
- E. Private Temporary Tables (PTTS) store metadata in memory only
Answer: A,B
NEW QUESTION 53
Which three statements are true about views in an Oracle database? (Choose three.)
- A. Data Manipulation Language (DML) can always be used on views
- B. The WITH CHECK clause prevents certain rows from being displayed when querying the view
- C. The WITH CHECK clause prevents certain rows from being updated or inserted
- D. Tables in the defining query of a view must always exist in order to create the view
- E. Views can be updated without the need to re-grant privileges on the view
- 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: A,D,G
NEW QUESTION 54
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:
https://docs.oracle.com/cd/B28359_01/server.111/b28310/monitoring001.htm#ADMIN11247
NEW QUESTION 55
Which three statements are true about single-row functions? (Choose three.)
- A. They can be used only in the WHERE clause of a SELECT statement
- B. The data type returned can be different from the data type of the argument
- C. The argument can be a column name, variable, literal or an expression
- D. They can accept only one argument
- E. They can be nested to any level
- F. They return a single result row per table
Answer: B,C,F
NEW QUESTION 56
Examine this command and some partial output:
Why does the DB01.abc.comservice 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 service DB01.abc.com is statically registered
- D. The LOCAL_LISTENER database parameter is not set to a service name that refers to LISTENER_1
- E. The SID_LIST_LISTENER section is not contained in the LISTENER.ORA file
Answer: D
NEW QUESTION 57
Which three statements are true about GLOBAL TEMPORARY TABLES? (Choose three.)
- A. GLOBAL TEMPORARY TABLE space allocation occurs at session start.
- B. GLOBAL TEMPORARY TABLE rows inserted by a session are available to any other session whose user has been granted select on the table.
- C. A TRUNCATE command issued in a session causes all rows in a GLOBAL TEMPORARY TABLE for the issuing session to be deleted.
- D. Any GLOBAL TEMPORARY TABLE rows existing at session termination will be deleted.
- E. A DELETE command on a GLOBAL TEMPORARY TABLE cannot be rolled back.
- F. A GLOBAL TEMPORARY TABLE'S definition is available to multiple sessions.
Answer: C,D,F
Explanation:
https://docs.oracle.com/javadb/10.8.3.0/ref/rrefdeclaretemptable.html
NEW QUESTION 58
......
Valid 1Z0-082 Exam Updates - 2022 Study Guide: https://www.passsureexam.com/1Z0-082-pass4sure-exam-dumps.html
Top Oracle 1Z0-082 Exam Audio Study Guide! Practice Questions Edition: https://drive.google.com/open?id=18hOt16UMFYALTaomTdA2LolDIWGWqivN