최신 1z1-061 무료덤프 - Oracle Database 12c: SQL Fundamentals

문제1

Which are /SQL*Plus commands? (Choose all that apply.)

A. UPDATE

B. RENAME

C. INSERT

D. DELETE

E. SELECT

F. DESCRIBE

정답: F

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

문제2

Examine the structure proposed for the transactions table:

Which two statements are true regarding the creation and storage of data in the above table structure?

A. The TRANS_VALIDITY column would have a maximum size of one character.

B. The CUST_CREDIT_LIMIT column would not be able to store decimal values.

C. The CUST_STATUS column would give an error.

D. The CUST_STATUS column would store exactly one character.

E. The TRANS_DATE column would be able to store day, month, century, year, hour, minutes, seconds, and fractions of seconds

F. The TRANS_VALIDITY column would give an error.

정답: D,F

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

문제3

Examine the data in the ORD_ITEMS table:

Evaluate the following query:

Which statement is true regarding the outcome of the above query?

A. It gives an error because the having clause should be specified after the group by clause.

B. It displays the item nos with their average quantity where the average quantity is more than double the minimum quantity of that item in the table.

C. It gives an error because all the aggregate functions used in the having clause must be specified in the select list.

D. It displays the item nos with their average quantity where the average quantity is more than double the overall minimum quantity of all the items in the table.

정답: B

문제4

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_CREDIT_VALUE column would allow storage of positive and negative integers.

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

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

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

정답: A,C

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

문제5

You issue the following command to alter the country column in the departments table:

Which statement is true?

A. It produces an error because the data type for the column is not specified.

B. It executes successfully and all the rows that have a null value for the country column will be updated with the value 'USA'.

C. It produces an error because column definitions cannot be altered to add default values.

D. It executes successfully. The modification to add the default value takes effect only from subsequent insertions to the table.

정답: D

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

문제6

You are the DBA for an academic database. You need to create a role that allows a group of users to modify existing rows in the STUDENT_GRADES table.
Which set of statements accomplishes this?

A. CREATE ROLE registrar; GRANT MODIFY ON student_grades TO registrar; GRANT registrar to user1, user2, user3

B. CREATE NEW ROLE registrar; GRANT ALL ON student_grades TO registrar; GRANT registrar to user1, user2, user3

C. CREATE registrar; GRANT CHANGE ON student_grades TO registrar; GRANT registrar;

D. CREATE ROLE registrar; GRANT UPDATE ON student_grades TO registrar; GRANT registrar to user1, user2, user3;

E. CREATE ROLE registrar; GRANT UPDATE ON student_grades TO registrar; GRANT ROLE registrar to user1, user2, user3

정답: D

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

문제7

Which statement is true regarding the COALESCE function?

A. It returns the highest NOT NULL value in the list for all rows.

B. It can have a maximum of five expressions in a list.

C. It requires that all expressions in the list must be of the same data type.

D. It requires that at least one of the expressions in the list must have a NOT NULL value.

정답: C

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

문제8

Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables:

Which DELETE statement is valid?

A. DELETE FROM employeesWHERE employee_id = (SELECT employee_id FROM
employees);

B. DELETE * FROM employeesWHERE employee_id=(SELECT employee_id FROM
new_employees);

C. DELETE * FROM employeesWHERE employee_id IN (SELECT employee_id . FROM new_employees . WHERE name = 'Carrey');

D. DELETE FROM employeesWHERE employee_id IN (SELECT employee_id . FROM new_employees . WHERE name = 'Carrey');

정답: D

문제9

Examine the structure of the EMPLOYEES table:
EMPLOYEE_ID NUMBER NOT NULL, Primary Key
EMP_NAME VARCHAR2(30)
JOB_ID NUMBER\
SAL NUMBER
MGR_ID NUMBER . References EMPLOYEE_ID column
DEPARTMENT_ID NUMBER . Foreign key to DEPARTMENT_ID column of the. .
DEPARTMENTS table
You created a sequence called EMP_ID_SEQ in order to populate sequential values for the EMPLOYEE_ID column of the EMPLOYEES table.
Which two statements regarding the EMP_ID_SEQ sequence are true? (Choose two.)

A. The EMP_ID_SEQ sequence is dropped automatically when you drop the
EMPLOYEE_ID column.

B. You cannot use the EMP_ID_SEQ sequence to populate the JOB_ID column.

C. The EMP_ID_SEQ sequence is invalidated when you modify the EMPLOYEE_ID column.

D. The EMP_ID_SEQ sequence is not affected by modifications to the EMPLOYEES table.

E. The EMP_ID_SEQ sequence is dropped automatically when you drop the EMPLOYEES table.

F. Any other column of NUMBER data type in your schema can use the EMP_ID_SEQ sequence.

정답: D,F

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

문제10

Which object privileges can be granted on a view?

A. none

B. DELETE, INSERT, SELECT, UPDATE

C. ALTER, DELETE, INSERT, SELECT

D. DELETE, INSERT, SELECT

정답: B

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

문제11

What are distinguishing characteristics of a public synonym rather than a private synonym?
(Choose two.)

A. Public synonyms can have the same names as tables or views.

B. Public synonyms can be selected from without needing any permissions.

C. Public synonyms can be accessed by name without a schema name qualifier.

D. Public synonyms are always visible to all users.

정답: A,C

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

문제12

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

Using the customers table, you need to generate a report that shows an increase in the credit limit by 15% for all customers. Customers whose credit limit has not been entered should have the message "Not Available" displayed.
Which SQL statement would produce the required result?

A. Option D

B. Option C

C. Option B

D. Option A

정답: A

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

문제13

SLS is a private synonym for the SH.SALES table.
The user SH issues the following command:
DROP SYNONYM sls;
Which statement is true regarding the above SQL statement?

A. The synonym would be dropped and the packages referring to the synonym would be dropped.

B. The synonym would be dropped and any PUBLIC synonym with the same name becomes invalid.

C. Only the synonym would be dropped.

D. The synonym would be dropped and the corresponding table would become invalid.

정답: C

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

문제14

You work as a database administrator at ABC.com. You study the exhibit carefully and examine the structure of CUSTOMRS AND SALES tables.

Evaluate the following SQL statement:
Exhibit:

Which statement is true regarding the execution of the above UPDATE statement?

A. It would not execute because two tables cannot be used in a single UPDATE statement

B. It would not execute because the SELECT statement cannot be used in place of the table name

C. It would not execute because a sub query cannot be used in the WHERE clause of an UPDATE statement

D. It would execute and restrict modifications to only the column specified in the SELECT statement

정답: D

문제15

View the Exhibit and examine the data in the employees table:

You want to display all the employee names and their corresponding manager names.
Evaluate the following query:

Which join option can be used in the blank in the above query to get the required output?

A. RIGHT OUTER JOIN

B. FULL OUTER JOIN

C. LEFT OUTER JOIN

D. INNER JOIN

정답: C

문제16

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

Examine the following two SQL statements:

Which statement is true regarding the above two SQL statements?

A. statement 2 gives an error, statement 1 executes successfully

B. statement 1 and statement 2 execute successfully and give a different output

C. statement 1 and statement 2 execute successfully and give the same output

D. statement 1 gives an error, statement 2 executes successfully

정답: B

문제17

Examine the structure of the customers table:

CUSTNO is the primary key in the table. You want to find out if any customers' details have been entered more than once using different CUSTNO, by listing all the duplicate names.
Which two methods can you use to get the required result?

A. Self-join

B. Subquery

C. Left outer-join with self-join

D. Right outer-join with self-join

E. Full outer-join with self-join

정답: A,B

문제18

You created an ORDERS table with the following description:
Exhibit:

You inserted some rows in the table. After some time, you want to alter the table by creating the PRIMARY KEY constraint on the ORD_ID column.
Which statement is true in this scenario?

A. You can add the primary key constraint even if data exists, provided that there are no duplicate values

B. You cannot have two constraints on one column

C. You cannot add a primary key constraint if data exists in the column

D. The primary key constraint can be created only a the time of table creation

정답: A

문제19

Which statement is true regarding the default behavior of the order by clause?

A. Only those columns that are specified in the select list can be used in the order by clause.

B. Numeric values are displayed from the maximum to the minimum value if they have decimal positions.

C. NULL values are not considered at all by the sort operation.

D. In a character sort, the values are case-sensitive.

정답: D

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

문제20

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

Using the PROMOTIONS table, you need to find out the average cost for all promos in the range $0-2000 and $2000-5000 in category A.
You issue the following SQL statements:

What would be the outcome?

A. It generates an error because multiple conditions cannot be specified for the WHEN clause

B. It generates an error because NULL cannot be specified as a return value

C. It executes successfully and gives the required result

D. It generates an error because CASE cannot be used with group functions

정답: C

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

최신 1z1-061 무료덤프 - Oracle Database 12c: SQL Fundamentals

우리와 연락하기

유용한 링크

최신 업데이트