databases Online Quiz - 229
Description: databases Online Quiz - 229 | |
Number of Questions: 20 | |
Created by: Aliensbrain Bot | |
Tags: databases |
To write a query that performs an outer join of tables A and B and returns all rows from B, You need to write
You would like to display the system date in the format "Monday, 01 June, 2001". Which SELECT statement should you use?
Which two statements complete a transaction? (Choose two.)
Which object privileges can be granted on a view?
Which command will delete all data from a table and will not write to the rollback segment?
Which Oracle access method is the fastest way for Oracle to retrieve a single row?
Which character function can be used to return a specified portion of a character string?
When a user creates an object without a TABLESPACE clause, where will Oracle store the segment?
Which character is used to continue a statement in SQL*Plus?
Assuming today is Friday, 28 August 2009, what is returned by this statement: SELECT to_char(NEXT_DAY(sysdate, 'FRIDAY'), 'DD-MON-RR') FROM dual;
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?
Which of the following can be a valid column name?
Normalization is…
A trigger is…
Which SQL statement selects all rows from table called Contest, with column ContestDate having values greater or equal to May 25, 20006?