Exercise : Oracle SQL PLSQL MCQ Questions and Answers
Question 1
SQL is:
| A. |
| B. |
| C. |
| D. |
Correct Answer : B. a data sublanguage.
Description :
No answer description available for this question. Let us discuss.
View Answer
50/50
Workspace
Report
Discuss
Question 2
Which JDBC driver Type(s) can you use in a three-tier architecture and if the Web server and the DBMS are running on the same machine?
| A. |
| B. |
| C. |
| D. |
Correct Answer : D. All of Type 1, Type 2, Type 3 and Type 4
Description :
No answer description available for this question. Let us discuss.
Question 3
A subquery in an SQL SELECT statement:
| A. |
| B. |
| C. |
| D. |
Correct Answer : C. has a distinct form that cannot be duplicated by a join.
Description :
No answer description available for this question. Let us discuss.
Question 4
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 5
In SQL Server 2000, which of the following makes a copy of the changes that have been made to the database since the last complete backup?
| A. |
| B. |
| C. |
| D. |
Correct Answer : A. Differential backup
Description :
No answer description available for this question. Let us discuss.
Question 6
ON UPDATE CASCADE ensures which of the following?
| A. |
| B. |
| C. |
| D. |
Correct Answer : B. Data Integrity
Description :
No answer description available for this question. Let us discuss.
Question 7
With this type of SQL Server cursor concurrency no lock is obtained until the user updates the data.
| A. |
| B. |
| C. |
| D. |
Correct Answer : D. OPTIMISTIC
Description :
No answer description available for this question. Let us discuss.
Question 8
For what purposes are views used?
| A. |
| B. |
| C. |
| D. |
Correct Answer : C. All of these are uses for SQL views.
Description :
No answer description available for this question. Let us discuss.
Question 9
SQL data definition commands make up a(n) ________ .
| A. |
| B. |
| C. |
| D. |
Correct Answer : C. DDL
Description :
No answer description available for this question. Let us discuss.
Question 10
The command to eliminate a table from a database is:
| A. |
| B. |
| C. |
| D. |
Correct Answer : D. DROP TABLE CUSTOMER;
Description :
No answer description available for this question. Let us discuss.