合格させるOracle 1Z0-082試験最速合格 [Q17-Q35]

合格させるOracle 1Z0-082試験最速合格

準備1Z0-082問題解答で1Z0-082試験問題集

質問 # 17
In one of your databases, you create a user, HR, and then execute this command:
GRANT CREATE SESSION TO hr WITH ADMIN OPTION;
Which three actions can HR perform? (Choose three.)

• A. Revoke the CREATE SESSION privilege from other users
• B. Revoke the CREATE SESSION privilege from user HR
• C. Execute DDL statements in the HR schema
• D. Execute DML statements in the HR schema
• E. Log in to the database instance
• F. Grant the CREATE SESSION privilege with ADMIN OPTION to other users

正解：A、E、F

質問 # 18
Which four statements are true regarding primary and foreign key constraints and the effect they can have on table data? (Choose four.)

• A. It is possible for child rows that have a foreign key to remain in the child table at the time the parent row is deleted
• B. It is possible for child rows that have a foreign key to be deleted automatically from the child table at the time the parent row is deleted
• C. A table can have only one primary key and one foreign key
• D. A table can have only one primary key but multiple foreign keys
• E. Only the primary key can be defined at the column and table level
• F. The foreign key columns and parent table primary key columns must have the same names
• G. Primary key and foreign key constraints can be defined at both the column and table level

正解：B、D、F、G

質問 # 19
In one of your databases, you create a user, HR, and then execute this command:
GRANT CREATE SESSION TO hr WITH ADMIN OPTION;
Which four actions can HR perform? (Choose four.)

• A. Revoke the CREATE SESSION privilege from other users
• B. Execute DDL statements in the HR schema
• C. Execute DML statements in the HR schema
• D. Log in to the database instance
• E. Grant the CREATE SESSION privilege with ADMIN OPTION to other users
• F. Revoke the CREATE SESSION privilege from user HR

正解：A、D、E、F

解説：
Explanation

質問 # 20
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 TO_CHAR(SYSDATE, 'DD-MON-YYYY') - '01-JAN-2019' FROM DUAL;
• C. SELECT ROUND(SYSDATE - '01-JAN-2019') FROM DUAL;
• D. SELECT TO_DATE(SYSDATE, 'DD/MONTH/YYYY') - '01/JANUARY/2019' FROM DUAL;
• E. SELECT ROUND(SYSDATE - TO_DATE('01/JANUARY/2019')) FROM DUAL;

正解：B、C

質問 # 21
Which two statements are true about the configuration and use of UNDO_RETENTION with GURANTEED RETENTION? (Choose two.)

• A. UNDO_RETENTION specifies how long all types of UNDO are retained.
• B. Active UNDO is always retained.
• C. UNDO_RETENTION specifies for how long Oracle attempts to keep expired and unexpired UNDO.
• D. UNDO_RETENTION specifies for how long Oracle attempts to keep unexpired UNDO.
• E. Unexpired UNDO is always retained.

正解：C、E

質問 # 22
Which two statements are true about the PMON background process? (Choose two.)

• A. It registers database services with all local and remote listeners known to the database instance
• B. It kills sessions that exceed idle time
• C. It records checkpoint information in the control file
• D. It frees resources held by abnormally terminated processes
• E. It frees unused temporary segments

正解：A、D

質問 # 23
Which three are types of segments in an Oracle Database? (Choose three.)

• A. clusters
• B. undo
• C. stored procedures
• D. tables
• E. sequences
• F. index

正解：A、D、F

解説：
Reference:
http://www.adp-gmbh.ch/ora/concepts/segments.html

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

• A. The SQL:1999 compliant ANSI join syntax supports creation of a Cartesian product of two tables
• B. The Oracle join syntax only supports right outer joins
• C. The Oracle join syntax performs less well than the SQL:1999 compliant ANSI join syntax
• D. The Oracle join syntax supports natural joins
• E. The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax
• F. The Oracle join syntax supports creation of a Cartesian product of two tables
• G. The SQL:1999 compliant ANSI join syntax supports natural joins

正解：A、D、G

質問 # 25
A database is configured to use automatic undo management with temporary undo enabled.
An UPDATE is executed on a temporary table.
Where is the UNDO stored?

• A. in the undo tablespace
• B. in the temporary tablespace
• C. in the SGA
• D. in the PGA
• E. in the SYSAUX tablespace

正解：A

質問 # 26
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 TO_DATE(SYSDATE, `DD/MONTH/YYYY') ?`01/JANUARY/2019' FROM DUAL;
• B. SELECT TO_CHAR(SYSDATE, `DD-MON-YYYY') ?'01-JAN-2019' FROM DUAL;
• C. SELECT SYSDATE ?TO_DATE('01-JANUARY-2019') FROM DUAL;
• D. SELECT ROUND(SYSDATE ?'01-JAN-2019') FROM DUAL;
• E. SELECT ROUND(SYSDATE ?TO_DATE(`01/JANUARY/2019')) FROM DUAL;

正解：B、D

質問 # 27
Evaluate these commands which execute successfully:

Which two statements are true about the ORD_ITEMS table and the ORD_SEQ sequence?
(Choose two.)

• A. If sequence ORD_SEQ is dropped then the default value for column ORD_NO will be NULL for rows inserted into ORD_ITEMS
• B. Any user inserting rows into table ORD_ITEMS must have been granted access to sequence ORD_SEQ
• C. Sequence ORD_SEQ cycles back to 1 after every 5000 numbers and can cycle 20 times
• D. 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
• E. Sequence ORD_SEQ is guaranteed not to generate duplicate numbers

正解：B、E

質問 # 28
In the ORCL database, UNDOTBS1 is the active undo tablespace with these properties:
1. A size of 100 MB
2. AUTOEXTEND is off
3. UNDO_RETENTION is set to 15 minutes
4. It has RETENTION GUARANTEE
UNDOTBS1 fills with uncommitted undo 10 minutes after the database opens.
What will happen when the next update is attempted by any transaction?

• A. It succeeds and the generated undo is stored in SYSTEM.
• B. It succeeds and the least recently written undo block of UNDOTBS1 is overwritten by the generated undo.
• C. It fails and returns the error message "ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS1'".
• D. It succeeds and the generated undo is stored in SYSAUX.
• E. It succeeds and the least recently read undo block of UNDOTBS1 is overwritten by the generated undo.

正解：C

解説：
To guarantee the success of long-running queries or Oracle Flashback operations, you can enable retention guarantee. If retention guarantee is enabled, the specified minimum undo retention is guaranteed; the database never overwrites unexpired undo data even if it means that transactions fail due to lack of space in the undo tablespace. If retention guarantee is not enabled, the database can overwrite unexpired undo when space is low, thus lowering the undo retention for the system. This option is disabled by default.

質問 # 29
Which four statements are true regarding primary and foreign key constraints and the effect they can have on table data? (Choose four.)

• A. It is possible for child rows that have a foreign key to remain in the child table at the time the parent row is deleted
• B. It is possible for child rows that have a foreign key to be deleted automatically from the child table at the time the parent row is deleted
• C. A table can have only one primary key but multiple foreign keys
• D. A table can have only one primary key and foreign key
• E. Only the primary key can be defined at the column and table level
• F. The foreign key columns and parent table primary key columns must have the same names
• G. Primary key and foreign key constraints can be defined at both the column and table level

正解：B、C、F、G

質問 # 30
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 = `%D_';
• D. SELECT * FROM customers WHERE city LIKE `D_';

正解：B

質問 # 31
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 terminates
• B. It continues to run in the background
• C. You can reattach to it and monitor it
• D. You can no longer monitor it
• E. It is paused and can be resumed

正解：C、E

質問 # 32
Which two statements are true about the SET VERIFY ON command? (Choose two.)

• A. It can be used in SQL Developer and SQL*Plus
• B. It displays values for variables created by the DEFINE command
• C. It displays values for variables used only in the WHERE clause of a query
• D. It can be used only in SQL*Plus
• E. It displays values for variables prefixed with &&

正解：B、D

質問 # 33
Examine this command:

Which two statements are true? (Choose two.)

• A. If Oracle Managed Files (OMF) is used, then the file is renamed but moved to DB_CREATE_FILE_DEST.
• B. The tablespace containing SALES1.DBF must be altered OFFLINE before executing the command.
• C. DML may be performed on tables with one or more extents in this data file during the execution of this command.
• D. The tablespace containing SALES1.DBF must be altered READ ONLY before executing the command.
• E. The file is renamed and stored in the same location

正解：C、D

質問 # 34
You have been tasked to create a table for a banking application.
One of the columns must meet three requirements:
* Be stored in a format supporting date arithmetic without using conversion functions
* Store a loan period of up to 10 years
* Be used for calculating interest for the number of days the loan remains unpaid Which data type should you use?

• A. TIMESTAMP WITH TIMEZONE
• B. TIMESTAMP WITH LOCAL TIMEZONE
• C. INTERVAL YEAR TO MONTH
• D. INTERVAL DAY TO SECOND
• E. TIMESTAMP

正解：D

質問 # 35
......

リアルOracle 1Z0-082試験問題 [更新されたのは2023年]：https://jp.fast2test.com/1Z0-082-premium-file.html

無料1Z0-082試験問題集には合格させるお手軽に試験合格：https://drive.google.com/open?id=11JRx9tdO336I95MjMDdfxEOcsmK7Aphy