Q.1
With SQL, how can you insert "Olsen" as the "LastName" in the "Persons" table?
  • INSERT INTO Persons ('Olsen') INTO LastName
  • INSERT INTO Persons (LastName) VALUES ('Olsen')
  • INSERT ('Olsen') INTO Persons (LastName)
Q.2
What is a record?
  • Each row in a table is a Record
  • Each column in a table is a Record
  • Every table is a Record
  • Only One name is a Record
Q.3
Which of the following is NOT a SQL command?
  • SELECT
  • FROM
  • LIKE
  • SIMILAR
  • DISTINCT
Q.4
What does database contains?
  • Tables and relations between them
  • Rows and Columns
  • Only raw Data
  • Excel Sheets
Q.5
Which operator is used to search for a specified pattern in a column?
  • FROM
  • GET
  • LIKE
  • None of these
Q.6
The NOT NULL constraint enforces a column to not accept NULL values.
  • True
  • False
Q.7
What is used in the database for entering data by a user?
  • Excel Sheets
  • Forms
  • SQL software
  • PL SQL Software
Q.8
What type of data does a field can hold
  • Only Numbers
  • Only Date
  • Only Text
  • All of the Above
Q.9
The OR operator displays a record if ANY conditions listed are true. The AND operator displays a record if ALL of the conditions listed are true
  • True
  • False
Q.10
With SQL, how can you return all the records from a table named "Persons" sorted descending by "FirstName"?
  • SELECT * FROM Persons ORDER BY FirstName DESC
  • SELECT * FROM Persons ORDER FirstName DESC
  • SELECT * FROM Persons SORT 'FirstName' DESC
  • SELECT * FROM Persons SORT BY 'FirstName' DESC
Q.11
With SQL, how can you delete the records where the "FirstName" is "Peter" in the Persons Table?
  • DELETE ROW FirstName='Peter' FROM Persons
  • DELETE FirstName='Peter' FROM Persons
  • DELETE FROM Persons WHERE FirstName = 'Peter'
  • None of these
Q.12
A primary key can be NULL in the table? TRUE or FALSE
  • TRUE
  • FALSE
Q.13
Oracle predefined errors are NOT associated with specific error codes.
  • True
  • False
Q.14
___________ is the skeleton structure that represents the logical view of the entire database
  • Database Tables
  • Database Rows and Columns
  • Database Schema
  • Database fields
Q.15
Rollback is the type of __________
  • Data Definition Language
  • Data Manipulation Language
  • Data Control language
  • Transaction Control Language
Q.16
_________ has the least control of the database
  • Administrators
  • End Users
  • Designers
  • Developers
Q.17
PL_SQL stands for ?
  • Procedural Language, Structured Query Language
  • Programming Language, Standard Query Language
  • Procedural Language, Standard Query Language
  • Programming Language, Structured Query Language
Q.18
PL/SQL is developed by Oracle in
  • 1970s
  • 1990s
  • 1960s
  • 1980s
Q.19
PL/SQL fully supports SQL data types
  • yes
  • No
Q.20
A PL/SQL block is defined by the keywords
  • Declare
  • BEGIN
  • EXCEPTION
  • all
0 h : 0 m : 1 s