Database Mock Test - 2
9 Questions
| Attempts: 1364
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
Recent Quizzes
Featured Quizzes
Popular Topics
- Binary Code Quizzes
- Computer Concept Quizzes
- Computer Essential Quizzes
- Computer Forensics Quizzes
- Computer Hardware Quizzes
- Computer Networking Quizzes
- Computer Parts Quizzes
- Computer Programming Quizzes
- Computer Science Quizzes
- Computer Security Quizzes
- Computer Shortcut Key Quizzes
- Computer Skills Quizzes
- Computer Virus Quizzes
- Cyber Security Quizzes
- Data Quizzes
- Data Security Quizzes
- Hacking Quizzes
- HCI Quizzes
- Internet Quizzes
- IT SecurITy Quizzes
- Malware Quizzes
- Microprocessor Quizzes
- Network Quizzes
- Operating System Quizzes
- Phishing Quizzes
- Programming Language Quizzes
- Server Quizzes
- Software Quizzes
Back to top