Oracle 1z0-082 Free Practice Questions

NEW QUESTION 1
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

Answer: CE

NEW QUESTION 2
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?

• A. SELECT &&col1, &&col2FROM &tableWHERE &&condition = &&cond;
• B. SELECT &col1, &col2FROM &&tableWHERE &condition;
• C. SELECT &col1, &col2FROM “&table”WHERE &condition;
• D. SELECT ‘&&col1’, ‘&&col2’FROM &tableWHERE ‘&&condition’ = ‘&cond’;
• E. SELECT &&col1, &&col2FROM &tableWHERE &&condition;

Answer: B

NEW QUESTION 3
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 LOCAL TIMEZONE
• D. TIMESTAMP
• E. TIMESTAMP WITH TIMEZONE

Answer: B

NEW QUESTION 4
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

Answer: AB

NEW QUESTION 5
You execute this command:
CREATE SMALLFILE TABLESPACE sales
DATAFILE ‘/u01/app/oracle/sales01.dbf SIZE 5G
SEGMENT SPACE MANAGEMENT AUTO;
Which two actions must you take to ensure UNDOTBS01 is used as the default UNDO tablespace? (Choose two.)

• A. It must be smaller than the smallest BIGFILE tablespace
• B. Free space is managed using freelists
• C. Any data files added to the tablespace must have a size of 5 gigabytes
• D. It uses the database default blocksize
• E. It is a locally managed tablespace

Answer: DE

NEW QUESTION 6
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 succeeds and the generated undo is stored in SYSTEM.
• B. It fails and returns the error message “ORA-30036: unable to extend segment by 8 in undo tablespace ‘UNDOTBS1’ “.
• 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.

Answer: C

NEW QUESTION 7
Which three statements are true about the tools used to configure Oracle Net Services? (Choose three.)

• A. The Oracle Net Configuration Assistant is only used when running the Oracle installer
• B. Oracle Net Manager can be used to centrally configure listeners on any database server target
• C. The lsnrctl utility requires a listener.ora file to exist before it is started
• D. Oracle Net Manager can be used to locally configure naming methods on a database server
• E. Enterprise Manager Cloud Control can be used to centrally configure listeners on any managed database server
• F. Enterprise Manager Cloud Control can be used to centrally configure net service names for any databaseserver target

Answer: BDE

NEW QUESTION 8
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_AMOUNTFROM customersWHEREcust_incoms_level IS NOT NULLAND due_amount IS NOT NULL;
• B. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level != NULLAND cust_credit_level !=NULL;
• C. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level <> NULLAND due_amount <> NULL;
• D. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level != NULLAND due_amount !=NULL;
• E. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level IS NOT NULLAND cust_credit_limit IS NOT NULL;

Answer: E

NEW QUESTION 9
Which two statements are true about Enterprise Manager Database Express? (Choose two.)

• A. It is available only when the database is open
• B. It can be used to perform database recovery
• C. The same port number can be used for Database Express configurations for databases on different hosts
• D. It can be used to switch a database into ARCHIVELOGMODE
• E. The same port number can be used for multiple Database Express configurations for multiple databases on the same host

Answer: DE

NEW QUESTION 10
Which two statements are true about the DUAL table? (Choose two.)

• A. It can be accessed only by the SYS user
• B. It consists of a single row and single column of VARCHAR2 data type
• C. It can display multiple rows but only a single column
• D. It can be used to display only constants or pseudo columns
• E. It can be accessed by any user who has the SELECT privilege in any schema
• F. It can display multiple rows and columns

Answer: AB

NEW QUESTION 11
Which three statements are true regarding indexes? (Choose three.)

• A. A UNIQUE index can be altered to be non-unique
• B. A SELECT statement can access one or more indices without accessing any tables
• C. A table belonging to one user can have an index that belongs to a different user
• D. An update to a table can result in updates to any or all of the table’s indexes
• E. When a table is dropped and is moved to the RECYCLE BIN, all indexes built on that table are permanently dropped
• F. An update to a table can result in no updates to any of the table’s indexes

Answer: ADE

NEW QUESTION 12
The SALES_Q1 and USERS tablespaces exist in one of your databases and TEMP is a temporary tablespace. Segment creation is not deferred.
You execute this command:

Which three statements must be true so that the SALES user can create tables in SALES_Q1? (Choose three.)

• A. The sales user must have a quota on the TEMP tablespace
• B. The sales user must have a quota on the SALES_Q1 tablespace to hold the initial extends of all tables they plan to create in their schema
• C. The sales user must have been granted the CREATE SESSION privilege
• D. The sales user must have their quota on the users tablespace removed
• E. The sales user must have a quota on the SALES_Q1 tablespace to hold all the rows to be inserted into any table in their schema
• F. The sales user must have been granted the CREATE TABLE privilege

Answer: BDF

NEW QUESTION 13
In the spfile of a single instance database, LOCAL_LISTENER is set to LISTENER_1.
The TNSNAMES.ORA file in $ORACLE_HOME/network/admin in the database home contains:

Which statement is true?

• A. Dynamic service registration cannot be used for this database instance
• B. The LREG process registers services dynamically with the LISTENER_1 listener
• C. LISTENER_1 must also be defined in the LISTENER.ORA file to enable dynamic service registration
• D. There are two listeners named LISTENER and LISTENER_1 running simultaneously using port 1521 on the same host as the database instances
• E. The definition for LISTENER_1 requires a CONNECT_DATA section to enable dynamic service registration

Answer: C

NEW QUESTION 14
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 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

Answer: B

NEW QUESTION 15
You execute this command:

During the export operation, you detach from the job by using CTRL+C and then execute this command: Export> STOP_JOB=immediate
Are you sure you wish to stop the job ([yes]/no): yes
Which two statements are true about the job? (Choose two.)

• A. You can no longer monitor it
• B. You can reattach to it and monitor it
• C. It is paused and can be resumed
• D. It continues to run in the background
• E. It terminates

Answer: AE

NEW QUESTION 16
View the Exhibit and examine the structure of the PRODUCTS table. Which two tasks require subqueries? (Choose two.)

• A. Display the number of products whose PROD_LIST_PRICE is more than the average PROD_LIST_PRICE
• B. Display suppliers whose PROD_LIST_PRICE is less than 1000
• C. Display products whose PROD_MIN_PRICE is more than the average PROD_LIST_PRICE of all products, and whose status is orderable
• D. Display the total number of products supplied by supplier 102 which have a product status of obsolete
• E. Display the minimum PROD_LIST_PRICE for each product status

Answer: AC

NEW QUESTION 17
Examine this command:

Which two statements are true? (Choose two.)

• A. DML may be performed on tables with one or more extents in this data file during the execution of this command.
• B. The tablespace containing SALES1.DBF must be altered READ ONLY before executing the command.
• C. The tablespace containing SALES1.DBF must be altered OFFLINE before executing the command.
• D. If Oracle Managed Files (OMF) is used, then the file is renamed but moved to DB_CREATE_FILE_DEST.
• E. The file is renamed and stored in the same location

Answer: AB

NEW QUESTION 18
Which statement is true about aggregate functions?

• A. Aggregate functions can be nested to any number of levels
• B. The AVG function implicitly converts NULLS to zero
• C. Aggregate functions can be used in any clause of a SELECT statement
• D. The MAX and MIN functions can be used on columns with character data types

Answer: A

NEW QUESTION 19
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

Answer: CD

NEW QUESTION 20
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 a PRIMARY KEY constraint
• D. To shrink a table it must have a UNIQUE KEY constraint
• E. To shrink a table it must have row movement enabled
• F. It must be in a tablespace that uses Automatic Segment Space Management (ASSM)

Answer: CE

NEW QUESTION 21
Which four statements are true regarding primary and foreign key constraints and the effect they can have on table data? (Choose four.)

• A. A table can have only one primary key but multiple foreign keys
• B. A table can have only one primary key and foreign key
• C. The foreign key columns and parent table primary key columns must have the same names
• D. It is possible for child rows that have a foreign key to remain in the child table at the time the parent row is deleted
• E. It is possible for child rows that have a foreign key to be deleted automatically from the child table at the time the parent row is deleted
• F. Only the primary key can be defined at the column and table level
• G. Primary key and foreign key constraints can be defined at both the column and table level

Answer: ACEG

NEW QUESTION 22
Which three functions are performed by dispatchers in a shared server configuration? (Choose three.)

• A. writing inbound request to the common request queue from all shared server connections
• B. checking for outbound shared server responses on the common outbound response queue
• C. receiving inbound requests from processes using shared server connections
• D. sending each connection input request to the appropriate shared server input queue
• E. broadcasting shared server session responses back to requesters on all connections
• F. sending shared server session responses back to requesters on the appropriate connection

Answer: ACD

NEW QUESTION 23
Which two statements are true about UNDO and REDO? (Choose two.)

• A. The generation of UNDO generates REDO
• B. DML modifies Oracle database objects and only generates UNDO
• C. The generation of REDO generates UNDO
• D. DML modifies Oracle database objects and only generates REDO

Answer: AC

NEW QUESTION 24
......