Technical Questions

Q:

 A benefit of the three-tier architecture is which of the following?

A) New modules can be built to support specific business needs B) Performance improves for compiled SQL statements
C) Results in a thinner client and database server D) All of the above.
 
Answer & Explanation Answer: A) New modules can be built to support specific business needs

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

1 7159
Q:

What happens during the bootstrap process?

Answer

A bootstrap is the process of starting up a computer. It also refers to the program that initializes the operating system (OS) during start-up.


It referred to a bootstrap load button that was used to initiate a hardwired bootstrap program, or smaller program that executed a larger program such as the OS.

Report Error

View answer Workspace Report Error Discuss

44 7043
Q:

Explain fork() system call?

Answer

The `fork()’ used to create a new process from an existing process. The new process is called the child process, and the existing process is called the parent. We can tell which is which by checking the return value from `fork()’. The parent gets the child’s pid returned to him, but the child gets 0 returned to him.

Report Error

View answer Workspace Report Error Discuss

Subject: Operating Systems Exam Prep: GATE

2 7005
Q:

 When assessing the table structure of an acquired set of tables with data, accessing the validity of possible referential integrity constraints on foreign keys is (part of) the:

A) first step. B) second step.
C) third step. D) fourth step.
 
Answer & Explanation Answer: C) third step.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

2 6997
Q:

A data dictionary is a special file that contains

A) The width of all fields in all files B) The data type of all fields in all file
C) The name of all fields in all files D) All of the above
 
Answer & Explanation Answer: D) All of the above

Explanation:

A data dictionary is a special file that contains a set of information describing the contents, format, and structure of a database and the relationship between its elements, used to control access to and manipulation of the database.

Report Error

View Answer Report Error Discuss

Filed Under: Database
Exam Prep: Bank Exams
Job Role: Analyst , Bank Clerk , Database Administration , IT Trainer

44 6962
Q:

A computer assisted method for the recording and analyzing of existing or hypothetical systems is

A) Data transmission B) Data capture
C) Data flow D) Data processing
 
Answer & Explanation Answer: C) Data flow

Explanation:
Report Error

View Answer Report Error Discuss

7 6950
Q:

What do the functions atoi(), itoa() and gcvt () do? Show how would you use them in a program.

Answer

atoi()         Converts a string to an integer.


itoa()         Convert an integer to a string


gcvt()        Converts a floating-point number to a string


 


#include "stdlib.h"


main()


{


      char s[] = "12345";


      char buffer [15], string[20];


      int i;


      


      i = atoi (s);


      printf("\n%d",i);


 


       gcvt (20.141672, 4, buffer);


       printf ("\n%s", buffer);


 


       itoa(15, string,2);


        printf ("\n%s", string);


}

Report Error

View answer Workspace Report Error Discuss

Subject: Programming

2 6744
Q:

Which type of entity is related to two or more associated entities that each contain specialized attributes that apply to some but not all of the instances of the entity?

A) Supertype entity B) Subtype entity
C) Archetype entity D) Instance entity
 
Answer & Explanation Answer: A) Supertype entity

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

2 6730