最新の2025年02月試験1z1-071問題集で合格させる認証試験合格させます [Q183-Q204]

Rate this post

最新の2025年02月試験1z1-071問題集で合格させる認証試験合格させます

最新でリアルなOracle 1z1-071試験問題集解答があります

Oracle 1z0-071試験は、Oracle Database 12c Administrator Certified AssociateやOracle Database 12c Administrator Certified Professionalなど、多くのOracle認証の前提条件となります。この認証は、IT業界での雇用を求める個人にとっても貴重な資産であり、Oracleデータベースを扱う専門知識を証明するものです。全体的に、Oracle 1z0-071試験は挑戦的ですが、データベースを扱う個人に多くの機会を提供する報酬の高い認証といえます。

質問 183
Which two are true about granting privileges on objects? (Choose two.)

An object privilege can be granted to other users only by the owner of that object.

An object privilege can be granted to a role only by the owner of that object.

A table owner must grant the REFERENCESprivilege to allow other users to create FOREIGN KEY constraints using that table.

The owner of an object acquires all object privileges on that object by default.

The WITH GRANT OPTIONclause can be used only by DBA users.

質問 184
Which three are true about multitable INSERTstatements? (Choose three.)

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

They can be performed on relational tables.

They can be performed only by using a subquery.

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

They can be performed on views.

They can be performed on remote tables.

質問 185
The ORDERStable has a primary key constraint on the ORDER_IDcolumn.
The ORDER_ITEMStable has a foreign key constraint on the ORDER_IDcolumn, referencing the primary key of the ORDERStable.
The constraint is defined with ON DELETE CASCADE.
There are rows in the ORDERStable with an ORDER_TOTALof less than 1000.
Which three DELETEstatements execute successfully?
DELETE order_id FROM orders WHERE order_total < 1000;

DELETE FROM orders WHERE order_total < 1000;

DELETE orders WHERE order_total < 1000;

DELETE * FROM orders WHERE order_total < 1000;

DELETE FROM orders;

質問 186
Examine the description of the EMPLOYEES table:

Which two statements will run successfully?

SELECT ‘The first_name is ” || first_name || ” FROM employees ;

SELECT ‘The first_name is ”’||first_name ||”” FROM employees ;

SELECT ‘The first_name is ”’ ||first_name||”’ FROM employees ;

SELECT ‘The first_name is ‘|| first_name|| ” FROM employees;

SELECT ‘The first_name is ” || first_name || ”’ FROM employees;

質問 187
Examine the structure of the PROMOTIONS table: (Choose the best answer.)

Management requires a report of unique promotion costs in each promotion category.
Which query would satisfy this requirement?

SELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1

SELECT promo_category, DISTINCT promo_cost FROM promotions

SELECT DISTINCT promo_cost, promo_category FROM promotions

SELECT DISTINCT promo_cost, DISTINCT promo_category FROM promotions;

質問 188
View the exhibit and examine the description of the PRODUCT_INFORMATION table.
Which SQL statement would retrieve from the table the number of products having LIST_PRICE as NULL?

SELECT COUNT (DISTINCT list_price)FROM product_informationWHERE list_price is NULL

SELECT COUNT (NVL(list_price, 0))FROM product_informationWHERE list_price is NULL

SELECT COUNT (list_price)FROM product_informationWHERE list_price i= NULL

SELECT COUNT (list_price)FROM product_informationWHERE list_price is NULL

質問 189
View the exhibit and examine the structure of the STOREStable.
STORES table
Name Null? Type
—————– —– ————-
STORE_ID NUMBER
NAME VARCHAR2(100)
ADDRESS VARCHAR2(200)
CITY VARCHAR2(100)
COUNTRY VARCHAR2(100)
START_DATE DATE
END_DATE DATE
PROPERTY_PRICE NUMBER
You want to display the NAME of the store along with the ADDRESS, START_DATE, PROPERTY_PRICE, and the projected property price, which is 115% of property price.
The stores displayed must have START_DATEin the range of 36 months starting from 01-Jan-2000 and above.
Which SQL statement would get the desired output?

SELECT name, concat (address| | ‘,’| |city| |’, ‘, country) AS full_address, start_date,
property_price, property_price*115/100
FROM stores
WHERE MONTHS_BETWEEN (start_date, ’01-JAN-2000′) <=36;

SELECT name, concat (address| | ‘,’| |city| |’, ‘, country) AS full_address, start_date,
property_price, property_price*115/100
FROM stores
WHERE TO_NUMBER(start_date-TO_DATE(’01-JAN-2000′,’DD-MON-RRRR’)) <=36;

SELECT name, address||’,’||city||’,’||country AS full_address,
start_date,
property_price, property_price*115/100
FROM stores
WHERE MONTHS_BETWEEN (start_date, TO_DATE(’01-JAN-2000′,’DD-MON-RRRR’))
<=36;

SELECT name, concat (address||’,’| |city| |’, ‘, country) AS full_address, start_date,
property_price, property_price*115/100
FROM stores
WHERE MONTHS_BETWEEN (start_date, TO_DATE(’01-JAN-2000′,’DD-MON-RRRR’))
<=36;

質問 190
View the exhibit and examine the structure of the SALES, CUSTOMERS, PRODUCTSand TIMEStables.

The PROD_IDcolumn is the foreign key in the SALEStable, which references the PRODUCTStable.
Similarly, the CUST_IDand TIME_IDcolumns are also foreign keys in the SALEStable referencing the CUSTOMERSand TIMEStables, respectively.
Evaluate the following CREATE TABLEcommand:
CREATE TABLE new_sales (prod_id, cust_id, order_date DEFAULT SYSDATE)
AS
SELECT prod_id, cust_id, time_id
FROM sales;
Which statement is true regarding the above command?

The NEW_SALEStable would get created and all the NOTNULLconstraints defined on the specified columns would be passed to the new table.

The NEW_SALEStable would not get created because the DEFAULTvalue cannot be specified in the column definition.

The NEW_SALEStable would not get created because the column names in the CREATETABLE command and the SELECTclause do not match.

The NEW_SALEStable would get created and all the FOREIGNKEYconstraints defined on the specified columns would be passed to the new table.

質問 191
Examine the structure of the MARKS table:

Which two statements would execute successfully? (Choose two.)

SELECT SUM(DISTINCT NVL(subject1,0)), MAX(subject1)FROM marksWHERE subject1 > subject2;

SELECT student_name subject1FROM marksWHERE subject1 > AVG(subject1);

SELECT SUM(subject1+subject2+subject3)FROM marksWHERE student_name IS NULL;

SELECT student_name,SUM(subject1)FROM marksWHERE student_name LIKE ‘R%’;

質問 192
The user SCOTTwho is the owner of ORDERSand ORDER_ITEMStables issues this GRANTcommand:
GRANT ALL
ON orders, order_items
TO PUBLIC;
What must be done to fix the statement?

PUBLICshould be replaced with specific usernames.

ALLshould be replaced with a list of specific privileges.

WITH GRANT OPTIONshould be added to the statement.

Separate GRANTstatements are required for ORDERSand ORDER_ITEMS tables.

質問 193
Examine the structure of the SHIPMENTS table:

You want to generate a report that displays the PO_IDand the penalty amount to be paid if the SHIPMENT_DATEis later than one month from the PO_DATE. The penalty is $20 per day.
Evaluate the following two queries:

Which statement is true regarding the above commands?

Both execute successfully and give correct results.

Only the first query executes successfully but gives a wrong result.

Only the first query executes successfully and gives the correct result.

Only the second query executes successfully but gives a wrong result.

Only the second query executes successfully and gives the correct result.

質問 194
Examine the description of the PRODUCT_DETAILS table:

Which two statements are true?

PRODUCT_PRICE contains the value zero by default if no value is assigned to it.

PRODUCT_PRICE can be used in an arithmetic expression even if it has no value stored in it.

EXPIRY_DATE cannot be used in arithmetic expressions.

PRODUCT_ID can be assigned the PRIMARY KEY constraint.

EXPIRY_DATE contains the SYSDATE by default if no date is assigned to it.

PRODUCT_NAME cannot contain duplicate values.

質問 195
View the Exhibit and examine the details of the PRODUCT_INFORMATION table. (Choose two.)

Evaluate this SQL statement:
SELECT TO_CHAR(list_price,’$9,999′)
From product_information;
Which two statements are true regarding the output? (Choose two.)

A row whose LIST_PRICE column contains value 11235.90 would be displayed as #######.

A row whose LIST_PRICE column contains value 1123.90 would be displayed as $1,123.

A row whose LIST_PRICE column contains value 1123.90 would be displayed as $1,124.

A row whose LIST_PRICE column contains value 11235.90 would be displayed as $1,123.

質問 196
Examine this data in the EMPLOYERS table

Which statement will execute successfully?

SELECT dept_id, MAX (Last_name), SUM (salary) FROM employees GROUP BY dept_id

SELECT dept_id, LENGTH (last_name), SUM (salary) FROM employees GROUP BY dept_id

SELECT dept_id, STDDEV (last_name), SUM (salary) FROM employees GROUP BY dept_id

SELECT dept_id, INSTR (last_name,’A’), SUM (salary) FROM employees GROUP BY dept_id

質問 197
View the Exhibit and examine the structure of the ORDER_ITEMS table.

You must select the ORDER_ID of the order that has the highest total value among all the orders in the ORDER_ITEMS table.
Which query would produce the desired result?

SELECT order_idFROM order_itemsGROUP BY order_idHAVING SUM(unit_price*quantity) = (SELECT MAX(SUM(unit_price*quantity))FROM order_items GROUP BY order_id);

SELECT order_idFROM order_itemsWHERE(unit_price*quantity) = (SELECT
MAX(unit_price*quantity)FROM order_items)GROUP BY order_id;

SELECT order_idFROM order_itemsWHERE(unit_price*quantity) =
MAX(unit_price*quantity)GROUP BY order_id;

SELECT order_idFROM order_itemsWHERE (unit_price*quantity) = (SELECT MAX(unit_price*quantity)FROM order_itemsGROUP BY order_id)

質問 198
View the Exhibit and examine the structure of ORDERS and CUSTOMERS tables. (Choose the best answer.)

You executed this UPDATE statement:
UPDATE
( SELECT order_date, order_total, customer_id FROM orders)
Set order_date = ’22-mar-2007′
WHERE customer_id IN
(SELECT customer_id FROM customers
WHERE cust_last_name = ‘Roberts’ AND credit_limit = 600);
Which statement is true regarding the execution?

It would not execute because a subquery cannot be used in the WHERE clause of an UPDATE statement.

It would not execute because two tables cannot be referenced in a single UPDATE statement.

It would execute and restrict modifications to the columns specified in the SELECT statement.

It would not execute because a SELECT statement cannot be used in place of a table name.

質問 199
Which three are true about the CREATE TABLE command?

It can include the CREATE…INDEX statement for creating an index to enforce the primary key constraint.

The owner of the table should have space quota available on the tablespace where the table is defined.

It implicitly executes a commit.

It implicitly rolls back any pending transactions.

A user must have the CREATE ANY TABLE privilege to create tables.

The owner of the table must have the UNLIMITED TABLESPACE system privilege.

質問 200
Evaluate the following CRTEATE TABLE commands:
CREATE_TABLE orders
(ord_no NUMBER (2) CONSTRAINT ord_pk PRIMARY KEY,
ord_date DATE,
cust_id NUMBER (4) );
CREATE TABLE ord_items
(ord _no NUMBER (2),
item_no NUMBER(3),
qty NUMBER (3) CHECK (qty BETWEEEN 100 AND 200),
expiry_date date CHECK (expiry_date> SYSDATE),
CONSTRAINT it_pk PRIMARY KEY (ord_no, item_no),
CONSTARAINT ord_fk FOREIGN KEY (ord_no) REFERENCES orders (ord_no) );
The above command fails when executed. What could be the reason?

SYSDATE cannot be used with the CHECK constraint.

The BETWEEN clause cannot be used for the CHECK constraint.

The CHECK constraint cannot be placed on columns having the DATE data type.

ORD_NO and ITEM_NO cannot be used as a composite primary key because ORD_NO is also the FOREIGN KEY.

質問 201
View the Exhibit and examine the structure of the PRODUCTS table.

You must display the category with the maximum number of items.
You issue this query:

What is the result?

It generates an error because = is not valid and should be replaced by the IN operator.

It executes successfully but does not give the correct output.

It executes successfully and gives the correct output.

It generate an error because the subquery does not have a GROUP BY clause.

質問 202
Examine the data in the CUST_NAME column of the CUSTOMERS table.

You want to extract only those customer names that have three names and display the * symbol in place of the first name as follows:

Which two queries give the required output?

SELECT LPAD(SUBSTR(cust_name, INSTR(cust_name, ‘ ‘)),LENGTH(cust_name),’*’) “CUST NAME”FROM customersWHERE INSTR(cust_name, ‘ ‘,1,2)<>0;

SELECT LPAD(SUBSTR(cust_name, INSTR(cust_name, ‘ ‘)),LENGTH(cust_name),’*’) “CUST NAME”FROM customersWHERE INSTR(cust_name, ‘ ‘,-1,2)<>0;

SELECT LPAD(SUBSTR(cust_name, INSTR (cust_name ‘ ‘)),LENGTH(cust_name) – INSTR(cust_name, ‘ ‘), ‘*’) “CUST NAME”FROM customersWHERE INSTR(cust_name, ‘ ‘,1,-2)<>0;

SELECT LPAD(SUBSTR(cust_name, INSTR (cust_name ‘ ‘)),LENGTH(cust_name) – INSTR(cust_name, ‘ ‘), ‘*’) “CUST NAME”FROM customersWHERE INSTR(cust_name, ‘ ‘,1,2)<>0;

質問 203
Examine the description of the ENPLOYES table:

Which query requires explicit data type conversion?

SELECT SUBSTR(join date, 1, 2) – 10 FROM employees;

SELECT join_ date + ’20’ EROM employees;

SELECT join_ date||”|| salary FROM employees;

SELECT join _ date FROM employees WHERE join date > *10-02-2018′;

SELECT salary + ‘120.50’ FROM employees;

質問 204
View the Exhibit and examine the structure of the SALES and PRODUCTS tables. (Choose two.)

In the SALES table, PROD_ID is the foreign key referencing PROD_ID in the PRODUCTS table. You must list each product ID and the number of times it has been sold.
Examine this query which is missing a JOIN operator:
SQL > SELECT p.prod_id, count(s.prod_id)
FROM products p ______________ sales s
ON p.prod_id = s.prod_id
GROUP BY p.prod_id;
Which two JOIN operations can be used to obtain the required output?

FULL OUTER JOIN

JOIN

LEFT OUETR JOIN

RIGHT OUTER JOIN

1z1-071問題集を使って一日でOracle PL/SQL Developer Certified Associate試験最速合格：https://www.goshiken.com/Oracle/1z1-071-mondaishu.html

Tags: 1z1-071参考書, 1z1-071合格対策, 1z1-071最新問題, 1z1-071試験参考書, 1z1-071認証pdf資料

最新の2025年02月試験1z1-071問題集で合格させる認証試験合格させます [Q183-Q204]

コメントを残すコメントをキャンセル

関連認証

1z1-071 練習テスト

最近の投稿

アーカイブ

カテゴリー

最新の2025年02月試験1z1-071問題集で合格させる認証試験合格させます [Q183-Q204]

コメントを残す コメントをキャンセル

関連認証

1z1-071 練習テスト

最近の投稿

アーカイブ

カテゴリー

コメントを残すコメントをキャンセル