Only the SELECT privilege
Only the CONNECT privilege.
All the privileges of a default user
. CREATIVE USER susan;
CREATIVE OR REPLACE USER susan;
CREATE NEW USER susan DEFAULT
CREATE USER susan IDENTIFIED BY blue;
C. Exception Handling
SELECT COUNT(*) FROM employees WHERE last_name='Smith';
SELECT COUNT (dept_id) FROM employees WHERE last_name='Smith';
SELECT DISTINCT(COUNT(dept_id)) FROM employees WHERE last_name='Smith';
SELECT COUNT(DISTINCT dept_id) FROM employees WHERE last_name='Smith';
SELECT UNIQUE(dept_id) FROM employees WHERE last_name='Smith'
A. A cursor for loop
B. A multiple selection cursor
C. A cursor for each active set
D. A cursor that uses parameters
A. SHOW FUNCTION_ERROR
B. SHOW USER_ERRORS
C. SHOW ERRORS
D. SHOW ALL_ERRORS
A. EXECUTE UPD_BAT_STAT(V_ID);
C. RUN UPD_BAT_STAT(V_ID);
D. START UPD_BAT_STAT(V_ID);
A. A stored procedure on the server.
B. A block of code in a PL/SQL library.
C. A standalone procedure on the client machine.
D.A block of code in the body of the program unit ORDERTOTAL
E. A local subprogram defined within the program unit ORDERTOTAL
A. A stored procedure uses the DELCLARE keyword in the procedure specification to declare formal parameters.
B. A stored procedure is named PL/SQL block with at least one parameter declaration in the procedure specification
C. A stored procedure must have at least one executable statement in the procedure body.
D. A stored procedure uses the DECLARE keyword in the procedure body to declare formal parameters.
A. A comma has been left after the STATS_EXIST_EXCEPTION exception.
B. The STATS_EXIST_EXCEPTION has not been declared as a number.
C. The STATS_EXIST_EXCEPTION has not been declared as an exception.
D. Only predefined exceptions are allowed in the EXCEPTION section.
A. The value displayed in the CALC_VALUE column will be lower.
B. The value displayed in the CALC_VALUE column will be higher.
C. There will be no difference in the value displayed in the CALC_VALUE column.
An error will be reported.
A. You use a NEXTVAL pseudo column to look at the next possible value that would be generated from a sequence, without actually retrieving the value.
B. You use a CURRVAL pseudo column to look at the current value just generated from a sequence, without affecting the further values to be generated from the sequence.
C. You use a NEXTVAL pseudo column to obtain the next possible value from a sequence by actually retrieving the value form the sequence
D. You use a CURRVAL pseudo column to generate a value from a sequence that would be used for a specified database column
E. If a sequence starting from a value 100 and incremented by 1 is used by more than one application, then all of these applications could have a value of 105 assigned to their column whose value is being generated by the sequence.
F. You use a REUSE clause when creating a sequence to restart the sequence once it generates the maximum value defined for the sequence.
D. AVG(start_date, end_date)
A. The results are not sorted.
B. The results are sorted numerically.
C. The results are sorted alphabetically.
D. The results are sorted numerically and then alphabetically.
A. 46 and 45
B. 46 and 45.93
C. 50 and 45.93
D. 50 and 45.9
E. 45 and 45.93
F. 45.95 and 45.93
A. You cannot update a view with group functions
B. When you update a view group functions are automatically computed
C. When you update a view only the constraints on the underlying table will be in effect.
D. When you update a view the constraints on the views always override the constraints on the underlying tables.
A. You have too many tables
B. Your tables are too long.
C. Your tables have difficult names
D. You want to work on your own tables.
E. You want to use another schema's tables.
F. You have too many columns in your tables
A. SELECT ADD_MONTHS(MAX(hire_Date), 6) FROM EMP;
B. SELECT ROUND(hire_date)FROM EMP; ;
C. SELECT sysdate-hire_date FROM EMP
D. SELECT TO_NUMBER(hire_date + 7)FROM EMP;
A. in the INTO clause of an INSERT statement
B. in the FROM clause of a SELECT statement
C. in the GROUP BY clause of a SELECT statement
E. in the SET clause of an UPDATE statement
F. in the VALUES clause of an INSERT statement
A. Group functions on columns ignore NULL values
B. Group functions on columns returning dates include NULL values.
C. Group functions on columns returning numbers include NULL values
D. Group functions on columns cannot be accurately used on columns that contain NULL values
E. Group functions on columns include NULL values in calculations if you use the keyword INC_NULLS.
F. composite index on ORDER_ID and ORDER_DATE
B. DELETE, INSERT,SELECT
C. ALTER, DELETE, INSERT, SELECT
D. DELETE, INSERT, SELECT, UPDATE
A. binary data up to 4 gigabytes
B. character data up to 4 gigabytes
C. raw binary data of variable length up to 2 gigabytes
D. binary data stored in an external file, up to 4 gigabytes
E. a hexadecimal string representing the unique address of a row in its table
A. cannot be nested
B. manipulate data items
C. act on each row returned
D. return one result per row
E. accept only one argument and return only one value
F. accept arguments which can be a column or an expression
A. The table is accessible to all users.
B. Tables are created in the public schema
C. Tables are created in your schema
D. Tables are created in the DBA schema
E. You must specify the schema when the table is created.
E. PRIMARY KEY
G. NOT NULL
A. You get an error because of a primary key violation.
B. The data and structure of the EMPLOYEES table are deleted.
C. The data in the EMPLOYEES table is deleted but not the structure
D. You get an error because the statement is not syntactically correct