1Z1-082試験無料問題集「Oracle Database Administration I 認定」

A. A column that is set to UNUSED still counts towards the limit of 1000 columns per table

B. An UNUSED column's space is reclaimed automatically when the row containing that column is next queried.

C. An UNUSED column's space is reclaimed automatically when the block containing that column is next queried.

D. Partition key columns cannot be dropped.

E. A primary key column referenced by another column as a foreign key can be dropped if using the CASCADE option.

F. A DROP COLUMN command can be rolled back

A. It is supported for SYS-owned tables contained in locally managed tablespaces.

B. It Is the default behavior for tables and indexes.

C. Indexes inherit the deferred or immediate segment creation attribute from their parent table

D. Sessions may dynamically switch back and forth from deferred to immediate segment creation.

E. It Is supported for Index Organized Tables (IOTs) contained in locally managed tablespaces.

A. The first ROLLBACK command restores the 101 rows that were deleted, leaving the inserted row still to be committed

B. The second ROLLBACK command replays the delete

C. The first ROLLBACK command restores the 101 rows that were deleted and commits the inserted row

D. The second ROLLBACK command does nothing

E. The second ROLLBACK command undoes the insert

A. SELECT join_date FROM employees WHERE join_date > '10-02-2018';

B. SELECT join_date I I ' ' II salary FROM employees;

C. SELECT SUBSTR<join_date, 1, 2) - 10 FROM employees;

D. SELECT join_date + '20' FROM employees; SELECT salary * '120.50' FROM employees;

A. It can be used to switch a database into ARCHIVELOGMODE

B. The same port number can be used for multiple Database Express configurations for multiple databases on the same host

C. The same port number can be used for Database Express configurations for databases on different hosts

D. It is available only when the database is open

E. It can be used to perform database recovery

A. V$TABLESPACE displays information about tablespaces contained in the data dictionary

B. Tablespace free space can be viewed in DBA_TABLESPACES

C. V$TABLESPACE displays information that is contained in the controlfile about tablespaces

D. A datafile can be renamed when the database is in MOUNT state and the new file name is displayed when querying DBA_DATA_FILES after the database is opened

E. Tablespace free space can be viewed in V$TABLESPACE

A. Operating System authentication may be used for system-privileged administrative users.

B. REKOTE_LOGIN_PASSMOREFiLE must be set to exclusive to permit password changes for system-privileged administrative users.

C. Password authentication must be used for system-privileged administrative users.

D. Password File authentication is supported for any type of database user.

E. Password File authentication must be used for system-privileged administrative users.

A. Employee 100 will have JOB_ID set to the same value as the JOB_ID of employee 200

B. Employee 200 will have JOB_ID set to the same value as the JOB_ID of employee 100

C. Employees 100 and 200 will have the same JOB_ID as before the update command

D. Employee 100 will have SALARY set to the same value as the SALARY of employee 200

E. Employees 100 and 200 will have the same SALARY as before the update command

F. Employee 200 will have SALARY set to the same value as the SALARY of employee 100

A. SYSDATE and CURRENT_DATE return the current date and time set for the operating system of the database server

B. CURRENT_TIMESTAMP returns the same date and time as SYSDATE with additional details of fractional seconds

C. CURRENT_DATE returns the current date and time as per the session time zone

D. CURRENT_TIMESTAMP returns the same date as CURRENT_DATE

E. SYSDATE can be queried only from the DUAL table

F. SYSDATE can be used in expressions only if the default date format is DD-MON-RR