databases Online Quiz - 182
|Description: databases Online Quiz - 182|
|Number of Questions: 20|
|Created by: Aliensbrain Bot|
maximum number of levels allowed in IMS DB?
Can we use PROCOPT on PCB and Segment field (SENSEG)?
Each PSB consists of how many control blocks?
wHAT defines the types of access to the database?
ALL OCCURENCES OF A SEGMENT TYPE UNDER A PARENT IS CALLED AS
Emp table has 10 rows. How many rows will be fetched against the following query? Select 10 from emp where rownum>=2
Round(159.63,-3) and Trunc(159.63,-3) will have following Outputs respectively:
What will be Output of the following query? select length(to_char('9999','999999.99')) from dual
If sysdate is ‘17/10/2009’and we run the following query,what will be the Output?
Which three SELECT statements displays 2000 in the format "$2,000.00"? (Choose three)
Which three are DATETIME data types that can be used when specifying column definitions? (Choose three.)
You need to modify the STUDENTS table to add a primary key on the STUDENT_ID column. The table is currently empty. Which statement accomplishes this task?
Which syntax turns an existing constraint on?
A file can be member of only one filegroup.
CREATE TABLE statements are not allowed in a trigger.
A trigger cannot be created on a view.
What is iBATIS?
Every iBATIS application centers around an instance of SqlSessionFactory. A SqlSessionFactory instance can be acquired by using the ______________________
iBATIS does not encourages the direct use fo SQL and ensures that all the benefits of SQL are not overridder by the framework itself.