Oracle 1Z0-082 Quiz 2 Topic 17 Questions 6-10

Question: 1

Examine the description of the SALES1 table:

q1_1Z0-082

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?

AINTERSECT

BUNION ALL

CUNION

DSUBTRACT

EMINUS

Show Answer

Question: 2

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

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

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

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

DThey can be nested to any level

EThey can accept only one argument

FThey return a single result row per table

Show Answer

Question: 3

In one of your databases, the user HR has the password HRMGR.

You want to connect to a database instance whose listener listens on port 1531 by using this statement:

CONNECT HR/HRMGR@orcl

No name server is used.

Which statement is true about ORCL?

AIt must be the value of the SERVICE_NAMES parameter on the client side

BIt must resolve to a valid connect descriptor in the server's tnsnames.ora file

CIt must resolve to a valid connect descriptor in the client's tnsnames.ora file

DIt must be the name of the database to whose instance HR wishes to connect

EIt must be the name of the server running the database to whose instance HR wishes to connect

Show Answer

Question: 4

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

AMOD : returns the quotient of a division operation

BFLOOR : returns the smallest integer greater than or equal to a specified number

CTRUNC : can be used with NUMBER and DATE values

DCONCAT : can be used to combine any number of values

ECEIL : can be used for positive and negative numbers

Show Answer

Question: 5

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

APCTFREE defaults to 10% for all blocks in all segments for all compression methods

BASSM assigns blocks to one of four fullness categories based on what percentage of the block is allocated for rows

CUpdate operations always attempt to find blocks with free space appropriate to the length of the row being updated

DInsert operations always attempt to find blocks with free space appropriate to the length of the row being inserted

EA block will always be eligible for inserts if the row is short enough to fit into the block

Show Answer

Oracle 1Z0-082 Quiz:2 Topic:17 Questions:6-10