Tag: databases

Questions Related to databases

When attempting to connect to an instance that is down, which Oracle Net feature or component facilitates automatic connect-time fail-over to another instance for the user?

technology databases

  1. Heterogeneous Services

  2. Oracle Connection Manager

  3. Dynamic Service Registration

  4. Oracle Names Server

Show answer
Correct Option: C

Which type of view is implemented as a subquery embedded in the FROM clause of a SELECT statement and is identified by an alias?
technology databases

  1. Inline

  2. Simple

  3. Complex

  4. Nested

Show answer
Correct Option: A

Archived Redo Log is
technology databases

  1. It consists of Redo Log files that have archived before being reused.

  2. It consists of Redo Log files that have archived after being reused.

  3. It consists of Redo Log files that is archiving when currently being reused.

  4. It consists of Redo Log files that have archived not being reused.

Show answer
Correct Option: A

Examine the syntax for creating a DEPARTMENT table: CREATE TABLE ABCD( A NUMBER(4), B VARCNAR2(30), C NUMBER(6), D NUMBER(4)) STORAGE(INITIAL 200K NEXT 200K PCTINCREASE 50 MINEXTENTS 1 MAXEXTENTS 5) TABLESPACE userdata; What is the size defined for the fifth extent?
technology databases

  1. 500K

  2. 300K

  3. 675K

  4. 275K

Show answer
Correct Option: C

The control file defines the current state of the physical database. Which dynamic performance views obtain information from the control file?
technology databases

  1. V$LOG

  2. V$THREAD

  3. V$DATAFILE

  4. All of the above

Show answer
Correct Option: D

Control file contains information about
technology databases

  1. database

  2. redo logfile & datafile

  3. archivelog file location

  4. All of the above

Show answer
Correct Option: D

What is a Parallel Server
technology databases

  1. Multiple instances accessing the same database (Only In Multi-CPU environments)

  2. Multiple instances accessing the same database (Only In single-CPU environments)

  3. Multiple instances accessing the different database (Only In single-CPU environments)

  4. Single instance accessing the multiple database (Only In Multi-CPU environments)

Show answer
Correct Option: A

To re-create a database, all existing database files should be reused. The following SQL statement is issued: CREATE DATABASE ABC DATAFILE '/u01/oradata/abc/system0l.dbf' SIZE 100M REUSE LOGFILE GROUP 1 ('/u01/oradata/abc/logla.rdo', '/u02/oradata/abc/loglb.rdo') SIZE 50K REUSE, GROUP 2 ('/u01/oradata/abc/log2a.rdo', '/u02/oradata/abc/log2b.rdo') SIZE 50K REUSE MAXLOGFILES 5 MAXLOGHISTORY 100 MAXDATAFILES 10; Why does the CREATE DATABASE statement fail?
technology databases

  1. The MAXLOGFILES are set too low

  2. The CONTROLFILE REUSE clause is omitted

  3. The online redo log files cannot be reused

  4. The data file belonging to the SYSTEM tablespace cannot be reused

Show answer
Correct Option: B

What represents the value of the ORACLE_HOME environment variable in Oracle 9i?
technology databases

  1. @

  2. !

  3. ^

  4. &

Show answer
Correct Option: A

Which of the following tasks can be performed by using the TO_CHAR function?
technology databases

  1. Convert '10'to 10

  2. Convert 'TEN' to 10

  3. Convert 10 to '10'

  4. Convert a character expression to a date

Show answer
Correct Option: C