Interview Questions

Q:

What are the basic SQL*Plus commands?

Answer

1) START- Used to run a SQL script.
2) ACCEPT- Accepts input from user.
3) GET- Gets the sql file from user to place in buffer.
4) LIST- Displays the last command executed.
5) RUN- Used to list and run the command in buffer
6) SHOW- Shows the environment settings. Example: SHOW PAGESIZE

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

0 1831
Q:

In a database table, the category of information is called

A) Record B) Field
C) Tuple D) None of the above
 
Answer & Explanation Answer: B) Field

Explanation:

In a database table, the category of information is called Field.

Report Error

View Answer Report Error Discuss

0 1830
Q:

What are windows object and navigator object in JavaScript?

Answer

Windows object is top level object in Java script. It contains several other objects such as, document, history, location, name, menu bar etc., in itself. Window object is the global object for Java script that is written at client-side.


Information pertaining to the client browser and system is returned by the navigator object of JavaScript. Navigator object is the top level object for all users.

Report Error

View answer Workspace Report Error Discuss

Subject: Web Technology

0 1830
Q:

What is the use of FOR XML in SQL Server?

Answer

SQL Server is having a fantastic feature to retrieve data persisted in the form of XML format. The data in the XML format can be retrieved using FOR XML clause appending to the SELECT statement.


It offers 3 modes.


- “FOR XML AUTO": Returns XML elements that are nested, based on which tables are listed in the "from" part of the query, and which fields are listed in the "select" part.


- "FOR XML RAW": Returns XML elements with the "row" prefix (ex: ""). Each column in a table is represented as an attribute and null column values aren't included.


- "FOR XML EXPLICIT": Explicit mode is the most complex shaping method used in SQL Server 2000. It allows users to query a data source in such a way that the names and values of the returned XML are specified before the query batch is executed. 

Report Error

View answer Workspace Report Error Discuss

Subject: Web Technology

0 1829
Q:

Describe the functionality of accelerometer of an iphone

Answer

iPhone responds to motion using a built-in accelerometer.
The accelerometer detects the movement and changes the display accordingly, at the time of rotating iPhone from portrait to landscape. 

Report Error

View answer Workspace Report Error Discuss

0 1827
Q:

Explain about Blackberry Operating System.

Answer

Research in Motion, a Canadian company provided a proprietary operating system for BlackBerry.

The operating system provides support for Java MIDP 1.0 and WAP 1.2.

The current version supports Novell Group Wise and Lotus Notes.

Third-party software can be developed using BlackBerry APIs as well, with certain restriction functionality must be signed by RIM digitally, so that it can be associated to a developer account. 

Report Error

View answer Workspace Report Error Discuss

0 1823
Q:

What is the security mechanism used in java?

Answer

Java uses sand box security model.

Report Error

View answer Workspace Report Error Discuss

Subject: Java

0 1820
Q:

What are the problems in processing batch input sessions and How is batch input process different from processing online ?

Answer

PROBLEMS:


i) If the user forgets to opt for keep session then the session will be automatically removed from the session queue(log remains). However if session is processed we may delete it manually.


ii)if session processing fails data will not be transferred to SAP database table.

Report Error

View answer Workspace Report Error Discuss

Subject: SAP

0 1818