[Q46-Q62] Get 100% Passing Success With True 1Z1-082 Exam! [May-2022]

NO.46 Which two statements are true about space-saving features in an Oracle Database? (Choose two.)

Private Temporary Tables (PTTS) store metadata in memory only

An index created with the UNUSABLE attribute has no segment

If they exist for a session, Private Temporary Tables (PTTs) are always dropped at the next COMMIT OR ROLLBACK statement

An index that is altered to be UNUSABLE will retain its segment

A table that is truncated will always have its segment removed

NO.47 In which three situations does a new transaction always start? (Choose three.)

when issuing a SELECT FOR UPDATE statement after a CREATE TABLE AS SELECT statement was issued in the same session

when issuing a TRUNCATE statement after a SELECT statement was issued in the same session

when issuing a CREATE TABLE statement after a SELECT statement was issued in the same session

when issuing the first Data Manipulation Language (DML) statement after a COMMIT OR ROLLBACK statement was issued in the same session

when issuing a CREATE INDEX statement after a CREATE TABLE statement completed successfully in the same session

when issuing a DML statement after a DML statement failed in the same session

NO.48 Which three statements are true about single-row functions? (Choose three.)

They can be used only in the WHERE clause of a SELECT statement

The argument can be a column name, variable, literal or an expression

The data type returned can be different from the data type of the argument

They can be nested to any level

They can accept only one argument

They return a single result row per table

NO.49 Which three Oracle database space management features will work with both Dictionary and Locally managed tablespaces? (Choose three.)

Oracle Managed Files (OMF)

Online table segment shrink

Online index segment shrink

Automatic data file extension (AUTOEXTEND)

Capacity planning growth reports based on historical data in the Automatic Workload Repository (AWR)

NO.50 Examine the description of the BOOKS table:

The table has 100 rows.
Examine this sequence of statements issued in a new session:
INSERT INTO books VALUES (‘ADV112’, ‘Adventures of Tom Sawyer’, NULL, NULL); SAVEPOINT a; DELETE FROM books; ROLLBACK TO SAVEPOINT a; ROLLBACK; Which two statements are true? (Choose two.)

The second ROLLBACK command does nothing

The second ROLLBACK command replays the delete

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

The second ROLLBACK command undoes the insert

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

NO.51 Which three Oracle database space management features will work with both Dictionary and Locally managed tablespaces? (Choose three.)

Oracle Managed Files (OMF)

Online table segment shrink

Online index segment shrink

Automatic data file extension (AUTOEXTEND)

Capacity planning growth reports based on historical data in the Automatic Workload Repository (AWR)

NO.52 In the ORCL database, UNDOTBS1 is the active undo tablespace with these properties:
1. A size of 100 MB
2. AUTOEXTEND is off
3. UNDO_RETENTION is set to 15 minutes
4. It has RETENTION GUARANTEE
UNDOTBS1 fills with uncommitted undo 10 minutes after the database opens.
What will happen when the next update is attempted by any transaction?

It succeeds and the generated undo is stored in SYSTEM.

It fails and returns the error message “ORA-30036: unable to extend segment by 8 in undo tablespace ‘UNDOTBS1′”.

It succeeds and the least recently written undo block of UNDOTBS1 is overwritten by the generated undo.

It succeeds and the generated undo is stored in SYSAUX.

It succeeds and the least recently read undo block of UNDOTBS1 is overwritten by the generated undo.

NO.53 Which two statements are true about the ORDER BY clause when used with a SQL statement containing a SET operator such as UNION? (Choose two.)

Column positions must be used in the ORDER BY clause

Only column names from the first SELECT statement in the compound query are recognized

The first column in the first SELECT of the compound query with the UNION operator is used by default to sort output in the absence of an ORDER BY clause

Each SELECT statement in the compound query must have its own ORDER BY clause

Each SELECT statement in the compound query can have its own ORDER BY clause

NO.54 Which two statements are true about the results of using the INTERSECT operator in compound queries? (Choose two.)

Column names in each SELECT in the compound query can be different

The number of columns in each SELECT in the compound query can be different

Reversing the order of the intersected tables can sometimes affect the output

INTERSECT returns rows common to both sides of the compound query

INTERSECT ignores NULLs

NO.55 Which two statements are true about Enterprise Manager Database Express? (Choose two.)

It is available only when the database is open

It can be used to perform database recovery

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

It can be used to switch a database into ARCHIVELOGMODE

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

NO.56 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?

Set OS_AUTHENT_PREFIX to OPS$

Have the OS administrator add KING to the OSDBA group

Grant DBA to KING

Unset REMOTE_LOGIN_PASSWORDFILE

Alter user KING to be IDENTIFIED EXTERNALLY

NO.57 What is true about non-equijoin statement performance? (Choose two.)

Table aliases can improve performance

The BETWEEN condition always performs better than using the >= and <= conditions

The join syntax used makes no difference to performance

The BETWEEN condition always performs less well than using the >= and <= conditions

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

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

Configure a nonstandard block size for a new database

Register a new database with an available Enterprise Manager Management server

Change the standard block size of an existing database

Configure incremental backups for a new database

Enable flashback database for an existing database

NO.59 In one of your databases, you create a user, HR, and then execute this command:
GRANT CREATE SESSION TO hr WITH ADMIN OPTION;
Which four actions can HR perform? (Choose four.)

Revoke the CREATE SESSION privilege from other users

Revoke the CREATE SESSION privilege from user HR

Log in to the database instance

Grant the CREATE SESSION privilege with ADMIN OPTION to other users

Execute DDL statements in the HR schema

Execute DML statements in the HR schema

NO.60 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?

SELECT &&col1, &&col2FROM &tableWHERE &&condition = &&cond;

SELECT &col1, &col2FROM &&tableWHERE &condition;

SELECT &col1, &col2FROM “&table”WHERE &condition;

SELECT ‘&&col1’, ‘&&col2’FROM &tableWHERE ‘&&condition’ = ‘&cond’;

SELECT &&col1, &&col2FROM &tableWHERE &&condition;