AS-TFINTCBSCIXM1001-T100 Basic Technical Knowledge (TFINTCBSCIXM1001) Free Practice Test

Question 1

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

A. System Monitor

B. Database Writer

C. Log Writer

D. Process Monitor

Correct Answer: C

Question 2

How do you visualize the content of the file "not_empty"?

A. type not_empty

B. cat not_empty

C. touch not_empty

D. more not_empty

Correct Answer: B

Question 3

Which SQL statement is used to insert new data into a database?

A. Insert INTO

B. ADD RECORD

C. Insert NEW

D. ADD NEW

Correct Answer: A

Question 4

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

A. All the files and directories under the directory "users"

B. only the directories under the directory "users"

C. Only the files under the directory "users"

Correct Answer: A

Question 5

The SQL statement to change "Hansen" into "Nilsen" in the "LastName" column in the Persons table

A. Update Persons SET LastName='Nilsen' where LastName='Hansen'

B. Modify Persons SET LastName='Nilsen' where LastName='Hansen'

C. Update Persons SET LastName='Hansen' INTO LastName='Nilsen'

D. Modify Persons SET LastName='Hansen' INTO LastName='Nilsen

Correct Answer: A

Question 6

The safest mode for a database to run is:

A. ARCHIVE Mode

B. SAFE Mode

C. ARCHIVELOG Mode

D. NONARCHIVE Mode

Correct Answer: C

Question 7

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

A. Views

B. Aliases

C. Indexes

D. Synonyms

Correct Answer: A

Question 8

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

A. False

B. True

Correct Answer: B

Question 9

Can the SELECT clause list have a computed value like in the example below? SELECT CustomerName, UnitPrice * NumberofUnits FROM Sales

A. No

B. Yes

Correct Answer: B

Welcome to TestSimulate

Infosys AS-TFINTCBSCIXM1001-T100 Basic Technical Knowledge (TFINTCBSCIXM1001) Free Practice Test