1z0-082 Exam - Oracle Database Administration I

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

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

Answer: AE

NEW QUESTION 2
Which three statements are true about Oracle synonyms? (Choose three.)

• A. A synonym cannot be created for a PL/SQL package
• B. A synonym can be available to all users
• C. A SEQUENCE can have a synonym
• D. A synonym created by one user can refer to an object belonging to another user
• E. Any user can drop a PUBLIC synonym

Answer: BCD

NEW QUESTION 3
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. NULLS influence the precedence of operators in an expression
• C. The + binary operator has the highest precedence in an expression in a SQL statement
• D. Arithmetic operators with equal precedence are evaluated from left to right within an expression
• E. Multiple parentheses can be used to override the default precedence of operators in an expression

Answer: CE

NEW QUESTION 4
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.)

• A. Column positions must be used in the ORDER BY clause
• B. Only column names from the first SELECT statement in the compound query are recognized
• C. 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
• D. Each SELECT statement in the compound query must have its own ORDER BY clause
• E. Each SELECT statement in the compound query can have its own ORDER BY clause

Answer: BE

NEW QUESTION 5
Examine this command and some partial output:

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

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

Answer: B

NEW QUESTION 6
Which two statements are true about the WHERE and HAVING clauses in a SELECT statement? (Choose two.)

• A. Aggregating functions and columns used in HAVING clauses must be specified in the SELECT list of a query
• B. WHERE and HAVING clauses can be used in the same statement only if applied to different table columns
• C. The HAVING clause can be used with aggregating functions in subqueries
• D. The WHERE clause can be used to exclude rows before dividing them into groups
• E. The WHERE clause can be used to exclude rows after dividing them into groups

Answer: CD

NEW QUESTION 7
What is true about non-equijoin statement performance? (Choose two.)

• A. Table aliases can improve performance
• B. The BETWEEN condition always performs better than using the >= and <= conditions
• C. The join syntax used makes no difference to performance
• D. The BETWEEN condition always performs less well than using the >= and <= conditions
• E. The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax

Answer: AE

NEW QUESTION 8
Which four account management capabilities can be configured using Oracle profiles? (Choose four.)

• A. the number of hours for which an account is locked after the configured number of login attempts has been reached
• B. the number of days for which an account may be inactive before it is locked
• C. the maximum amount of CPU time allowed for a user’s sessions before their account is locked
• D. the ability to prevent a password from ever being reused
• E. the number of password changes required within a period of time before a password can be reused
• F. the number of days for which an account is locked after the configured number of login attempts has been reached
• G. the maximum number of sessions permitted for a user before the account is locked

Answer: DEFG

NEW QUESTION 9
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.)

• A. The second ROLLBACK command does nothing
• B. The second ROLLBACK command replays the delete
• C. The first ROLLBACK command restores the 101 rows that were deleted, leaving the inserted row still to be committed
• D. The second ROLLBACK command undoes the insert
• E. The first ROLLBACK command restores the 101 rows that were deleted and commits the inserted row

Answer: DE

NEW QUESTION 10
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. The value is changed for the current instance and in the PFILE
• C. It fails because the SCOPE clause is missing
• D. Change is applied to the current instance, but does not persist after instance restart

Answer: D

NEW QUESTION 11
You want to apply the principle of Least Privilege in all your live databases.
One of your requirements is to revoke unnecessary privileges from all users who have them using Privilege Analysis.
Which three types of analyses can be done using the DBMS_PRIVILEGE_CAPTURE package? (Choose three.)

• A. analysis of all privileges used by all users including administrative users in the database
• B. analysis of all privileges used by all users but excluding administrative users in the database
• C. analysis of privileges that a user has on their own schema objects that they did not use
• D. analysis of privileges that a user has on their own schema objects that they did use
• E. analysis of privileges granted directly to a role that are then used by a user who has been granted that role
• F. analysis of privileges granted indirectly to a role that are then used by a user who has been granted that role

Answer: ACF

NEW QUESTION 12
Which three statements are true concerning logical and physical database structures? (Choose three.)

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

Answer: CFG

NEW QUESTION 13
You execute this command:

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

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

Answer: AB

NEW QUESTION 14
Which two statements are true about trace files produced by the Oracle Database server? (Choose two.)

• A. They can be written by server processes
• B. Trace files are written to the Fast Recovery Area (FRA)
• C. They can be written by background processes
• D. All trace files contain error information that require contacting Oracle Support
• E. Trace file names are based on the database name concatenated with a sequential number

Answer: AC

NEW QUESTION 15
You execute this command:
CREATE SMALLFILE TABLESPACE sales
DATAFILE ‘/u01/app/oracle/sales01.dbf SIZE 5G
SEGMENT SPACE MANAGEMENT AUTO;
Which two actions must you take to ensure UNDOTBS01 is used as the default UNDO tablespace? (Choose two.)

• A. It must be smaller than the smallest BIGFILE tablespace
• B. Free space is managed using freelists
• C. Any data files added to the tablespace must have a size of 5 gigabytes
• D. It uses the database default blocksize
• E. It is a locally managed tablespace

Answer: DE

NEW QUESTION 16
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 a quota on the SALES_Q1 tablespace to hold the initial extends of all tables they plan to create in their schema
• C. The sales user must have been granted the CREATE SESSION privilege
• D. The sales user must have their quota on the users tablespace removed
• E. 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
• F. The sales user must have been granted the CREATE TABLE privilege

Answer: BDF

NEW QUESTION 17
Which two statements are true regarding Oracle database space management within blocks managed by Automatic Segment Space Management (ASSM)? (Choose two.)

• A. PCTFREE defaults to 10% for all blocks in all segments for all compression methods
• B. ASSM assigns blocks to one of four fullness categories based on what percentage of the block is allocated for rows
• C. Update operations always attempt to find blocks with free space appropriate to the length of the row being updated
• D. Insert operations always attempt to find blocks with free space appropriate to the length of the row being inserted
• E. A block will always be eligible for inserts if the row is short enough to fit into the block

Answer: CE

NEW QUESTION 18
Which three statements are true about a self-join? (Choose three.)

• A. The ON clause must be used
• B. The query must use two different aliases for the table
• C. It must be an equi join
• D. It must be an inner join
• E. The ON clause can be used
• F. It can be an outer join

Answer: BDE

NEW QUESTION 19
Which two tasks can you perform using DBCA for databases? (Choose two.)

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

Answer: BC

NEW QUESTION 20
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 Database Express configurations for databases on different hosts
• D. It can be used to switch a database into ARCHIVELOGMODE
• E. The same port number can be used for multiple Database Express configurations for multiple databases on the same host

Answer: DE

NEW QUESTION 21
In your data center, Oracle Managed Files (OMF) is used for all databases. All tablespaces are smallfile tablespaces.
SALES_Q1 is a permanent user-defined tablespace in the SALES database.
Examine this command which is about to be issued by a DBA logged in to the SALES database: ALTER TABLESPACE sales_q1 ADD DATAFILE;
Which are two actions, either one of which you could take to ensure that the command executes successfully? (Choose two.)

• A. Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify with at least50 Mb of available space.
• B. Specify a path in the DATAFILE clause of the command specifying a location with at least 100M of available space.
• C. Ensure that DB_CREATE_FILE_DEST specifies a location with at least 100 Mb of available space.
• D. Add the AUTOEXTEND ON clause with NEXT set to 100M.
• E. Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify locations with at least 50 Mb of available space.

Answer: BD

NEW QUESTION 22
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_AUTHEN_PREFIX to OPS$
• B. Have the OS administrator add KING to the OSDBA group
• C. Grant DBA to KING
• D. Unset REMOTE_LOGIN_PASSWORDFILE
• E. Alter user KING to be IDENTIFIED EXTERNALLY

Answer: D

NEW QUESTION 23
Which three statements are true about inner and outer joins? (Choose three.)

• A. A full outer join returns matched and unmatched rows
• B. An inner join returns matched rows
• C. Outer joins can only be used between two tables per query
• D. A full outer join must use Oracle syntax
• E. Outer joins can be used when there are multiple join conditions on two tables
• F. A left or right outer join returns only unmatched rows

Answer: ABF

NEW QUESTION 24
......