최신 1Z1-082 무료덤프 - Oracle Database Administration I

문제1

You must create a tablespace of non-standard block size in a new file system and plan to use this command:

The standard block size is 8k but other non-standard block sizes will also be used. Which two are requirements for this command to succeed?

A. db_32r_cache_si2e must be less than db_ca=he_size.

B. db_cache_s:ze must be set to a size that is smaller than db_32k_cache_size.

C. d3_32k_cache_size should be set to a value greater than db_cache_size.

D. The operating system must use a 32k block size.

E. db_32k_cache_size must be set to a value that can be accommodated in the SGA.

F. The /u02 file system must have at least lOOg space for the datafile.

정답: A,B

문제2

You want to apply the principle of Least Privilege in all your live databases.
One of your requirements is to revoke unnecessary privileges from all users who have them using Privilege Analysis.
Which three types of analyses can be done using the DBMS_PRIVILEGE_CAPTURE package? (Choose three.)

A. analysis of all privileges used by all users including administrative users in the database

B. analysis of privileges that a user has on their own schema objects that they did not use

C. analysis of privileges granted directly to a role that are then used by a user who has been granted that role

D. analysis of privileges that a user has on their own schema objects that they did use

E. analysis of all privileges used by all users but excluding administrative users in the database

F. analysis of privileges granted indirectly to a role that are then used by a user who has been granted that role

정답: C,E,F

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

문제3

Which three statements are true about the Oracle join and ANSI join syntax? (Choose three.)

A. The Oracle join syntax performs less well than the SQL:1999 compliant ANSI join syntax

B. The SQL:1999 compliant ANSI join syntax supports creation of a Cartesian product of two tables

C. The SQL:1999 compliant ANSI join syntax supports natural joins

D. The Oracle join syntax supports creation of a Cartesian product of two tables

E. The Oracle join syntax only supports right outer joins

F. The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax

G. The Oracle join syntax supports natural joins

정답: B,C,D

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

문제4

Which two statements are true?

A. SALES1 is created with 55,000 rows.

B. SALES1 is created with no rows.

C. SALES1 is created with 1 row.

D. SALES1 has not NULL constraints on any selected columns which had those constraints in the sales table.

E. SALES1 has primary key and unique constraints on any selected columns which had those constraints in the sales table.

정답: A,D

문제5

Which three statements are true about advanced connection options supported by Oracle Net for connection to Oracle Database instances? (Choose three.)

A. Connect Time Failover requires the use of Transparent Application Failover (TAF)

B. Load Balancing requires the use of a name server

C. Source Routing requires the use of a name server

D. Load Balancing can balance the number of connections to dispatchers when using a Shared Server configuration

E. Connect Time Failover requires the connect string to have two or more listener addresses configured

F. Source Routing enables the use of Connection Manager (CMAN) which enables network traffic to be routed through a firewall

정답: D,E,F

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

문제6

You execute this command:

During the export operation, you detach from the job by using CTRL+C and then execute this command:
Export> STOP_JOB=immediate
Are you sure you wish to stop the job ([yes]/no): yes
Which two statements are true about the job? (Choose two.)

A. It is paused and can be resumed

B. It continues to run in the background

C. You can reattach to it and monitor it

D. It terminates

E. You can no longer monitor it

정답: A,C

문제7

Examine the description of the CUSTOMERS table:

You want to display details of all customers who reside in cities starting with the letter D followed by at least two characters.
Which query can be used?

A. SELECT * FROM customers WHERE city = '%D_';

B. SELECT * FROM customers WHERE city LIKE 'D_';

C. SELECT * FROM customers WHERE city LIKE 'D_%';

D. SELECT * FROM customers WHERE city = 'D_%';

정답: C

문제8

Examine the description of the CUSTOMERS table:

For customers whose income level has a value, you want to display the first name and due amount as 5% of their credit limit. Customers whose due amount is null should not be displayed.
Which query should be used?

A. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level IS NOT NULLAND due_amount IS NOT NULL;

B. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level IS NOT NULLAND cust_credit_limit IS NOT NULL;

C. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level <> NULLAND due_amount <> NULL;

D. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level != NULLAND cust_credit_level !=NULL;

E. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level != NULLAND due_amount != NULL;

정답: B

문제9

You need to calculate the number of days from 1st January 2019 until today.
Dates are stored in the default format of DD-MON-RR.
Which two queries give the required output? (Choose two.)

A. SELECT SYSDATE - TO_DATE('01-JANUARY-2019') FROM DUAL;

B. SELECT ROUND(SYSDATE - '01-JAN-2019') FROM DUAL;

C. SELECT ROUND(SYSDATE - TO_DATE('01/JANUARY/2019')) FROM DUAL;

D. SELECT TO_DATE(SYSDATE, 'DD/MONTH/YYYY') - '01/JANUARY/2019' FROM DUAL;

E. SELECT TO_CHAR(SYSDATE,'DD-MON-YYYY') - '01-JAN-2019' FROM DUAL;

정답: A,C

문제10

Which two statements are true regarding the UNION and UNION ALL operators? (Choose two.)

A. The number of columns selected in each SELECT statement must be identical

B. The output is sorted by the UNION ALL operator

C. The names of columns selected in each SELECT statement must be identical

D. NULLS are not ignored during duplicate checking

E. Duplicates are eliminated automatically by the UNION ALL operator

정답: A,D

최신 1Z1-082 무료덤프 - Oracle Database Administration I

우리와 연락하기

유용한 링크

최신 업데이트