Java J2ee Planet

1. SNAPSHOT is used for [DBA] a] Synonym, b] Table space, c] System server, d] Dynamic data replication Ans : D 2. We can create SNAPSHOTLOG for [DBA] a] Simple snapshots, b] Complex snapshots, c] Both A & B, d] Neither A nor B Ans : A 3. Transactions per rollback segment is derived from [DBA] a] Db_Block_Buffers, b] Processes, c] Shared_Pool_Size, d] None of the above Ans : B 4. ENQUEUE resources parameter information is derived from [DBA] a] Processes or DDL_LOCKS and DML_LOCKS, b] LOG_BUFFER, c] DB__BLOCK_SIZE.. Ans : A 5. LGWR process writes information into a] Database files, b] Control files, c] Redolog files, d] All the above. Ans : C 6. SET TRANSACTION USE ROLLBACK SEGMENT is used to create user objects in a particular Tablespace a] True, b] False Ans : False 7. Databases overall structure is maintained in a file called a] Redolog file, b] Data file, c] Control file, d] All of the above. Ans : C 8. These following parameters are option

1. What is PL/SQL ? PL/SQL is a procedural language that has both interactive SQL and procedural programming language constructs such as iteration, conditional branching. 2. What is the basic structure of PL/SQL ? PL/SQL uses block structure as its basic structure. Anonymous blocks or nested blocks can be used in PL/SQL. 3. What are the components of a PL/SQL block ? A set of related declarations and procedural statements is called block. 4. What are the components of a PL/SQL Block ? Declarative part, Executable part and Exception part. Datatypes PL/SQL 5. What are the datatypes a available in PL/SQL ? Some scalar data types such as NUMBER, VARCHAR2, DATE, CHAR, LONG, BOOLEAN. Some composite data types such as RECORD & TABLE. 6. What are % TYPE and % ROWTYPE ? What are the advantages of using these over datatypes? % TYPE provides the data type of a variable or a database column to that variable. % ROWTYPE provides the record type that represents a entire row o

1. What are the types of SQL Statement ? Data Definition Language : CREATE,ALTER,DROP,TRUNCATE,REVOKE,NO AUDIT & COMMIT. Data Manipulation Language : INSERT,UPDATE,DELETE,LOCK TABLE,EXPLAIN PLAN & SELECT. Transactional Control : COMMIT & ROLLBACK Session Control : ALTERSESSION & SET ROLE System Control : ALTER SYSTEM. 2. What is a transaction ? Transaction is logical unit between two commits and commit and rollback. 3. What is difference between TRUNCATE & DELETE ? TRUNCATE commits after deleting entire table i.e., can not be rolled back. Database triggers do not fire on TRUNCATE DELETE allows the filtered deletion. Deleted records can be rolled back or committed. Database triggers fire on DELETE. 4. What is a join ? Explain the different types of joins ? Join is a query which retrieves related columns or rows from multiple tables. Self Join - Joining the table with itself. Equi Join - Joining two tables by equating two common columns. Non-Equi

Data Base Administration 51. What are the responsibilities of a Database Administrator ? Installing and upgrading the Oracle Server and application tools. Allocating system storage and planning future storage requirements for the database system. Managing primary database structures (tablespaces) Managing primary objects (table, views, indexes) Enrolling users and maintaining system security. Ensuring compliance with Oracle license agreement Controlling and monitoring user access to the database. Monitoring and optimising the performance of the database. Planning for backup and recovery of database information. Maintain archived data on tape Backing up and restoring the database. Contacting Oracle Corporation for technical support. 52. What are the roles and user accounts created automatically with the database ? DBA - role Contains all database system privileges. SYS user account - The DBA role will be assigned to this account. All of the basetables and views for t

What is iText iText is an ideal library for developers looking to enhance web- and other applications with dynamic PDF document generation and/or manipulation. iText is not an end-user tool. Typically you won't use it on your Desktop as you would use Acrobat or any other PDF application. Rather, you'll build iText into your own applications so that you can automate the PDF creation and manipulation process. For instance in one or more of the following situations: * Due to time or size, the PDF documents can't be produced manually. * The content of the document must be calculated or based on user input. * The content needs to be customized or personalized. * The PDF content needs to be served in a web environment. * Documents are to be created in "batch process" mode. You can use iText to * Serve PDF to a browser * Generate dynamic documents from XML files or databases * Use PDF's many interactive features * Add bookmarks, page numbers, watermarks,