An NPS 10600 has how many SPU's
True
False
In NPS, you can ALTER DATABASE while other people are accessing the same database
No
Yes
1
0
In NPS, in the expression 'NULL = NULL' results in a value of 'true'
NULL=NULL
2
In NPS, you can use datasliceid to view distribution
Which operators can be used for a subquery to return multiple rows? (MCQ)
IN
ALL
<>
ANY
Choose the options which represent true statements? (MCQ)
SQL is a language for accessing data from an Oracle server
iSQL*Plus cannot be abbreviated
SQL cannot be abbreviated.
iSQL*Plus is a language for accessing data from an Oracle
Which of the following options IS NOT represent types of Single-Row functions?
Number functions
Conversion functions
Date Functions
Compute functions
Which of the following options represent explicit data-type conversion functions?
TO_CHAR
TO_VALUE
TO_DATE
TO_ERROR
What can NOT you accomplish using a SQL SELECT statement?
Creation of a new table based off of the output of SELECT statements
Return information from specific columns
Return information from specific rows
The combination of values in different tables
A subquery can consist of a statement located within a clause from a parent statement?