1z0-071 Questions and Answers

Question # 6

Examine this query which executes successfully;

Select job,deptno from emp

Union all

Select job,deptno from jobs_history;

What will be the result?

It will return rows from both select statements after eliminating duplicate rows.

It will return rows common to both select statements.

It will return rows both select statements including duplicate rows.

It will return rows that are not common to both select statements.

Full Access

Question # 7

Examine the description of the EMPLOYEES table:

NLS_DATE FORMAT is DD-MON-RR.

Which two queries will execute successfully?

SELECT dept_ id, AVG (MAX(salary)) FROM employees GROUP By dept_id HAVING hire_date> ' O1-JAN-19';

SELECT dept_ id, AVG(MAX(salary)) FROM employees GROUP BY dept_id, salary;

SELECT dept id, MAX (SUM(salary)) FROM employees GROUP BY dept_id;

SELECT dept_ iD, sum(salary) FROM employees WHERE hire_date > '01-JAN-9' GROUP BY dept_id;

SELECT AVG(MAX(salary)) FROM employees GROUP BY salary;

Full Access

Question # 8

Examine this description of the PRODUCTS table:

You successfully execute this command:

CREATE TALE new_prices(prod_id NUBER(2),price NUMBER(8,2));

Which two statements execute without errors?

MERGE INTO new_prices n

USING(SELECT*FROM products)p

WHEN MATECHED THEN

UPDATE SET n.price=p.cost*.01

WHEN NOT MATCHED THEN

INSERT(n.prod_id,n.price)VALUES (p.prod_id,cost*01)

WHERE(p.cost<200);

MERGE INTO new_prices n

USING(SELECT*FROM product WHERE cost>150) p

ON (n.prod_id=p.prod_id)

WHEN NATCHED THEN

DELETE WHERE(p.cost<200)

WHEN NOT MATCHED THEN

INSERT (n.prod_id,n.price)VALUES (p.prod_id,p.cost*.01);

MERGE INTO new_prices n

USING (SELECT * FROM products WHERE cost>150) p

ON (n.prod_id=p.prod_id)

WHEN NATCHED THEN

UPDATE SET n.price=p.cost*.01

DELETE WHERE (p.cost<200);

MERGE INTO new_prices n

USING products p

WHEN NOT NATCHED THEN

INSERT (n.prod_id, n.price)VALUES (p.prod_id,cost*.01)

WHERE (p.cost <200);

Full Access

Question # 9

Examine the description of the CUSTOMERS table:

Which three statements will do an implicit conversion?

SELECT * FROM customers WHERE insert_date=DATE’2019-01-01’;

SELECT * FROM customers WHERE customer_id=’0001’;

SELECT * FROM customers WHERE TO_DATE(insert_date)=DATE’2019-01-01’;

SELECT * FROM customers WHERE insert_date’01-JAN-19’;

SELECT * FROM customers WHERE customer_id=0001;

SELECT * FROM customers WHERE TO_CHAR(customer_id)=’0001’;

Full Access

Question # 10

Which two are true about queries using set operators (UNION, UNION ALL, INTERSECT and MINUS)?

There must be an equal number of columns in each SELECT list.

The name of each column in the first SELECT list must match the name of the corresponding column in each subsequent SELECT list.

Each SELECT statement in the query can have an ORDER BY clause.

None of the set operators can be used when selecting CLOB columns.

The FOR UPDATE clause cannot be specified.

Full Access

Question # 11

Which two statements are true about transactions in the Oracle Database server?

An uncommitted transaction commits automatically if the user exits SQL*Plus

Data Manipulation Language (DML) statements always start a new transaction.

A user can always see uncommitted updates made by the same user in a different session.

A Data Definition Language (DDL) statement does a commit automatically only for the data dictionary updates caused by the DDL

A session can always see uncommitted updates made by itself.

If a session has an uncommitted transaction, then a DDL statement issue a COMMIT before starting a new transaction.

Full Access

Question # 12

You execute these commands successfully:

CREATE GLOBAL TEMPORARY TABLE invoices _ gtt

( customer id INTEGER,

invoice_ total NUMBER (10, 2)

) ON COMMIT PRESERVE ROWS;

INSERT INTO invoices_ gtt VALUES (1， 100);

COMMIT;

Which two are true?

You can add a foreign key to the table.

When you terminate your session, the row will be deleted.

To drop the table in this session, you must first truncate it.

You can add a column to the table in this session.

Other sessions can view the committed row.

Full Access

Question # 13

Which three statements are true about dropping and unused columns in an Oracle database?

A primary key column referenced by another column as a foreign key can be dropped if using the CASCADE option.

A DROP COLUMN command can be rolled back.

An UNUSED column's space is remained automatically when the block containing that column is next queried.

An UNUSED column's space is remained automatically when the row containing that column is next queried.

Partition key columns cannot be dropped.

A column that is set to NNUSED still counts towards the limit of 1000 columns per table.

Full Access

Answer:

B, E, F

Explanation:

A. A primary key column referenced by another column as a foreign key can be dropped if using the CASCADE option. (Incorrect)

Primary key columns that are referenced by foreign keys cannot be dropped as it would violate referential integrity. The CASCADE option does not apply in this context.

B. A DROP COLUMN command can be rolled back. (Correct)

Dropping a column from a table is a transactional operation. If it's not committed, it can be rolled back.

Reference: [Reference: Oracle Database SQL Language Reference confirms that the DROP COLUMN operation is transactional and can be rolled back if it is not committed (Oracle Database SQL Language Reference, 12c Release 1 (12.1))., C. An UNUSED column's space is remained automatically when the block containing that column is next queried. (Incorrect), The space occupied by an UNUSED column is not automatically reclaimed in this way., D. An UNUSED column's space is remained automatically when the row containing that column is next queried. (Incorrect), Similar to C, the space for an UNUSED column is not reclaimed automatically upon querying the row., E. Partition key columns cannot be dropped. (Correct), Partition key columns are integral to the partitioning strategy of a table and cannot be dropped., Reference: Oracle Database VLDB and Partitioning Guide details the restrictions on dropping partition key columns (Oracle Database VLDB and Partitioning Guide, 12c Release 1 (12.1))., F. A column that is set to UNUSED still counts towards the limit of 1000 columns per table. (Correct), Marking a column as UNUSED is a logical operation that prevents it from being used in future DML operations, but it still counts towards the column limit of the table until it is actually dropped from the table., Reference: Oracle Database SQL Language Reference indicates that UNUSED columns count toward the column limit (Oracle Database SQL Language Reference, 12c Release 1 (12.1))., ]

Question # 14

Which two statements are true about single row functions?

CONCAT: can be used to combine any number of values

FLOOR: returns the smallest integer greater than or equal to a specified number

CEIL: can be used for positive and negative numbers

TRUNC: can be used with NUMBER and DATE values

MOD: returns the quotient of a division operation

Full Access

Question # 15

Examine the BRICKS table:

You write this query:

SELECT

FROM bricks b1 CROSS JOIN bricks b2

WHERE b1. Weight < b2. Weight:

How many rows will the query return?

Full Access

Question # 16

The STORES table has a column START_ DATE of data type DATE, containing the date the row was inserted.

You only want to display details of rows where START_ DATE is within the last 25 months.

Which WHERE clause can be used?

WHERE MONTHS_ BETWEEN (SYSDATE, start_ date) <= 25

WHERE MONTHS_ BETWEEN (start_ date, SYSDATE) <= 25

WHERE TO_ NUMBER (start_ date - SYSDATE) <= 25

WHERE ADD_ MONTHS (start_ date, 25) <= SYSDATE

Full Access

Question # 17

Which two statements will convert the string Hello world to ello wozid?

SELECT LOWER (SUBSTR(‘Hello World, 2, 1)) FROM DUAL;

SELECT LOWER (SUBSTR(‘Hello World’, 2)) FROM DUAL;

SELECT LOWER(TRIM(‘H’ FROM ‘Hello World’)) FROM DUAL;

SELECT SUBSTR(‘Hello world’, 2) FROM DUAL;

SELECT INITCAP(TRIM(‘H’ FROM ‘Hello World’)) FROM DUAL;

Full Access

Question # 18

Which two are true about creating tables in an Oracle database?

A create table statement can specify the maximum number of rows the table will contain.

The same table name can be used for tables in different schemas.

A system privilege is required.

Creating an external table will automatically create a file using the specified directory and file name.

A primary key constraint is manadatory.

Full Access

Question # 19

Which two actions can you perform with object privileges?

Create roles.

Delete rows from tables in any schema except sys.

Set default and temporary tablespaces for a user.

Create FOREIGN KEY constraints that reference tables in other schemas.

Execute a procedure or function in another schema.

Full Access

Question # 20

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?

invoice_date> '01-02-2019': uses implicit conversion

qty_sold ='05549821 ': requires explicit conversion

CONCAT(qty_sold, invoice_date): requires explicit conversion

qty_sold BETWEEN '101' AND '110': uses implicit conversion

invoice_date = '15-march-2019': uses implicit conversion

Full Access

Question # 21

Which two are true about the USING clause when joining tables?

All column names in a USING clause must be qualified with a table name or table alias.

It can never be used with onatural join.

It is used to specify an equijoin of columns that have the same name in both tables.

It can never be used with a full outer join.

It is used to specify an explicit join condition involving operators.

Full Access

Question # 22

Which three are true about multiple INSERT statements?

They can be performed only by using a subquery.

They can be performed on relational tables.

They can be performed on views.

They can be performed on remote tables.

They can be performed on external tables using SQL*Loader.

They can insert each computed row into more than one table.

Full Access

Question # 23

Examine these two queries and their output:

SELECT deptno, dname FROM dept;

SELECT ename, job, deptno FROM emp ORDER BY deptno;

Now examine this query:

SELECT ename, dname

FROM emp CROSS JOIN dept WHERE job = 'MANAGER'

AND dept.deptno IN (10, 20) ;

Full Access

Question # 24

Which two statements about INVISIBLE indexes are true?

an INVISIBLE Index consumes no storage

You can only create one INVISIBLE index on the same column list

The query optimizer never considers INVISIBLE Indexes when determining execution plans

You use AlTER INDEX to make an INVISIBLE Index VISIBLE

All INSERT, UPDATE, and DELETE statements maintain entries in the index

Full Access

Question # 25

Examine this incomplete query:

SELECT DATA’2019-01-01’+

FROM DUAL;

Which three clauses can replaceti add 22 hours to the date?

INTERVAL ‘12:00’

INTERVAL’0,5’DAY

INTERVAL’12’ HOUR

INTERVAL’720’MINUTE

INTERVAL’0 12’DAY TO HOUR

INTERVAL’11:60’HOUR TO MINUTE

Full Access

Question # 26

Which two statements are true about date/time functions in a session where NLS_DATE_PORMAT is set to DD-MON-YYYY SH24:MI:SS

SYSDATE can be used in expressions only if the default date format is DD-MON-RR.

CURRENT_TIMESTAMP returns the same date as CURRENT_DATE.

CURRENT_DATE returns the current date and time as per the session time zone

SYSDATE and CURRENT_DATE return the current date and time set for the operating system of the database server.

CURRENT_TIMESTAMP returns the same date and time as SYSDATE with additional details of functional seconds.

SYSDATE can be queried only from the DUAL table.

Full Access

Question # 27

Examine the data in the ENPLOYEES table:

Which statement will compute the total annual compensation tor each employee？

SECECT last_namo, (menthy_salary + monthly_commission_pct) * 12 AS annual_comp

FROM employees;

SELCECT last_namo, (monthly_salary * 12) + (monthly_commission_pct * 12) AS annual_comp

FROM employees

SELCECT last_namo, (monthly_salary * 12) + (menthy_salary * 12 * NVL

(monthly_commission_pct, 0)) AS annual_comp FROM employees

SELCECT last_namo, (monthly_salary * 12) + (menthy_salary * 12 * monthly_commission_pct)

AS annual_comp FROM employees

Full Access

Question # 28

An Oracle database server session has an uncommitted transaction in progress which updated 5000 rows

in a table.

In which three situations does the transact ion complete thereby committing the updates?

When the session logs out is successfully

When a DBA issues a successful SHUTDOWN IMMEDIATE statement and the user then issues a COMMIT

When a CREATE INDEX statement is executed successfully in same session

When a COMMIT statement is issued by the same user from another session in the same database instance

When a CREATE TABLE AS SELECT statement is executed unsuccessfully in the same session

When a DBA issues a successful SHUTDOWN TRANSACTIONAL statement and the user, then issues a COMMIT

Full Access

Question # 29

Which two statements cause changes to the data dictionary?

DELETE FROM scott. emp;

GRANT UPDATE ON scott. emp TO fin manager;

AITER SESSION set NLs. _DATE FORMAT = 'DD/MM/YYYY';

TRUNCATE TABLE emp:

SELECT * FROM user_ tab._ privs;

Full Access

Question # 30

Which three statements are true?

The COMMISSION column can contain negative values .

The MANAGER column is a foreign key referencing the EMPNO column.

The SALARY column must have a value .

An index is created automatically in the MANAGER column.

The DEPTNO column in the EMP table can contain the value 1.

The DEPTNO column in the EMP table can contain NULLS .

The DNAME column has a unique constraint.

Full Access

Question # 31

Which statement fails to execute successfully?

Option A

Option B

Option C

Option D

Full Access

Question # 32

Evaluate these commands which execute successfully CREATE SEQUENCE ord_seq

INCREMENT BY 1

START WITH 1

MAXVALUE 100000

CYCLE

CACHE 5000;

Create table ord_items(

ord_no number(4) default ord_seq.nextval not null,

Item_no number(3),

Qty number(3),

Expiry_date date,

Constraint it_pk primary key(ord_no,item_no),

Constraint ord_fk foreign key (ord_no) references orders(ord_no));

Which two statements are true about the ORD_ITEMS table and the ORD_SEQ sequence?

Any user inserting rows into table ORD_ITEMS must have been granted access to sequence ORD_SEQ.

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.

Sequence ORD_SEQ cycles back to 1 after every 5000 numbers and can cycle 20 times

IF sequence ORD_SEQ is dropped then the default value for column ORD_NO will be NULL for rows inserted into ORD_ITEMS.

Sequence ORD_SEQ is guaranteed not to generate duplicate numbers.

Full Access

Question # 33

You execute this command:

TRUNCATE TABIE depts;

Which two are true?

A ROLLBACK statement can be used to retrieve the deleted data.

It drops any triggers defined on the table.

It retains the indexes defined on the table.

It retains the integrity constraints defined on the table,

It always retains the space used by the removed rows.

A FLASHBACK TABLE statement can be used to retrieve the deleted data.

Full Access

Question # 34

The SYSDATE function displays the current Oracle Server date as:

21 -MAY-19

You wish to display the date as:

MONDAY, 21 MAY, 201 9

Which statement will do this?

SELECT TO _ CHAR (SYSDATE, ' FMDAY, DD MONTH, YYYY') FROM DUAL;

SELECT TO _ DATE (SYSDATE, ' FMDAY, DD MONTH, YYYY') FROM DUAL;

SELECT TO_ CHAR (SYSDATE, ' FMDD, DAY MONTH, YYYY') FROM DUAL;

SELECT TO_ CHAR (SYSDATE, ' FMDAY, DDTH MONTH, YYYY') FROM DUAL;

Full Access

Question # 35

Which three statements are true about inner and outer joins?

A full outer join returns matched and unmatched rows.

A full outer join must use Oracle syntax.

Outer joins can be used when there are multiple join conditions on two tables.

Outer joins can only be used between two tables per query.

An inner join returns matched rows.

A left or right outer join returns only unmatched rows.

Full Access

Question # 36

The STORES table has a column START_DATE of data type DATE, containing the datethe row was inserted.

You only want to display details of rows where START_DATEis within the last 25 months.which WHERE clause can be used?

WHERE TO_NUMBER(start_date - SYSDATE)<=25

WHERE ADD_MONTHS (start date , 25)<= SYSDATE

WHERE MONTHS_BETWEEN(SYSDATE, start_date)<=25

WHERE MONTHS_BETWEEN (start_date, SYSDATE)<=25

Full Access

Question # 37

Which three are true about scalar subquery expressions?

A scalar subquery expression that returns zero rows evaluates to zoro

They cannot be used in the values clause of an insert statement*

They can be nested.

A scalar subquery expression that returns zero rows evaluates to null.

They cannot be used in group by clauses.

They can be used as default values for columns in a create table statement.

Full Access

Question # 38

Examine this statement:

Which two things must be changed for it to execute successfully?

The word CONSTRAINT in the foreign key constraint on DEPT_ID must be changed to FOREIGN KEY.

The foreign key constraint on DEPT_ID must be defined at the table level instead of the column level.

One of the LONG columns must be changed to a VARCHAR2 or CLOB.

The NOT NULL constraint on ENAME must be defined at the column level instead of the table level.

The primary key constraint on BMP_ID must have a name.

Full Access

Question # 39

Which two statements execute successfully?

SELECT TO_ DATE('2019-DEC-25 15:30'， 'YYYY-MON-DD HH24:MI', 'NLS_ DATE_ LANGUAGE

=AMERICAN' ) FROM DUAL;

SELECT TO_CHAR('2019-DEC-25 15:30"， YY-MON-D HH24:M2', 'NLS_DATE LANGUAGE =

AMERICAN')

FROM DUAL;

SELECT TO _DATE (TO_ CHAR (‘2019-DEC-25 03:30’, ‘YYYY-MON-DD HH12:MI’))

FROM DUAL;

SELECT TO _ CHAR (TO_ DATE (‘2019-DEC-25 03:30’,’YYYY-MON-DD HH12:MI’))

FROM DUAL

SELECT TO _ CHAR (‘2019-DEC-25 15:30’.’YYYY-MON-DD HH24:MI’)

FROM DUAL

Full Access

Question # 40

You execute this command:

TRUNCATE TABLE depts;

Which two are true?

It retains the indexes defined on the table.

It drops any triggers defined on the table.

A Flashback TABLE statement can be used to retrieve the deleted data.

It retains the integrity constraints defined on the table.

A ROLLBACK statement can be used to retrieve the deleted data.

It always retains the space used by the removed rows

Full Access

Question # 41

Which two are true about unused columns?

The DESCRIBE command displays unused columns

A primary key column cannot be set to unused.

A query can return data from unused columns, but no DML is possible on those columns.

Once a column has been set to unused, a new column with the same name can be added to the table.

A foreign key column cannot be set to unused.

Unused columns retain their data until they are dropped

Full Access

Question # 42

Which two true about a sql statement using SET operations such as UNION?

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

The data type of each column retuned by the second query must exactly match the data type of the corresponding column returned by the first query

The number, but not names, of columns must be identical for all SELECT statements in the query

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

The names and number of columns must be identical for all SELECT statements in the query.

Full Access

Question # 43

What is true about non-equijoin statement performance?

The between condition always performs less well than using the >= and <= conditions.

The Oracle join syntax performs better than the SQL: 1999 compliant ANSI join syntax.

The join syntax used makes no difference to performance.

The between condition always performs better than using the >= and <= conditions.

Table aliases can improve performance.

Full Access

Question # 44

Examine this partial query:

SELECT ch.channel_type, t.month, co.country_code, SUM(s.amount_sold) SALES

FROM sales s, times t, channels ch, countries co

WHERE s.time_ id = t.time id

AND s.country_ id = co. country id

AND s. channel id = ch.channel id

AND ch.channel type IN ('Direct Sales', 'Internet')

AND t.month IN ('2000-09', '2000-10')

AND co.country code IN ('GB', 'US')

Examine this output:

Which GROUP BY clause must be added so the query returns the results shown?

GROUP BY ch.channel_type, t.month, co.country code;

GROUP BY ch.channel_type,ROLLUP (t month, co. country_ code) ;

GROUP BY CUBE (ch. channel_ type, t .month, co. country code);

GROUP BYch. channel_ type, t.month,ROLIUP (co. country_ code) ;

Full Access

Question # 45

Which two statements are true about substitution variables?

A substitution variable used to prompt for a column name must be endorsed in single quotation marks.

A substitution variable used to prompt for a column name must be endorsed in double quotation marks.

A substitution variable prefixed with & always prompts only once for a value in a session.

A substitution variable can be used with any clause in a SELECT statement.

A substitution variable can be used only in a SELECT statement.

A substitution variable prefixed with 6 prompts only once for a value in a session unless is set to undefined in the session.

Full Access

Question # 46

Which two statements are true about the results of using the INTERSECT operator in compound queries?

Reversing the order of the intersected tables can sometimes affect the output.

Column names in each SELECT in the compound query can be different.

INTERSECT returns rows common to both sides of the compound query.

The number of columns in each SELECT in the compound query can be different.

INTERSECT ignores NULLs

Full Access

Question # 47

Examine the data in the COLORS table:

Examine the data in the BRICKS table:

Which two queries return all the rows from COLORS?

Full Access

Answer:

A, D

Explanation:

In SQL, to return all rows from one table in a join regardless of whether they match rows in the other table, a LEFT JOIN is used when we want all rows from the left table, or a RIGHT JOIN when we want all rows from the right table. Here’s an explanation for each query provided in the context of the COLORS and BRICKS tables:

A. This query uses a LEFT JOIN and will return all the rows from the COLORS table (c) because it is on the left side of the join. Additionally, it joins the BRICKS table (b) on the condition that the color_rgb_hex_value matches. The condition in the WHERE clause (b.brick_id > 0) will not exclude any COLORS rows because it only filters the rows from the right table (BRICKS) after the join.

B. This query uses a RIGHT JOIN, and while it does return all rows from the COLORS table, it doesn't place it on the left side of the join, which is not what is typically expected from a RIGHT JOIN to return all rows from the right side table.

C. This query is a plain JOIN (also known as an inner join), which only returns rows that have matching values in both tables, so it will not return all the rows from the COLORS table if there is no match in the BRICKS table.

D. This query uses a FULL JOIN, which returns all rows when there is a match in one of the tables. Hence, it will return all the rows from both the COLORS and BRICKS tables. While this does return all rows from the COLORS table, it also includes all rows from the BRICKS table, which may not be desired if the requirement was only to return all rows from COLORS.

E. This query is similar to option A and uses the USING clause to specify the join condition. The USING clause is used when both tables have a column with the same name and is meant to simplify the syntax. However, in this case, the columns do not have the same name in both tables (RGB_HEX_VALUE in COLORS and COLOR_RGB_HEX_VALUE in BRICKS), so this query will not execute successfully.

References:

Oracle Database SQL Language Reference, 12c Release 1 (12.1): "Joins"
Oracle Database SQL Language Reference, 12c Release 1 (12.1): "LEFT OUTER JOIN"
Oracle Database SQL Language Reference, 12c Release 1 (12.1): "RIGHT OUTER JOIN"
Oracle Database SQL Language Reference, 12c Release 1 (12.1): "FULL OUTER JOIN"

Based on the explanations above, the correct answers that return all rows from the COLORS table are A and D. However, D includes all rows from BRICKS as well, which may not be the intended requirement if the question specifies only rows from COLORS should be returned. Thus, A is the most accurate answer to the question as it adheres to the standard expectation of a LEFT JOIN.

Question # 48

Examine this statement:

SELECT last name

FROM employees

ORDER BY CASE WHEN salary = (SELECT MAX(salary) FROM employees)

THEN ‘A’

ELSE last_ name

END ,last_name DESC;

Which two statements are true?

The names of employees earning the maximum salary will appear first in descending order.

The names of employees earning the maximum salary will appear first In ascending order.

All remaining employee names will appear in ascending order.

All remaining employee names will appear in an unspecified order.

All remaining employee names will appear in descending order.

The names of employees earning the maximum salary will appear first in an unspecified order.

Full Access

Question # 49

Examine these statements:

CREATE TABLE dept (

deptno NUMBER PRIMARY KEY,

diname VARCHAR2(10) ,

mgr NUMBER ,

CONSTRAINT dept_fkey FOREIGN KEY(mgr) REFERENCES emp (empno));

CREATE TABLE emp (

Empno NUMBER PRIMARY KEY,

Ename VARCHAR2 (10) ,

deptno NUMBER,

CONSTRAINT emp_fkey FOREIGN KEY (deptno) REFERENCES dept (deptno) DISABLE);

ALTER TABLE emp MODIFY CONSTRAINT emp_fkey ENABLE;

Which two are true?

The MGR column in the DEPT table will not be able to contain NULL values.

The CREATE TABLE EMP statement must precede the CREATE TABLE DEPT statement for all threestatements to execute successfully.

Both foreign key constraint definitions must be removed from the CREATE TABLE statements, andbe added with ALTER TABLE statements once both tables are created, for the two CREATE TABLEstatements to

execute successfully in the order shown.

The DEFT FKEY constraint definition must be removed from the CREATE TABLE DEF statement.and be added with an AITER TABLE statement once both tables are created, for the two CREATE TABLE statements

to execute successfully in the order shown.

The Deptno column in the emp table will be able to contain nulls values.

All three statements execute successfully in the order shown

Full Access

Question # 50

Examine this partial command:

CREATE TABLE cust(

cust_id NUMBER(2),

credit_limit NUMBER(10)

ORGANIZATION EXTERNAL

Which two clauses are required for this command to execute successfully?

the ACCESS PARAMETERS clause

the DEFAULT DIRECTORY clause

the access driver TYPE clause

the LOCATION clause

the REJECT LIMIT clause

Full Access

Question # 51

You issued this command: DROP TABLE hr. employees;

Which three statements are true?

ALL constraints defined on HR, EMPLOYEES are dropped.

The HR. EMPLOYEES table may be moved to the recycle bin.

Synonyms for HR EMPLOYEES are dropped.

Sequences used to populate columns in the HR. EMPLOYEES table are dropped.

All indexes defined on HR, EMPLOYEES are dropped.

Views referencing HR, EMPLOYEES are dropped.

Full Access

Question # 52

Which two statements are true about truncate and delete?

the result of a delete can be undone by issuing a rollback

delete can use a where clause to determine which row(s) should be removed.

TRUNCATE can use a where clause to determine which row(s) should be removed.

truncate leavers any indexes on the table in an UNUSABLE STATE.

the result of a truncate can be undone by issuing a ROLLBACK.

Full Access

Question # 53

Examine the description of the EMPLOYEES table:

Which two queries return rows for employees whose manager works in a different department?

SELECT emp. *

FROM employees emp

WHERE manager_ id NOT IN (

SELECT mgr.employee_ id

FROM employees mgr

WHERE emp. department_ id < > mgr.department_ id

);

SELECT emp.*

FROM employees emp

WHERE NOT EXISTS (

SELECT NULL

FROM employees mgr

WHERE emp.manager id = mgr.employee_ id

AND emp.department_id<>mgr.department_id

);

SELECT emp.*

FROM employees emp

LEFT JOIN employees mgr

ON emp.manager_ id = mgr.employee_ id

AND emp. department id < > mgr. department_ id;

SELECT emp. *

FROM employees emp

RIGHT JOIN employees mgr

ON emp.manager_ id = mgr. employee id

AND emp. department id <> mgr.department_ id

WHERE emp. employee_ id IS NOT NULL;

SELECT emp. *

FROM employees emp

JOIN employees mgr

ON emp. manager_ id = mgr. employee_ id

AND emp. department_ id<> mgr.department_ id;

Full Access

Question # 54

Evaluate the following SQL statement

SQL>SELECT promo_id, prom _category FROM promotions

WHERE promo_category=’Internet’ ORDER BY promo_id

UNION

SELECT promo_id, promo_category FROM Pomotions

WHERE promo_category = ‘TV’

UNION

SELECT promoid, promocategory FROM promotions WHERE promo category=’Radio’

Which statement is true regarding the outcome of the above query?

It executes successfully and displays rows in the descend ignore of PROMO CATEGORY.

It produces an error because positional, notation cannot be used in the ORDER BY clause with SBT operators.

It executes successfully but ignores the ORDER BY clause because it is not located at the end of the compound statement.

It produces an error because the ORDER BY clause should appear only at the end of a compound query-that is, with the last SELECT statement.

Full Access

Question # 55

Examine the description of the PRODUCTS table:

Which three queries use valid expressions?

SELECT produet_id, unit_pricer, 5 "Discount",unit_price+surcharge-discount FROM products;

SELECT product_id, (unit_price * 0.15 / (4.75 + 552.25)) FROM products;

SELECT ptoduct_id, (expiry_date-delivery_date) * 2 FROM products;

SPLECT product_id, expiry_date * 2 FROM products;

SELEGT product_id, unit_price, unit_price + surcharge FROM products;

SELECT product_id,unit_price || "Discount", unit_price + surcharge-discount FROM products;

Full Access

Question # 56

Examine the description of the EMPLOYEES table:

Which query is valid?

SELECT dept_id, join date, SUM(salary) FROM employees GROUP BY dept_id,join_date;

SELECT dept_id, MAX (AVG(salary)) FROM employees GROUP BY dept_id;

SELECT dept_id, AVG(NAX(salary)) FROM employees GROUP BY dept_id;

SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id;

Full Access

Question # 57

Which three statements are true about single-row functions?

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

They can be nested to any level.

They return a single result row per table.

They can accept only one argument.

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

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

Full Access

Question # 58

Which two statements are true about the results of using the intersect operator in compound queries?

intersect ignores nulls.

Reversing the order of the intersected tables can sometimes affect the output.

Column names in each select in the compound query can be different.

intersect returns rows common to both sides of the compound query.

The number of columns in each select in the compound query can be different.

Full Access

Question # 59

Which two are true about the data dictionary?

Base tables in the data dictionary have the prefix DBA_.

All user actions are recorded in the data dictionary.

The data dictionary is constantly updated to reflect changes to database objects, permissions, and data.

All users have permissions to access all information in the data dictionary by default

The SYS user owns all base tables and user-accessible views in the data dictionary.

Full Access

Question # 60

Which two are true about the MERGE statement?

The WHEN NOT MATCHED clause can be used to specify the deletions to be performed.

The WHEN NOT MATCHED clause can be used to specify the inserts to be performed.

The WHEN MATCHED clause can be used to specify the inserts to be performed.

The WHEN NOT MATCHED clause can be used to specify the updates to be performed.

The WHEN MATCHED clause can be used to specify the updates to be performed.

Full Access

Question # 61

Which two are true about self joins?

They are always equijoins.

They require the NOT EXISTS operator in the join condition.

They have no join condition.

They can use INNER JOIN and LEFT JOIN.

They require table aliases.

They require the EXISTS opnrator in the join condition.

Full Access

Question # 62

Examine the description of the EMPLOYEES table:

Which statement will fail?

SELECT department_id, COUNT (*)

FROM employees

HAVING department_ id <> 90 AND COUNT(*) >= 3

GROUP BY department_id;

SELECT department_id, COUNT (*)

FROM employees

WHERE department_ id <> 90 AND COUNT(*) >= 3

GROUP BY department_id;

SELECT department_id, COUNT(*)

FROM employees

WHERE department_id <> 90 HAVING COUNT(*) >= 3

GROUP BY department_id;

SELECT department_id, COUNT(*)

FROM employees

WHERE department_id <> 90 GROUP BY department_id

HAVING COUNT(*) >= 3;

Full Access

Question # 63

Examine this query:

SELECT TRUNC (ROUND(156.00,-2),-1) FROM DUAL; What is the result?

160

150

200

100

Full Access

Question # 64

Which two statements are true about a self join?

The join key column must have an index.

It can be a left outer join.

It must be a full outer join.

It can be an inner join.

It must be an equijoin.

Full Access

Question # 65

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 SALIES2 table.

Which set operator generates the required output?

SUBTRACT

INTERSECT

UNION ALL

MINUS

UNION

Full Access

Question # 66

Examine the ORDER _ITEms table:

Which two queries return rows where QUANTITY is a multiple of ten?

SELECT * FROM order_ items WHERE quantity = TRUNC (quantity, -1);

SELECT * FROM order_ items WHERE MOD (quantity, 10) = 0;

SELECT” FROM order_ items WHERE FLOOR (quantity / 10) = TRUNC (quantity / 10);

SELECT FROM order_ items WHERE quantity / 10 = TRUNC (quantity);

SELECT” FROM order_ _items WHERE quantity = ROUND (quantity, 1);

Full Access

Question # 67

Which three statements are true about time zones, date data types, and timestamp data types in an Oracle database?

The DBTIMEZONE function can return an offset from Universal Coordinated Time (UTC)

A TIMESTAMP WITH LOCAL TIMEZONE data type column is stored in the database using the time zone of the session that inserted the row

A TIMESTAMP data type column contains information about year, month, and day

The SESSIONTIMEZONE function can return an offset from Universal Coordinated Time (UTC)

The CURRENT_TIMESTAMP function returns data without time zone information

Full Access

Question # 68

Which two statements are true about views?

Views can be indexed.

Theethi CHEcK clause prevents certalin rows from being updated or inserted in the underying table through the view.

Tables in the defining query of a view must always exist in order to create the view.

Views can be updated without the need to re-grant privileges on the view.

The wITH CHECK clause prevents certain rows from being displayed when querying the view.

Full Access

Question # 69

Which statement falls to execute successfully?

SELECT *

FROM employees e

JOIN department d

WHERE e.department_id=d.department_id

AND d.department_id=90;

SELECT *

FROM employees e

JOIN departments d

ON e.department_id=d.department_id

WHERE d.department_id=90;

SELECT *

FROM employees e

JOIN departments d

ON e.department_id=d.department_id

AND d.department_id=90;

SELECT *

FROM employees e

JOIN departments d

ON d.departments_id=90

WHERE e.department_id=d.department_id;

Full Access

Question # 70

Which two tasks require subqueries?

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

Display suppliers whose PROD_LIST_PRICE is less than 1000.

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

Display the minimum PROD_LIST_PRICE for each product status.

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

Full Access

Question # 71

Examine this business rule:

Each student can work on multiple projects and each project can have multiple students.

You must design an Entity Relationship(ER) model for optimal data storage and allow for generating reports in this format:

Which two statements are true?

An associative table must be created with a composite key of STUDENT_ID and PROJRCT_ID, which is the foreign key linked to the STUDENTS and PROJECTS entities.

PROJECT_ID must be the primary key in the PROJECTS entity and foreign key in the STUDENTS entity.

The ER must have a 1-to-many relationship between the STUDENTS and PROJECTS entities.

The ER must have a many to-many relationship between the STUDENTS and PROJECTS entities that must be resolved into 1-to-many relationships.

STUDENT ID must be the primary key in the STUDENTS entity and foreign key in the PROJECTS entity.

Full Access

Question # 72

Examine these statements which execute successfully:

Both statements display departments ordered by their average salaries.

Which two are true?

Only the second statement will display departments with no employees.

Only the first statement will display departments with no employees.

Both statements will execute successfully If you add e.avg_sal to the select list.

Both statements will display departments with no employees.

Only the first statement will execute successfully if you add E.AVG_SAK to the select list.

Only the second statement will execute successfully if you add E.AVG_SAL to the select list.

Full Access

Question # 73

Which three statements are true about sequences in a single instance Oracle database?

A sequence's unallocated cached values are lost if the instance shuts down.

Two or more tables cannot have keys generated from the same sequence.

A sequence number that was allocated can be rolled back if a transaction fails.

A sequence can issue duplicate values.

Sequences can always have gaps.

A sequence can only be dropped by a DBA.

Full Access

Question # 74

The ORDERS table has a column ORDER_DATE of date type DATE The default display format for a date is DD-MON-RR

Which two WHERE conditions demonstrate the correct usage of conversion functions?

WHERE ordet_date> TO_CHAR(ADD_MONTHS(SYSDATE, 6),'MON DD YYYY')

WHERE TO_CHAR(order_date,'MON DD YYYY') ='JAN 20 2019';

WHERE order_date> TO_DATE('JUL 10 2018','MON DD YYYY');

WHERE order_date IN (TO_DATE ('Oct 21 2018','MON DD YYYY'), TO_CHAR('Nov 21 2018','MON DD YYYY'));

WHERE order_date> TO_DATE(ADD_MONTHS(SYSDATE,6),'MON DD YYYY');

Full Access

Question # 75

Which two statements are true about single row functions?

CONCAT: can be used to combine any number of values

MOD: returns the quotient of a division operation

CEIL: can be used for positive and negative numbers

FLOOR: returns the smallest integer greater than or equal to a specified number

TRUNC: can be used with NUMBER and DATE values

Full Access

Question # 76

Which two statements are true about selecting related rows from two tables based on entity relationship diagram (ERD)?

Relating data from a table with data from the same table is implemented with a self join.

An inner join relates rows within the same table.

Rows from unrelated tables cannot be joined.

Implementing a relationship between two tables might require joining additional tables.

Every relationship between the two tables must be implemented in a Join condition.

Full Access

Question # 77

Which three statements are true about the DESCRIBE command?

It can be used from SQL Developer.

It can be used to display the structure of an existing view.

It can be used only from SQL*Plus.

It displays the NOT NULL constraint for any columns that have that constraint.

It displays all constraints that are defined for each column.

It displays the PRIMARY KEY constraint for any column or columns that have that constraint.

Full Access

Question # 78

Which two statements are true about * _ TABLES views?

You must have SELECT privileges on a table to view it in ALL _TABLES.

You must have SELECT privileges on a table to view it in DBA TABLES.

USER_ TABLES displays all tables owned by the current user.

ALL TABLES displays all tables owned by the current user.

You must have SELECT privileges on a table to view it in USER TABLES.

All users can query DBA TABLES successfully.

Full Access

Question # 79

You create a table by using this command:

CREATE TABLE rate_list (rate NUMBER(6,2));

Which two are true about executing statements?

INSERT INTO rate_list VALUES (-.9) inserts the value as -.9.

INSERT INTO rate_list VALUES (0.999) produces an error.

INSERT INTO rate_list VALUES (-10) produces an error.

INSERT INTO rate_list VALUES (87654. 556) inserts the value as 87654.6.

INSERT INTO rate_list VALUES (0.551) inserts the value as .55.

INSERT INTO rate_list VALUES (-99.99) inserts the value as 99.99.

Full Access

Question # 80

Which three statements are true about Data Manipulation Language (DML)?

delete statements can remove multiple rows based on multiple conditions.

insert statements can insert nulls explicitly into a column.

insert into. . .select. . .from statements automatically commit.

DML statements require a primary key be defined on a table.

update statements can have different subqueries to specify the values for each updated column.

Full Access

Question # 81

Which two queries will result in an error?

SELECT FIRST_NAME LAST_NAME FROM EMPLOYEES;

SELECT FIRST_NAME,LAST_NAME FROM EMPLOYEES;

SELECT LAST_NAME,12 * SALARY AS ANNUAL_SALARY

FROM EMPLOYEES

WHERE ANNUAL_SALARY > 100000

ORDER BY 12 * SALARY ;

SELECT LAST_NAME,12 * SALARY AS ANNUAL_SALARY

FROM EMPLOYEES

WHERE 12 * SALARY > 100000

ORDER BY ANNUAL_SALARY;

SELECT LAST_NAME,12 * SALARY AS ANNUAL_SALARY

FROM EMPLOYEES

WHERE 12 * SALARY > 100000

ORDER BY 12 * SALARY;

SELECT LAST_NAME,12 * SALARY AS ANNUAL_SALARY

FROM EMPLOYEES

WHERE ANNUAL_SALARY > 100000

ORDER BY ANNUAL_SALARY;

Full Access

Question # 82

Examine these requirements:

1. Display book titles for books purchased before January 17, 2007 costing less than 500 or more than 1000.

2. Sort the titles by date of purchase, starting with the most recently purchased book.

Which two queries can be used?

SELECT book_title FROM books WHERE (price< 500 OR >1000) AND (purchase date< '17-JAN-2007') ORDER BY purchase date DESC;

SELECT book_title FROM books WHERE (price IN (500, 1000)) AND (purchase date < '17-JAN-2007') ORDER BY purchase_date ASC;

SELECT book_title FROM books WHERE (price NOT BETWEEN 500 AND 1000) AND (purchase_date< '17-JAN-2007') ORDER BY purchase_date DESC;

SELECT book_title FROM books WHERE (price BETWEEN 500 AND 1000) AND (purchase_date<'17-JAN-2007') ORDER BY purchase_date;

Full Access

Question # 83

Which two are true about creating tables in an Oracle database?

A create table statement can specify the maximum number of rows the table will contain.

The same table name can be used for tables in different schemas.

A system privilege is required.

Creating an external table will automatically create a file using the specified directory and file name.

A primary key constraint is manadatory.

Full Access

Question # 84

Which statement is true about aggregate functions?

The AVG function implicitly converts NULLS to zero

The MAX and MIN functions can be used on columns with character data types

Aggregate functions can be used in any clause of a SELECT statement

Aggregate functions can be nested to any number of levels

Full Access

Question # 85

Which two queries only return CUBE?

SELECT shape FROM bricks JOIN boxes ON weight >= min_weight AND weight < max_weight;

SELECT shape FROM bricks JOIN boxes ON weight > min_weight;

SELECT shape FROM bricks JOIN boxes ON weight BETWEEN min_weight AND max_weight;

SELECT shape FROM bricks JOIN boxes ON weight < max_weight;

SELECT shape FROM bricks JOIN boxes ON NOT (weight > max_weight);

Full Access

Question # 86

Which four statements are true regarding primary and foreign key constraints and the effect they can have on table data?

Only the primary key can be defined at the column and table level.

The foreign key columns and parent table primary key columns must have the same names.

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.

A table can have only one primary key but multiple foreign keys.

Primary key and foreign key constraints can be defined at both the column and table level.

A table can have only one primary key and one foreign key.

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

Full Access

Question # 87

Which two statements are true about external tables?

Indexes can be created on them.

You can populate them from existing data in the database by using the CREATE TABLE AS SELECT command.

DML statements cannot be used on them.

Their data can be retrieved by using only SQL or PL/SQL.

Their metadata and actual data are both stored outside the database.

Full Access

Question # 88

Examine this SQL statement:

SELECT cust_id, cust_last_name "Last Name

FROM customers

WHERE countryid=10

UNION

SELECT custid CUSTNO, cust_last_name

FROM customers

WHERE countryid=30

Identify three ORDER BY clauses, any one of which can complete the query successfully.

ORDER BY“CUST NO"

ORDER BY 2, cust_id

ORDERBY2, 1

ORDER BY "Last Name"

ORDER BY CUSTNO

Full Access

Question # 89

You execute this query:

SELECT TO CHAR (NEXT_DAY(LAST_DAY(SYSDATE),’MON’ ),’ dd“Monday for” fmMonth rrr’) FROM DUAL;

What is the result?

It executes successfully but does not return any result.

It returns the date for the first Monday of the next month.

It generates an error.

It returns the date for the last Monday of the current month.

Full Access

Question # 90

Examine these statements executed in a single Oracle session:

CREATE TABLE product (pcode NUMBER(2),pname VARCHAR2(20));

INSERT INTO product VALUES(1,'pen');

INSERT INTO product VALUES (2,'pencil');

INSERT INTO product VALUES(3,'fountain pen');

SAVEPOINT a;

UPDATE product SET pcode=10 WHERE pcode =1;

COMMIT;

DELETE FROM product WHERE pcode =2;

SAVEPOINT b;

UPDATE product SET pcode=30 WHERE pcode =3;

SAVEPOINT c;

DELETE FROM product WHERE pcode =10;

ROLLBACK TO SAVEPOINT b;

COMMIT;

Which three statements are true？

The code for pen is 10.

There is no row containing fountain pen.

There is no row containing pencil.

The code for pen is 1.

The code for fountain pen is 3

There is no row containing pen

Full Access

Question # 91

Which two statements will return the names of the three employees with the lowest salaries?

SELECT last_name, salary

FROM employees

WHERE ROWNUM<=3

SELECT last_name,salary

FROM employees

ORDER BY salary

FETCH FIRST 3 ROWS ONLY;

SELECT last_name,salary

FROM employees

WHERE ROWNUM<=3

ORDER BY (SELECT salary FROM employees);

SELECT last_name,salary

FROM (SELECT * FROM employees ORDER BY salary)

SELECT last_name,salary

FROM employees

FETCH FIRST 3 ROWS ONLY

ORDER BY salary;

Full Access

Question # 92

Examine the data in the PRODUCTS table:

Examine these queries:

1. SELECT prod name, prod list

FROM products

WHERE prod 1ist NOT IN(10，20) AND category _id=1;

2. SELECT prod name, | prod _ list

FROM products

WHERE prod list < > ANY (10，20) AND category _id= 1;

SELECT prod name, prod _ list

FROM products

WHERE prod_ list <> ALL (10， 20) AND category _ id= 1;

Which queries generate the same output?

1 and 3

1, 2 and 3

2 and 3

1 and 2

Full Access

Question # 93

Examine this statement:

Which two statements are true?

All remaining employee names will appear in an ascending order

The names of employees remaining the maximum salary will appear first in an ascending order

All remaining employee names will appear in ascending order

All remaining employee names will appear in descending order

The names of employees maximum salary will appear fist to descending order

The names of employees maximum salary will appear fist to ascending order

Full Access

Question # 94

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 pro

motion time interval.

Examine this SQL statement:

SELECT prod id

FROM costs

WHERE promo id IN

(SELECT promo id

FROM promotions

WHERE promo_cost < ALL

(SELECT MAX (promo cost)

FROM promotions

GROUP BY (promo_end date-promo_begin_date)) );

What will be the result?

It executes successfully but does not give the required result.

It gives an error because the ALL keyword is not valid.

It gives an error because the GROUP BY clause is not valid

It executes successfully and gives the required result.

Full Access

Question # 95

The ORDERS table has a primary key constraint on the ORDER_ID column.

The ORDER_ITEMS table has a foreign key constraint on the ORDER_ID column, referencing the primary key of the ORDERS table.

The constraint is defined with on DELETE CASCADE.

There are rows in the ORDERS table with an ORDER_TOTAL less than 1000.

Which three DELETE statements execute successfully?

DELETE FROM orders WHERE order_total<1000;

DELETE * FROM orders WHERE order_total<1000;

DELETE orders WHERE order_total<1000;

DELETE FROM orders;

DELETE order_id FROM orders WHERE order_total<1000;

Full Access

Question # 96

You create a table named 123.

Which statement runs successfully?

SELECT * FROM TABLE (123) ;

SELECT * FROM '123';

SELECT * FROM "123";

SELECT * FROM V'123V';

Full Access

Question # 97

Examine the description of the BOOKS_TRANSACTIONS table:

Examine this partial SQL statement:

SELECT * FROM books_transactions

Which two WHERE conditions give the same result?

WHERE (borrowed_date = SYSDATE AND transaction_type = 'RM') OR member_id IN ('A101','A102');

WHERE borrowed_date = SYSDATE AND transaction_type = 'RM' OR member_id IN('A101','A102');

WHERE borrowed_date = SYSDATE AND transaction_type = 'RM' AND (member_id = 'A101' OR member_id = 'A102'));

WHERE borrowed_date = SYSDATE AND transaction_type = 'RM' AND member_id = 'A101' OR member_id = 'A102');

Full Access

Answer:

A, D

Explanation:

When writing SQL statements with multiple conditions in the WHERE clause, it's important to understand how logical operators like AND and OR work. These operators are used to filter records based on more than one condition:

The AND operator displays a record if all the conditions separated by AND are TRUE.
The OR operator displays a record if any of the conditions separated by OR is TRUE.

The precedence of these operators is also important: AND operations are always evaluated before OR operations unless parentheses are used to explicitly define the order of operations. Therefore, conditions enclosed in parentheses are evaluated first as per the standard SQL operator precedence.

Given this understanding, let's evaluate the options:

Option A uses parentheses to group the borrowed_date and transaction_type conditions together, ensuring these are evaluated first before the OR operator. This means the query will return records that meet both of these conditions or records with member_id 'A101' or 'A102', regardless of other conditions.
Option D does not use parentheses around the borrowed_date and transaction_type conditions but does use them to group the member_id conditions. Since the AND operator has higher precedence than the OR, this query will first evaluate the borrowed_date and transaction_type conditions, then evaluate the grouped member_id conditions. The outcome is records that have a borrowed_date of SYSDATE, a transaction_type of 'RM', and a member_id of either 'A101' or 'A102'.

The results of Options A and D are effectively the same, even though the use of parentheses is different. This is because in both cases, the evaluation of the borrowed_date and transaction_type conditions will be performed first due to their grouping by parentheses in Option A and the precedence of AND over OR in Option D. Therefore, they will both return all records where borrowed_date equals SYSDATE and transaction_type equals 'RM', plus any records where member_id is either 'A101' or 'A102'.

For further details on SQL operator precedence and logical operators, you can refer to Oracle Database SQL Language Reference 12c documentation, specifically the sections on conditional expressions.

Labour Day - Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 70dumps

DumpsTool Header

dumpstool logo

1z0-071 Questions and Answers

Answer:

Explanation:

Answer:

Explanation:

Answer:

Explanation:

Answer:

Explanation:

Answer:

Explanation:

Answer:

Explanation:

Answer:

Explanation:

Answer:

Explanation:

Answer:

Explanation:

Answer:

Explanation:

Answer:

Explanation:

Answer:

Explanation:

Answer:

Explanation:

Answer:

Explanation:

Answer:

Explanation:

Answer:

Explanation:

Answer:

Explanation:

Answer:

Explanation:

Answer:

Explanation:

Answer:

Explanation:

Answer:

Explanation:

Answer:

Explanation:

Answer:

Explanation:

Answer:

Explanation:

Answer:

Explanation:

Answer:

Explanation:

Answer:

Explanation:

Answer:

Explanation:

Answer:

Explanation:

Answer:

Explanation:

Answer:

Explanation:

Answer:

Explanation:

Answer:

Explanation:

Answer:

Explanation:

Answer:

Explanation:

Answer:

Explanation:

Answer:

Explanation:

Answer:

Explanation: