Q.1.
With SQL, how can you insert "Olsen" as the "LastName" in the "Persons" table?
Q.2.
What is a record?
Q.3.
Which of the following is NOT a SQL command?
Q.4.
What does database contains?
Q.5.
Which operator is used to search for a specified pattern in a column?
Q.6.
The NOT NULL constraint enforces a column to not accept NULL values.
Q.7.
What is used in the database for entering data by a user?
Q.8.
What type of data does a field can hold
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
Q.10.
With SQL, how can you return all the records from a table named "Persons" sorted descending by "FirstName"?
Q.11.
With SQL, how can you delete the records where the "FirstName" is "Peter" in the Persons Table?
Q.12.
A primary key can be NULL in the table? TRUE or FALSE
Q.13.
Oracle predefined errors are NOT associated with specific error codes.
Q.14.
___________ is the skeleton structure that represents the logical view of the entire database
Q.15.
Rollback is the type of __________
Q.16.
_________ has the least control of the database
Q.17.
PL_SQL stands for ?
Q.18.
PL/SQL is developed by Oracle in
Q.19.
PL/SQL fully supports SQL data types
Q.20.
A PL/SQL block is defined by the keywords