Tag: databases

Questions Related to databases

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

technology databases

  1. ALTER TABLE TABLE1 SHRINK;

  2. ALTER TABLE TABLE1 SHRINK SPACE;

  3. ALTER TABLE TABLE1 SHRINK UNUSED;

  4. ALTER TABLE TABLE1 SHRINK ROWs;

Show answer
Correct Option: B

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

technology databases

  1. WHERE clauses

  2. START WITH and CONNECT BY clauses

  3. select lists

  4. HAVING clauses

Show answer
Correct Option: A,B,C,D

What is syntax to unlock the table statastics?

technology databases

  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');

Show answer
Correct Option: E

A Tablespace can hold objects from different Schemes.

technology databases

  1. True

  2. False

Show answer
Correct Option: A

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

technology databases

  1. colons

  2. parentheses

  3. commas

  4. semi-colons

Show answer
Correct Option: B

A Tablespace can have multiple datafiles.

technology databases

  1. True

  2. False

Show answer
Correct Option: A

A Datafile can be part of multiple tablespaces.

technology databases

  1. True

  2. False

Show answer
Correct Option: B

Which of the following can be partitioned (choose all that apply):

technology databases

  1. Indexes

  2. Hints

  3. Tables

  4. Bitmaps

Show answer
Correct Option: A,C

What type of joins extends the result of a simple join

technology databases

  1. left join

  2. right join

  3. outer join

  4. equil join

  5. simple join

Show answer
Correct Option: C

To write a query that performs an outer join of tables A and B and returns all rows from B, you need a:

technology databases

  1. left outer join

  2. inner join

  3. equil join

  4. right outer join

Show answer
Correct Option: D