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

What are the disadvantages of SQL ?

  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

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

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

The SQL application developer need not know how the Grid has been implemented

  1. True

  2. False


Correct Option: A

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

Is it possible to add new column in the existing table at our desired location?

  1. True

  2. False


Correct Option: A

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

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

How do you put a message in the browser's status bar?

  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