Tag: databases

Questions Related to databases

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

  1. Network Layer, Transport Layer

  2. Operating system, Hardware Vendors

  3. Developer, DBA

  4. Program Design, Oracle Server

Show answer
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?
technology databases

  1. True

  2. False

Show answer
Correct Option: A

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

  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);

Show answer
Correct Option: A,C

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

  1. True

  2. False

Show answer
Correct Option: A

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

  1. True

  2. False

Show answer
Correct Option: B

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

  1. document.write("Hello World")

  2. "Hello World"

  3. response.write("Hello World")

  4. ("Hello World")

Show answer
Correct Option: A

What is the correct syntax for referring to an external script called "xxx.js"?
technology databases
Show answer
Correct Option: B

How can you add a comment in a JavaScript?
technology databases

  2. 'This is a comment

  3. //This is a comment

  4. /*This is a comment */

Show answer
Correct Option: C

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

  1. ceil(x,y)

  2. Math.ceil(x,y)

  3. Math.max(x,y)

  4. top(x,y)

Show answer
Correct Option: B

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

  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");

Show answer
Correct Option: A