Solved MCQ of PL/SQL and Oracle set-1

1. ........................ is a procedural extension of Oracle - SQL that offers language constructs similar to those in imperative programming languages.
A) SQL
B) PL/SQL
C) Advanced SQL
D) PQL

2. .................... combines the data manipulating power of SQL with the data processing power of Procedural languages.
A) PL/SQL
B) SQL
C) Advanced SQL
D) PQL

3. ................... has made PL/SQL code run faster without requiring any additional work on the part of the programmer.
A) SQL Server
B) My SQL
C) Oracle
D) SQL Lite

4. A line of PL/SQL text contains groups of characters known as .......................
A) Lexical Units
B) Literals
C) Textual Units
D) Identifiers

5. We use ........................ name PL/SQL program objects and units.
A) Lexical Units
B) Literals
C) Delimiters
D) Identifiers

6. A .................... is an explicit numeric, character, string or Boolean value not represented by an identifier.
A) Comments
B) Literals
C) Delimiters
D) Identifiers

7. If no header is specified, the block is said to be an ...................... PL/SQL block.
A) Strong
B) Weak
C) Empty
D) Anonymous

8. ............. is a sequence of zero or more characters enclosed by single quotes.
A) Integers literal
B) String literal
C) String units
D) String label

9. In ........................, the management of the password for the account can be handled outside of oracle such as operating system.
A) Database Authentication

B) Operating System Authentication
C) Internal Authentication
D) External Authentication

10. In ............................ of Oracle, the database administrator creates a user account in the database for each user who needs access.
A) Database Authentication
B) Operating System Authentication
C) Internal Authentication
D) External Authentication

Answers:

1. B) PL/SQL
2. A) PL/SQL
3. C) Oracle
4. A) Lexical Units
5. D) Identifiers
6. B) Literals
7. D) Anonymous
8. B) String literal
9. B) Operating System Authentication
10.A) Database Authentication

You Might also view the following Related Posts

• MCQ of PL/SQL and Oracle With Answer set -2
• Solved MCQ of SQL Server set-1
• Solved MCQ of Internet and HTML set-1
• Solved MCQ of Data Structure Set-2  
• Solved MCQ of Data Structure Set-1
• MCQ of Structured Query Language(SQL) With Answer Set -2
• Solved MCQ of Database Management System (DBMS) Set - 3

You can view the following other posts

• Solved MCQ of System Analysis and Design Set-3
• Solved MCQ of Data Structure Set - 2
• Solved MCQ of Java for Java Proficiency test set-3
• MCQ of C++ with answer Set-2
• Solved MCQ of C set-1
• MCQ of Computer Networking with answer set-4
• Solved MCQ of Database Management System (DBMS) Set - 8

For other more Multiple Choice Questions (MCQs): Click Here