Category Archives: Oracle Database Administration I 1Z0-082

Oracle Database Administration I 1Z0-082 Question and Answers

Your database instance was shut down normally and then started in NOMOUNT state. You then execute this

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 online redo logs are opened B. The online data files are opened C. The alert log records the execution details D. The Oracle background processes are started E. The initialization… Read More »

Your database instance is started with a PFILE. Examine these parameters: (Exhibit) You want to increase

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. The value is changed only in the PFILE and takes effect at the next instance startup B.… Read More »

The SALES_Q1 and USERS tablespaces exist in one of your databases and TEMP is a temporary tablespace.

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 been granted the CREATE SESSION privilege B. The sales user must have… Read More »

Which two statements are true about date/time functions in a session where NLS_DATE_FORMAT is set to

Which two statements are true about date/time functions in a session where NLS_DATE_FORMAT is set to DD-MON-YYYY HH24:MI:SS? (Choose two.) A. CURRENT_TIMESTAMP returns the same date and time as SYSDATE with additional details of fractional seconds B. SYSDATE can be queried only from the DUAL table C. CURRENT_DATE returns the current date and time as per the session… Read More »

In one of your databases, you create a user, HR, and then execute this command: GRANT CREATE SESSION

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. Log in to the database instance D. Grant the CREATE… Read More »

Examine the description of the SALES1 table: (Exhibit) SALES2 is a table with the same description as

Examine the description of the SALES1 table:SALES2 is a table with the same description as SALES1.Some sales data is duplicated in both tables.You want to display the rows from the SALES1 table which are not present in the SALES2 table.Which set operator generates the required output? A. UNION ALL B. MINUS C. INTERSECT D. UNION E. SUBTRACT Correct… Read More »

Which three statements are true about time zones, date data types, and timestamp data types in an Oracle

Which three statements are true about time zones, date data types, and timestamp data types in an Oracle database? (Choose three.) A. The DBTIMEZONE function can return an offset from Universal Coordinated Time (UTC) B. The SESSIONTIMEZONE function can return an offset from Universal Coordinated Time (UTC) C. A TIMESTAMP data type column contains information about year, month,… Read More »

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

Which two are true about a SQL statement using SET operators such as UNION? (Choose two.) A. The number, but not names, of columns must be identical for all SELECT statements in the query. B. The data type of each column returned by the second query must exactly match the data type of the corresponding column returned by… Read More »

Which three statements are true about external tables in Oracle 18c and later releases? (Choose three.)

Which three statements are true about external tables in Oracle 18c and later releases? (Choose three.) A. They cannot be partitioned B. The ORACLE_DATAPUMP access driver can be used to unload data from a database into an external table C. The ORACLE_DATAPUMP access driver can be used to load data into a database from an external table D.… Read More »