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

What's the length of SQL integer ?

  1. 32 bit

  2. 64 bit

  3. 18 bit

  4. None of the above


Correct Option: A

What languages can run within the oracle database?

  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

Dual table can be deleted, dropped or altered or updated or inserted ?

  1. True

  2. False


Correct Option: A
  1. <>

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

  3. field +constant

  4. field||''

  5. AND


Correct Option: A,B,C,D

At the physical level, some ------------- and ------------ are providing Grid-like capabilities.

  1. Network Layer, Transport Layer

  2. Operating system, Hardware Vendors

  3. Developer, DBA

  4. Program Design, Oracle Server


Correct Option: B

Grid will take care of making sure that at any moment pools of application servers and instances sized appropriately for the current workload are available?

  1. True

  2. False


Correct Option: A
  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

Can 2 functions have same name & input parameters but differ only by return datatype?

  1. True

  2. False


Correct Option: B
  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