Weekend Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

Free and Premium Infosys TFINTCBSCIXM1001 Dumps Questions Answers

AS-TFINTCBSCIXM1001-T100 Basic Technical Knowledge Questions and Answers

Question 1

When a new user is created in Unix by the system administrator, the details are stored in

Options:

A.

/etc/hosts file

B.

/etc/passwd file

C.

/etc/group

D.

/etc/user

Buy Now
Question 2

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

Options:

A.

Kernel

B.

Shell

C.

File System

D.

None of the options are correct

Question 3

The heart of a UNIX system is:

Options:

A.

Kernel

B.

Shell

C.

File System

D.

None of the options are correct

Question 4

The only process in Oracle database that reads the redo logs is:

Options:

A.

Database Writer

B.

Log Writer

C.

Process Monitor

D.

System Monitor

Question 5

Defining a database consists of:

Options:

A.

Data types specification

B.

Structures

C.

Constraints for the data that is to be stored in the database

D.

All the options are correct

Question 6

Data dictionary contains information about database files,tables,indexes,columns,users,privileges.

Options:

A.

True

B.

False

Question 7

The main components of a computer system are:

Options:

A.

Hardware

B.

Operating System

C.

Applications

D.

All the options are correct

Question 8

The environment variable called PATH tells the shell where to look for the

Options:

A.

.profile file

B.

Commands

C.

Passwd file

D.

None of the options are correct

Question 9

Program Global Area is an area of memory that is used by a single Oracle process.

Options:

A.

True

B.

False

Question 10

Problems associated with centralization and complexity of backup and recovery is one of the demerits of RDBMS.

Options:

A.

True

B.

False

Question 11

What does the ALTER TABLE clause do?

Options:

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.

Question 12

The sql statement "DESC emptable"

Options:

A.

Is used to view the structure of the table emptable

B.

Shows the user all the data in the table

C.

Selects the number of rows in the table

D.

None of the options are correct

Question 13

To map the key 'ctrl-X' to the 'wq' command:

Options:

A.

:map ^X :wq^M

B.

:unmap^X

C.

:map ctrl+X :wq^M

D.

None of the options are correct

Question 14

SQL stands for

Options:

A.

Stored Query Language

B.

Structured Query Language

C.

Stored Question Language

D.

Structured Question Language

Question 15

Which of the following is not a valid type of UNIX files?

Options:

A.

Regular files

B.

Directories

C.

Special or Device files

D.

FILO files

Question 16

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

Options:

A.

echo %TBA_PROD_ROOT

B.

display TBA_PROD_ROOT

C.

echoTBA_PROD_ROOT

D.

display %TBA_PROD_ROOT%

Question 17

The safest mode for a database to run is:

Options:

A.

ARCHIVELOG Mode

B.

SAFE Mode

C.

ARCHIVE Mode

D.

NONARCHIVE Mode

Question 18

The SQL statement to return the number of records in the "Persons" table

Options:

A.

Select COLUMNS(*) from Persons

B.

Select Count(*) from Persons

C.

Select Count() from Persons

D.

Select COLUMNS() from Persons

Question 19

If "users" is a directory, the command "ls users" will display

Options:

A.

Only the files under the directory "users"

B.

All the files and directories under the directory "users"

C.

only the directories under the directory "users"

Question 20

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

Options:

A.

Open

B.

Extract

C.

Get

D.

Select

Question 21

How do you rename file "new" as file "old"?

Options:

A.

mv new old

B.

rn new old

C.

cp new old

Question 22

Which SQL keyword is used to sort the result-set?

Options:

A.

ORDER

B.

SORT

C.

SORT BY

D.

ORDER BY