Oracle Database Administration I Free Sample Questions

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

It always eleminates all migrated ows if any exist in the table

To shrink a table it must have a PRIMARY KEY constraint

To shrink a table it must have a UNIQUE KEY constraint

To shrink a table it must have row movement enabled.

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

a primary key column referenced by another column as a foreign key can be dropped if using the CASCADE option.

An UNUSED column’s space is reclaimed automatically when the block containing that column is next queried.

An UNUSED column’s space is reclaimed automatically when the row containing that column is next queried.

Partition key columns cannot be dropped.

A DROP COLUMN command can be rolled back

a column that is set to UNUSED still counts towards the limit of 1000 columns per table

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

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)

analysis of all privileges used by all users including administrative users in the database

analysis of all privileges used by all users but excluding administrative users in the database

analysis of privileges that a user has on their own schema objects that they did not use

analysis of privileges that a user has on their own schema objects that they did use

analysis of privileges granted directly to a role that are then used by a user who has been granted that role

analysis of privileges granted indirectly to a role that are then used by a user who has been granted that role

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

it must resolve to a valid connect descriptor in the server’s tnsnames.ora file

it must resolve to a valid connect descriptor in the client’s tnsnames.ora file

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

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

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

ASSM assigns blocks to one of four fullness categories based on what percentage of the block is all

ted for rowsC. Update operations always attempt to find blocks with free space appropriate to the length of the row being updated

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

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

COLUMN STORE COMPRESS FOR QUERY LOW

ROW STORE COMPRESS BASIC

COLUMN STORE COMPRESS FOR ARCHIVE LOW

COLUMN STORE COMPRESS FOR ARCHIVE HIGH

ROW STORE COMPRESS ADVANCED

If sequence ORD_SEQ is dropped then the default value for column ORD_NO will be NULL for rows inserted into ORDJTEMS

Any user inserting rows into table ORDJTEMS must have been granted access to sequence ORD_SEQ

Column ORD_NO gets the next number from sequence ORDJBEQ whenever a row is inserted into ORDJTEMS and no explicit value is given for ORD_NO

Sequence ORD_SEQ cycles back to 1 after every 5000 numbers and can cycle 20 times

Sequence ORD_SEQ is guaranteed not to generate duplicate numbers

CONCAT (qty_sold, invoice_date): requires explicit conversion

invoice_date = ’15-march-2019’: uses implicit conversion

invoie_date ) ’01-02-2019’: uses implicit conversion

qty_sold BETWEEN ‘101’ AND ’110’: uses implicit conversion

qty_sold = ‘0554982’ uses implicit conversion