Guaranteed 1z0-082 Forum 2021

NEW QUESTION 1
Which three statements are true concerning logical and physical database structures? (Choose three.)

• A. All tablespaces may have one or more data files
• B. The extents of a segment must always reside in the same datafile
• C. A smallfile tablespace might be bigger than a bigfile tablespace
• D. A segment can span multiple data files in some tablespaces
• E. A segment’s blocks can be of different sizes
• F. A segment might have only one extent
• G. Segments can span multiple tablespsaces

Answer: CFG

NEW QUESTION 2
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 SEGMENT SPACE MANAGEMENT AUTO clause
• B. Set UNDO_TABLESPACE to UNDOTBS01
• C. Add the NOLOGGING clause
• D. Make certain that the database operates in automatic undo management mode
• E. Add the ONLINE clause

Answer: BD

NEW QUESTION 3
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 4
In the SALES database, DEFERRED_SEGMENT_CREATION is TRUE. Examine this command:
SQL> CREATE TABLE T1(c1 INT PRIMARY KEY, c2 CLOB);
Which segment or segments, if any, are created as a result of executing the command?

• A. T1, an index segment for the primary key, a LOB segment, and a lobindex segment
• B. no segments are created
• C. T1 only
• D. T1 and an index segment created for the primary key only
• E. T1, an index segment for the primary key, and a LOB segment only

Answer: C

NEW QUESTION 5
Which statement is true about the INTERSECT operator used in compound queries?

• A. Multiple INTERSECT operators are not possible in the same SQL statement
• B. It processes NULLs in the selected columns
• C. INTERSECT is of lower precedence than UNION or UNION ALL
• D. It ignores NULLs

Answer: B

NEW QUESTION 6
Which two statements are true about single row functions? (Choose two.)

• A. MOD : returns the quotient of a division operation
• B. FLOOR : returns the smallest integer greater than or equal to a specified number
• C. TRUNC : can be used to combine any number of values
• D. CONCAT : can be used to combine any number of values
• E. CEIL : can be used for positive and negative numbers

Answer: AC

NEW QUESTION 7
You want to use table compression suitable for OLTP that will:
Compress rows for all DML statements on that table
Minimize the overheads associated with compression
Which compression option is best suited for this?

• A. COLUMN STORE COMPRESS FOR QUERY LOW
• B. ROW STORE COMPRESS BASIC
• C. COLUMN STORE COMPRESS FOR ARCHIVE LOW
• D. COLUMN STORE COMPRESS FOR ARCHIVE HIGH
• E. ROW STORE COMPRESS ADVANCED

Answer: E

NEW QUESTION 8
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 9
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 10
Which three statements are true about GLOBAL TEMPORARY TABLES? (Choose three.)

• A. A TRUNCATE command issued in a session causes all rows in a GLOBAL TEMPORARY TABLE for the issuing session to be deleted.
• 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. GLOBAL TEMPORARY TABLE space allocation occurs at session start.
• D. Any GLOBAL TEMPORARY TABLE rows existing at session termination will be deleted.
• E. A GLOBAL TEMPORARY TABLE’S definition is available to multiple sessions.
• F. A DELETE command on a GLOBAL TEMPORARY TABLE cannot be rolled back.

Answer: BCF

NEW QUESTION 11
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 DALLAS_DB
• B. as SCOTT in BOSTON_DB
• C. as SCOTT in BOSTON_DB and SYS in DALLAS_DB
• D. as SYS in both the databases
• E. as SCOTT in both the databases

Answer: D

NEW QUESTION 12
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 13
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 14
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 gives an error because the ALL keyword is not valid
• B. It gives an error because the GROUP BY clause is not valid
• C. It executes successfully but does not give the required result
• D. It executes successfully and gives the required result

Answer: D

NEW QUESTION 15
Which two statements are true about the ORDER BY clause when used with a SQL statement containing a SET operator such as UNION? (Choose two.)

• A. Column positions must be used in the ORDER BY clause
• B. Only column names from the first SELECT statement in the compound query are recognized
• C. The first column in the first SELECT of the compound query with the UNION operator is used by default to sort output in the absence of an ORDER BY clause
• D. Each SELECT statement in the compound query must have its own ORDER BY clause
• E. Each SELECT statement in the compound query can have its own ORDER BY clause

Answer: BE

NEW QUESTION 16
Which two are true about a SQL statement using SET operators such as UNION? (Choose two.)

• A. The data type group of each column returned by the second query must match the data type group of the corresponding column returned by the first query.
• B. The number, but not names, of columns must be identical for all SELECT statements in the query.
• C. The data type of each column returned by the second query must exactly match the data type of the corresponding column returned by the first query.
• D. The names and number of columns must be identical for all SELECT statements in the query.
• E. The data type of each column returned by the second query must be implicitly convertible to the data type of the corresponding column returned by the first query.

Answer: AC

NEW QUESTION 17
Which three statements are true about inner and outer joins? (Choose three.)

• A. A full outer join returns matched and unmatched rows
• B. An inner join returns matched rows
• C. Outer joins can only be used between two tables per query
• D. A full outer join must use Oracle syntax
• E. Outer joins can be used when there are multiple join conditions on two tables
• F. A left or right outer join returns only unmatched rows

Answer: ABF

NEW QUESTION 18
Examine these commands:

Which two statements are true about the sqlldr execution? (Choose two.)

• A. It overwrites data in EMP with data in EMP.DAT
• B. It uses the database buffer cache to load data
• C. It generates a log that contains control file entries, which can be used with normal SQL*Loader operations
• D. It generates a sql script that it uses to load data from EMP.DAT to EMP
• E. It appends data from EMP.DAT to EMP

Answer: BD

NEW QUESTION 19
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 20
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 21
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 22
Which three statements are true about the Oracle join and ANSI join syntax? (Choose three.)

• A. The Oracle join syntax supports creation of a Cartesian product of two tables
• B. The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax
• C. The SQL:1999 compliant ANSI join syntax supports natural joins
• D. The SQL:1999 compliant ANSI join syntax supports creation of a Cartesian product of two tables
• E. The Oracle join syntax only supports right outer joins
• F. The Oracle join syntax supports natural joins
• G. The Oracle join syntax performs less well than the SQL:1999 compliant ANSI join syntax

Answer: CDF

NEW QUESTION 23
......