Q.1
I write the following block of code:
  • WHEN PROGRAM_ERRORTHEN DBMS_OUTPUT.put_line ('PL/SQL is fantastic!');
  • WHEN PROGRAM_ERRORTHEN DECLARE l_fact VARCHAR2 (100) := 'PL/SQL is fantastic!'; BEGIN DBMS_OUTPUT.put_line (l_fact); END;
  • WHEN OTHERS THEN DBMS_OUTPUT.put_line ('PL/SQL is fantastic!');
  • All Of above
Q.2
_________ Block are optional Blocks.
  • Exception Handling
  • Declaration
  • Both A & B
  • None of the above
Q.3
______ block are obligatory block
  • Declaration
  • Execution
  • Exception Handling
  • None of the above
Q.4
PL/SQL stands for
  • procedural Language extension to SQL
  • procedural extension of SQL
  • programming language of sql
  • None
Q.5
PL/SQL has these advantages:
  • Tight Integration with SQL
  • High Performance
  • Tight Security
  • all
Q.6
What is the full form of SQL?
  • Structured Query Language
  • Simple Query Language
  • Structured Question Language
  • Structure Quality Language
Q.7
What is the Full form of DBMS
  • Data Base Management Studies
  • Data Base Mein se
  • Data Base Management System
  • Data Byte Management System
Q.8
Which operator is used to select values within a range?
  • RANGE
  • WITHIN
  • BETWEEN
  • None of these
Q.9
DBMS is an Interface between?
  • Database and developer
  • Database and Administrator
  • Database and End User
  • Database and Software
Q.10
Which SQL statement is used to create a table in a database?
  • CREATE DATABASE TABLE
  • CREATE DB
  • CREATE TABLE
  • CREATE DATABASE TAB
Q.11
What are the Different Types of Keys?
  • Primary Key and Secondary Key
  • Foreign Key and Secondary Key
  • Indian Key and Foreign Key
  • Primary Key and Foreign Key
Q.12
What is the most common type of join?
  • JOINED
  • INNER JOIN
  • INSIDE JOIN
  • JOINED TABLE
Q.13
With SQL, how can you insert a new record into the "Persons" table?
  • INSERT INTO Persons VALUES ('Jimmy', 'Jackson')
  • INSERT VALUES ('Jimmy', 'Jackson') INTO Persons
  • INSERT ('Jimmy', 'Jackson') INTO Persons
  • All Of above
Q.14
_____cursor is declared by ORACLE for each UPDATE, DELETE and INSERT SQL commands.
  • Internal
  • External
  • Implicit
  • Explicit
Q.15
With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"?
  • SELECT * FROM Persons WHERE FirstName='Peter'
  • SELECT [all] FROM Persons WHERE FirstName='Peter'
  • SELECT * FROM Persons WHERE FirstName<>'Peter'
  • SELECT [all] FROM Persons WHERE FirstName LIKE 'Peter'
Q.16
What are the characteristics of DBMS?
  • Real-world entity
  • Less Redundancy
  • Relation based Tables
  • All of the above
Q.17
How can you change "Hansen" into "Nilsen" in the "LastName" column in the Persons table?
  • UPDATE Persons SET LastName='Nilsen' WHERE LastName='Hansen'
  • UPDATE Persons SET LastName='Hansen' INTO LastName='Nilsen'
  • MODIFY Persons SET LastName='Nilsen' WHERE LastName='Hansen'
  • MODIFY Persons SET LastName='Hansen' INTO LastName='Nilsen
Q.18
Which of the following is true about the execution section of a PL/SQL block
  • It is enclosed between the keywords BEGIN and END.
  • It is a mandatory section.
  • It consists of the executable PL/SQL statements.
  • All of the above.
Q.19
Which SQL statement is used to delete data from a database?
  • DELETE
  • COLLAPSE
  • REMOVE
  • Both A & B
Q.20
Which SQL statement is used to extract data from a database?
  • SELECT
  • OPEN
  • GET
  • EXTRACT
0 h : 0 m : 1 s