1Z0-082 Actual Questions Answers PDF 100% Cover Real Exam Questions
1Z0-082 Exam questions and answers
NEW QUESTION # 79
Which three statements are true about dropping and unused columns in an Oracle database?
(Choose three.)
- A. A column that is set to UNUSED still counts towards the limit of 1000 columns per table
- B. An UNUSED column's space is reclaimed automatically when the block containing that column is next queried.
- C. A DROP COLUMN command can be rolled back
- D. A primary key column referenced by another column as a foreign key can be dropped if using the CASCADE option.
- E. An UNUSED column's space is reclaimed automatically when the row containing that column is next queried.
- F. Partition key columns cannot be dropped.
Answer: A,B,D
NEW QUESTION # 80
Examine this command:
Which two statements are true? (Choose two.)
- A. The file is renamed and stored in the same location
- B. The tablespace containing SALES1.DBF must be altered READ ONLY before executing the command.
- C. If Oracle Managed Files (OMF) is used, then the file is renamed but moved to DB_CREATE_FILE_DEST.
- D. The tablespace containing SALES1.DBF must be altered OFFLINE before executing the command.
- E. DML may be performed on tables with one or more extents in this data file during the execution of this command.
Answer: B,E
NEW QUESTION # 81
A script abc.sql must be executed to perform a job.
A database user HR, who is defined in this database, executes this command:
$ sqlplus hr/hr@orcl @abc.sql
What will happen upon execution?
- A. The command succeeds and HR will be connected to the orcl and abc.sql databases
- B. The command fails because the script must refer to the full path name
- C. The command fails and reports an error because @ is used twice
- D. The command succeeds and HR will be connected to the orcl database instance, and the abc.sql script will be executed
Answer: D
Explanation:
Explanation
NEW QUESTION # 82
Evaluate these commands which execute successfully:
Which two statements are true about the ORD_ITEMS table and the ORD_SEQ sequence? (Choose two.)
- A. Any user inserting rows into table ORD_ITEMS must have been granted access to sequence ORD_SEQ
- B. Sequence ORD_SEQ is guaranteed not to generate duplicate numbers
- 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. If sequence ORD_SEQ is dropped then the default value for column ORD_NO will be NULL for rows inserted into ORD_ITEMS
Answer: A,C
NEW QUESTION # 83
Examine the description of the EMPLOYEES table:
Which query is valid?
- A. SELECT dept_id, join_date, SUM(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, join_date;
- D. SELECT dept_id, MAX(AVG(salary)) FROM employees GROUP BY dept_id;
Answer: C
NEW QUESTION # 84
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.
Which query can be used?
SELECT &&col1, &&col2
- A. FROM &table
WHERE &&condition; - B. FROM "&table"
WHERE &condition;
SELECT '&&col1', '&&col2' - C. FROM &table
WHERE '&&condition' = '&cond';
SELECT &&col1, &&col2 - D. FROM &table
WHERE &&condition = &&cond;
SELECT &col1, &col2 - E. FROM &&table
WHERE &condition;
SELECT &col1, &col2
Answer: E
NEW QUESTION # 85
The ORCL database has RESUMABLE__TIMEOUT = 7200 and DEFERRED_SEGMENT_CREATION = FALSE User U1 has a 1 MB quota in tablespace DATA.
U1 executes this command:
SQL> CREATE TABLE t1 AS
(SELECT object_name, sharing, created
FROM dba_objects);
U1 complains that the command is taking too long to execute.
In the alert log, the database administrator (DBA) finds this:
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 exceeded for tablespace 'DATA' Which are three actions any one of which the DBA could take to resume the session? (Choose three.)
- A. Grant UNLIMITED TABLESPACE to U1
- B. Increase U1's quota sufficiently in DATA
- C. Set AUTOEXTEND ON for data files in DATA
- D. Add a data file to DATA
- E. Set DEFERRED_SEGMENT_CREATION to TRUE
- F. Drop other U1 objects in DATA
Answer: A,B,F
NEW QUESTION # 86
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.
Which query should be used?
- A. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT FROM customers WHERE cust_income_level <> NULL AND due_amount <> NULL;
- B. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT FROM customers WHERE cust_income_level != NULL AND due_amount != NULL;
- C. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT FROM customers WHERE cust_income_level IS NOT NULL AND due_amount IS NOT NULL;
- D. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT FROM customers WHERE cust_income_level IS NOT NULL AND cust_credit_limit IS NOT NULL;
- E. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT FROM customers WHERE cust_income_level != NULL AND cust_credit_level !=NULL;
Answer: D
NEW QUESTION # 87
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. Alter user KING to be IDENTIFIED EXTERNALLY
- C. Have the OS administrator add KING to the OSDBA group
- D. Grant DBA to KING
- E. Unset REMOTE_LOGIN_PASSWORDFILE
Answer: E
NEW QUESTION # 88
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.
Examine this SQL statement:
Exhibit 1.
Exhibit 2.
What will be the result?
- A. It executes successfully and gives the required result
- B. It executes successfully but does not give the required result
- C. It gives an error because the GROUP BY clause is not valid
- D. It gives an error because the ALL keyword is not valid
Answer: A
NEW QUESTION # 89
Which three are types of segments in an Oracle Database? (Choose three.)
- A. undo
- B. sequences
- C. index
- D. stored procedures
- E. clusters
- F. tables
Answer: C,E,F
Explanation:
Explanation/Reference: http://www.adp-gmbh.ch/ora/concepts/segments.html
NEW QUESTION # 90
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 use
- B. analysis of all privileges used by all users but excluding administrative users in the database
- C. analysis of all privileges used by all users including administrative users in the database
- D. analysis of privileges granted directly to a role that are then used by a user who has been granted that role
- E. analysis of privileges that a user has on their own schema objects that they did not use
- F. analysis of privileges granted indirectly to a role that are then used by a user who has been granted that role
Answer: C,E,F
NEW QUESTION # 91
You currently have an active transaction in your session and have been granted select access to vstransaction.
In which three situations will re-executing this query still return a row but with a different XID, indicating a new transaction has started?
- A. after successfully executing a truncate statement followed by a DML statement
- B. after successfully executing a create table as select statement followed by a select for update statement
- C. after successfully executing a commit or rollback followed by a select statement
- D. after successfully executing a commit or rollback followed by a DML statement
- E. after successfully executing a create table statement followed by a create index statement
- F. after successfully executing a DML statement following a failed DML statement
Answer: A,B,D
NEW QUESTION # 92
Which three statements are true about a self join? (Choose three.)
- A. It must be an equijoin
- B. It can be an outer join
- C. The query must use two different aliases for the table
- D. The ON clause must be used
- E. It must be an inner join
- F. The ON clause can be used
Answer: C,E,F
Explanation:
Explanation
NEW QUESTION # 93
The CUSTOMERS table has a CUST_CREDIT_LIMIT column of data type NUMBER.
Which two queries execute successfully? (Choose two.)
- A. SELECT TO_CHAR(NVL(cust_credit_limit * .15, 'Not Available')) FROM customers;
- B. SELECT NVL(cust_credit_linit * .15, 'Not Available') FROM customers;
- C. SELECT NVL(TO_CHAR(cust_credit_limit * .15), 'Not Available') FROM customers;
- D. SELECT NVL2(cust_credit_limit, TO_CHAR(cust_credit_limit * .15), 'Not Available') FROM customers;
- E. SELECT NVL2(cust_credit_linit * .15, 'Not Available') FROM customers;
Answer: C,E
NEW QUESTION # 94
Which three statements are true about undo segments and the use of undo by transactions in an Oracle database instance? (Choose three.)
- A. Undo segments can wrap around to the first extent when a transaction fills the last extend of the undo segment
- B. Undo segments can extend when a transaction fills the last extent of the undo segment
- C. Undo segments have a minimum of three extents
- D. A single transaction may use multiple undo segments simultaneously
- E. An undo segment may be used by multiple transactions simultaneously
- F. Undo segments must be stored in a SMALLFILE tablespace
- G. Undo segments must be stored in a BIGFILE tablespace
Answer: B,E,F
NEW QUESTION # 95
......
UpdateDumps 1Z0-082 Exam Practice Test Questions: https://www.updatedumps.com/Oracle/1Z0-082-updated-exam-dumps.html
Pass 1Z0-082 Exam Info and Free Practice Test: https://drive.google.com/open?id=1FK0nqewPgZDNn9iQ-ZeeMJRGeAACE5PO