MCQs > IT & Programming > Oracle Database MCQs > General MCQs

General MCQ for Oracle Database

1. Which syntax turns an existing constraint on?

2. Which of these is not a language element of SQL?

3. What is the purpose of the Rollback command?

4. Which of the following is not DML (Data Manipulation Language)?

5. What is true about this set of statements? CREATE TABLE dept (deptno NUMBER(2), dname VARCHAR2(14), loc VARCHAR2(13)); ROLLBACK; DESCRIBE DEPT;

6. You need to give the MANAGER role the ability to select from, insert into, and modify existing rows in the STUDENT_GRADES table. Anyone given this MANAGER role should be able to pass those privileges on to others. Which statement accomplishes this?

7. How would you display a listing of the sums of employee salaries for those employees not making a commission, for each job type, including only those sums greater than 2500?

8. You need to modify the STUDENTS table to add a primary key on the STUDENT_ID column. The table is currently empty. Which statement accomplishes this task?

9. Which of the following SQL functions can operate on any datatype?

10. What is Extended Rowid?

11. Which DATETIME data types cannot be used when specifying column definitions?

Oracle Database MCQs | Topic-wise

MCQ on Basic Oracle Database General Oracle Database MCQs
Buy us a coffee
Oracle Database Subjects
Basic Oracle Database MCQs
More Resources
Oracle Database Skill Assessment
Oracle Database PDF
Related MCQs
OS (Operating System)
Pay per click (PPC)
Paypal Web Integration
PayPal-Development
Perl
search
Buy us a coffee
Oracle Database Subjects
Basic Oracle Database MCQs
More Resources
Oracle Database MCQ
Oracle Database Skill Assessment
Oracle Database PDF
Related MCQs
OS (Operating System)
Pay per click (PPC)
Paypal Web Integration
PayPal-Development
Perl
Logo

Join our newsletter for the latest updates.

play store app store
Coming Soon

Our Products

Skill Assessment
Categories
MCQs
PDFs
Buy us a coffee

Company

About
Advertising
Privacy Policy
Terms & Conditions
Sitemap
Contact
Blog
Back to top back to top
Logo
play store app store
Coming Soon
Buy us a coffee

© Copyrights 2025 Quizack.com