Tag: technology

Questions Related to technology

_____ searches for a text string in a file.
technology operating systems

  1. LOOKUP

  2. FIND

  3. STRFIND

  4. SEARCH

Show answer
Correct Option: B

Using a _____ symbol you can redirect standard output to a file.
technology operating systems

  2. ^

  3. >

  4. -->

Show answer
Correct Option: C

To ensure proper data conversion between databases with different character sets, you must ensure that
technology databases

  1. ASCII characters are capitalized

  2. INT data consists of non-negative numbers

  3. CHAR data consists of well-formed strings.

  4. CHAR data consists of at least a nil string

  5. None of the choices.

Show answer
Correct Option: C

Which of the following correctly describe the LONG columns (choose all that apply):

technology databases

  1. You can use them to store long text strings

  2. They have many of the characteristics of VARCHAR2 columns

  3. They store variable-length character strings containing up to 2 gigabytes

  4. None of the choices.

Show answer
Correct Option: A,B,C

Which of the following are the valid datetime datatypes in Oracle (choose all that apply):

technology databases

  1. TIMESTAMP WITH LOCAL TIME ZONE

  2. TIMESTAMP

  3. TIMESTAMP WITH TIME ZONE

  4. DATE

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

Which of the following are the restrictions of creating bitmap indexes (choose all that apply):
technology databases

  1. You cannot specify BITMAP for a domain index

  2. You cannot specify both UNIQUE and BITMAP

  3. You cannot specify BITMAP when creating a local index.

  4. You cannot specify BITMAP when creating a global partitioned index

Show answer
Correct Option: A,B,D

Text literals have properties of which of the following datatypes (choose all that apply):

technology databases

  1. CHAR

  2. CLOB

  3. VARCHAR2

  4. Float

Show answer
Correct Option: A,C

A sequence generates values that are often used for (choose all that apply):
technology databases

  1. primary keys

  2. sales figures

  3. foreign keys

  4. unique keys

Show answer
Correct Option: A,D

What's command to start DBCONSOLE service on database installed on Linux?

technology databases

  1. emctl start dbconsole

  2. start dbconsole

  3. dbconsole start

  4. emctl dbconsole start

Show answer
Correct Option: A

In Oracle, the result of comparison conditions can be (choose all that apply):

technology databases

  1. TRUE

  2. UNKNOWN

  3. ERROR

  4. NULL

  5. FALSE

Show answer
Correct Option: A,B,E