Subcategories for Oracle Certification Interview Questions & Answers :-
Following are sub categories for which Interview Questions & Answers are available under Oracle Certification Interview Questions & Answers. Please select the appropriate sub-category:-
OCP 9i DBA Certification Exam Interview Questions & Answers (0) Exam Mode | Learning Mode
Oracle Application Developer Certification Exam Interview Questions & Answers (4) Exam Mode | Learning Mode
Previous 1 2
Sort By :
Latest First | Oldest First | By Rating
|
Question |
Rating |
View Answer |
|
Which statements are correct regarding indexes? (Choose all that apply.) A. When a table is dropped, the corresponding indexes are automatically dropped B. A FOREIGN KEY constraint on a column in a table automatically creates a nonunique key C. A nondeferrable PRIMARY KEY or UNIQUE KEY constraint in a table automatically creates a unique index D. For each data manipulation language operation performed, the corresponding indexes are automatically updated
|
|
View Answer |
|
Which three statements are true regarding the data types in Oracle Database 10g/11g? (Choose two.) A. Only One LONG column can be used per table B. A TIMESTAMP data type column stores only time values with fractional seconds C. The BLOB data type column is used to store binary data in an operating system file D. The minimum column width that can be specified for a VARCHAR2 data type column is one E. The value for a CHAR data type column is blanked-padded to the maximum defined column width
|
|
View Answer |
|
You need to calculate the number of days from 1st Jan 2007 till date: Dates are stored in the default format of dd-mm-rr. Which two SQL statements would give the required output? (Choose two.) A. SELECT SYSDATE - '01-JAN-2007' FROM DUAL B. SELECT SYSDATE - TO_DATE('01/JANUARY/2007') FROM DUAL; C. SELECT SYSDATE - TO_DATE('01-JANUARY-2007) FROM DUAL; D. SELECT TO_CHAR(SYSDATE,'DD-MON-YYYY')-'01-JAN-2007' FROM DUAL; E. SELECT TO_DATE(SYSDATE,'DD/MONTH/YYYY')-'01/JANUARY/2007' FROM DUAL;
|
|
View Answer |
|
Which two statements are true regarding single row functions? (Choose two.) A. They accept only a single argument B. They can be nested only to two levels C. Arguments can only be column values or constant D. They always return a single result row for every row of a queried table E. They can return a data type value different from the one that is reference
|
|
View Answer |
Previous 1 2
|