Technical Questions

Q:

 Which of the following is the original purpose of SQL?

A) To specify the syntax and semantics of SQL data definition language B) To specify the syntax and semantics of SQL manipulation language
C) To define the data structures D) All of the above.
 
Answer & Explanation Answer: D) All of the above.

Explanation:

SQL is a domain-specific language used in programming and designed for managing data held in a relational database management system, or for stream processing in a relational data stream management system.

 

Purpose of SQL are ::

* To define the data structures

* To specify the syntax and semantics of SQL manipulation language

* To specify the syntax and semantics of SQL data definition language

Report Error

View Answer Report Error Discuss

Filed Under: Database
Job Role: Analyst , Database Administration , IT Trainer

31 29916
Q:

Transmission data rate is decided by

A) Transport layer B) Network layer
C) Physical layer D) Data link layer
 
Answer & Explanation Answer: C) Physical layer

Explanation:

The speed of the transmission data is generally determined by the cables or connectors we use for data transmission. In networking, layer-1 the physical is which deals with the network cables like pins, usb, connectors, etc... we use for data transmission.

Report Error

View Answer Report Error Discuss

Filed Under: Networking
Exam Prep: AIEEE , Bank Exams
Job Role: Analyst , Bank Clerk , IT Trainer , Network Engineer

39 28581
Q:

 A goal of data mining includes which of the following?

A) To explain some observed event or condition B) To analyze data for expected relationships
C) To confirm that data exists D) To create a new data warehouse
 
Answer & Explanation Answer: A) To explain some observed event or condition

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

42 27633
Q:

What will output when you compile and run the following code?

#include <stdio.h>
struct student
{

int roll;
int cgpa;
int sgpa[8];

};

void main()
{

struct student s = { 12,8,7,2,5,9 };
int *ptr;
ptr = (int *)&s;
clrscr();
printf( "%d", *(ptr+3) );
getch();

}

A) 8 B) 7
C) 2 D) Compiler error
 
Answer & Explanation Answer: C) 2

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Programming

1 27111
Q:

What are the typical elements of a process image?

Answer

User data: Modifiable part of user space. May include program data, user stack area, and programs that may be modified.


User program: The instructions to be executed.


System Stack: Each process has one or more LIFO stacks associated with it. Used to store parameters and calling addresses for procedure and system calls.


Process control Block (PCB): Info needed by the OS to control processes.

Report Error

View answer Workspace Report Error Discuss

26 26394
Q:

Unreachable code would best be found using

A) code inspections B) a static analysis tool
C) code reviews D) a test management tool
 
Answer & Explanation Answer: C) code reviews

Explanation:

Code review is a software quality assurance activity in which one or several humans check a program mainly by viewing and reading parts of its source code, and they do so after implementation or as an interruption of implementation.

Report Error

View Answer Report Error Discuss

23 26246
Q:

Physical or logical arrangement of network is

A) Topology B) Routing
C) Both A & B D) Networking
 
Answer & Explanation Answer: A) Topology

Explanation:

The logical arrangement of the nodes of different networks to communicate is called as topology.

Report Error

View Answer Report Error Discuss

41 25854
Q:

If no multivalued attributes exist and no partial dependencies exist in a relation, then the relation is in what normal form?

A) First normal form B) Second normal form
C) Third normal form D) Fourth normal form
 
Answer & Explanation Answer: B) Second normal form

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

27 25847