Question 1

What are the disadvantages of SQL ?

technology databases

Cannot drop a field
Cannot rename a field
Cannot manage memory
Index on view or index on index not provided
View updation problem

Answer

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

Question 2

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

technology databases

Error
1 & A are retreived
1 is retreived
A is retreived

Answer

Correct Option: A

Question 3

Index can be created on view?

technology databases

True
False

Answer

Correct Option: B

Question 4

What's the length of SQL integer ?

technology databases

32 bit
64 bit
18 bit
None of the above

Answer

Correct Option: A

Question 5

What languages can run within the oracle database?

technology databases

Java
Any other language linked to the OCI libraries
SQL
C
PL/SQL
All the above expect Option 2

Answer

Correct Option: A,C,E

Question 6

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

technology databases

True
False

Answer

Correct Option: A

Question 7

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

technology databases

<>
like '%...' is NOT functions
field +constant
field||''
AND

Answer

Correct Option: A,B,C,D

Question 8

Oracle is the sole proprietor of grid concept

technology databases

True
False

Answer

Correct Option: B

Question 9

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

technology databases

True
False

Answer

Correct Option: A

Question 10

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

technology databases

Network Layer, Transport Layer
Operating system, Hardware Vendors
Developer, DBA
Program Design, Oracle Server

Answer

Correct Option: B

Question 11

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

True
False

Answer

Correct Option: A

Question 12

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

technology databases

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

Answer

Correct Option: A,C

Question 13

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

technology databases

True
False

Answer

Correct Option: A

Question 14

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

technology databases

True
False

Answer

Correct Option: B

Question 15

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

technology databases

document.write("Hello World")
"Hello World"
response.write("Hello World")
("Hello World")

Answer

Correct Option: A

Question 16

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

technology databases

Answer

Correct Option: B

Question 17

How can you add a comment in a JavaScript?

technology databases

'This is a comment
//This is a comment
/*This is a comment */

Answer

Correct Option: C

Question 18

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

technology databases

ceil(x,y)
Math.ceil(x,y)
Math.max(x,y)
top(x,y)

Answer

Correct Option: B

Question 19

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

technology databases

p2=window.open("http://www.tcs.com");
p2=window.new("http://www.tcs.com");
p2=window.create("http://www.tcs.com");
p2=window.add("http://www.tcs.com");

Answer

Correct Option: A

Question 20

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

technology databases

window.status("put your message here")
status("put your message here")
window.status = "put your message here"
statusbar = "put your message here"

Answer

Correct Option: C

Description: databases Online Quiz - 38
Number of Questions: 20
Created by: Aliensbrain Bot
Tags: databases

databases Online Quiz - 38

Find more quizzes from top tags