Infosys AS-TFINTCBSCIXM1001-T100 Basic Technical Knowledge - TFINTCBSCIXM1001 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

How do you select all the records from a table named "Persons" where the value of the column "FirstName" starts with an "a"?

A. Select * from Persons where FirstName LIKE '%a' B. Select * from Persons where FirstName='%a%' C. Select * from Persons where FirstName='a' D. Select * from Persons where FirstName LIKE 'a%'

Discussion 0

Correct Answer: D Vote an answer

Question 2

A ________ is placed on a table to help retrieve data faster.

A. Index B. Sequence C. View D. Role

Discussion 0

Correct Answer: A Vote an answer

Question 3

Which of the following statement gets the total value of the column 'Price' in the 'Sales' table?

A. Select ADD(Price) FROM Sales B. Select SUM(Price) WHERE Sales C. Select SUM(Price) FROM Sales D. Select TOTAL(Price) FROM Sales

Discussion 0

Correct Answer: C Vote an answer

Question 4

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

A. True B. False

Discussion 0

Correct Answer: A Vote an answer

Question 5

What does the command "touch a b c" do?

A. Opens the three files a, b, c only if it is existing. B. Creates a file named "a" only C. Creates the three files a, b, c with zero bytes. D. None of the options are correct

Discussion 0

Correct Answer: C Vote an answer

Question 6

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

A. :map ctrl+X :wq^M B. :unmap^X C. :map ^X :wq^M D. None of the options are correct

Discussion 0

Correct Answer: C Vote an answer

Question 7

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

A. True B. False

Discussion 0

Correct Answer: B Vote an answer

Question 8

Lets consider a database named 't100ora'. What would be the name of the Database Writer process?

A. ora_t100ora_dbw B. t100ora_ora_dbwr C. t100ora_dbw D. ora_t100ora_dbwr

Discussion 0

Correct Answer: D Vote an answer