Tag: technology

Quizzes (307) Questions (36705)

Questions Related to technology

Multiple choice technology databases

Conventional path load (the default) uses the SQL INSERT statement and a bind array buffer to load data into database tables. When SQL*Loader performs a conventional path load, it wont competes equally with all other processes for buffer resources. This can slow the load significantly. Extra overhead is added as SQL statements are generated, passed to Oracle, and executed. Although appropriate during normal use, this can slow bulk loads dramatically.

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
A Correct answer
Full explanation
Multiple choice technology databases

In Direct Path Loading, Oracle will not use SQL INSERT statement for loading rows. It directly writes the rows, into fresh blocks beyond High Water Mark, in datafiles i.e. it does not scan for free blocks before high water mark. Direct Path load is very fast because Partial blocks are not used, so no reads are needed to find them, and fewer writes are performed. SQL*Loader need not execute any SQL INSERT statements; therefore, the processing load on the Oracle database is reduced. A direct path load calls on Oracle to lock tables and indexes at the start of the load and releases them when the load is finished. During a direct path load, processes perform their own write I/O, instead of using Oracle's buffer cache. This minimizes contention with other Oracle users.

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
A Correct answer
Full explanation
Multiple choice technology web technology

Which is wrong??

  1. Volume testing is a way to test functionality.

  2. Stress testing is a way to test reliability.

  3. GUI Testing; Data Base Testing; Syntax Checking ; Structure Investigation ; is the type of dynamic Testing.

  4. unit, integration, regression, are the Type of white box testing.
Reveal answer Fill a bubble to check yourself
C Correct answer
Full explanation
Multiple choice technology testing

Regression Testing is :

  1. IT is a method by which individual units of source code are tested to determine if they are fit for use.

  2. It is the testing of integrated system to evaluate the system's compliance with its specified requirements.

  3. Testing that seeks to uncover software errors by partially retesting a modified program.

  4. None
Reveal answer Fill a bubble to check yourself
C Correct answer
Full explanation
Multiple choice technology testing

Regression Testing is :

  1. IT is a method by which individual units of source code are tested to determine if they are fit for use.

  2. It is the testing of integrated system to evaluate the system's compliance with its specified requirements.

  3. Testing that seeks to uncover software errors by partially retesting a modified program.

  4. None
Reveal answer Fill a bubble to check yourself
C Correct answer
Full explanation