Tag: databases
Questions Related to databases
-
You obtain the results retrieved from the public synonym HR created by the DBA.
-
You obtain the results retrieved from the HR table that belongs to you schema.
-
You get an error message because you cannot retrieve from a table that has the same name as a public synonym.
-
You obtain the results retrieved from both the publich synonym HR and the HR table that belongs to your schema, as a Cartesian product.
-
A view can be created as read only.
-
A view can be created as a join of two or more tables.
-
A view can not have an ORDER BY clause in the SELECT statement.
-
A view can not be created with a GROUP BY clause in the SELECT statement.
-
A main query can have mroe than one subquery.
-
A subquery can have more than one main query.
-
The sub query and main query must retrieve data from the same table.
-
The subquery and main query can retrieve data from different tables.
-
Only one column or expression can be compared between the subquery and main query.
-
Convert any date literal to a date.
-
Convert any numeric literal to a date.
-
Convert any character literal to a date.
-
Convert any date literal to a character literal
-
Format '10-JAN-99' to 'January 10 1999'.
-
The start value of the sequence is always 1.
-
The sequence always increments by 1.
-
The minimum value of an ascending sequence defaults to 1.
-
The maximum value of descending sequence defaults to 1.
-
An error is generated.
-
A public synonym is created for employees table.
-
You create an alternative name for the employees table of HR schema in HR schema
-
You create an alternative name for the employees table of HR schema in SCOTT schema
-
INSERT INTO employees VALUES (NULL, 'JOHN','Smith');
-
. INSERT INTO employees( first_name, last_name) VALUES ('JOHN','Smith');
-
INSERT INTO employees VALUES ('1000','JOHN','NULL');
-
INSERT INTO employees(first_name,last_name, employee_id) VALUES ('1000, 'john','Smith');
-
. INSERT INTO employees (employee_id) VALUES (1000);
-
INSERT INTO employees (employee_id, first_name, last_name) VALUES ( 1000, 'john',");