Tag: programming languages

Questions Related to programming languages

You specified segment space management as automatic for a tablespace what effect would this have on space management?
technology programming languages

  1. Extents would be managed by freelists.

  2. Free space would be managed by data dictionary

  3. The segment would be managed by bitmaps.

  4. The segment would be managed by freelists.

Show answer
Correct Option: C

A user wants to connect to the database instance from an application that is running on a remote machine. Which tool should the DBA use to establish the required configuration to ensure that the user is able to connect to the database instance? (Choose two).
technology programming languages

  1. Oracle Net Manager.

  2. Data Pump.

  3. Oracle Universal Installer (OUI).

  4. Oracle Enterprise Manager.

  5. Database Configuration Assistant (DBCA).

Show answer
Correct Option: D

Which two are valid locking levels that are used by transactions in oracle database? (Choose two)
technology programming languages

  1. Object level.

  2. Row level.

  3. Block level.

  4. Schema level.

  5. Database level.

Show answer
Correct Option: A,B

Your database is having two control files; three redo log file groups with two members in each group. Failure of which file would cause a instance to shut down?
technology programming languages

  1. Loss of the initialization parameter file.

  2. One of the redo log members.

  3. Any data file belonging to the default permanent tablespace

  4. Any archive log file.

  5. Any control file.

Show answer
Correct Option: E

Which statements are true regarding the logical structure of database? (Choose three)
technology programming languages

  1. It is possible to have tablespaces of different block sizes in a database.

  2. A data block is the smallest unit of I/O for data files.

  3. Multiple tablespaces can share single data file.

  4. Each data block in the database always corresponds to one OS block

  5. Each segment contains one or more extents.

Show answer
Correct Option: A,B,E

Which three statements are true about the stages of database startup?
technology programming languages

  1. Data files and redo log files can be renamed at the MOUNT stage

  2. Control files are required to bring the database to the NOMOUNT stage.

  3. Data files and online redo log files are checked for consistency while opening the database

  4. Data files and redo log files are made available to users at the OPEN stage.

Show answer
Correct Option: A,C,D

What will be the value of $size after executing the following code?my @a = (0, 1, 2);$#a = 0;my $size = @a;
technology programming languages

  1. undef

  2. 0

  3. 1

  4. 2

Show answer
Correct Option: C

What elements will the @a array consist of? $_ = ' a b c '; my @a = split();
technology programming languages

  1. ', 'a', ' ', 'b', ' ', 'c', ' '

  2. ', 'a', 'b', 'c', ''

  3. undef, 'a', 'b', 'c', undef

  4. 'a', 'b', 'c'

Show answer
Correct Option: D

package A; sub NEW { bless {}, shift } sub AUTOLOAD { print ref(shift) } package main; my $obj = NEW A; $obj->foo();
technology programming languages

  1. A

  2. AA

  3. Can't locate object method "foo" via package "A"

  4. none of the above

Show answer
Correct Option: B

my $a = '123'; my $b = '0123'; if ($a == $b) { print "same"; } else { print "different"; }
technology programming languages

  1. same

  2. different

  3. the code is ill-formed

  4. none of the above

Show answer
Correct Option: A