1z0-071試験無料問題集「Oracle Database SQL 認定」

ページ: 1 / 22
トータル 325 問

サインアップ、ログインされた後に、試験全体を無料で表示できるようになります。

完全版を入手する

出題：1

Examine this statement:

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

A. The primary key constraint on BMP_ID must have a name.

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

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

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

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

正解：B,D 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：2

Which two statements are true about Oracle databases and SQL?

A. A query can access only tables within the same schema.

B. When you execute an UPDATE statement, the database instance locks each updated row.

C. A user can be the owner of multiple schemas In the same database.

D. Updates performed by a database user can be rolled back by another user by using the ROLLBACK command.

E. The database guarantees read consistency at select level on user-created tablers.

正解：B,E 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：3

Which three queries execute successfully?

A. SELECT 1 / SYSDATE - DATE '2019-01-01' FROM DUAL;

B. SELECT 1 - SYSDATE- DATE '2019-01-01' FROM DUAL;

C. SELECT SYSDATE - 1 - DATE'2019-01-01' EROM DUAL;

D. SELECT SYSDATE - DATE '2019-01-01' - 1 FROM DUAL;

E. SELECT SYSDATE / DATE '2019-01-01' - 1 FROM DUAL

F. SELECT (SYSDATE-DATE '2019-01-01') / 1 FROM DUAL;

正解：C,D,F 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：4

In your session, the NLS._DAE_FORMAT is DD- MM- YYYY.There are 86400 seconds in a day.Examine this result:
DATE
02-JAN-2020
Which statement returns this?

A. SELECT-TO_CHAR(TO _DATE('29-10-2019'+ INTERVAL '2' MONTH+INTERVAL '6' DAYINTERVAL
'120' SECOND, 'DD-MON-YY') AS "daTe"
FROM DUAL;

B. SELECT-TO_CHAR(TO _DATE('29-10-2019'+ INTERVAL '2' MONTH+INTERVAL '4' DAYINTERVAL
'120' SECOND, 'DD-MON-YY') AS "daTe"
FROM DUAL;

C. SELECT To CHAR(TO _DATE('29-10-2019') + INTERVAL '2' NONTH + INTERVAL '5' DAY INEERVAL '120' SECOND, ' DD-MON-YYY) AS "date" FROM DUAL;

D. SELECT TO_ CHAR(TO_ DATE('29-10-2019') +INTERVAL '2'; MONTH + INTERVAL '5'; DAY - INTERVAL '86410' SECOND, ' DD-MON-YYYY') AS "date" FROM DUAL;

E. SELECT TO_ CHAR(TO_ DATE('29-10-2019') + INTERVAL '3' MONTH + INTERVAL '7' DAY - INTERVAL '360' SECOND, ' DD-MON-YYYY') AS "date" FROM DUAL;

正解：E 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：5

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

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

B. 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.

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

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

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

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

G. 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,B,F 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：6

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

A. SELECT LOWER (SUBSTR('Hello World, 2, 1)) FROM DUAL;

B. SELECT SUBSTR('Hello world', 2) FROM DUAL;

C. SELECT LOWER(TRIM('H' FROM 'Hello World')) FROM DUAL;

D. SELECT LOWER (SUBSTR('Hello World', 2)) FROM DUAL;

E. SELECT INITCAP(TRIM('H' FROM 'Hello World')) FROM DUAL;

正解：B,D 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：7

Examine this query:
SELECT employee_id, first_name, salary
FROM employees
WHERE hiredate > 61*
Which two methods should yours to prevent prompting for hire date value when this queries executed?

A. Use the UNDEFINE command before executing the query.

B. Use the DEFINE command before executing the query

C. Store the query in a script and pass the substitution value to the script when executing it.

D. Execute the SET VERIFY ON command before executing the query.

E. Replace 's1' with &1'in the query:

F. Execute the SET VERIFY OFF command before executing the query.

正解：B,F 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：8

Examine the data in the ORDERS table:

Examine the data in the INVOICES table:

Examine this query:
SELECT order_ id, order_ date FROM orders
INTERSECT
SELECT order_ 1d, order_ date FROM invoices;
Which two rows will it return?

A. 3 <null>

B. 2 <null>

C. 4 01-FEB-2019

D. 3 01-JAN-2019

E. 5 01-MAR-2019

F. 1 <null>

正解：C,F 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：9

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

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

B. CURRENT_TIMESTAMP returns the same date as CURRENT_DATE.

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

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

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

F. SYSDATE can be queried only from the DUAL table.

正解：A,D 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：10

Examine the description of the CUSTONERS table:

CUSTNO is the PRIMARY KEY.
You must determine if any customers' details have been entered more than once using a different CUSTNO, by listing all duplicate names.
Which two methods can you use to get the required result?

A. subquery

B. RIGHT OUTER JOIN with self join

C. PULL OUTER JOIN with self join

D. self Join

E. LEFT OUTER JOIN with self join

正解：A,D 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：11

You own table DEPARTMENTS, referenced by views, indexes, and synonyms.
Examine this command which executes successfully:
DROP TABLE departments PURGE;
Which three statements are true?

A. It will remove all synonyms for the DEPARTMENTS table.

B. It will remove all views that are based on the DEPARTMENTS table.

C. Neither can it be rolled back nor can the DEPARTMENTS table be recovered.

D. It will drop all indexes on the DEPARTMENTS table.

E. It will delete all rows from the DEPARTMENTS table, but retain the empty table.

F. It will remove the DE PARTMENTS table from the database.

正解：C,D,F 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：12

Examine this partial command:

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

A. the ACCESS PARAMETERS clause

B. the access driver TYPE clause

C. the REJECT LIMIT clause

D. the LOCATION clause

E. the DEFAULT DIRECTORY clause

正解：B,D 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：13

Examine the description of the ENPLOYES table:

Which query requires explicit data type conversion?

A. SELECT join _ date FROM employees WHERE join date > *10-02-2018';

B. SELECT join_ date + '20' EROM employees;

C. SELECT join_ date||''|| salary FROM employees;

D. SELECT salary + '120.50' FROM employees;

E. SELECT SUBSTR(join date, 1, 2) - 10 FROM employees;

正解：A 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：14

You and your colleague Andrew have these privileges on the EMPLOYEE_RECORDS table:
1. SELECT
2. INSERT
3. UPDATE
4. DELETE
You connect to the database instance an perform an update to some of the rows in EMPLOYEE_RECORDS, but don't commit yet.
Andrew connects to the database instance and queries the table
No othet user are accessing the table
Which two statements ate true at this point?

A. Andrew will be unable to see the changes you have made

B. Andrew will be able to SELECT from the table, but be unable to modify any existing rows.

C. Andrew will be able to modify any rows in the table that have not been modified by your transaction

D. Andrew will be unable to perform any INSERT, UPDATE of DELETE on the teble

E. Andrew will be able to see the changes you habe made

正解：A,C 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：15

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?

A. 2 and 3

B. 1 and 3

C. 1 and 2

D. 1, 2 and 3

正解：B 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

ページ: 1 / 22
トータル 325 問

1z0-071 の機能をすべて解除する

キャプチャ不要
365日無料更新サービス
希望する合格率を設定できる
時間の割り当てられる（時間：分）
1z0-071 に2つの練習用モード
サポートサービス対応

完全版を入手する

弊社のサイトにはあなたの試験合格を助けるために研究された効果的な知能問題集を提供しています。材料はすべてのユーザーによって称賛されています。弊社のサイトは、最短時間で多くの証明書を取得するのに役立つ学習プラットフォームになります。

掲示板

試験OmniStudio-Consultant-JPN トピック1 問題118 スレッド
試験Salesforce-AI-Specialist-JPN トピック1 問題5 スレッド
試験OmniStudio-Consultant-JPN トピック4 問題17 スレッド
試験OmniStudio-Consultant-JPN トピック1 問題54 スレッド
試験OmniStudio-Consultant-JPN トピック1 問題51 スレッド
試験IIA-CIA-Part3 トピック3 問題134 スレッド
試験MS-102J トピック1 問題136 スレッド

弊社を連絡する

我々の働いている時間：( UTC+9 ) 9:00-24:00

月曜日から土曜日まで

サポート：現在連絡

我々は１２時間以内ですべてのお問い合わせを答えます。