Assuming today is Monday, 10 July 2000, what is returned by this statement: SELECT to_char(NEXT_DAY(sysdate, 'MONDAY'), 'DD-MON-RR') FROM dual;
03-JUL-00
10-JUL-00
12-JUL-00
11-JUL-00
17-JUL-00
To produce a meaningful result set without any cartesian products, what is the minimum number of conditions that should appear in the WHERE clause of a four-table join?
8
2
3
4
THERE IS NO SUCH CRITERIA
An internal LOB is a
A Table
A column that is a primary key
Stored in database
A file , which is pointed from database column
The old and new qualifiers can be used in which type of trigger ?
Row level DML trigger
Statement level DML trigger
Row level Application trigger
Statement level Application trigger
Which view display indirect dependencies, indenting each dependency?
DEPTREE
IDEPTREE
INDENT_TREE
I_DEPT_TREE
A call statement inside the trigger enables you to call the ?
Package
Stored Function
Stored Procedure
Another Trigger
Which type of argument passes a value from a procedure to calling environment ?
VARCHAR2
BOOLEAN
IN
OUT
What are different variants of SQL Server 2005?
(a) Developer Edition
(b) Express Edition
(c) Enterprise Edition
(d) Integration Edition
(e) Standard Edition
(f) All of the above
You are planning for a new installation of SQL Server 2005. You need to select the protocols that client computers might use to connect to the server. Which two protocols will you use to achieve this goal?
(a) Named Pipes
(b) TCP/IP
(c) Shared Memory
(d) Virtual Interface Adapter
(e) Multiprotocol
What are the different components of SQL Server 2005?
(a) Reporting Services
(b) Integration Services
(c) Analysis Services
(d) Database Engine
(e) Mobile Engine