databases Online Quiz - 229
Description: databases Online Quiz - 229 | |
Number of Questions: 20 | |
Created by: Aliensbrain Bot | |
Tags: databases |
Which of the following events can be used to fire triggers?
Which of the following queries can you use to search for employees with the pattern 'A_B' in their names?
To write a query that performs an outer join of tables A and B and returns all rows from B, You need to write
15 Examine the description of the STUDENTS table: STD_ID NUMBER (4) COURSE_ID VARCHAR2 (10) START_DATE DATE END_DATE DATE Which two aggregate functions are valid on the START_DATE column? (Choose two)
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 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?
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?