Complete TFINTCBSCIXM1001 Infosys Materials

AS-TFINTCBSCIXM1001-T100 Basic Technical Knowledge Questions and Answers

Question 9

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

True

False

Question 10

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

True

False

Question 11

What does the ALTER TABLE clause do?

The Sql ALTER TABLE clause is used to insert data into database table.

The Sql ALTER TABLE clause is used to delete a database table.

The Sql ALTER TABLE deletes data from database table.

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"

Is used to view the structure of the table emptable

Shows the user all the data in the table

Selects the number of rows in the table

None of the options are correct