Exercise : Oracle SQL PLSQL MCQ Questions and Answers
1. The SQL WHERE clause:
| A. |
| B. |
| C. |
| D. |
Correct Answer : B. II. limits the row data are returned.
Description :
No answer description available for this question. Let us discuss.
View Answer
50/50
Workspace
Report
Discuss
2. With which type of SQL Server recovery model, is no logging done?
| A. |
| B. |
| C. |
| D. |
Correct Answer : B. Simple recovery
Description :
No answer description available for this question. Let us discuss.
View Answer
50/50
Workspace
Report
Discuss
3. What MySQL property is used to create a surrogate key in MySQL?
| A. |
| B. |
| C. |
| D. |
Correct Answer : D. AUTO_INCREMENT
Description :
No answer description available for this question. Let us discuss.
View Answer
50/50
Workspace
Report
Discuss
4. A reason for using an SQL view to hide columns is:
| A. |
| B. |
| C. |
| D. |
Correct Answer : A. to accomplish both of the above.
Description :
No answer description available for this question. Let us discuss.
View Answer
50/50
Workspace
Report
Discuss
5. SQL Server automatically creates an index on:
| A. |
| B. |
| C. |
| D. |
Correct Answer : D. both primary and foreign keys.
Description :
No answer description available for this question. Let us discuss.
View Answer
50/50
Workspace
Report
Discuss
6. The benefits of a standard relational language include which of the following?
| A. |
| B. |
| C. |
| D. |
Correct Answer : D. Reduced training costs
Description :
No answer description available for this question. Let us discuss.
View Answer
50/50
Workspace
Report
Discuss
7. The Microsoft Access wildcards are ____ and ____ .
| A. |
| B. |
| C. |
| D. |
Correct Answer : A. question mark (?); asterisk (*)
Description :
No answer description available for this question. Let us discuss.
View Answer
50/50
Workspace
Report
Discuss
8. Which of the following is NOT a type of SQL constraint?
| A. |
| B. |
| C. |
| D. |
Correct Answer : D. ALTERNATE KEY
Description :
No answer description available for this question. Let us discuss.
View Answer
50/50
Workspace
Report
Discuss
9. What is not an advantage of stored procedures?
| A. |
| B. |
| C. |
| D. |
Correct Answer : A. Increased network traffic
Description :
No answer description available for this question. Let us discuss.
View Answer
50/50
Workspace
Report
Discuss
10. With which type of SQL Server recovery model are all database changes logged?
| A. |
| B. |
| C. |
| D. |
Correct Answer : B. Full recovery
Description :
No answer description available for this question. Let us discuss.
View Answer
50/50
Workspace
Report
Discuss