Managing Databases with Oracle - General Questions Online Exam Quiz
Managing Databases with Oracle - General Questions GK Quiz. Question and Answers related to Managing Databases with Oracle - General Questions. MCQ (Multiple Choice Questions with answers about Managing Databases with Oracle - General Questions
What type of failure occurs when Oracle fails due to an operating system or computer hardware failure?
Options
A : Application failure
B : Instance Failure
C : Media Failure
D : Rollback failure
Which statement about sequences is not true?
Options
A : A sequence is an object that generates a sequential series of unique numbers.
B : Sequences are most often used to provide values for surrogate keys.
C : NextVal and CurrVal are both sequence methods.
D : Sequences guarantee valid surrogate key values.
Which prefixes are available to Oracle triggers?
Options
A : :new only
B : :old only
C : Both :new and :old
D : Neither :new nor :old
In creating a procedure, you may get a message if you have compile errors. Which of the following is true?
Options
A : The line numbers reported match the line numbers you see in your text editor.
B : SQL*Plus will automatically show the errors to you.
C : To see the errors, enter SHOW ERRORS in SQL*Plus.
D : If there are no syntax errors, you will receive the message "NO ERRORS."
Which of the following is not true about indexes?
Options
A : Indexes are created to enforce uniqueness on columns.
B : Indexes are created to enable fast retrieval by column values.
C : Columns that are frequently used with equal conditions in WHERE clauses are good candidates for indexes.
D : Indexes are created with the ALTER TABLE command.
Which of the following is not true of SQL views?
Options
A : Oracle views cannot use the ORDER BY clause in view definitions.
B : Oracle views are created using the standard SQL-92 CREATE VIEW command.
C : Oracle views can by queried.
D : The SQL-92 standard does not allow the use of the ORDER BY clause in view definitions.
SQL*Plus will finish the statement and execute it when the user types in this:
Options
A : A left slash ( ) followed by [Enter].
B : A colon ( : ) followed by [Enter].
C : A semicolon ( ; ) followed by [Enter].
D : A period ( . ) followed by [Enter].
Which of the following is NOT an Oracle-supported trigger?
Options
A : BEFORE
B : DURING
C : AFTER
D : INSTEAD OF
After a table has been created, its structure can be modified using the SQL command:
Options
A : UPDATE TABLE [ TableName ].
B : MODIFY TABLE [ TableName ].
C : ALTER TABLE [ TableName ].
D : CHANGE TABLE [ TableName ].
Which of the following is not true about modifying table columns?
Options
A : You can drop a column at any time.
B : You can add a column at any time as long as it is a NULL column.
C : You can increase the number of characters in character columns or the number of digits in numeric columns
D : You cannot increase or decrease the number of decimal places.
Advanced SQL - General Questions more Online Exam Quiz
Distributed Databases - General Questions
Introduction to Database - General Questions
Introduction to SQL - General Questions
JDBC, Java Server Pages, and MySQL - General Questions
Logical Database Design - General Questions
SQL Server 2000 - General Questions
Managing Multiuser Databases - General Questions
Modeling Data in the Organization - General Questions