PL/SQL :: Basic Concepts

Home > Technical Aptitude > PL/SQL > Basic Concepts > General Questions
NA
SHSTTON
71
Solv. Corr.
43
Solv. In. Corr.
114
Attempted
1 M:23 S
Avg. Time

1 / 41

Choose the correct option.

You can add a row using SQL in a database with which of the following?


AADD

BCREATE

CINSERT

DMAKE

Answer: Option C

Explanation:

Here is no explanation for this answer

Workspace

NA
SHSTTON
91
Solv. Corr.
46
Solv. In. Corr.
137
Attempted
0 M:0 S
Avg. Time

2 / 41

Choose the correct option.

The command to remove rows from a table 'CUSTOMER' is:


AREMOVE FROM CUSTOMER ...

BDROP FROM CUSTOMER ...

CDELETE FROM CUSTOMER WHERE ...

DUPDATE FROM CUSTOMER ...

Answer: Option C

Explanation:

DELETE FROM CUSTOMER WHERE ...

Workspace

NA
SHSTTON
27
Solv. Corr.
105
Solv. In. Corr.
132
Attempted
0 M:0 S
Avg. Time

3 / 41

Choose the correct option.

The SQL WHERE clause:


Alimits the column data that are returned.

Blimits the row data are returned.

CBoth A and B are correct.

DNeither A nor B are correct.

Answer: Option B

Explanation:

limits the row data are returned.

Workspace

NA
SHSTTON
87
Solv. Corr.
45
Solv. In. Corr.
132
Attempted
0 M:0 S
Avg. Time

4 / 41

Choose the correct option.

The command to eliminate a table from a database is:


AREMOVE TABLE CUSTOMER;

BDROP TABLE CUSTOMER;

CDELETE TABLE CUSTOMER;

DUPDATE TABLE CUSTOMER;

Answer: Option B

Explanation:

If you actually want to remove the table definitions as well as the data, simply drop the tables.
TRUNCATE TABLE empties it, but leaves its structure for future dat Like TRUNCATE TABLE CUSTOMER.
Removes all rows from a table without logging the individual row deletions

Workspace

NA
SHSTTON
42
Solv. Corr.
88
Solv. In. Corr.
130
Attempted
0 M:0 S
Avg. Time

5 / 41

Choose the correct option.

ON UPDATE CASCADE ensures which of the following?


ANormalization

BData Integrity

CMaterialized Views

DAll of the above.

Answer: Option B

Explanation:

ON UPDATE CASCADE is used for checking data in the table after ALTER operation.
Example: Alter table emp add constraint Unique Key (DID) ON UPDATE CASCADE. This will restrict the update operation if any dublicate values exists.

Workspace

NA
SHSTTON
85
Solv. Corr.
29
Solv. In. Corr.
114
Attempted
0 M:0 S
Avg. Time

6 / 41

Choose the correct option.

SQL data definition commands make up a(n) ________ .


ADDL

BDML

CHTML

DXML

Answer: Option A

Explanation:

Oracle SQL Do support XML to be inserted into the DB table. The Datatype for XML is XMLType.
We use extract() and existsNode() like functions to access the XML data into DB.

Workspace

NA
SHSTTON
73
Solv. Corr.
41
Solv. In. Corr.
114
Attempted
0 M:0 S
Avg. Time

7 / 41

Choose the correct option.

Which of the following is valid SQL for an Index?


ACREATE INDEX ID;

BCHANGE INDEX ID;

CADD INDEX ID;

DREMOVE INDEX ID;

Answer: Option A

Explanation:

Index is created to make the searches (select query) faster. But to use the index we need to write the SQL select statement using the column on which we created the Index.
Example: Create index indx1 on emp (empno). To use the benefits, we have to write select * from emp where empno > 0;

Workspace

NA
SHSTTON
49
Solv. Corr.
54
Solv. In. Corr.
103
Attempted
0 M:6 S
Avg. Time

8 / 41

Choose the correct option.

In which three cases would you use the USING clause? (Choose three.)


AThe tables to be joined have columns of the same name and different data types.

BThe tables to be joined have multiple NULL columns.

CThe tables to be joined have columns with the same name and compatible data types.

DYou want to use a NATURAL join, but you want to restrict the number of columns in the join condition.

EA, C & D

Answer: Option E

Explanation:

Here is no explanation for this answer

Workspace

NA
SHSTTON
78
Solv. Corr.
28
Solv. In. Corr.
106
Attempted
0 M:0 S
Avg. Time

9 / 41

Choose the correct option.

Which of the following is the original purpose of SQL?


ATo specify the syntax and semantics of SQL data definition language

BTo specify the syntax and semantics of SQL manipulation language

CTo define the data structures

DAll of the above.

Answer: Option D

Explanation:

All of the above.

Workspace

NA
SHSTTON
28
Solv. Corr.
72
Solv. In. Corr.
100
Attempted
0 M:0 S
Avg. Time

10 / 41

Choose the correct option.

The wildcard in a WHERE clause is useful when?


AAn exact match is necessary in a SELECT statement.

BAn exact match is not possible in a SELECT statement.

CAn exact match is necessary in a CREATE statement.

DAn exact match is not possible in a CREATE statement.

Answer: Option B

Explanation:

Wildcards are basically for pattern matching.
Select * from emp where ename like = 'A%'; - Lists all emps with starting
Likewise % (For ignoring any number of characters) and _(Only one character).

Workspace

PL/SQL Basic Concepts Questions and Answers pdf

At PL/SQL topic Basic Concepts page No: 1 you will find list of 10 practice questions, tips/trick and shortcut to solve questions, solved questions, quiz, and download option to download the whole question along with solution as pdf format for offline practice. You can practice all the listed PL/SQL Basic Concepts topic questions offline too, by downloading the MCQs practice question of Basic Concepts with detail solution, with formula/Tips & Tricks, with Solved examples and with top-rated users answers, which will give you best answer ascross webs. It is one of the perfect Basic Concepts e-book pdf covering all types of questions in detail. These PL/SQL test with answers pdf cover all types of question asked in IIFT, XAT, SNAP, GRE, GMAT, NMAT, CMAT, MAT or for IT companies written exam like Wipro, HCL, Infosys, Accenture, Government exams, IBPS Exams etc. There are multiple formats to download your online free PL/SQL Basic Concepts e-book, like fully solved, unsolved questions with Answers sheet. Even you can customize your ebook format by adjusting the given options in the download section to make it your one of the best PL/SQL topic-based ebook. It is recommended to bookmark this page PL/SQL Basic Concepts for your preparation. Most of the students and fresher candidates finding it hard to clear the PL/SQL section in exams. Here Given Basic Concepts practice questions, quiz, fully solved questions, tips & trick and Mock tests, which include question from each topic will help you to excel in Basic Concepts. Each test has all the basics questions to advanced questions with answer and explanation for your clear understanding, you can download the test result as pdf for further reference.

At PL/SQL topic Basic Concepts, you will get multiple online quiz difficulty wise, which will have a total of 6 quizzes, categorized as easy, medium, and moderate level. While preparing for any Basic Concepts, take all the list quiz and check your preparation level for that topic. Each quiz have 10 different question, which needs to be answered in 20 min., all the listed quiz here is free, however, you will get only one chance for each quiz to attempt(Take Quiz seriously), so it is always recommended to take one quiz in each section before you start solving Basic Concepts MCQs practice question, and one after solving all the question of the respective level, you can refer back your Basic Concepts quiz result any time or you can download it as pdf for reference.

PL/SQL Quiz Online Test

The details of the PL/SQL quiz are as follows. There are 10 questions for you. You have to answer them in 20 minutes. Within 20 minutes you have to see the errors in the sentences given as a question. Four options are also given to you, and you have to choose your opinion. You must be confident in your answer that the choices are difficult. Therefore, below we provide you with some information about PL/SQL that you see and keep them in mind while answering questions.

PL/SQL MCQs Practice Questions with Answer

On this section of page you will find the easiest quickest ways to solve a question, formulas, shortcuts and tips and tricks to solve various easiest methods to solve PL/SQL Question Quickly. It contains all the PL/SQL topic Basic Concepts questions which are common in any of the preliminary exams of any company. The solution is provided along with the questions. The practice of these questions is a must as they are easy as well as scoring and asked in all the exams They will confirm the selection if all the questions attempted wisely with little practice. It is recommanded to Take Mock test based on PL/SQL topic and Basic Concepts topic based quiz.

PL/SQL solved examples question

Clarity of concepts is a must if you want to master the skill of solving PL/SQL problems. This page contains sample PL/SQL questions and answers for freshers and competitive exams. PL/SQL Questions with the detailed description, the explanation will help you to master the topic. Here solved examples with detailed answer description, explanations are given and it would be easy to understand. How to solve questions relating to PL/SQL? Here are some examples solved with the Common Rules/tricks/tips of PL/SQL. Enhance your chance to score maximum marks in PL/SQL sections through. Error Spotting Grammar Questions Online Test for Free. Fully solved Sentence Formation MCQs questions with detailed answer description. PL/SQL is an important topic for any exams but most aspirants find it difficult. You need to learn various tricks tips, rules, etc to solve quickly. At this page, you will find frequently asked PL/SQL questions or problems with solutions, shortcuts, formulas for all-important competitive exams like IT companies exams, interviews. It is always a best practice to go through the example and understand the types of question and way to solve it, so let's do some examples to calculate efficiency, read through all the given here solved examples. You can post your solution, tips, trick and shortcut if you have any in respect to questions.

You can get here fully solved Basic Concepts examples with a detailed answer and description. You can solve Basic Concepts problems with solutions, the questions by companies wise by filtering the questions, additionally, you can check what type of questions are being asked in IT companies Written Round from Basic Concepts. Basic Concepts became one of the most important sections in the entire competitive exams, Companies Campus, and entrance online test. Go through Basic Concepts Examples, Basic Concepts sample questions. You can Evaluate your level of preparation in Basic Concepts by Taking the Q4Interivew Basic Concepts Online Mock Test based on most important questions. All the Basic Concepts practice questions given here along with answers and explanations are absolutely free, you can take any number of time any mock Test.

Why PL/SQL Basic Concepts?

In this practice section, you can practice PL/SQL Questions based on "Basic Concepts" and improve your skills in order to face the interview, competitive examination, IT companies Written exam, and various other entrance tests (CAT, GATE, GRE, MAT, Bank Exam, Railway Exam etc.) with full confidence.

Where can I get PL/SQL Basic Concepts questions and answers with explanation?

Q4Interview provides you lots of fully solved PL/SQL (Basic Concepts) questions and answers with Explanation. Solved examples with detailed answer description, explanation are given and it would be easy to understand. You can download PL/SQL Basic Concepts quiz questions with answers as PDF files and eBooks.

Where can I get PL/SQL Basic Concepts Interview Questions and Answers (objective type, multiple-choice, quiz, solved examples)?

Here you can find objective type PL/SQL Basic Concepts questions and answers for interview and entrance examination. Multiple choice and true or false type questions are also provided.