Oracle 1z0-061 問題集

質問 1：
Which statement adds a constraint that ensures the CUSTOMER_NAME column of the CUSTOMERS table holds a value?
A. ALTER TABLE customers MODIFY name CONSTRAINT cust_name_nn NOT NULL;
B. ALTER TABLE customers MODIFY customer_name CONSTRAINT cust_name_nn
NOT NULL;
C. ALTER TABLE customers ADD CONSTRAINT cust_name_nn CHECK customer_name NOT NULL;
D. ALTER TABLE customers MODIFY customer_name CONSTRAINT cust_name_nn IS NOT NULL;
E. ALTER TABLE customers ADD CONSTRAINT cust_name_nn CHECK customer_name IS NOT NULL;
F. ALTER TABLE customers MODIFY CONSTRAINT cust_name_nn CHECK
customer_name IS NOT NULL;
正解：B

質問 2：
Which two statements about sub queries are true? (Choose two.)
A. A sub query CANNOT be used in an SQL query statement that uses group functions.
B. When a sub query is used with an inequality comparison operator in the outer SQL statement, the column list in the SELECT clause of the sub query should contain only one column.
C. A sub query can be used only in SQL query statements.
D. Sub queries CANNOT be nested by more than two levels.
E. A sub query can retrieve zero or more rows.
F. A sub query should retrieve only one row.
正解：B,E
解説: (Topexam メンバーにのみ表示されます)

質問 3：
Examine the types and examples of relationships that follow:
1 . One-to-one a) Teacher to students
2 . One-to-many b) Employees to Manager
3 . Many-to-one c) Person to SSN
4 . Many-to-many d) Customers to products
Which option indicates the correctly matched relationships?
A. 1-c, 2-a, 3-b, and 4-d
B. 1-c, 2-d, 3-a, and 4-b
C. 1-d, 2-b, 3-a, and 4-c
D. 1-a, 2-b, 3-c, and 4-d
正解：A

質問 4：
Which two statements are true regarding single row functions? (Choose two.)
A. They accept only a single argument
B. They always return a single result row for every row of a queried table
C. They can return a data type value different from the one that is referenced
D. Arguments can only be column values or constant
E. They can be nested only to two levels
正解：B,C
解説: (Topexam メンバーにのみ表示されます)

質問 5：
Examine the data in the CUST_NAME column of the CUSTOMERS table.
CUST_NAME
---------------------
Lex De Haan
Renske Ladwig
Jose Manuel Urman
Jason Mallin
You want to extract only those customer names that have three names and display the * symbol in place of the first name as follows:
CUST NAME
---------------------
*** De Haan
**** Manuel Urman
Which two queries give the required output? (Choose two.)
A. SELECT LPAD(SUBSTR(cust_name, INSTR(cust_name, ' ')), LENGTH(cust_name)- INSTR(cust_name, ' '), '*') "CUST NAME"FROM customersWHERE INSTR(cust_name, ' ',
1, 2)<>0 ;
B. SELECT LPAD(SUBSTR(cust_name, INSTR(cust_name, ' ')), LENGTH(cust_name), '*')
"CUST NAME" FROM customersWHERE INSTR(cust_name, ' ', -1, 2)<>0;
C. SELECT LPAD(SUBSTR(cust_name, INSTR(cust_name, ' ')), LENGTH(cust_name), '*')
"CUST NAME" FROM customersWHERE INSTR(cust_name, ' ', 1, 2)<>0;
D. SELECT LPAD(SUBSTR(cust_name, INSTR(cust_name, ' ')), LENGTH(cust_name)- INSTR(cust_name, ''), '*') "CUST NAME"FROM customersWHERE INSTR(cust_name, ' ', -
1, -2)<>0;
正解：B,C

質問 6：
Which three statements are true regarding sub queries? (Choose three.)
A. Sub queries can contain GROUP BY and ORDER BY clauses
B. Main query and sub query can get data from different tables
C. Main query and sub query must get data from the same tables
D. Only one column or expression can be compared between the main query and subqeury
E. Multiple columns or expressions can be compared between the main query and sub query
F. Sub queries can contain ORDER BY but not the GROUP BY clause
正解：A,B,E

質問 7：
The CUSTOMERS table has these columns:

A promotional sale is being advertised to the customers in France.
Which WHERE clause identifies customers that are located in France?
A. WHERE lower(country_address) IS 'france'
B. WHERE lower(country_address) = '%france%'
C. WHERE lower(country_address) LIKE %france%
D. WHERE lower(country_address) = 'france'
E. WHERE lower(country_address) = "france"
正解：D
解説: (Topexam メンバーにのみ表示されます)