0

databases Online Quiz - 230

Description: databases Online Quiz - 230
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0
  1. My$ql

  2. Linuxab$

  3. ""

  4. None of the above


Correct Option: C
  1. Error

  2. All columns ordered randomly

  3. rows picked in a random way

  4. None of the above


Correct Option: C

Is it a valid mySQL statements? SELECT @min_price:=MIN(price),@max_price:=MAX(price) FROM shop; SELECT * FROM shop WHERE [email protected]_price OR [email protected]_price;

  1. True

  2. False


Correct Option: B
  1. Would skip the first 7, and then get you the next ten highest.

  2. not a valid mysql query

  3. Would skip the first 10, and then get you the next 7 highest.

  4. None of the above


Correct Option: A
  1. My$ql

  2. Linuxab$

  3. ""

  4. None of the above


Correct Option: C
  1. Error

  2. All columns ordered randomly

  3. rows picked in a random way

  4. None of the above


Correct Option: C

What will be the output of the query SELECT column FROM table ORDER BY column DESC LIMIT 7,10;

  1. Would skip the first 7, and then get you the next ten highest.

  2. not a valid mysql query

  3. Would skip the first 10, and then get you the next 7 highest.

  4. None of the above


Correct Option: A
  1. Primary key access

  2. Access via unique index

  3. Table access by ROWID

  4. Full table scan


Correct Option: C
  1. Column

  2. 1966_Invoices

  3. Catch_#22

  4. #Invoices


Correct Option: C

Which character function can be used to return a specified portion of a character string?

  1. INSTR

  2. SUBSTRING

  3. SUBSTR

  4. POS


Correct Option: C
  1. System tablespace

  2. Users tablespace

  3. Default tablespace for the user

  4. Oracle will give an error


Correct Option: C

What is the best way for a deadlock to be resolved?

  1. All statements are removed and have to be resubmitted

  2. The Oracle server rolls back the statement that detected the deadlock

  3. The administrator has to kill the session

  4. Deadlocks can not be resolved


Correct Option: B
  1. The user disconnects from Oracle

  2. A COMMIT or a ROLLBACK statement is used in conjunction with a SAVEPOINT clause

  3. A user process is terminated abnormally

  4. A DDL statement such as DROP, GRANT, RENAME


Correct Option: B

Which of the following options would be queried to get the descriptions of all tablespaces?

  1. USER_TABLESPACES

  2. V$TABLESPACE

  3. DBA_TABLESPACE_GROUPS

  4. DBA_TABLESPACES


Correct Option: D

A single database session failure is classified as what type of error?

  1. Statement failure

  2. User process failure

  3. Network failure

  4. Instance failure


Correct Option: B
- Hide questions