次の認定試験に速く合格する！

簡単に認定試験を準備し、学び、そして合格するためにすべてが必要だ。

会員センターカート (0)

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

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

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

完全版を入手する

質問 1

Examine the structure proposed for the TRANSACTIONS table:

Which two statements are true regarding the storage of data in the above table structure?
(Choose two.)

（A）The CUST_STATUS column would allow storage of data up to the maximum VARCHAR2 size of 4, 000 characters.

（B）The TRANS_VALIDITY column would allow storage of a time interval in days, hours, minutes, and seconds.

（C）The TRANS_DATE column would allow storage of dates only in the dd-mon-yyyy format.

（D）The CUST_CREDIT_VALUE column would allow storage of positive and negative integers.

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

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

質問 2

Which three tasks can be performed using SQL functions built into Oracle Database?

（A）Substituting a character string in a text expression with a specified string

（B）Displaying a date in a nondefault format

（C）Finding the number of characters in an expression

（D）Combining more than two columns or expressions into a single column in the output

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

質問 3

In which two cases would you use an outer join? (Choose two.)

（A）The tables being joined have only unmatched data.

（B）The tables being joined have NOT NULL columns.

（C）The tables being joined have both matched and unmatched data.

（D）The tables being joined have only matched data.

（E）Only when the tables have a primary key/foreign key relationship.

（F）The columns being joined have NULL values.

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

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

質問 4

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 解答を投票する

質問 5

The COMMISSION column shows the monthly commission earned by the employee.
Exhibit

Which two tasks would require sub queries or joins in order to be performed in a single step? (Choose two.)

（A）listing the employees who do not earn commission and who are working for department
20 in descending order of the employee ID

（B）finding the total commission earned by the employees in department 10

（C）finding the number of employees who earn a commission that is higher than the average commission of the company

（D）listing the employees who earn the same amount of commission as employee 3

（E）listing the employees whose annual commission is more than 6000

（F）listing the departments whose average commission is more that 600

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

質問 6

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

Examine the data in the ename and hiredate columns of the employees table:

You want to generate a list of user IDs as follows:

You issue the following query:

What is the outcome?

（A）It generates an error because the SUBSTR function cannot be nested in the CONCAT function.

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

（C）It generates an error because the REPLACE function is not valid.

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

正解：B 解答を投票する

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

質問 7

Evaluate the following query:
SQL> SELECT TRUNC(ROUND(156.00, -1), -1)
FROM DUAL;
What would be the outcome?

（A）150

（B）16

（C）160

（D）200

（E）100

正解：C 解答を投票する

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

質問 8

Examine the structure of the PROMOS table:

You want to display the list of promo names with the message 'Same Day' for promos that started and ended on the same day.
Which query gives the correct output?

（A）SELECT promo_name, NVL2(TO_CHAR(TRUNC(promo_end_date-promo_start_date)), NULL, 'Same Day')FROM promos;

（B）SELECT promo_name, NVL(NULLIF(promo_start_date, promo_end_date), 'Same Day') FROM promos;

（C）SELECT promo_name, DECODE((NULLIF(promo_start_date, promo_end_date)), NULL, 'Same day') FROM promos;

（D）SELECT promo_name, NVL(TRUNC(promo_end_date - promo_start_date), 'Same Day') FROM promos;

正解：C 解答を投票する

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

質問 9

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

Which two tasks would require subqueries? (Choose two.)

（A）Display the total number of products supplied by supplier 102 and have product status as 'obsolete'.

（B）Display the number of products whose list price is more than the average list price.

（C）Display all products whose minimum list price is more than the average list price of products and have the status 'orderable'.

（D）Display the minimum list price for each product status.

（E）Display all suppliers whose list price is less than 1000.

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

質問 10

See the Exhibit and examine the structure of the SALES, CUSTOMERS, PRODUCTS and ITEMS tables:

The PROD_ID column is the foreign key in the SALES table, which references the PRODUCTS table.
Similarly, the CUST_ID and TIME_ID columns are also foreign keys in the SALES table referencing the CUSTOMERS and TIMES tables, respectively.
Evaluate the following the CREATE TABLE command:
Exhibit:

Which statement is true regarding the above command?

（A）The NEW_SALES table would not get created because the column names in the CREATE TABLE command and the SELECT clause do not match

（B）The NEW_SALES table would get created and all the FOREIGN KEY constraints defined on the specified columns would be passed to the new table

（C）The NEW_SALES table would get created and all the NOT NULL constraints defined on the specified columns would be passed to the new table

（D）The NEW_SALES table would not get created because the DEFAULT value cannot be specified in the column definition

正解：C 解答を投票する

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

質問 11

Examine the structure and data in the PRIC E_LIST table: Name Null? Type
------------ ------------- -------------------
PROD_D NOT NULL NUMBER(3)
PROD_PRICE VARCHAR2(10)
PROD_ID PROD PRICE
----------- ------------------------
100 $234.55
101 $6, 509.75
102 $1, 234
in the same format as the PROD_PRICE. Which SQL statement would give the required result?

（A）SELECT TO_CHAR(prod_price* .25.'$99.999.99') FROM PRICEJLIST:

（B）. SELECT TO_CHAR(TO_NUMBER(prod_price)* .25.'$99.999.00') FROM PRICE_LIST;

（C）SELECT TO_CRAR(TO_NUMBER(prod_price.'S99.999.99')* .25.'$99.999.00') FROM PRICE_LIST:

（D）SELECT TO_NUMBER(TO_NUMBER(prod_price., $99.999.99')* .25/$99.999.00') FROM PRICE_LIST:

正解：C 解答を投票する

質問 12

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

You need to generate a report in the following format:
CATEGORIES
---------------------------------------------
5MP Digital Photo Camera's category is Photo
Y Box's category is Electronics
Envoy Ambassador's category is Hardware
Which two queries would give the required output? (Choose two.)

（A）SELECT prod_name || q'''s category is ' || prod_category CATEGORIES FROM products;

（B）SELECT prod_name || q'\'s\' || ' category is ' || prod_category CATEGORIES FROM products;

（C）SELECT prod_name || q'<'s >' || 'category is ' || prod_category CATEGORIES FROM products;

（D）SELECT prod_name || q'['s ]'category is ' || prod_category CATEGORIES FROM products;

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

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

質問 13

You need to perform these tasks:
Which set of SQL statements achieves the desired results?

（A）CREATE ROLE manager;GRANT create table, create viewTO manager;GRANT
manager TO BLAKE, CLARK;

（B）GRANT manager ROLE TO BLAKE, CLARK;GRANT create table, create voewTO BLAKE CLARK;***MISSING***

（C）CREATE ROLE manager;GRANT create table, create voewTO manager;GRANT
manager ROLE TO BLAKE, CLARK;

正解：A 解答を投票する

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

質問 14

Exhibit contains the structure of PRODUCTS table:

Evaluate the following query:

What would be the outcome of executing the above SQL statement?

（A）It shows the names of products whose list price is the second highest in the table.

（B）It produces an error

（C）It shown the names of all products whose list price is less than the maximum list price

（D）It shows the names of all products in the table

正解：A 解答を投票する

質問 15

The CUSTOMERS table has these columns:
The CUSTOMER_ID column is the primary key for the table.
You need to determine how dispersed your customer base is.
Which expression finds the number of different countries represented in the CUSTOMERS table?

（A）COUNT DISTINCT UPPER(country_address)

（B）COUNT(DIFF(UPPER(country_address)))

（C）COUNT(UNIQUE(UPPER(country_address)))

（D）COUNT(DISTINCT (UPPER(country_address)))

（E）COUNT(UPPER(country_address))

正解：D 解答を投票する

質問 16

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

（A）They can be created on tables and simple views.

（B）They can be created on tables and clusters.

（C）You can create more than one index by using the same columns if you specify distinctly different combinations of the columns.

（D）You can create only one index by using the same columns.

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

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

1z1-061 の機能をすべて解除する

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

完全版を入手する

弊社を連絡する

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

オンラインサポート時間：( UTC+9 ) 9:00-24:00
月曜日から土曜日まで

サポート：現在連絡

トップ試験

ATM 試験問題集
AgilePM-Foundation 試験問題集
CCAK 試験問題集
MB-700 試験問題集
Acquia-Certified-Site-Builder-D8 試験問題集
SY0-701 試験問題集

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

弊社を連絡する

関連リンク

トップ試験