Exercise : Oracle SQL PLSQL MCQ Questions and Answers
Question 1
SQL data definition commands make up a(n) ________ .
A. |
B. |
C. |
D. |
Correct Answer : A. DDL
Description :
No answer description available for this question. Let us discuss.
Question 2
With this type of SQL Server cursor concurrency no lock is obtained until the user updates the data.
A. |
B. |
C. |
D. |
Correct Answer : C. OPTIMISTIC
Description :
No answer description available for this question. Let us discuss.
Question 3
Which JDBC driver Types are for use over communications networks?
A. |
B. |
C. |
D. |
Correct Answer : A. Both Type 3 and Type 4
Description :
No answer description available for this question. Let us discuss.
Question 4
What MySQL property is used to create a surrogate key in MySQL?
A. |
B. |
C. |
D. |
Correct Answer : B. AUTO_INCREMENT
Description :
No answer description available for this question. Let us discuss.
Question 5
To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included.
A. |
B. |
C. |
D. |
Correct Answer : B. DISTINCT
Description :
No answer description available for this question. Let us discuss.
Question 6
Which of the following is true concerning systems information in an RDBMS?
A. |
B. |
C. |
D. |
Correct Answer : C. All of these.
Description :
No answer description available for this question. Let us discuss.
Question 7
To update an SQL view, the DBMS must be able to associate the column(s) to be updated with:
A. |
B. |
C. |
D. |
Correct Answer : B. a particular row in a particular underlying table.
Description :
No answer description available for this question. Let us discuss.
Question 8
How many copies of a JSP page can be in memory at a time?
A. |
B. |
C. |
D. |
Correct Answer : D. One
Description :
No answer description available for this question. Let us discuss.
Question 9
A UNION query is which of the following?
A. |
B. |
C. |
D. |
Correct Answer : D. Combines the output from multiple queries and must include the same number of columns.
Description :
No answer description available for this question. Let us discuss.
Question 10
Which of the following is not a factor in determining the concurrency control behavior of SQL Server?
A. |
B. |
C. |
D. |
Correct Answer : A. Lock level
Description :
No answer description available for this question. Let us discuss.