最新的Oracle Database 19c認證 1Z0-082考試題庫

問題1

Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.)

A. It is held inside an Oracle database schema

B. It supports diagnostics for Oracle Clusterware

C. It supports diagnostics for Automatic Storage Management (ASM)

D. The ADR base defaults to $ORACLE_HOME/dbs if the DIAGNOSTIC_DEST parameter and the ORACLE_BASE environment variable are not set

E. The ADR base defaults to $ORACLE_HOME/rdbms/admin if neither DIAGNOSTIC_DEST nor ORACLE_BASE is set

正確答案: A,E

說明：（僅 VCESoft 成員可見）

問題2

Examine the description of the PROMOTIONS table:

You want to display the unique promotion costs in each promotion category.
Which two queries can be used? (Choose two.)

A. SELECT DISTINCT promo_cost || ' in ` || DISTINCT promo_category FROM promotions ORDER BY 1;

B. SELECT promo_cost, promo_category FROM promotions ORDER BY by 1;

C. SELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1;

D. SELECT promo_category, DISTINCT promo_cost FROM promotions ORDER BY 2;

E. SELECT DISTINCT promo_category || ` has ` || promo_cost AS COSTS FROM promotions ORDER BY 1;

正確答案: C,D

問題3

Which two tasks can you perform using DBCA for databases? (Choose two.)

A. Change the standard block size of an existing database

B. Register a new database with an available Enterprise Manager Management server

C. Configure a nonstandard block size for a new database

D. Configure incremental backups for a new database

E. Enable flashback database for an existing database

正確答案: A,B

說明：（僅 VCESoft 成員可見）

問題4

Which two are true about conventional path SQL load? (Choose two.)

A. It locks objects being processed.

B. It always generates redo.

C. It enforces referential integrity constraints.

D. It does not generate UNDO.

E. It cannot load data into clustered tables.

正確答案: C,D

問題5

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. Log in to the database instance

B. Grant the CREATE SESSION privilege with ADMIN OPTION to other users

C. Revoke the CREATE SESSION privilege from other users

D. Execute DML statements in the HR schema

E. Revoke the CREATE SESSION privilege from user HR

F. Execute DDL statements in the HR schema

正確答案: B,C,F

說明：（僅 VCESoft 成員可見）

問題6

Which two statements are true about interval data types?

A. The value in an interval day to SECOND column can be copied into an interval year to month column.

B. INTERVAL year to month columns only support monthly intervals within a range of years.

C. INTERVAL day to second columns support fractions of seconds.

D. INTERVAL year to month columns only support monthly Intervals within a single year.

E. INTERVAL year TO month columns support yearly intervals.

F. The year field in an interval year to month column must be a positive value.

正確答案: C,E

問題7

Which three statements are true about roles?

A. All roles granted to a user are set on by default when the user logs in,

B. The SET ROLE statement can disable one or more roles for a session.

C. The SET ROLE statement can enable one or more roles for a session.

D. Object privileges may not be granted to roles.

E. Roles must be password protected.

F. Roles may be granted to roles.

正確答案: B,D,F

問題8

Which two statements are true about single row functions? (Choose two.)

A. CEIL : can be used for positive and negative numbers

B. MOD : returns the quotient of a division operation

C. CONCAT : can be used to combine any number of values

D. TRUNC : can be used with NUMBER and DATE values

E. FLOOR : returns the smallest integer greater than or equal to a specified number

正確答案: B,D

說明：（僅 VCESoft 成員可見）

問題9

Which two statements are true about Database Instances and Real Application Clusters (RAC)?

A. A RAC database must have two or more instances.

B. A RAC database must have three or more Instances.

C. A RAC database can have one Instance.

D. A RAC database can have instances on separate servers.

E. Two RAC databases can share their instances.

正確答案: C,D

問題10

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_AMOUNT FROM customers WHERE cust_income_level IS NOT NULL AND due_amount IS NOT NULL;

B. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT FROM customers WHERE cust_income_level <> NULL AND due_amount <> NULL;

C. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT FROM customers WHERE cust_income_level != NULL AND cust_credit_level !=NULL;

D. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT FROM customers WHERE cust_income_level IS NOT NULL AND cust_credit_limit IS NOT NULL;

E. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT FROM customers WHERE cust_income_level != NULL AND due_amount != NULL;

正確答案: D

問題11

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

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

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

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

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

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

F. The Oracle join syntax supports natural joins

G. The Oracle join syntax only supports right outer joins

正確答案: C,D,F

問題12

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 ROUND(SYSDATE ?TO_DATE(`01/JANUARY/2019')) FROM DUAL;

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

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

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

E. SELECT TO_DATE(SYSDATE, `DD/MONTH/YYYY') ?`01/JANUARY/2019' FROM DUAL;

正確答案: C,D

問題13

Your database instance was shut down normally and then started in NOMOUNT state. You then execute this command:
ALTER DATABASE MOUNT;
Which two actions are performed? (Choose two.)

A. The control file is read

B. The Oracle background processes are started

C. The alert log records the execution details

D. The online data files are opened

E. The initialization parameter file is read

F. The online redo logs are opened

正確答案: A,B

問題14

Which three are true about the Oracle Optimizer? (Choose three.)

A. It updates stale object statistics in the Data Dictionary.

B. It will only generate SQL Plan Directives specific to a given SQL statement.

C. It can optimize only SELECT statements.

D. It can re-optimize execution plans after previous executions detect suboptimal plans.

E. It determines the optimal table join order and method.

F. It generates execution plans for SQL statements based on relevant schema objects, system and session parameters, and information found in the Data Dictionary.

正確答案: C,E,F

問題15

Which three statements are true regarding indexes? (Choose three.)

A. An update to a table can result in updates to any or all of the table's indexes

B. When a table is dropped and is moved to the RECYCLE BIN, all indexes built on that table are permanently dropped

C. A table belonging to one user can have an index that belongs to a different user

D. An update to a table can result in no updates to any of the table's indexes

E. A UNIQUE index can be altered to be non-unique

F. A SELECT statement can access one or more indices without accessing any tables

正確答案: A,B,E

最新的Oracle Database Administration I - 1Z0-082免費考試真題

最新更新

站內鏈接

聯系我們