Exercise : Oracle SQL PLSQL MCQ Questions and Answers
Question 1
SQL Server 2000 stored procedures can:
| A. |
| B. |
| C. |
| D. |
Correct Answer : A. be kept within the database and invoked by application programs.
Description :
No answer description available for this question. Let us discuss.
View Answer
50/50
Workspace
Report
Discuss
Question 2
In an SQL SELECT statement querying a single table, according to the SQL-92 standard the asterisk (*) means that:
| A. |
| B. |
| C. |
| D. |
Correct Answer : A. all columns of the table are to be returned.
Description :
No answer description available for this question. Let us discuss.
Question 3
What type of join is needed when you wish to return rows that do have matching values?
| A. |
| B. |
| C. |
| D. |
Correct Answer : B. All of these.
Description :
No answer description available for this question. Let us discuss.
Question 4
SQL Server program code that is executed after an SQL command has been processed is called a(n):
| A. |
| B. |
| C. |
| D. |
Correct Answer : C. AFTER trigger.
Description :
No answer description available for this question. Let us discuss.
Question 5
With which type of SQL Server recovery model, is no logging done?
| A. |
| B. |
| C. |
| D. |
Correct Answer : C. Simple recovery
Description :
No answer description available for this question. Let us discuss.
Question 6
Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?
| A. |
| B. |
| C. |
| D. |
Correct Answer : D. Data Definition Language(DDL)
Description :
No answer description available for this question. Let us discuss.
Question 7
Where is metadata stored in MySQL?
| A. |
| B. |
| C. |
| D. |
Correct Answer : B. In the MySQL database mysql
Description :
No answer description available for this question. Let us discuss.
Question 8
Which type of SQL Server cursor concurrency places an update lock on a row when the row is read?
| A. |
| B. |
| C. |
| D. |
Correct Answer : C. READCOMMITTED
Description :
No answer description available for this question. Let us discuss.
Question 9
The wildcard in a WHERE clause is useful when?
| A. |
| B. |
| C. |
| D. |
Correct Answer : C. An exact match is not possible in a SELECT statement.
Description :
No answer description available for this question. Let us discuss.
Question 10
SQL can be used to:
| A. |
| B. |
| C. |
| D. |
Correct Answer : A. All of these can be done by SQL.
Description :
No answer description available for this question. Let us discuss.