IT認証試験問題集
毎月、ITshikenは1500人以上の受験者が試験準備を助けて、試験に合格するために受験者にご協力します
 ホームページ / 1Z0-071 問題集  / 1Z0-071 問題練習

Oracle 1Z0-071 問題練習

Oracle Database 12c SQL 試験

最新更新時間: 2019/07/10,合計954問。

平成から令和へ:1Z0-071 最新真題を買う時、日本語版と英語版両方を同時に獲得できます。

実際の問題集を練習し、試験のポイントを了解し、テストに申し込むするかどうかを決めることができます。

さらに試験準備時間の35%を節約するには、1Z0-071 問題集を使用してください。

 / 64

Question No : 1
Using the CUSTOMERS table, you need to generate a report that shows 50% of each credit amount in each income level. The report should NOT show any repeated credit amounts in each income level.
Which query would give the required result?

正解:

Question No : 2
Evaluate the following CREATE TABLE command:



Which statement is true regarding the above SQL statement?

正解:

Question No : 3
Which two statements are true about sequences crated in a single instance Oracle database?

正解:

Question No : 4
View the exhibit and examine the structure of the PROMOTIONS table.



You have to generate a report that displays the promo name and start date for all promos that started after the last promo in the ‘INTERNET’ category.
Which query would give you the required output?

正解:

Question No : 5
Which statement is true about Data Manipulation Language (DML)?

正解:

Question No : 6
The BOOKS_TRANSACTIONS table exists in your schema in this database.
You execute this SQL statement when connected to your schema in your database instance.
SQL> SELECT * FROM books_transactions ORDER BY 3;
What is the result?

正解:

Question No : 7
View the exhibit and examine the descriptions of the DEPT and LOCATIONS tables.



You want to update the CITY column of the DEPT table for all the rows with the corresponding value in the CITY column of the LOCATIONS table for each department.
Which SQL statement would you execute to accomplish the task?

正解:

Question No : 8
View the exhibits and examine the structures of the COSTS and PROMOTIONS tables.






Evaluate the following SQL statement:



What would be the outcome of the above SQL statement?

正解:

Question No : 9
Which three statements are true? (Choose three.)

正解:
Explanation:
References: https://docs.oracle.com/cd/B10501_01/server.920/a96524/c05dicti.htm

Question No : 10
Which three statements are true regarding group functions? (Choose three.)

正解:
Explanation:
References: https://www.safaribooksonline.com/library/view/mastering-oracle-sql/0596006322/ch04.html

Question No : 11
Evaluate the following SELECT statement and view the exhibit to examine its output:
SELECT constraint_name, constraint_type, search_condition, r_constraint_name,
delete_rule, status,
FROM user_constraints
WHERE table_name = 'ORDERS';



Which two statements are true about the output? (Choose two.)

正解:

Question No : 12
View the exhibit and examine the structure of the SALES, CUSTOMERS, PRODUCTS and TIMES 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 CREATE TABLE command:
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?

正解:

Question No : 13
Examine the data in the CUST_NAME column of the CUSTOMERS table.



You need to display customers' second names where the second name starts with "Mc" or "MC".
Which query gives the required output?

正解:

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

正解:
Explanation:
References: https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions135.htm https://docs.oracle.com/cd/B28359_01/olap.111/b28126/dml_functions_2127.htm

Question No : 15
Rows are returned by the inner query, after being evaluated with the value from the candidate row in the outer query.
Which is the correct sequence in which the Oracle server evaluates a correlated subquery?

正解:
Explanation:
References: http://rajanimohanty.blogspot.co.uk/2014/01/correlated-subquery.html

 / 64