Latest Oracle 1Z1-082 Actual Free Exam Questions & Community Discussion, Page 1

Question #1

Which two statements are true about single row functions? (Choose two.)

A. FLOOR : returns the smallest integer greater than or equal to a specified number

B. CEIL : can be used for positive and negative numbers

C. MOD : returns the quotient of a division operation

D. CONCAT : can be used to combine any number of values

E. TRUNC : can be used with NUMBER and DATE values

Discussion 0

Correct Answer: C,E Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #2

Which two are true about the roles? (Choose two.)

A. The SET ROLE statement enables as well as disables roles in a session.

B. All privileges and roles granted to a user are enabled by default when the user logs in.

C. The SET ROLE statement can be used once per session.

D. A role must be disabled before it can be revoked from a user.

E. The ALTER USER statement must be used to set specific default roles for a user.

Discussion 0

Correct Answer: A,B Vote an answer

Question #3

Which two statements are true about Oracle synonyms?

A. All private synonym names must be unique in the database.

B. A synonym can be created on an object in a package.

C. A synonym has an object number.

D. A synonym can have a synonym.

E. Any user can create a PUBLIC synonym.

Discussion 0

Correct Answer: C,D Vote an answer

Question #4

Which four statements are true regarding primary and foreign key constraints and the effect they can have on table data? (Choose four.)

A. A table can have only one primary key and one foreign key

B. A table can have only one primary key but multiple foreign keys

C. It is possible for child rows that have a foreign key to be deleted automatically from the child table at the time the parent row is deleted

D. It is possible for child rows that have a foreign key to remain in the child table at the time the parent row is deleted

E. Primary key and foreign key constraints can be defined at both the column and table level

F. Only the primary key can be defined at the column and table level

G. The foreign key columns and parent table primary key columns must have the same names

Discussion 0

Correct Answer: B,C,E,G Vote an answer

Question #5

Examine the description of the CUSTOMERS table:

You want to display details of all customers who reside in cities starting with the letter D followed by at least two characters.
Which query can be used?

A. SELECT * FROM customers WHERE city = `D_%';

B. SELECT * FROM customers WHERE city LIKE `D_';

C. SELECT * FROM customers WHERE city = `%D_';

D. SELECT * FROM customers WHERE city LIKE `D_%';

Discussion 0

Correct Answer: D Vote an answer

Question #6

The CUSTOMERS table has a CUST_CREDIT_LIMIT column of data type NUMBER.
Which two queries execute successfully? (Choose two.)

A. SELECT NVL2(cust_credit_limit * .15, `Not Available') FROM customers;

B. SELECT TO_CHAR(NVL(cust_credit_limit * .15, `Not Available')) FROM customers;

C. SELECT NVL2(cust_credit_limit, TO_CHAR(cust_credit_limit * .15), `Not Available') FROM customers;

D. SELECT NVL(cust_credit_limit * .15, `Not Available') FROM customers;

E. SELECT NVL(TO_CHAR(cust_credit_limit * .15), `Not Available') FROM customers;

Discussion 0

Correct Answer: A,E Vote an answer

Question #7

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. Have the OS administrator add KING to the OSDBA group

B. Set OS_AUTHENT_PREFIX to OPS$

C. Grant DBA to KING

D. Unset REMOTE_LOGIN_PASSWORDFILE

E. Alter user KING to be IDENTIFIED EXTERNALLY

Discussion 0

Correct Answer: D Vote an answer

Question #8

You must create a tablespace of non-standard block size in a new file system and plan to use this command:

The standard block size is 8k but other non-standard block sizes will also be used. Which two are requirements for this command to succeed?

A. db_32r_cache_si2e must be less than db_ca=he_size.

B. The operating system must use a 32k block size.

C. db_cache_s:ze must be set to a size that is smaller than db_32k_cache_size.

D. The /u02 file system must have at least lOOg space for the datafile.

E. db_32k_cache_size must be set to a value that can be accommodated in the SGA.

F. d3_32k_cache_size should be set to a value greater than db_cache_size.

Discussion 0

Correct Answer: A,C Vote an answer

Question #9

Which two are true about shrinking a segment online? (Choose two.)

A. To shrink a table it must have a PRIMARY KEY constraint

B. To shrink a table it must have a UNIQUE KEY constraint

C. It is not possible to shrink either indexes or Index Organized Tables (IOTs)

D. It always eliminates all migrated rows if any exist in the table

E. To shrink a table it must have row movement enabled

F. It must be in a tablespace that uses Automatic Segment Space Management (ASSM)

Discussion 0

Correct Answer: A,E Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #10

Which three statements are true about table data storage in an Oracle Database? (Choose three.)

A. Index block free space is always contiguous in the middle of the block

B. Data block headers contain their own Data Block Address (DBA)

C. Multiple row pieces from the same row may be stored in different database blocks

D. Data block free space is always contiguous in the middle of the block

E. Multiple row pieces from the same row may be stored in the same block

F. A table row piece can be chained across several database blocks

Discussion 0

Correct Answer: C,D,F Vote an answer

Question #11

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 Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax

D. The join syntax used makes no difference to performance

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

Discussion 0

Correct Answer: A,C Vote an answer

Question #12

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. Each SELECT statement in the compound query must have its own ORDER BY clause

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

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

D. 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

E. Column positions must be used in the ORDER BY clause

Discussion 0

Correct Answer: B,C Vote an answer

Question #13

Examine this description of the books table containing 100 rows:

Now examine this sequence of statements Issued In a new session;

Examine this description of the books table containing 100 rows:
Which three statements are true?

A. The first rollback command restores the 100 rows that were in the table originally.

B. The first rollback command leaves the table's 100 original rows locked.

C. The second rollback command restores the 100 rows that were in the table originally.

D. The first RollBack command restores the row that was inserted.

E. The second rollback command restores the row that was inserted.

F. The first rollback command leaves the inserted row locked.

G. The second rollback command rolls back the rollback to savepoint a command.

Discussion 0

Correct Answer: D,E,G Vote an answer

Oracle 1Z1-082 Actual Free Exam Questions & Community Discussion

Download Free Oracle 1Z1-082 Demo