Oracle 1Z1-082

Oracle 1Z1-082 認定試験の出題範囲：

参照：https://education.oracle.com/oracle-database-administration-i/pexam_1Z0-082

Oracle Database Administration I 認定 1Z1-082 試験問題：

問題 #1
Examine the description of the product_details table:

Which two statements are true?

A. PRODUCT _price can be used in an arithmetic expression even if it has no value stored in it.
B. PRODUCT_NAKE cannot contain duplicate values.
C. EXPIRY_ DATE cannot be used in arithmetic expressions.
D. PRODUCT _ic can be assigned the PRIMARY KEY constraint.
E. EXPIRY_ DATE contains the sysdate by default if no date is assigned to it.
F. PRODUCT _price contains the value zero by default if no value is assigned to it.

問題 #2
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 alert log records the execution details
B. The control file is read
C. The Oracle background processes are started
D. The online redo logs are opened
E. The online data files are opened
F. The initialization parameter file is read

問題 #3
In one of your databases, user KING is:
1. Not a DBA user
2. An operating system (OS) user
Examine this command and its output:

What must you do so that KING is authenticated by the OS when connecting to the database instance?

A. Set OS_AUTHENT_PREFIX to OPS$
B. Grant DBA to KING
C. Have the OS administrator add KING to the OSDBA group
D. Unset REMOTE_LOGIN_PASSWORDFILE
E. Alter user KING to be IDENTIFIED EXTERNALLY

問題 #4
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, &col2
FROM &&table
WHERE &condition;
B. SELECT &&col1, &&col2
FROM &table
WHERE &&condition = &&cond;
C. SELECT &col1, &col2
FROM "&table"
WHERE &condition;
D. SELECT &&col1, &&col2
FROM &table
WHERE &&condition;
E. SELECT `&&col1', `&&col2'
FROM &table
WHERE `&&condition' = `&cond';

問題 #5
The SALES_Q1 and USERS tablespaces exist in one of your databases and TEMP is a temporary tablespace.
Segment creation is not deferred.
You execute this command:

Which three statements must be true so that the SALES user can create tables in SALES_Q1?
(Choose three.)

A. The sales user must have a quota on the TEMP tablespace
B. The sales user must have their quota on the users tablespace removed
C. The sales user must have a quota on the SALES_Q1 tablespace to hold all the rows to be inserted into any table in their schema
D. The sales user must have been granted the CREATE TABLE privilege
E. The sales user must have been granted the CREATE SESSION privilege
F. The sales user must have a quota on the SALES_Q1 tablespace to hold the initial extends of all tables they plan to create in their schema

解説：