⟩ Bats can sense obstacles because they produce(1) Supersonic sound waves(2) Ultrasonic sound waves(3) Infrasonic sound waves(4) Micro sound waves
(2) Ultrasonic sound waves
(2) Ultrasonic sound waves
Explain Which two statements are true regarding constraints? (Choose two.) A. A foreign key cannot contain NULL values B. A columns with the UNIQUE constraint can contain NULL values C. A constraint is enforced only for the INSERT operation on a table D. A constraint can be disabled even if the constraint column contains data E. All constraints can be defined at the column level as well as the table level
Explain What are the benefits of system-managed locally managed tablespace?
Explain Which three statements/commands would cause a transaction to end? (Choose three.) A. COMMIT B. SELECT C. CREATE D. ROLLBACK E. SAVEPOINT
Evaluate the following SQL statements DELETE FROM sales; There are no other uncommitted transactions on the SALES table. Which statement is true about the DELETE statement? A. It would not remove the rows if the table has a primary key B. It removes all the rows as well as the structure of the table C. It removes all the rows in the table and deleted rows can be rolled back D. It removes all the rows in the table and deleted rows cannot be rolled back
Explain 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
Explain What is the use of PARALLEL_ADAPTIVE_MULTI_USER initialization parameter?
What is row chaining and row migration?
Explain 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
How to use STANDBY_ARCHIVE_DEST parameter and explain its need?
What is the difference between primary key and foreign key