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

Index can be created on view?

  1. True

  2. False


Correct Option: B

What's the length of SQL integer ?

  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

For which relational operators in where clause, index is not used ?

  1. <>

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

  3. field +constant

  4. field||''

  5. AND


Correct Option: A,B,C,D

Oracle is the sole proprietor of grid concept

  1. True

  2. False


Correct Option: B

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

Which of the following queries are correct to delete duplicate records in a table?

  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

What is the correct JavaScript syntax to write "Hello World"?

  1. document.write("Hello World")

  2. "Hello World"

  3. response.write("Hello World")

  4. ("Hello World")


Correct Option: A

What is the correct syntax for referring to an external script called "xxx.js"?


Correct Option: B

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

How do you find the number with the highest value of x and y?

  1. ceil(x,y)

  2. Math.ceil(x,y)

  3. Math.max(x,y)

  4. top(x,y)


Correct Option: B

What is the correct JavaScript syntax for opening a new window called "p2"

  1. p2=window.open("http://www.tcs.com");

  2. p2=window.new("http://www.tcs.com");

  3. p2=window.create("http://www.tcs.com");

  4. p2=window.add("http://www.tcs.com");


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