MCQGeeks
0 : 0 : 1
CBSE
JEE
NTSE
NEET
English
UK Quiz
Quiz
Driving Test
Practice
Games
Quiz
Computer Science
Pl/Sql
Quiz 2
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
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
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Report Question
×
What's an issue?
Question is wrong
Answer is wrong
Other Reason
Want to elaborate a bit more? (optional)
Support mcqgeeks.com by disabling your adblocker.
×
Please disable the adBlock and continue.
Thank you.
Reload page