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

17 17219
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

14 16337
Q:

#define clrscr() 100

main()

{

clrscr();

printf( "%dn", clrscr() );

}

A) 100 B) 0
C) Compilation error D) Exception occurs
 
Answer & Explanation Answer: A) 100

Explanation:

Preprocessor executes as a seperate pass before the execution of the compiler. So textual replacement of clrscr() to 100 occurs.The input program to compiler looks like this :

main ()

{

100;

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

}

Note: 100; is an executable statement but with no action. So it doesn't give any problem.

Report Error

View Answer Report Error Discuss

Filed Under: Programming

10 16214
Q:

 For what purposes are views used?

A) To hide rows only B) To hide columns only
C) To hide complicated SQL statements only D) All of the above are uses for SQL views.
 
Answer & Explanation Answer: D) All of the above are uses for SQL views.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

12 15841
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

13 15530
Q:

List out some reasons for process termination.

Answer

- Normal completion


- Time limit exceeded


- Memory unavailable


- Bounds violation


- Protection error


- Arithmetic error


- Time overrun


- I/O failure


- Invalid instruction


- Privileged instruction


- Data misuse


- Operator or OS intervention


- Parent termination.

Report Error

View answer Workspace Report Error Discuss

22 14984
Q:

________ is an open source DBMS product that runs on UNIX, Linux and Windows.

A) MySQL B) JSP/SQL
C) JDBC/SQL D) Sun ACCESS
 
Answer & Explanation Answer: A) MySQL

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

25 14630
Q:

What is page cannibalizing?

Answer

Page swapping or page replacements are called page cannibalizing.

Report Error

View answer Workspace Report Error Discuss

22 12730