TFINTCBSCIXM1001 Exam Training Practice Tests (Infosys AS-TFINTCBSCIXM1001-T100 Basic Technical Knowledge)]

Infosys AS-TFINTCBSCIXM1001-T100 Basic Technical Knowledge - TFINTCBSCIXM1001 Exam Practice Test

Question 1

Which of the following is a SQL aggregate function?

A. Right B. Left C. Min D. Cast

Correct Answer: C

Question 2

Which of these SQL statement is correct?

A. Select user_id and user_name from upr B. Select user_id, user_name where user_name ='TEST1' C. Select user_id, user_name from upr D. None of the options are correct

Correct Answer: C

Question 3

The output of the command "ls -lrt" is -rw-rw-r-- 1 finadm finuser 3283 May 8 13:09 showrep The owner of the file showrep is

A. Root B. Finadm C. Finuser D. None of the options are correct

Correct Answer: B

Question 4

The SQL statement 'Rollback':

A. Undo all the changes since the last commit. B. None of the options are correct C. Make permanent changes for the current transaction. D. Change data in a table.

Correct Answer: A

Question 5

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

A. System Global Area and Process Global Area B. System Global Area and Program Global Area C. None of the options are correct D. Shared Global Area and Process Global Area

Correct Answer: B

Question 6

SQL*PRO* is the interface through which data is defined and manipulated in Oracle's relational database.

A. True B. False

Correct Answer: B