3i Infotech Papers: Sample Questions 343 - 344 of 1245

Examrace Placement Series prepares you for the toughest placement exams to top companies.

Question number: 343

» Database » Oracle

MCQ▾

Question

REPLACE (‘JACK AND JUE’, ‘J’, ‘BL’) will return

Choices

Choice (4) Response

a.

BLACK AND BLUE

b.

BLACK AND JACK

c.

JACK AND BLUE

d.

Question does not provide sufficient data or is vague

Answer

a.

Explanation

  • REPLACE function replaces a sequence of characters in a string with another set of characters.

  • replacement_string is omitted or null, then all search_string are removed.

  • search_string is null, then char is return.

Syntax:

REPLACE (string1, string_to_replace [, replacement_string] )

EX:

REPLACE (‘JACK AND JUE’, ‘J’, ‘BL’)

J = search_string

BL = replacement_string

So, JACK = BLACK

JUE = BLUE

So, return string is BLACK AND BLUE

Question number: 344

» Operating System » Unix

Essay Question▾

Describe in Detail

What are links and symbolic links in UNIX file system?

Explanation

Define symbolic links.

Define Symbolic Links.

Define symbolic links.

  • A link is a pointer or reference to another file.

  • A directory UNIX has a list of file names and corresponding inodes.

  • Link points to another file.

Hard Link

  • In hard link- the i-numbers of two difference directory file entries point to the same inode.

Soft Link

  • A symbolic link or a soft link a special type of link containing links or references to another file or directory in the form of the path.

  • To create a symbolic link, following command is used:

    Ln-s target link_name

  • Path is the target and name of the link is link_name.

  • Symbolic link can created to creare a file system based on different views of the user.