1z1-061無料問題集「Oracle Database 12c: SQL Fundamentals」

質問 1

Which statement adds a column called salary to the employees table having 100 rows, which cannot contain null?

（A）Option D

（B）Option B

（C）Option C

（D）Option A

正解：C 解答を投票する

質問 2

Which object privileges can be granted on a view?

（A）DELETE, INSERT, SELECT, UPDATE

（B）none

（C）DELETE, INSERT, SELECT

（D）ALTER, DELETE, INSERT, SELECT

正解：A 解答を投票する

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

質問 3

You need to display the date 11-Oct-2007 in words as 'Eleventh of October, Two Thousand Seven'.
Which SQL statement would give the required result?

（A）SELECT TO_CHAR(TO_DATE('11-oct-2007'), 'fmDdthsp "of" Month, Year') FROM DUAL;

（B）SELECT TO_DATE(TO_CHAR('11-oct-2007', 'fmDdspth ''of'' Month, Year')) FROM DUAL;

（C）SELECT TO_CHAR(TO_DATE('11-oct-2007'), 'fmDdspth of month, year') FROM DUAL;

（D）SELECT TO_CHAR('11-oct-2007', 'fmDdspth "of" Month, Year') FROM DUAL;

正解：A 解答を投票する

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

質問 4

View the Exhibit and examine the structure of the PRODUCTS table.

You want to display the category with the maximum number of items.
You issue the following query:
SQL>SELECT COUNT(*), prod_category_id
FROM products
GROUP BY prod_category_id
HAVING COUNT(*) = (SELECT MAX(COUNT(*)) FROM products);
What is the outcome?

（A）It generates an error because the subquery does not have a GROUP BY clause.

（B）It executes successfully and gives the correct output.

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

（D）It executes successfully but does not give the correct output.

正解：A 解答を投票する

質問 5

Which two statements are true regarding single row functions?

（A）INSTR: can be used to find only the first occurrence of a character in a string

（B）TRIM: can be used to remove all the occurrences of a character from a string

（C）TRUNC: can be used with number and date values

（D）MOD: returns the quotient of a division

（E）CONCAT: can be used to combine any number of values

（F）SYSDATE: returns the database server current date and time

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

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

質問 6

Which two statements are true regarding constraints? (Choose two.)

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

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

（C）Both primary key and foreign key constraints can be defined at both column and table levels.

（D）Only the primary key can be defined at the column and table levels.

（E）The foreign key and parent table primary key must have the same name.

正解：B、C 解答を投票する

質問 7

Which three statements are true about multiple-row sub queries? (Choose three.)

（A）They can contain group functions and the GROUP BY clause, but not the HAVING clause.

（B）They can return only one column but multiple rows.

（C）They can contain group functions and GROUP BY and HAVING clauses.

（D）They can return multiple columns as well as rows.

（E）They cannot contain a subquery within a subquery.

（F）They can contain a subquery within a sub query.

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

質問 8

Evaluate the following SQL statement:

Which statement is true regarding the above query if one of the values generated by the subquery is null?

（A）It executes but returns no rows.

（B）It ignores the null value and generates output for the other values produced by the subquery.

（C）It produces an error.

（D）It generates output for null as well as the other values produced by the subquery.

正解：B 解答を投票する

質問 9

View the Exhibit and examine the structure of the PROMOTIONS table.
Exhibit:

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

（A）SELECT TO_CHAR(promo_begin_date,'dd/month')FROM promotionsWHERE
promo_begin_date IN (TO_DATE('JUN 01 98'), TO_DATE('JUL 01 98'));

（B）SELECT promo_begin_dateFROM promotionsWHERE
TO_CHAR(promo_begin_date,'mon dd yy')='jul 01 98';

（C）UPDATE promotionsSET promo_cost = promo_cost+ 100WHERE
TO_CHAR(promo_end_date,'yyyy') > '2000';

（D）UPDATE promotionsSET promo_cost = promo_cost+ 100WHERE promo_end_date > TO_DATE(SUBSTR('01-JAN-2000', 8));

正解：B、C 解答を投票する

質問 10

Which constraint can be defined only at the column level?

（A）CHECK

（B）UNIQUE

（C）PRIMARY KEY

（D）FOREIGN KEY

（E）NOT NULL

正解：E 解答を投票する

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

質問 11

You need to extract details of those products in the SALES table where the PROD_ID column contains the string '_D123'. Which WHERE clause could be used in the SELECT statement to get the required output?

（A）WHERE prod_id LIKE '%\_D123%' ESCAPE '\'

（B）WHERE prod_id LIKE '%\_D123%' ESCAPE '\_'

（C）WHERE prod_id LIKE '%_D123%' ESCAPE '_'

（D）WHERE prod_id LIKE '%_D123%' ESCAPE '%_'

正解：A 解答を投票する

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

質問 12

Examine the structure of the EMP_DEPT_VU view:

Which SQL statement produces an error?

（A）SELECT job_id, SUM(salary) FROM emp_dept_vu WHERE department_id IN (10, 20) GROUP BY job_id HAVING SUM(salary) > 20000;

（B）SELECT department_id, SUM(salary) FROM emp_dept_vu GROUP BY department_id;

（C）SELECT *FROM emp_dept_vu;

（D）SELECT department_id, job_id, AVG(salary) FROM emp_dept_vu GROUP BY
department_id, job_id;

（E）None of the statements produce an error; all are valid.

正解：E 解答を投票する

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

質問 13

Examine the structure and data of the CUSTJTRANS table:
CUSTJRANS
Name Null? Type
CUSTNO NOT NULL CHAR(2) TRANSDATE DATE TRANSAMT NUMBER(6.2) CUSTNO
TRANSDATE TRANSAMT
11 01-JAN-07 1000
22 01-FEB-07 2000
33 01-MAR-07 3000
Dates are stored in the default date format dd-mon-rr in the CUSTJTRANS table. Which three SQL statements would execute successfully? (Choose three.)

（A）SELECT * FROM custjrans WHERE transdate = '01-01-07':

（B）SELECT custno - 'A' FROM custjrans WHERE transamt > 2000:

（C）SELECT transamt FROM custjrans WHERE custno > '11':

（D）SELECT * FROM custjrans WHERE transdate='01-JANUARY-07':

（E）SELECT transdate + '10' FROM custjrans;

正解：C、D、E 解答を投票する

質問 14

Examine the structure of the PROMOS table:

You want to generate a report showing promo names and their duration (number of days).
If the PROMO_END_DATE has not been entered, the message 'ONGOING' should be displayed. Which queries give the correct output? (Choose all that apply.)

（A）SELECT promo_name, DECODE(promo_end_date-promo_start_date, NULL,
'ONGOING', promo_end_date - promo_start_date) FROM promos;

（B）SELECT promo_name, ecode(coalesce(promo_end_date, promo_start_date), null,
'ONGOING', promo_end_date - promo_start_date)FROM promos;

（C）SELECT promo_name, NVL(TO_CHAR(promo_end_date -promo_start_date),
'ONGOING') FROM promos;

（D）SELECT promo_name, COALESCE(TO_CHAR(promo_end_date - promo_start_date),
'ONGOING') FROM promos;

（E）SELECT promo_name, TO_CHAR(NVL(promo_end_date -promo_start_date,
'ONGOING')) FROM promos;

正解：A、C、D 解答を投票する

質問 15

What is the primary difference between the relational database (RDB) and object-oriented database (OODB) models?

（A）RDB allows the definition of relationships between different tables, whereas OODB does not allow this.

（B）OODB supports multiple objects in the same database, whereas RDB supports only tables.

（C）OODB incorporates methods with data structure definition, whereas RDB does not allow this.

（D）RDB supports E.F. Codd's rules, whereas OODB does not support them.

正解：C 解答を投票する

1z1-061 無料問題集「Oracle Database 12c: SQL Fundamentals」

弊社を連絡する

関連リンク

トップ試験