How many columns are there in dual table?
1
2
>1
N
There are 10 rows in Table A and 0 Rows in table B. Select * from A,B How many rows will be retrieved.
0
10
None of the above
There is a % sign in one field of a column. Say for example table test_chk has a column name1 which contains a value “desdf%dsf”. What will be the queries to find it?
SELECT * FROM test_chk ;
select * from test_chk where name1 like '%%\%' escape '\'
select * from test_chk where name1 like ' \ ' escape '\';
select * from test_chk where name1 like '%!%%' escape '!'
Can a function have an out parameter?
True
False
Can you add not null column to a table already containing data ?
Say for e.g. we declare x char(20): = 'name' and y varchar2(20):='name' If we compare x and y then what should be the result?
Both values will be equal
Both values will not be equal
You can’t compare these two values
Both will be NULL
In PL/SQL if we write select statement with INTO clause which of the following exceptions are returned
NO_DATA_FOUND
ROWTYPE_MISMATCH
TOO_MANY_ROW
DUP_VAL_ON_INDEX
Without closing the cursor, If you want to open it what will happen. If error, get what is the error?
INVALID_CURSOR
CURSOR_ALREADY_OPEN
TIMEOUT_ON_RESOURCE
SYS_INVALID_ROWID
What is Detail Object?
More detail about either Dimension/Measure
More detail about Measure
More detail about Dimension
separate object for Time Dimension