Home
10th Grade
11th And 12th
11th Grade
12th Grade
3rd Grade
4th Grade
5th Grade
6th Grade
7th Grade
8th Grade
9th Grade
Advance Accountancy
Auditing
Computer Aptitude
Direct And Indirect Taxation
Exams
General Hindi
Indian Finance System
Information Technology And Application In Business
Macro Economics
Town Planning
Aerospace And Aeronautical
Analytical Instrumentation
Banking Awareness
Banking Exam
Biochemistry
Bioinformatics
Biology
Biotechnology
Business Statistics
C Program
C Programming
C++ Programming
Career Aptitude Test
Cell Biology
Central Superior Service (css)
Chemical Engineering
Chemistry
Civil Engineering
Commerce
Computer
Computer Fundamentals
Computer Science
Cost Accounting
Css
Database
Drug And Pharmaceutical Biotechnology
Ecat And Mcat Entry Test
Economics
Electrical Engineering
Electrical Engineering Questions
Electrical Measurement And Instrumentation
Engineering
English
English Literature
Environment Management
Environmental Biotechnology
Enzyme Technology
Financial Management And Financial Markets
Gate
General Knowledge
Graduate Assessment Test (gat)
Health And Physical
Heat Transfer
Html
Human Anatomy And Physiology
Human And Cultural Diversity
Human Resource Management
Ias
Indian Economy
Indian Economy
Indian General Awareness
Indian Geography
Indian Geography
Indian History
Indian History
Indian Polity
Instrumentation Transducers
International Relations
Java Program
Javascript
Judiciary And Law
Life Sciences
Management
Marketing And Marketing Management
Mass Transfer
Mechanical Engineering
Mechanics Of Materials
Medical Subjects
Microbiology
Networking
Php
Placement Tests
Professional Communication
Quantitative Aptitude
Reasoning Aptitude
Renewable Energy
Science
Sociology
Sql
Surveying
Total Quality Management
Uidai Aadhaar Supervisor Certification
Virology
Notificatin
Exam
Blog
Contact Us
Managing Databases With Oracle(Engineering > Computer Science And Engineering > Database System ) Questions and Answers
Home
Topic
Engineering
Computer Science And Engineering
Database System
Managing Databases With Oracle
Question 1.
Which statement about sequences is not true?
A sequence is an object that generates a sequential series of unique numbers.
NextVal and CurrVal are both sequence methods.
Sequences are most often used to provide values for surrogate keys.
Sequences guarantee valid surrogate key values.
Explanation:-
Answer: Option D. ->
Sequences guarantee valid surrogate key values.
Question 2.
Which of the following is not true about indexes?
Indexes are created to enforce uniqueness on columns.
Indexes are created to enable fast retrieval by column values.
Indexes are created with the ALTER TABLE command.
Columns that are frequently used with equal conditions in WHERE clauses are good candidates for indexes.
Explanation:-
Answer: Option C. ->
Indexes are created with the ALTER TABLE command.
Question 3.
Which prefixes are available to Oracle triggers?
Neither :new nor :old
:old only
Both :new and :old
:new only
Explanation:-
Answer: Option C. ->
Both :new and :old
Question 4.
In creating a procedure, you may get a message if you have compile errors. Which of the following is true?
The line numbers reported match the line numbers you see in your text editor.
To see the errors, enter SHOW ERRORS in SQL*Plus.
If there are no syntax errors, you will receive the message "NO ERRORS."
SQL*Plus will automatically show the errors to you.
Explanation:-
Answer: Option B. ->
To see the errors, enter SHOW ERRORS in SQL*Plus.
Question 5.
What type of failure occurs when Oracle fails due to an operating system or computer hardware failure?
Media Failure
Rollback failure
Instance Failure
Application failure
Explanation:-
Answer: Option C. ->
Instance Failure
Question 6.
Which of the following is not true about modifying table columns?
You can increase the number of characters in character columns or the number of digits in numeric columns
You can drop a column at any time.
You cannot increase or decrease the number of decimal places.
You can add a column at any time as long as it is a NULL column.
Explanation:-
Answer: Option C. ->
You cannot increase or decrease the number of decimal places.
Question 7.
SQL*Plus will finish the statement and execute it when the user types in this:
A colon ( : ) followed by [Enter].
A left slash ( ) followed by [Enter].
A period ( . ) followed by [Enter].
A semicolon ( ; ) followed by [Enter].
Explanation:-
Answer: Option D. ->
A semicolon ( ; ) followed by [Enter].
Question 8.
Which of the following is not true of SQL views?
Oracle views are created using the standard SQL-92 CREATE VIEW command.
Oracle views can by queried.
Oracle views cannot use the ORDER BY clause in view definitions.
The SQL-92 standard does not allow the use of the ORDER BY clause in view definitions.
Explanation:-
Answer: Option C. ->
Oracle views cannot use the ORDER BY clause in view definitions.
Question 9.
Which of the following is NOT an Oracle-supported trigger?
BEFORE
AFTER
INSTEAD OF
DURING
Explanation:-
Answer: Option D. ->
DURING
Question 10.
After a table has been created, its structure can be modified using the SQL command:
CHANGE TABLE [TableName].
ALTER TABLE [TableName].
UPDATE TABLE [TableName].
MODIFY TABLE [TableName].
Explanation:-
Answer: Option B. ->
ALTER TABLE [TableName].
1
2
3
4
Next →
One click Login
Login With Google
Old way of Login
Login With Email