최신 1z1-071 무료덤프 - Oracle Database SQL

문제1

Examine the description of the ORDER_ITEMS table:

Examine this incomplete query:
SELECT DISTINCT quantity * unit_price total_paid FROM order_items ORDER BY <clause>; Which two can replace <clause> so the query completes successfully?

A. quantity

B. quantity, unit_price

C. quantity * unit_price

D. product_id

E. total_paid

정답: B,C

설명: (DumpTOP 회원만 볼 수 있음)

문제2

Evaluate these commands which execute successfully CREATE SEQUENCE ord_seq INCREMENT BY 1 START WITH 1 MAXVALUE 100000 CYCLE CACHE 5000; Create table ord_items( ord_no number(4) default ord_seq.nextval not null, Item_no number(3), Qty number(3), Expiry_date date, Constraint it_pk primary key(ord_no,item_no), Constraint ord_fk foreign key (ord_no) references orders(ord_no)); Which two statements are true about the ORD_ITEMS table and the ORD_SEQ sequence?

A. Column ORD_NO gets the next number from sequence ORD_SEQ whenever a row is inserted into ORD_ITEMS and no explicit value is given for ORD_NO.

B. Any user inserting rows into table ORD_ITEMS must have been granted access to sequence ORD_SEQ.

C. Sequence ORD_SEQ is guaranteed not to generate duplicate numbers.

D. Sequence ORD_SEQ cycles back to 1 after every 5000 numbers and can cycle 20 times

E. IF sequence ORD_SEQ is dropped then the default value for column ORD_NO will be NULL for rows inserted into ORD_ITEMS.

정답: A,E

설명: (DumpTOP 회원만 볼 수 있음)

문제3

You execute these commands:
CREATE TABLE customers (customer id INTEGER, customer name VARCHAR2 (20)); INSERT INTO customers VALUES (1,'Custmoer1 '); SAVEPOINT post insert; INSERT INTO customers VALUES (2, 'Customer2 ');
<TODO>
SELECTCOUNT (*) FROM customers;
Which two, used independently, can replace <TODO> so the query retums 1?

A. ROLLBACK;

B. ROLIBACK TO SAVEPOINT post_ insert;

C. CONOIT TO SAVEPOINT post_ insert;

D. COMMIT;

E. ROLLEBACK TO post_ insert;

정답: A,B

설명: (DumpTOP 회원만 볼 수 있음)

문제4

Which three actions can you perform by using the ORACLE DATAPUMP access driver?

A. Read data from a table in the database and insert it into an external table.

B. Query data from an external table.

C. Create a directory object for an external table.

D. Execute DML statements on an external table.

E. Create a directory object for a flat file.

F. Read data from an external table and load it into a table in the database.

정답: A,B,F

설명: (DumpTOP 회원만 볼 수 있음)

문제5

A session's NLS_DATE_FORMAT is set to DD Mon YYYY .
Which two queries return the value 1 Jan 2019?

A. SELECT TO_ DATE('2019-01-01') FROM DUAL;

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

C. SELECT '2019-01-01' FROM DUAL ; 2019-01-01

D. SELECT to_date(' 2019-01-01 ', 'YYYY -MM-DD' ) FROM DUAL;

E. SELECT TO_CHAR('2019-01-01') FROM DUAL; 2019-01-01

정답: B

설명: (DumpTOP 회원만 볼 수 있음)

문제6

The ORDERS table has a primary key constraint on the ORDER_ID column.
The ORDER_ITEMS table has a foreign key constraint on the ORDER_ID column, referencing the primary key of the ORDERS table.
The constraint is defined with on DELETE CASCADE.
There are rows in the ORDERS table with an ORDER_TOTAL less than 1000.
Which three DELETE statements execute successfully?

A. DELETE FROM orders;

B. DELETE FROM orders WHERE order_total<1000;

C. DELETE * FROM orders WHERE order_total<1000;

D. DELETE order_id FROM orders WHERE order_total<1000;

E. DELETE orders WHERE order_total<1000;

정답: A,B,E

설명: (DumpTOP 회원만 볼 수 있음)

문제7

Examine this SQL statement:
SELECT cust_id, cus_last_name "Last Name"
FROM customers
WHERE country_id = 10
UNION
SELECT cust_id CUST_NO, cust_last_name
FROM customers
WHERE country_id = 30
Identify three ORDER BY clauses, any one of which can complete the query successfully.

A. ORDER BY 2,cust_id

B. ORDER BY CUST_NO

C. ORDERBY 2, 1

D. ORDER BY "CUST_NO"

E. ORDER BY "Last Name"

정답: C,E

설명: (DumpTOP 회원만 볼 수 있음)

문제8

Examine this Statement which returns the name of each employee and their manager, SELECT e.last name AS emp,,m.last_name AS mgr FROM employees e JOIN managers m ON e.manager_ id = m. employee_ id ORDER BY emp; You want to extend the query to include employees with no manager. What must you add before JOIN to do this?

A. CROSS

B. RIGHT OUTER

C. FULL OUTER

D. LEFT OUTER

정답: D

설명: (DumpTOP 회원만 볼 수 있음)

문제9

Examine this business rule:
Each student can work on multiple projects and earth project can have multiple students.
You must decide an Entity Relationship (ER) model for optional data storage and allow generating reports in this format:
STUDENT_ID FIRST_NAME LAST_NAME PROJECT_ID PROJECT_NAME PROJECT_TASK Which two statements are true?

A. PROJECT_ID must be the primary key in the PROJECTS entity and foreign key in the STUDENTS entity.

B. STUDENT_ID must be the primary key in the STUDENTS entity and foreign key in the PROJECTS entity.

C. An associative table must be created with a composite key of STUDENT_ID and PROJECT_ID, which is the foreign key linked to the STUDENTS and PROJECTS entities.

D. The ER must have a many-to-many relationship between the STUDENTS and PROJECTS entities that must be resolved into 1-to-many relationships.

E. The ER must have a 1-to-many relationship between the STUDENTS and PROJECTS entities.

정답: C,D

설명: (DumpTOP 회원만 볼 수 있음)

문제10

SELECT *
FROM bricks,colors;
Which two statements are true?

A. You can add an ON clause with a join condition.

B. It returnsthe same rows as SELECT * FROM bricks CROSS JOIN colors.

C. You can add a USING clause with a join condition.

D. You can add a WHERE clause with filtering criteria.

E. It returns the number of rows in BRICKS plus the number of rows in COLORS.

정답: B,D

설명: (DumpTOP 회원만 볼 수 있음)

문제11

Which two statements are true about the data dictionary?

A. Views with the prefix all_, dba_ and useb_ are not all available for every type of metadata.

B. The data dictionary is accessible when the database is closed.

C. Views with the prefix dba_ display only metadata for objects in the SYS schema.

D. Views with the prefix all_ display metadata for objects to which the current user has access.

E. The data dictionary does not store metadata in tables.

정답: A,D

설명: (DumpTOP 회원만 볼 수 있음)

문제12

Which two statements are true about the DUAL table?

A. It can be used to display only constants or pseudo columns.

B. It can display multiple rows and columns.

C. It consists of a single row and single column of VARCHAR2 data type.

D. It can display multiple rows but only a single column.

E. It can be accessed by any user who has the SELECT privilege in any schema

F. It can be accessed only by the SYS user.

정답: C,E

설명: (DumpTOP 회원만 볼 수 있음)

문제13

Which two are true?

A. FLOOR returns the largest positive integer less than or equal to a specified number.

B. FLOOR returns the largest integer less than or equal to a specified number.

C. CONCAT joins two character strings together.

D. INSTR finds the offset within a string of a single character only.

E. CONCAT joins two or more character strings together.

F. INSTR finds the offset within a character string, starting from position 0.

정답: B,E

설명: (DumpTOP 회원만 볼 수 있음)

문제14

BOOK_SEQ is an existing sequence in your schema.
Which two CREATE TABLE commands are valid?

A. CREATE TABLE bookings (
bk_id NUMBER(4) NOT NULL DEFAULT book_seq.CURRVAL,
start_date DATE NOT NULL,
end_date DATE DEFAULT SYSDATE);

B. CREATE TABLE bookings (
bk_id NUMBER(4) DEFAULT book_seq.CURRVAL,
start_date DATE DEFAULT SYSDATE,
end_date DATE DEFAULT start date);

C. CREATE TABLE bookings (
bk_id NUMBER(4) DEFAULT book_seq.NEXTVAL PRIMARY KEY,
start_date DATE DEFAULT SYSDATE,
end_date DATE DEFAULT SYSDATE NOT NULL);

D. CREATE TABLE bookings (
bk_id NUMBER(4) NOT NULL PRIMARY KEY,
start_date DATE NOT NULL,
end_date DATE DEFAULT SYSDATE);

E. CREATE TABLE bookings ( bk_id NUMBER(4),
start_date DATE DEFAULT SYSDATE,
end_date DATE DEFAULT (end_date >= start_date));

정답: C,D

설명: (DumpTOP 회원만 볼 수 있음)

문제15

Which two statements will return the names of the three employees with the lowest salaries?

A. SELECT last_name, salary
FROM employees
WHERE ROWNUM<=3

B. SELECT last_name,salary
FROM (SELECT * FROM employees ORDER BY salary)

C. SELECT last_name,salary
FROM employees
ORDER BY salary
FETCH FIRST 3 ROWS ONLY;

D. SELECT last_name,salary
FROM employees
WHERE ROWNUM<=3
ORDER BY (SELECT salary FROM employees);

E. SELECT last_name,salary
FROM employees
FETCH FIRST 3 ROWS ONLY
ORDER BY salary;

정답: C

설명: (DumpTOP 회원만 볼 수 있음)

문제16

Examine the data in the NEW_EMPLOYEES table:

Examine the data in the EMPLOYEES table:

You want to:
1. Update existing employee details in the EMPLOYEES table with data from the NEW EMPLOYEES table.
2. Add new employee detail from the NEW_ EMPLOYEES able to the EMPLOYEES table.
Which statement will do this:

A. MERGE INTO employees e
USING new employees ne
ON (e.employee_id = ne.employee_id)
WHEN FOUND THEN
UPDATE SET e.name =ne.name, e.job_id=ne.job_id, e.salary =ne.salary
WHEN NOT FOUND THEN
INSERT VALUES (ne.employee_id,ne.name,ne.job_id,ne.salary) ;

B. MERGE INTO employees e
USING new employees ne
WHERE e.employee_id = ne.employee_ id
WHEN MATCHED THEN
UPDATE SET e.name = ne.name, e.job_id = ne.job_id,e.salary =ne. salary
WHEN NOT MATCHED THEN
INSERT VALUES (ne. employee_id,ne.name, ne.job_id,ne.salary) ;

C. MERGE INTO employees e
USING new_employees n
WHERE e.employee_id = ne.employee_id
WHEN FOUND THEN
UPDATE SET e.name=ne.name,e.job_id =ne.job_id, e.salary=ne.salary
WHEN NOT FOUND THEN
INSERT VALUES (ne.employee_ id,ne.name,ne.job id,ne.salary) ;

D. MERGE INTO employees e
USING new_employees n
ON (e.employee_id = ne.employee_id)
WHEN MATCHED THEN
UPDATE SET e.name = ne.name, e.job id = ne.job_id,e.salary =ne. salary
WHEN NOT MATCHED THEN
INSERT VALUES (ne. employee_id,ne.name,ne.job_id,ne.salary);

정답: D

설명: (DumpTOP 회원만 볼 수 있음)

문제17

Which two statements are true about an Oracle database?

A. A NUMBER column without data has a zero value.

B. A table can have multiple foreign keys.

C. A table can have multiple primary keys.

D. A VARCHAR2 column without data has a NULL value.

E. A column definition can specify multiple data types.

정답: B,D

설명: (DumpTOP 회원만 볼 수 있음)

문제18

Which two statements are true about the WHERE and HAVING clauses in a SELECT statement?

A. The WHERE clause can be used to exclude rows before dividing them into groups.

B. WHERE and HAVING clauses can be used in the same statement only if applied to different table columns.

C. The WHERE clause can be used to exclude rows after dividing them into groups

D. The HAVING clause can be used with aggregating functions in subqueries.

E. Aggregating functions and columns used in HAVING clauses must be specified in these SELECT list of a query.

정답: A,E

설명: (DumpTOP 회원만 볼 수 있음)

최신 1z1-071 무료덤프 - Oracle Database SQL

우리와 연락하기

유용한 링크

최신 업데이트