Database Mock Test - 2
9 Questions
| Total Attempts: 1317
This is a simple quiz which is created for test your basic data base knowledge!
Questions and Answers
- 1.What does a positive value of SQL code mean?
- A.
Error
- B.
Successful execution
- C.
No rows found
- 2.. AUTOMATIC RECOMPILATION occurs when
- A.
A existing index is dropped.
- B.
A new index is created.
- C.
Both (A) and (B).
- 3.Collections are essentially just a means of giving a name to a logically related set of packages
- A.
True
- B.
False
- 4.Cartesian product ‘ is the result of a join that does not specify matching columns
- A.
True
- B.
False
- 5.13 Group By does not do any sorting .
- A.
True
- B.
False
- 6.. In EXIST operator when a match is found, the query ends processing for that row
- A.
True
- B.
False
- 7.. GRANT SELECT ON EMPTAB TO USER is a correct syntax
- A.
True
- B.
False
- 8.Performed for each row in the result table
- A.
Scalar function
- B.
Group by
- C.
Aggregate function
- 9.. What is single bound DBRM with optimized access path .
- A.
1) PLAN
- B.
2) PACKAGE
- C.
3) BIND
Below is a Relational Database Trivia Quiz! It is designed to help you understand how databases holding the same information are structured and maintained. Do you think that you have what it takes to tackle it based on what you...
Questions: 9 | Attempts: 8211 | Last updated: Apr 2, 2021
-
Sample QuestionWhich of the following makes it possible for entities toshare a relationship?
Ever wondered how much you know about DBMS, or the Database Management System? For this quiz, you should know what is responsible for authorizing access to the databases and obtaining software and hardware services, what is a...
Questions: 31 | Attempts: 5841 | Last updated: May 6, 2021
-
Sample Question-------------------------------responsible for authorizing access to the database, for coordinating and monitoring its use, acquiring software, and hardware resources, controlling its use, andmonitoring efficiency of operations.
Questions: 22 | Attempts: 5851 | Last updated: Jan 28, 2013
-
Sample QuestionWhat are the basic components of a linked list?
Back to top