Summer Sale - Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: dpt65

TFINTCBSCIXM1001 Questions and Answers

Note! Following TFINTCBSCIXM1001 Exam is Retired now. Please select the alternative replacement for your Exam Certification.

TFINTCBSCIXM1001 Questions and Answers

Question # 6

In Unix, an environment variable is set as TBA_PROD_ROOT=/finacle/V10/app. To display the variables value, the command is

A.

echo %TBA_PROD_ROOT

B.

display TBA_PROD_ROOT

C.

echoTBA_PROD_ROOT

D.

display %TBA_PROD_ROOT%

Full Access
Question # 7

Unix is written in

A.

C language

B.

Perl Language

C.

Pascal Language

D.

Ada language

Full Access
Question # 8

Which of the following is not a valid part of UNIX in its structural classification?

A.

Kernel

B.

Shell

C.

File System

D.

None of the options are correct

Full Access
Question # 9

Which among the following is not a valid database object naming rule?

A.

Name of the database object must not exceed 45 characters.

B.

Name must not contain a question mark.

C.

Name must begin with an alphabet.

D.

Name should not be Oracle reserved word.

Full Access
Question # 10

What does the ALTER TABLE clause do?

A.

The Sql ALTER TABLE clause is used to insert data into database table.

B.

The Sql ALTER TABLE clause is used to delete a database table.

C.

The Sql ALTER TABLE deletes data from database table.

D.

The Sql ALTER TABLE clause modifies a table definition by altering, adding, or deleting table columns and/or constraints.

Full Access
Question # 11

Grants are a group of privileges that are collected together and granted to users.

A.

True

B.

False

Full Access
Question # 12

Which of the following is not a merit of RDBMS?

A.

Controlling Redundancy

B.

Restricting authorized access

C.

Enforcing integrity constraints

D.

Provide backup and recovery

Full Access
Question # 13

In a typical Unix Environment, there are

A.

Several kernels and one shell

B.

Several shells and one kernel

C.

Severalkernels and several shells

Full Access
Question # 14

The UPDATE sql clause can

A.

Delete more than one row at a time

B.

Update more than one row at a time

C.

Update only one row at a time

D.

Delete only one row at a time

Full Access
Question # 15

___________ is a database object that allows the creation of a customised slice of a table or a collection of tables

A.

Views

B.

Indexes

C.

Synonyms

D.

Aliases

Full Access
Question # 16

"Select cust_name from cmg where cust_emp_id between 200 and 400" can give

A.

A customer name whose cust_emp_id is 200

B.

A cust_emp_id whose cust_emp_id is 400

C.

A customer name whose cust_emp_id is 250

D.

Two customer names whose cust_emp_id are 200 and 250 respectively

Full Access
Question # 17

It is possible to join a table to itself.

A.

True

B.

False

Full Access
Question # 18

Which command is used to show an environment variables current value?

A.

Echo

B.

Display

C.

Show

D.

None of the options are correct

Full Access
Question # 19

How do you get help about the command cp?

A.

help cp

B.

man cp

C.

cp?

Full Access
Question # 20

Oracle's memory structure consists of two memory areas, namely

A.

System Global Area and Program Global Area

B.

System Global Area and Process Global Area

C.

Shared Global Area and Process Global Area

D.

None of the options are correct

Full Access
Question # 21

The command "chmod 755 file2" gives the permission

A.

Read,write ,execute to all

B.

Read ,write execute to owner, read and execute to group and others

C.

Read ,write,execute to others, read and write to group and owner

D.

Read ,write ,execute to owner ,read and write to group and others

Full Access
Question # 22

Which SQL statement is used to extract data from a database?

A.

Open

B.

Extract

C.

Get

D.

Select

Full Access