[Q27-Q52] ベスト良質なOracle 1Z0-082試験問題PassTestリアル練習試験 [2024]

ベスト良質なOracle 1Z0-082試験問題PassTestリアル練習試験 [2024]

重要な試験問題でOracle Database Administration I一発合格

質問 # 27
In the SALES database, DEFERRED_SEGMENT_CREATION is TRUE.
Examine this command:
SQL> CREATE TABLE T1(c1 INT PRIMARY KEY, c2 CLOB);
Which segment or segments, if any, are created as a result of executing the command?

A. T1 and an index segment created for the primary key only
B. T1 only
C. T1, an index segment for the primary key, and a LOB segment only
D. no segments are created
E. T1, an index segment for the primary key, a LOB segment, and a lobindex segment

正解：B

解説：
Explanation/Reference:

質問 # 28
You want to write a query that prompts for two column names and the WHERE condition each time it is executed in a session but only prompts for the table name the first time it is executed.
The variables used in your query are never undefined in your session.
Which query can be used?

A. SELECT &&col1, &&col2FROM &tableWHERE &&condition = &&cond;
B. SELECT '&&col1', '&&col2'FROM &tableWHERE '&&condition' = '&cond';
C. SELECT &&col1, &&col2FROM &tableWHERE &&condition;
D. SELECT &col1, &col2FROM "&table"WHERE &condition;
E. SELECT &col1, &col2FROM &&tableWHERE &condition;

正解：E

質問 # 29
Examine this command and some partial output:

Why does the DB01.abc.com service show unknown status?

A. The service DB01.abc.com is statically registered
B. The SID_LIST_LISTENER section is not contained in the LISTENER.ORA file
C. The service DB01.abc.com is dynamically registered
D. The listener is not listening on the default port 1521
E. The LOCAL_LISTENER database parameter is not set to a service name that refers to LISTENER_1

正解：A

質問 # 30
You want to use table compression suitable for OLTP that will:
1. Compress rows for all DML statements on that table
2. Minimize the overheads associated with compression
Which compression option is best suited for this?

A. ROW STORE COMPRESS BASIC
B. COLUMN STORE COMPRESS FOR ARCHIVE LOW
C. COLUMN STORE COMPRESS FOR ARCHIVE HIGH
D. ROW STORE COMPRESS ADVANCED
E. COLUMN STORE COMPRESS FOR QUERY LOW

正解：D

解説：
Explanation/Reference: https://www.oracle.com/technetwork/database/options/compression/advanced-compression-wp-
12c-1896128.pdf

質問 # 31
Which two are true about a SQL statement using SET operators such as UNION? (Choose two.)

A. The data type of each column returned by the second query must exactly match the data type of the corresponding column returned by the first query.
B. The number, but not names, of columns must be identical for all SELECT statements in the query.
C. The data type of each column returned by the second query must be implicitly convertible to the data type of the corresponding column returned by the first query.
D. The data type group of each column returned by the second query must match the data type of the corresponding column returned by the first query.
E. The names and number of columns must be identical for all SELECT statements in the query.

正解：A、C

質問 # 32
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. Sequence ORD_SEQ is guaranteed not to generate duplicate numbers
C. 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
D. Any user inserting rows into table ORD_ITEMS must have been granted access to sequence ORD_SEQ
E. Sequence ORD_SEQ cycles back to 1 after every 5000 numbers and can cycle 20 times

正解：B、D

質問 # 33
Your database instance is started with a PFILE.
Examine these parameters:

You want to increase the size of the buffer cache.
Free memory is available to increase the size of the buffer cache.
You execute the command:
SQL> ALTER SYSTEM SET DB_CACHE_SIZE=1024M;
What is the outcome?

A. Change is applied to the current instance, but does not persist after instance restart
B. The value is changed for the current instance and in the PFILE
C. The value is changed only in the PFILE and takes effect at the next instance startup
D. It fails because the SCOPE clause is missing

正解：A

解説：
https://docs.oracle.com/database/121/SQLRF/statements_2017.htm#SQLRF00902

質問 # 34
Which three statements are true concerning logical and physical database structures? (Choose three.)

A. The extents of a segment must always reside in the same datafile
B. A segment's blocks can be of different sizes
C. A segment can span multiple data files in some tablespaces
D. All tablespaces may have one or more data files
E. A smallfile tablespace might be bigger than a bigfile tablespace
F. A segment might have only one extent
G. Segments can span multiple tablespaces

正解：E、F、G

質問 # 35
Which three statements are true about Deferred Segment Creation in Oracle databases?

A. Sessions may dynamically switch back and forth from deferred to immediate segment creation.
B. It is supported for SYS-owned tables contained in locally managed tablespaces.
C. Indexes inherit the deferred or immediate segment creation attribute from their parent table
D. It Is the default behavior for tables and indexes.
E. It Is supported for Index Organized Tables (IOTs) contained in locally managed tablespaces.

正解：A、C、D

質問 # 36
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_incoms_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

質問 # 37
Which two statements are true about the results of using the INTERSECT operator in compound queries? (Choose two.)

A. INTERSECT ignores NULLs
B. The number of columns in each SELECT in the compound query can be different
C. Column names in each SELECT in the compound query can be different
D. INTERSECT returns rows common to both sides of the compound query
E. Reversing the order of the intersected tables can sometimes affect the output

正解：C、D

解説：
https://www.oracletutorial.com/oracle-basics/oracle-intersect/

質問 # 38
Which two statements are true about Enterprise Manager Database Express? (Choose two.)

A. It is available only when the database is open
B. It can be used to perform database recovery
C. The same port number can be used for multiple Database Express configurations for multiple databases on the same host
D. It can be used to switch a database into ARCHIVELOGMODE
E. The same port number can be used for Database Express configurations for databases on different hosts

正解：C、D

質問 # 39
The INVOICE table has a QTY_SOLD column of data type NUMBER and an INVOICE_DATE column of data type DATE.
NLS_DATE_FORMAT is set to DD-MON-RR.
Which two are true about data type conversions involving these columns in query expressions? (Choose two.)

A. invoice_date = '15-march-2019' : uses implicit conversion
B. qty_sold = '0554982' uses implicit conversion
C. qty_sold BETWEEN '101' AND '110' : uses implicit conversion
D. CONCAT (qty_sold, invoice_date) : requires explicit conversion
E. invoie_date > '01-02-2019' : uses implicit conversion

正解：A、C

質問 # 40
Which statement is true about the INTERSECT operator used in compound queries?

A. It processes NULLs in the selected columns
B. Multiple INTERSECT operators are not possible in the same SQL statement
C. INTERSECT is of lower precedence than UNION or UNION ALL
D. It ignores NULLs

正解：A

質問 # 41
Which two statements are true about Enterprise Manager Database Express? (Choose two.)

A. It is available only when the database is open
B. It can be used to perform database recovery
C. The same port number can be used for multiple Database Express configurations for multiple databases on the same host
D. It can be used to switch a database into ARCHIVELOGMODE
E. The same port number can be used for Database Express configurations for databases on different hosts

正解：C、D

解説：
https://docs.oracle.com/en/database/oracle/oracle-database/19/admqs/getting-started-with- database-administration.html#GUID-EB851101-07BE-4038-BB9D-06E01CC7F5D5

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

A. A RAC database must have three or more Instances.
B. Two RAC databases can share their instances.
C. A RAC database can have one Instance.
D. A RAC database can have instances on separate servers.
E. A RAC database must have two or more instances.

正解：C、D

質問 # 43
Which two statements are true about the rules of precedence for operators? (Choose two.)

A. The concatenation operator | | is always evaluated before addition and subtraction in an expression
B. Arithmetic operators with equal precedence are evaluated from left to right within an expression
C. Multiple parentheses can be used to override the default precedence of operators in an expression
D. The + binary operator has the highest precedence in an expression in a SQL statement
E. NULLS influence the precedence of operators in an expression

正解：B、C

解説：
Reference:
https://docs.oracle.com/cd/A87860_01/doc/server.817/a85397/operator.htm Precedence is the order in which Oracle evaluates different operators in the same expression. When evaluating an expression containing multiple operators, Oracle evaluates operators with higher precedence before evaluating those with lower precedence. Oracle evaluates operators with equal precedence from left to right within an expression.

質問 # 44
Which two tasks can you perform using DBCA for databases? (Choose two.)

A. Configure incremental backups for a new database
B. Configure a nonstandard block size for a new database
C. Enable flashback database for an existing database
D. Register a new database with an available Enterprise Manager Management server
E. Change the standard block size of an existing database

正解：D、E

解説：
Explanation/Reference: https://docs.oracle.com/cd/B16254_01/doc/server.102/b14196/install003.htm

質問 # 45
The orders table has a column ORDER_DATE of data type date.
The default display format for a date Is DD-MON-RR.
Which two where conditions demonstrate the correct usage of conversion functions?

A. WHERE order date > TO DATE('JUL 10 2018', *MON DD YYYY')
B. WHERE order_date > TO_DATE<ADD_MONTHS(SYSDATE, c) , 'MON DD YYYY')
C. WHERE order_date IN (TO_DATE ('Oct 21 2018', 'Mon DD YYYY'), TC_CHAR('Nov 21 2018', 'Mon DD YYYY'))
D. WHERE order_date > TO_CHAR(ADD_MONTHS(SYSDATE, 6), 'MON DD YYYY')
E. WHERE TO_CHAR(order_date, 'MON DD YYYY') = 'JAN 20 2019'

正解：A、E

質問 # 46
Which two statements are true about single row functions? (Choose two.)

A. CEIL : can be used for positive and negative numbers
B. FLOOR : returns the smallest integer greater than or equal to a specified number
C. TRUNC : can be used with NUMBER and DATE values
D. CONCAT : can be used to combine any number of values
E. MOD : returns the quotient of a division operation

正解：C、E

解説：
https://docs.oracle.com/en/database/oracle/oracle-database/18/sqlrf/Single-Row- Functions.html#GUID-B93F789D-B486-49FF-B0CD-0C6181C5D85C

質問 # 47
Which three statements are true about dropping and unused columns in an Oracle database? (Choose three.)

A. An UNUSED column's space is reclaimed automatically when the row containing that column is next queried.
B. A column that is set to UNUSED still counts towards the limit of 1000 columns per table
C. An UNUSED column's space is reclaimed automatically when the block containing that column is next queried.
D. A primary key column referenced by another column as a foreign key can be dropped if using the CASCADE option.
E. Partition key columns cannot be dropped.
F. A DROP COLUMN command can be rolled back

正解：B、C、D

質問 # 48
You execute this command:

Sufficient storage is available in filesystem /u01.
Which two statements are true about the BIG_TBStablespace? (Choose two.)

A. AUTOEXTEND is possible for the datafile
B. It will always have a 32K blocksize
C. It will be a dictionary-managed tablespace by default
D. Additional data files may not be added
E. It must be bigger than the largest SMALLFILE tablespace

正解：A、E

質問 # 49
Which two statements are true about the Oracle Data Dictionary?

A. It is owned by the system user.
B. Data dictionary views are always created with queries that join two or more base tables.
C. Data dictionary base tables can be queried directly.
D. It is owned by the sys user.
E. All data dictionary view joins base tables to dynamic performance views.

正解：C、D

質問 # 50
The customers table has a cust_last_name column of data type varchar2.
The table has two rows whose "jst_last_name values are Andersen and Ausson.
Which query produces output for cust_last_xame containing Oder for the first row and Aus for the second?

A. SELECT REPLACE<TRIM<TRAILING 'son* FROM cust_last_name), 'An', *O'> FROM customers;
B. SELECT REPLACE(REPLACE(cust_last_name, 'son', ''), 'An', 'O'> FROM customers;
C. SELECT INITCAP (REPLACE(TRIM('son' FROM cust_last_name), 'An', 'O*)) FROM customers;
D. SELECT REPLACE(SUBSTR(cust_last_name, -3), 'An', 'O') FROM customers;

正解：A

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

A. The Oracle join syntax supports natural joins
B. The Oracle join syntax only supports right outer joins
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 performs less well than the SQL:1999 compliant ANSI join syntax
F. The SQL:1999 compliant ANSI join syntax supports creation of a Cartesian product of two tables
G. The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax

正解：A、C、F

質問 # 52
......

Oracle 1Z1-082試験は、Oracleデータベース管理の概念と原則に関する知識を試験するものです。この試験は、データベース管理の特定の領域をカバーする複数のセクションに分かれています。これらのセクションには、データベースアーキテクチャ、インスタンス管理、ストレージ管理、ユーザー管理、およびバックアップとリカバリが含まれます。各セクションでは、対象となる分野についての深い理解が求められ、試験の問題はこれらの概念の知識と応用を試すために設計されています。

1Z0-082試験問題集合格保証：https://www.passtest.jp/Oracle/1Z0-082-shiken.html

ベスト良質なOracle 1Z0-082試験問題：https://drive.google.com/open?id=1sxloLB6hd1F4qFM60TNIDRVxVuTqzhls

関するブログ

もっと

1Z0-082 無料問題集