What Guaranteed 1z0-082 Free Practice Questions Is

NEW QUESTION 1
Examine the description of the EMPLOYEES table:

Which query is valid?

• A. SELECT dept_id, AVG(MAX(salary)) FROM employees GROUP BY dept_id;
• B. SELECT dept_id, join_date, SUM(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: B

NEW QUESTION 2
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 3
The INVOICE table has a QTY_SOLD column of data type NUMBER and an INVOICE_DATE column of data type DATE.
NLS_DATE_FORMAT is set to DD-MON-RR.
Which two are true about data type conversions involving these columns in query expressions? (Choose two.)

• A. CONCAT (qty_sold, invoice_date) : requires explicit conversion
• B. invoice_date = ’15-march-2019’ : uses implicit conversion
• C. invoie_date > ’01-02-2019’ : uses implicit conversion
• D. qty_sold BETWEEN ‘101’ AND ’110’ : uses implicit conversion
• E. qty_sold = ‘0554982’ uses implicit conversion

Answer: BD

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
Examine the description of the BOOKS table:

The table has 100 rows.
Examine this sequence of statements issued in a new session:
INSERT INTO books VALUES (‘ADV112’, ‘Adventures of Tom Sawyer’, NULL, NULL); SAVEPOINT a;
DELETE FROM books; ROLLBACK TO SAVEPOINT a; ROLLBACK;
Which two statements are true? (Choose two.)

• A. The second ROLLBACK command does nothing
• B. The second ROLLBACK command replays the delete
• C. The first ROLLBACK command restores the 101 rows that were deleted, leaving the inserted row still to be committed
• D. The second ROLLBACK command undoes the insert
• E. The first ROLLBACK command restores the 101 rows that were deleted and commits the inserted row

Answer: DE

NEW QUESTION 6
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 7
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 8
Your database instance is started with a PFILE.
Examine these parameters:

You want to increase the size of the buffer cache.
Free memory is available to increase the size of the buffer cache. You execute the command:
SQL> ALTER SYSTEM SET DB_CACHE_SIZE=1024M;
What is the outcome?

• A. The value is changed only in the PFILE and takes effect at the next instance startup
• B. The value is changed for the current instance and in the PFILE
• C. It fails because the SCOPE clause is missing
• D. Change is applied to the current instance, but does not persist after instance restart

Answer: D

NEW QUESTION 9
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 1;
• B. SELECT DISTINCT promo_cost || ’ in ‘ || DISTINCT promo_category FROM promotions ORDER BY 1;
• C. SELECT DISTINCT promo_category || ‘ has ‘ || promo_cost AS COSTS FROM promotions ORDER BY 1;
• D. SELECT promo_category, DISTINCT promo_cost FROM promotions ORDER BY 2;
• E. SELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1;

Answer: DE

NEW QUESTION 10
Which two statements are true regarding the UNION and UNION ALL operators? (Choose two.)

• A. Duplicates are eliminated automatically by the UNION ALL operator
• B. The number of columns selected in each SELECT statement must be identical
• C. The names of columns selected in each SELECT statement must be identical
• D. The output is sorted by the UNION ALL operator
• E. NULLS are not ignored during duplicate checking

Answer: BE

NEW QUESTION 11
Which three statements are true about the Oracle Data Dictionary? (Choose three.)

• A. Data dictionary views are created by joins of dictionary base tables and DBA-defined tables
• B. The data dictionary is created and maintained by the database administrator
• C. Views with the same name but different prefixes, such as CDB, DBA, ALL and USER, reference the same base tables from the data dictionary
• D. Base tables can be queried directly
• E. It is owned by the SYSTEM user
• F. Usernames of all users including database administrators are stored in the data dictionary

Answer: CDF

NEW QUESTION 12
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 13
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 14
Which three instance situations are possible with the Oracle Database server without multi-tenant? (Choose three.)

• A. two or more instances on separate servers all associated with one database
• B. one instance on one server associated with one database
• C. one instance on one server associated with two or more databases on the same server
• D. one instance on one server not associated with any database
• E. one instance on one server associated with two or more databases on separate servers

Answer: CDE

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
What is true about non-equijoin statement performance? (Choose two.)

• A. Table aliases can improve performance
• B. The BETWEEN condition always performs better than using the >= and <= conditions
• C. The join syntax used makes no difference to performance
• D. The BETWEEN condition always performs less well than using the >= and <= conditions
• E. The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax

Answer: AE

NEW QUESTION 17
Which three statements are true about a self-join? (Choose three.)

• A. The ON clause must be used
• B. The query must use two different aliases for the table
• C. It must be an equi join
• D. It must be an inner join
• E. The ON clause can be used
• F. It can be an outer join

Answer: BDE

NEW QUESTION 18
Your database instance was shut down normally and then started in NOMOUNT state. You then execute this command:
ALTER DATABASE MOUNT;
Which two actions are performed? (Choose two.)

• A. The online redo logs are opened
• B. The online data files are opened
• C. The alert log records the execution details
• D. The Oracle background processes are started
• E. The initialization parameter file is read
• F. The control file is read

Answer: DF

NEW QUESTION 19
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 20
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 21
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 22
Which three statements are true about time zones, date data types, and timestamp data types in an Oracle database? (Choose three.)

• A. The CURRENT_TIMESTAMP function returns data without time zone information
• B. A TIMESTAMP WITH LOCAL TIMEZONE data type column is stored in the database using the time zone of the session that inserted the row
• C. A TIMESTAMP data type column contains information about year, month, and day
• D. The DBTIMEZONE function can return an offset from Universal Coordinated Time (UTC)
• E. The SESSIONTIMEZONE function can return an offset from Universal Coordinated Time (UTC)

Answer: ADE

NEW QUESTION 23
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 24
......