In NPS, the nzsql internal command '\d' describes an object.exampl \d customer will describe customer table
True
False
NPS, the nzsql internal command '\du' displays list of all defined users
In NPS, SPU means Snippet processing Unit
The database administrator of your company created a public synonum called HR for the HUMAN_RESOURCES table of the GENERAL schema, because many users frequently use this table. As a user of the database, you created a table called HR in your schema. What happens when you execute this query?
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.
Which two statements about views are true?
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.
Which three statements about SubQueries are true?
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.
For which action can you use the TO_DATE function?
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'.
What is true about sequences?
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.
SCOTT user has grants on HR schema objects. You are connected to SCOTT schema and issued following command:Create synonym emp for hr.employees;What happens when you issue this statement?
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
Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) Which three statements inserts a row into the table? (Choose three)
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',");