0

databases Online Quiz - 38

Description: databases Online Quiz - 38
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0
  1. Cannot drop a field

  2. Cannot rename a field

  3. Cannot manage memory

  4. Index on view or index on index not provided

  5. View updation problem


Correct Option: A,B,C,D,E

What is the result of the following SQL: Select 1 from dual UNION Select 'A' from dual;

  1. Error

  2. 1 & A are retreived

  3. 1 is retreived

  4. A is retreived


Correct Option: A
  1. 32 bit

  2. 64 bit

  3. 18 bit

  4. None of the above


Correct Option: A
  1. Java

  2. Any other language linked to the OCI libraries

  3. SQL

  4. C

  5. PL/SQL

  6. All the above expect Option 2


Correct Option: A,C,E
  1. <>

  2. like '%...' is NOT functions

  3. field +constant

  4. field||''

  5. AND


Correct Option: A,B,C,D
  1. Network Layer, Transport Layer

  2. Operating system, Hardware Vendors

  3. Developer, DBA

  4. Program Design, Oracle Server


Correct Option: B
  1. SELECT * FROM table a WHERE ROWID < (SELECT MAX(ROWID) FROM table b WHERE a.col1 = b.col1);

  2. SELECT * FROM table a WHERE ROWID <= (SELECT MAX(ROWID) FROM table b WHERE a.col1 = b.col1);

  3. SELECT * FROM table a WHERE ROWID > (SELECT MIN(ROWID) FROM table b WHERE a.col1 = b.col1);

  4. SELECT * FROM table a WHERE ROWID >= (SELECT MIN(ROWID) FROM table b WHERE a.col1 = b.col1);


Correct Option: A,C
  1. document.write("Hello World")

  2. "Hello World"

  3. response.write("Hello World")

  4. ("Hello World")


Correct Option: A

How can you add a comment in a JavaScript?

  1. 'This is a comment

  2. //This is a comment

  3. /*This is a comment */


Correct Option: C
  1. ceil(x,y)

  2. Math.ceil(x,y)

  3. Math.max(x,y)

  4. top(x,y)


Correct Option: B
  1. window.status("put your message here")

  2. status("put your message here")

  3. window.status = "put your message here"

  4. statusbar = "put your message here"


Correct Option: C
- Hide questions