[Q15-Q36] 1Z0-082 Practice Test Give You First Time Success with 100% Money Back Guarantee!

QUESTION 15
Which two statements are true?

SALES1 has not NULL constraints on any selected columns which had those constraints in the sales table.

SALES1 has primary key and unique constraints on any selected columns which had those constraints in the sales table.

SALES1 is created with 55,000 rows.

SALES1 is created with no rows.

SALES1 is created with 1 row.

QUESTION 16
In one of your databases, the user HR has the password HRMGR.
You want to connect to a database instance whose listener listens on port 1531 by using this statement:
CONNECT HR/HRMGR@orcl
No name server is used.
Which statement is true about ORCL?

It must be the value of the SERVICE_NAMES parameter on the client side

It must resolve to a valid connect descriptor in the server’s tnsnames.ora file

It must resolve to a valid connect descriptor in the client’s tnsnames.ora file

It must be the name of the database to whose instance HR wishes to connect

It must be the name of the server running the database to whose instance HR wishes to connect

QUESTION 17
The sales table has columns prod_id and quantity_sold of data type number In two queries execute successfully? x

SELECT prod_id FROM sales WHERE quantity_sold > 55000 GROUP BY prod_id HAVING COUNT(-) > 10;

SELECT prod_id FROM sales WHERE quantity_sold > 5S000 AND COUNT(-) > 10 GROUP BY prod_id HAVING COUNT(-) > 10;

SELECT COUNT|prod_id> FROM sales WHERE quantity_sold > 55000 GROUP BY prod_id;

SELECT COUNTlprod_id> FROM sales GROUP BY prod_id WHERE quantity_Sold > 55000;

SELECT prod_id FROM sales WHERE quantity_scld > 55000 AND COUNT(-) > 10 GROUP BY COUNT(-) > 10;

QUESTION 18
Examine these SQL statements which execute successfully:

Which two statements are true after execution?

The primary key constraint will be enabled and deferred.

The foreign key constraint will be enabled and deferred.

The foreign key constraint will be disabled.

The foreign key constraint will be enabled and immediate.

The primary key constraint will be enabled and immediate.

QUESTION 19
Which two statements are true about the rules of precedence for operators? (Choose two.)

The concatenation operator | | is always evaluated before addition and subtraction in an expression

NULLS influence the precedence of operators in an expression

The + binary operator has the highest precedence in an expression in a SQL statement

Arithmetic operators with equal precedence are evaluated from left to right within an expression

Multiple parentheses can be used to override the default precedence of operators in an expression

QUESTION 20
Which three statements are true about single-row functions? (Choose three.)

They can be used only in the WHERE clause of a SELECT statement

The argument can be a column name, variable, literal or an expression

The data type returned can be different from the data type of the argument

They can be nested to any level

They can accept only one argument

They return a single result row per table

QUESTION 21
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?

The value is changed only in the PFILE and takes effect at the next instance startup

The value is changed for the current instance and in the PFILE

It fails because the SCOPE clause is missing

Change is applied to the current instance, but does not persist after instance restart

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

It is available only when the database is open

It can be used to perform database recovery

The same port number can be used for Database Express configurations for databases on different hosts

It can be used to switch a database into ARCHIVELOGMODE

The same port number can be used for multiple Database Express configurations for multiple databases on the same host

QUESTION 23
Which three statements are true about undo segments and the use of undo by transactions in an Oracle database instance? (Choose three.)

An undo segment may be used by multiple transactions simultaneously

Undo segments can wrap around to the first extent when a transaction fills the last extend of the undo segment

Undo segments have a minimum of three extents

Undo segments can extend when a transaction fills the last extent of the undo segment

A single transaction may use multiple undo segments simultaneously

Undo segments must be stored in a BIGFILE tablespace

Undo segments must be stored in a SMALLFILE tablespace

QUESTION 24
Examine this command:

Which two statements are true? (Choose two.)

DML may be performed on tables with one or more extents in this data file during the execution of this command.

The tablespace containing SALES1.DBF must be altered READ ONLY before executing the command.

The tablespace containing SALES1.DBF must be altered OFFLINE before executing the command.

If Oracle Managed Files (OMF) is used, then the file is renamed but moved to DB_CREATE_FILE_DEST.

The file is renamed and stored in the same location

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

Data dictionary views are created by joins of dictionary base tables and DBA-defined tables

The data dictionary is created and maintained by the database administrator

Views with the same name but different prefixes, such as CDB, DBA, ALL and USER, reference the same base tables from the data dictionary

Base tables can be queried directly

It is owned by the SYSTEM user

Usernames of all users including database administrators are stored in the data dictionary

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

It is available only when the database is open

It can be used to perform database recovery

The same port number can be used for Database Express configurations for databases on different hosts

It can be used to switch a database into ARCHIVELOGMODE

The same port number can be used for multiple Database Express configurations for multiple databases on the same host

QUESTION 27
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?

SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level IS NOT NULLAND due_amount IS NOT NULL;

SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level != NULLAND cust_credit_level !=NULL;

SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level <> NULLAND due_amount <> NULL;

SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level != NULLAND due_amount != NULL;

SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level IS NOT NULLAND cust_credit_limit IS NOT NULL;

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

writing inbound request to the common request queue from all shared server connections

checking for outbound shared server responses on the common outbound response queue

receiving inbound requests from processes using shared server connections

sending each connection input request to the appropriate shared server input queue

broadcasting shared server session responses back to requesters on all connections

sending shared server session responses back to requesters on the appropriate connection

QUESTION 29
Which three are types of segments in an Oracle Database? (Choose three.)

undo

index

stored procedures

sequences

tables

clusters

QUESTION 30
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.)

Column positions must be used in the ORDER BY clause

Only column names from the first SELECT statement in the compound query are recognized

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

Each SELECT statement in the compound query must have its own ORDER BY clause

Each SELECT statement in the compound query can have its own ORDER BY clause

QUESTION 31
Examine this SQL statement:
SELECT cust_id, cust_last_name “Last Name”
FROM customers
WHERE country_id = 10
UNION
SELECT cust_id CUST_NO, cust_last_name
FROM customers
WHERE country_id = 30
Identify three ORDER BY clauses, any one of which can complete the query successfully.
(Choose three.)

ORDER BY “Last Name”

ORDER BY 2, 1

ORDER BY 2, cust_id

ORDER BY CUST_NO

ORDER BY “CUST_NO”

QUESTION 32
Table EMPLOYEES contains columns including EMPLOYEE_ID, JOB_ID and SALARY.
Only the EMPLOYEE_ID column is indexed.
Rows exist for employees 100 and 200.
Examine this statement:

Which two statements are true? (Choose two.)

Employee 100 will have SALARY set to the same value as the SALARY of employee 200

Employee 200 will have JOB_ID set to the same value as the JOB_ID of employee 100

Employee 200 will have SALARY set to the same value as the SALARY of employee 100

Employee 100 will have JOB_ID set to the same value as the JOB_ID of employee 200

Employees 100 and 200 will have the same JOB_ID as before the update command

Employees 100 and 200 will have the same SALARY as before the update command

QUESTION 33
You execute this command:

Sufficient storage is available in filesystem /u01.
Which two statements are true about the BIG_TBStablespace? (Choose two.)

AUTOEXTEND is possible for the datafile

It must be bigger than the largest SMALLFILE tablespace

Additional data files may not be added

It will be a dictionary-managed tablespace by default

It will always have a 32K blocksize

QUESTION 34
View the Exhibit and examine the description of the tables.
You execute this SQL statement:

Which three statements are true?

The statement will fall if a row already exists in the sales table for product 23.

The sales table has five foreign keys.

A product can have a different unit price at different times.

A customer can exist in many countries.

The statement will execute successfully and a new row will be inserted into the sales table.

The statement will fail because a subquery may not be contained in a values clause.

QUESTION 35
Examine the description of the SALES1 table:

SALES2 is a table with the same description as SALES1.
Some sales data is duplicated in both tables.
You want to display the rows from the SALES1 table which are not present in the SALES2 table.
Which set operator generates the required output?

INTERSECT

UNION ALL

UNION

SUBTRACT

MINUS

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

Display the number of products whose PROD_LIST_PRICE is more than the average PROD_LIST_PRICE

Display suppliers whose PROD_LIST_PRICE is less than 1000

Display products whose PROD_MIN_PRICE is more than the average PROD_LIST_PRICE of all products, and whose status is orderable

Display the total number of products supplied by supplier 102 which have a product status of obsolete

Display the minimum PROD_LIST_PRICE for each product status

[Q15-Q36] 1Z0-082 Practice Test Give You First Time Success with 100% Money Back Guarantee!

Be the first to reply

Leave a Reply Cancel reply