Cannot drop a field

Cannot rename a field

Cannot manage memory

Index on view or index on index not provided

View updation problem

Error

1 & A are retreived

1 is retreived

A is retreived

True

False

32 bit

64 bit

18 bit

None of the above

Java

Any other language linked to the OCI libraries

SQL

C

PL/SQL

All the above expect Option 2

True

False

<>

like '%...' is NOT functions

field +constant

field||''

AND

True

False

True

False

Network Layer, Transport Layer

Operating system, Hardware Vendors

Developer, DBA

Program Design, Oracle Server

True

False

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

True

False

True

False

document.write("Hello World")

"Hello World"

response.write("Hello World")

("Hello World")

'This is a comment

//This is a comment

/*This is a comment */

ceil(x,y)

Math.ceil(x,y)

Math.max(x,y)

top(x,y)

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

window.status("put your message here")

status("put your message here")

window.status = "put your message here"

statusbar = "put your message here"