0

databases Online Quiz - 190

Description: databases Online Quiz - 190
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0
  1. SELECT SUBSTR ('Hello',) FROM dual;

  2. SELECT INITCAP (TRIM ('Hello World',1,1) FROM dual;

  3. SELECT LOWER (SUBSTR ('Hello World',1,1) FROM dual

  4. SELECT LOWER (SUBSTR ('Hello World',2,1) FROM dual;

  5. SELECT LOWER (TRIM ('H' FROM 'Hello World')) FROM dual;


Correct Option: E
  1. INSTR returns the numeric position of a named character.

  2. NVL2 returns the first non-null expression in the expression list.

  3. DECODE translates an expression after comparing it to each search value

  4. TRIM trims the heading of trailing characters (or both) from a character string

  5. NVL compares two expressions and returns null if they are equal, or the first expression of they are not equal

  6. NULLIF compares twp expressions and returns null if they are equal, or the first expression if they are not equal


Correct Option: A,C,D,F
  1. Convert 10 to 'TEN'

  2. Convert '10' to 10

  3. Convert '10' to '10'

  4. Convert 'TEN' to 10

  5. Convert a date to a character expression

  6. Convert a character expression to a date


Correct Option: C,E
  1. The sort is in ascending by order by default

  2. The sort is in descending order by default

  3. The ORDER BY clause must precede the WHERE clause

  4. The ORDER BY clause is executed on the client side

  5. The ORDER BY clause comes last in the SELECT statement

  6. The ORDER BY clause is executed first in the query execution


Correct Option: A,E
  1. update more than one row at a time.

  2. delete more than one row at a time.

  3. update only one row at a time.

  4. delete only one row at a time.


Correct Option: A
  1. COMMIT

  2. MERGE

  3. UPDATE

  4. DELETE

  5. CREATE

  6. DROP


Correct Option: B,C,D
  1. The loss of an entire redo log file group, but no loss in any other group

  2. The loss of one member of each redo log file group

  3. The failure of the ARC0 background process

  4. The failure of the LGWR background process


Correct Option: A
  1. The last redo log file switch

  2. The last checkpoint position

  3. The last commit

  4. The last incremental backup using RMAN


Correct Option: C

Which of the following commands places the database in ARCHIVELOG mode?

  1. ALTER SYSTEM ARCHIVELOG;

  2. ALTER DATABASE ARCHIVELOG;

  3. ALTER SYSTEM SET ARCHIVELOG=TRUE;

  4. ALTER DATABASE ENABLE ARCHIVELOG MODE;

  5. ALTER DATABASE ARCHIVELOG MODE;


Correct Option: B
  1. Database performance

  2. Guards against failure

  3. Faster archiving

  4. Writes are concurrent, so having control files on different disks speeds up control file writes


Correct Option: B
  1. ALTER DATABASE ADD LOGFILE ‘/logs/redo22.log’ TO GROUP 2;

  2. ALTER DATABASE ADD LOGFILE MEMBER ‘/logs/redo22.log’ TO GROUP 2;

  3. ALTER DATABASE ADD MEMBER ‘/logs/redo22.log’ TO GROUP 2;

  4. ALTER DATABASE ADD LOGFILE ‘/logs/redo22.log’;


Correct Option: B

Which initialization parameter contains the value used as the default for archived log file destination 10?

  1. LOG_ARCHIVE_DEST

  2. STANDBY_ARCHIVE_DEST

  3. LOG_ARCHIVE_DUPLEX_DEST

  4. DB_RECOVERY_FILE_DEST

  5. USE_DB_RECOVERY_FILE_DEST


Correct Option: D

Following is not a part of SQL.

  1. Commit

  2. Cursors

  3. savepoint

  4. truncate


Correct Option: B

Which of the following will automatically order the result.

  1. Union All

  2. Distinct

  3. Unique

  4. Intersect


Correct Option: D
  1. Union

  2. Intersect

  3. Minus

  4. None of above


Correct Option: D
- Hide questions