Tag: technology

Questions Related to technology

What is default location for portlist.ini file?

  1. $ORACLE_HOME/sysman/install

  2. $ORACLE_HOME/install

  3. $ORACLE_HOME/rdbms/admin/install

  4. $ORACLE_HOME/dbs/install


Correct Option: B

What command is used to reclaim unused space for table TABLE1?

  1. ALTER TABLE TABLE1 SHRINK;

  2. ALTER TABLE TABLE1 SHRINK SPACE;

  3. ALTER TABLE TABLE1 SHRINK UNUSED;

  4. ALTER TABLE TABLE1 SHRINK ROWs;


Correct Option: B

Single-row functions can appear in which of the following (choose all that apply):

  1. WHERE clauses

  2. START WITH and CONNECT BY clauses

  3. select lists

  4. HAVING clauses


Correct Option: A,B,C,D

What is syntax to unlock the table statastics?

  1. exec DBMS_STATS.UNLOCK_SCHEMA_STATS('TABLE_NAME','OWNER');

  2. exec DBMS_STATS.UNLOCK_SCHEMA_STATS('OWNER','TABLE_NAME');

  3. exec DBMS_STATS.UNLOCK_DB_STATS('DB_NAME','OWNER','TABLE_NAME');

  4. exec DBMS_STATS.UNLOCK_TABLE_STATS('TABLE_NAME','OWNER');

  5. exec DBMS_STATS.UNLOCK_TABLE_STATS('OWNER','TABLE_NAME');


Correct Option: E

A Tablespace can hold objects from different Schemes.

  1. True

  2. False


Correct Option: A

You can use ____________ in a SQL expression to override operator precedence

  1. colons

  2. parentheses

  3. commas

  4. semi-colons


Correct Option: B

A Tablespace can have multiple datafiles.

  1. True

  2. False


Correct Option: A

A Datafile can be part of multiple tablespaces.

  1. True

  2. False


Correct Option: B
  1. bootcfg

  2. repair boot

  3. sfc /boot

  4. config /boot


Correct Option: A