What is the Physical Storage Length of DATE DB2 data type?
2 Bytes
4 Bytes
8 Bytes
6 Bytes
What's the output select to_Date('2009-may-25','yyyymmdd') from dual
20090525
Error
2009-may-25
may-25-2009
Which of the query will print the output as 'TCS' (single quotes should come in the output)
select ' ' ' || 'TCS' || ' ' ' from dual
select ' ' 'TCS' ' ' from dual
select 'TCS' from dual
select "TCS" from dual
What is the maximum number of tables that can be stored on a Partitioned Table Space?
TWO
ONE
FIVE
EIGHT
Which view contains details about locked objects ?
v$lock
v$user_objects
v$locked_object
v$session
A new table has been created in the employee. There are no rows in the table.What would be the output of the query?select count(*) from employee
No data found
1
0
select INSTR('TCS_SQL','S',4) from dual;
3
6
5
4
MAX. NO OF ROWS PER PAGE?
127
136
38
16
What is the size of a data page?
4K to 8K
4K to 10K
5K to 10K
5K to 15K