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

Hot Vendors
  1. Home
  2. Infosys
  3. Basic Technical
  4. TFINTCBSCIXM1001
  5. AS-TFINTCBSCIXM1001-T100 Basic Technical Knowledge Questions and Answers
Note! The TFINTCBSCIXM1001 Exam is no longer available.

TFINTCBSCIXM1001 AS-TFINTCBSCIXM1001-T100 Basic Technical Knowledge Questions and Answers

Questions 4

Data definition language allows the following tasks

Options:

A.

Creation of a database object

B.

Dropping a database object

C.

Creating and also dropping a database object

D.

None of the options are correct

Buy Now
Questions 5

Any user having access to Unix automatically gets an access to all the files present in it.

Options:

A.

True

B.

False

Buy Now
Questions 6

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

Options:

A.

True

B.

False

Buy Now
Questions 7

"Select DISTINCT empname FROM emptable" selects

Options:

A.

All the empname form the emptable

B.

A set of distinct empname from the table emptable

C.

All the rows and columns from the emptable

D.

None of the options are correct

Buy Now
Questions 8

Each instance in Oracle is identified by

Options:

A.

SID - systemidentifier

B.

PID - process id

C.

PID - program id

D.

SID - shared id

Buy Now
Questions 9

With SQL, how do you Select all the records from a table named "Persons" where the "FirstName" is "Peter" and the "LastName" is "Jackson"?

Options:

A.

Select * from Persons where FirstName LIKE 'Peter' AND LastName LIKE 'Jackson'

B.

Select * from Persons where FirstName='Peter' AND LastName='Peter'

C.

Select FirstName='Peter', LastName='Jackson' from Persons

Buy Now
Questions 10

Synonyms are used for

Options:

A.

Security reasons to mask the owner and name of the object

B.

To simplify the SQL statements

C.

As an alias to database object

D.

All the options are correct

Buy Now
Questions 11

Whenever a database checkpoint occurs or there is a change to the structure of the database, the control file is updated.

Options:

A.

True

B.

False

Buy Now
Questions 12

Traditional database management systems are data-driven and relational systems are design-driven.

Options:

A.

True

B.

False

Buy Now
Questions 13

The database management system is a system that facilitates the processes of _________, ___________ and ___________ databases for different applications.

Options:

A.

Compiling, analyzing and maintaining

B.

Constructing, defining and manipulating

C.

Constructing, analyzing and manipulating

D.

Compiling, defining and maintaining

Buy Now
Questions 14

The user cannot change the environment variables once it is set.

Options:

A.

True

B.

False

Buy Now
Questions 15

The output of the command "ls -lrt" is drwxr-xr-x 2 finadm finuser 512 Jun 1 2006 ErrorAuditlogs/ErrorAuditlogs is a

Options:

A.

File

B.

Directory

C.

Link

D.

None of the options are correct

Buy Now
Questions 16

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

Options:

A.

Echo

B.

Display

C.

Show

D.

None of the options are correct

Buy Now
Questions 17

The output of the command "ls -lrt" is -rw-r--r-- 1 finadm finuser 283 Jun 1 2006 EnvVals the second column represents

Options:

A.

The number of files under the directory

B.

The number of links

C.

Whether it is a directory or not

D.

None of the options are correct

Buy Now
Questions 18

Which among the following data types will be used for storing binary data upto 2GB?

Options:

A.

RAW(n)

B.

VARCHAR2(n)

C.

LONG

D.

None of the options are correct

Buy Now
Questions 19

The UPDATE sql clause can

Options:

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

Buy Now
Questions 20

____________ is a group of programs that allow users to create and maintain a database.

Options:

A.

Database Management Systems

B.

Database Systems

C.

Relational Database Management Systems

D.

None of the options are correct

Buy Now
Questions 21

"Select * from SOL" gives

Options:

A.

All the records from the SOL table.

B.

Only the first 10 rows from the SOL table.

C.

Only the first 10 columns from the SOL table

D.

None of the options are correct

Buy Now
Questions 22

An index is a

Options:

A.

Database table attribute, which speeds-up data search within a table

B.

Special way to join 2 or more tables

C.

The same as alias

Buy Now
Exam Code: TFINTCBSCIXM1001
Exam Name: AS-TFINTCBSCIXM1001-T100 Basic Technical Knowledge
Last Update: Mar 21, 2024
Questions: 150
dumpsmate guaranteed to pass
24/7 Customer Support

DumpsMate's team of experts is always available to respond your queries on exam preparation. Get professional answers on any topic of the certification syllabus. Our experts will thoroughly satisfy you.

Site Secure

mcafee secure

TESTED 21 Nov 2024