Oracle
Which view displays indirect dependencies, indenting each dependency?
DEPTREE
IDEPTREE
INDENT_TREE
I_DEPT_TREE
Which three are valid ways to minimize dependency failure? (Choose three)
Querying with the SELECT * notification.
Declaring variables with the %TYPE attribute.
Specifying schema names when referencing objects.
Declaring records by using the %ROWTYPE attribute.
Specifying package procedure notation while executing procedures.
What happens during the execute phase with dynamic SQL for INSERT, UPDATE, and DELETE operations?
A. The rows are selected and ordered.
B. The validity of the SQL statement is established.
C. An area of memory is established to process the SQL statement.
D. The SQL statement is run and the number of rows processed is returned.
E. The area of memory established to process the SQL statement is released.
Which two programming constructs can be grouped within a package? (Choose two)
A. Cursor
B. Constant
C. Trigger
D. Sequence
E. View
Which two tables are fused track object dependencies? (Choose two)
A. USER_DEPENDENSIES.
B. USER_IDEPTREE.
C. IDEPTREE.
D. USER_DEPTREE.
E. USER_DEPENDS.
Which statement about the local dependent object is TRUE?
A. They are on different nodes.
B. They are in a different database.
C. They are on the same node in the same database.
D. They are on the same node in a different database.
The programmer view developed a procedure ACCOUNT_TRANSACTION left organization. You were assigned a task to modify this procedure. YOU want to find all the program units invoking the ACCOUNT_TRANSACTION procedure. How can you find this information?
A. Query the USER_SOURCE data dictionary view.
B. Query the USER_PROCEDURES data dictionary view.
C. Query the USER_DEPENDENCIES data dictionary views.
D. Set the SQL Plus environment variable trade code
E. Set the SQL Plus environment variable DEPENDENCIES Account_Transaction procedure.
You need to drop a table from within a stored procedure. How do you implement this?
A. You cannot drop a table from a stored procedure.
B. Use the DROP command in the procedure to drop the table.
C. Use the DBMS_DDL packaged routines in the procedure to drop the table.
D. Use the DBMS_SQL packaged routines in the procedure to drop the table.
E. Use the DBMS_DROP packaged routines in the procedure to drop the table.
What happens during the parse phase with dynamic SQL?
A. Rows are selected and ordered.
B. The number of rows processed is returned.
C. The validity of the SQL statement is established.
D. An area of memory is established to process the SQL statement.
E. An area of memory is established to process the SQL statement is released.
Which script file must be executed before you can determine indirect independence’s using the DEPTREE AND IDEPTREE VIEWS?
A. UTL_IDEPT.SQL.
B. UTLIDD.SQL.
C. UTLINDD.SQL.
D. UTLDTREE.SQL
You work as an application developer for Dolliver Inc. The company uses an oracle database. You own subprograms that reference to other subprograms on remote locations. Oracle server uses the signature mode of remote dependency in order to manage remote dependencies among the subprograms. Which of the following statements about the signature mode of dependency are true? (Choose two)
A. Oracle Server records only the signature for each PL/SQL program unit.
B. Using the signature mode prevents the unnecessary recompilation of dependent local procedures, as it allows remote procedures to be recompiled without affecting the dependent local procedures.
C. Signature mode is the default mode of remote dependency.
D. Oracle server records both the timestamp and the signature for each PL/SQL program unit.
Ou work as an application developer for federal Inc. The company uses an Oracle database. You have created a function named My_Func in the database. You want to change the arguments declared for the function. Before changing the arguments you want to see the names of the procedures and other functions that invoke the My_Func function. Which of the following data dictionary views will you query to accomplish this? (choose two)
A. USER_DB_LINKS
B. ALL_DEPENDENCIES
C. USER_DEPENDENCIES
D. USER_SOURCE.
Procedure PROCESS_EMP references the table EMP. Procedure UPDATE_EMP updates rows if table EMP through procedure PROCESS_EMP. There is a remote procedure QUERY_EMP that queries the EMP table through the local procedure PROCESS_EMP. The dependency mode is set to TIMESTAMP in this session. Which two statements are true? (Choose two)
A. If the signature of procedure PROCESS_EMP is modified and successfully recompiles, the EMP table is invalidated.
B. If internal logic of procedure PROCESS_EMP is modified and successfully recompiles, UPDATE_EMP gets invalidated and will recompile when invoked for the first time.
C. If the signature of procedure PROCESS_EMP is modified and successfully recompiles, UPDATE_EMP gets invalidated and will recompile when invoked for the first time.
D. If internal logic of procedure PROCESS_EMP is modified and successfully recompiles, QUERY_EMP gets invalidated and will recompile when invoked for the first time.
E. If internal logic of procedure PROCESS_EMP is modified and successfully recompiles, QUERY_EMP gets invalidated and will recompile when invoked for the second time.
Which operator you can use to produce cross-tabulation values with a single SELECT statement?
A. ROLLUP
B. CUBE
C. GROUPING
D. GROUPING SETS
A value of 0 returned by the GROUPING function based on an expression indicates one of the following
A. The expression has been used to calculate the aggregate value.
B. The value in the expression column is a stored NULL value.
C. The expression has not been used to calculate the aggregate value.
D. The NULL value in the expression column is created by ROLLUP or CUBE as a result of grouping.
A value of 1 returned by the GROUPING function based on an expression indicates one of the following:
A. The expression has been used to calculate the aggregate value.
B. The NULL value in the expression column is a stored NULL value.
C. The expression has not been used to calculate the aggregate value.
D. The NULL value in the expression column is changed by ROLLUP or CUBE as a result of grouping.
Concatenation of grouping sets is very helpful for these reasons:
A. Ease of query development: You need manually enumerate all groupings.
B. Use by applications: SQL generated by online analytical processing (OLAP) applications often involves concatenation of grouping sets, with each GROUPING SET defining groupings needed for a dimension.
What character matches the start-of-line?
A. *
B. |
C. $
D. ^
What character matches the end-of-line?
A. *
B. |
C. $
D. ^
Choose description of REGEXP_INSTR
A. Similar to the LIKE operator, but performs regular expression matching instead of simple pattern matching
B. Searches for a regular expression pattern and replaces it with a replacement string
C. Searches for a given string for a regular expression pattern and returns the position where the match is found
D. Searches for a regular expression pattern within a given string and returns the matched substring
Description of symbol «?» in Meta Characters
A. Matches one or more occurrences
B. Matches zero or one occurrence
C. Matches zero or more occurrences
D. Matches any character in the supported character set, except NULL
Choose right «REGEXP_SUBSTR» function syntax
A. (srcstr, pattern [,match_option])
B. (srcstr, pattern [, position [, occurrence [, return_option [, match_option]]]])
C. (srcstr, pattern [, position [, occurrence [, match_option]]])
D. (srcstr, pattern [,replacestr [, position [, occurrence [, match_option]]]])
SELECT street_address, REGEXP_SUBSTR(street_address , ' [^ ]+ ') "Road" FROM locations; In this query what does it mean «+» in meta characters
A. indicates NOT
B. Ends the expression
C. indicates 1 or more
D. Indicates space
Pairwise Comparison Subquery. Display the details of the employees who are managed by the same manager and work in the same department as employees with the first name of “John.” SELECT employee_id, manager_id, department_id FROM employees WHERE (manager_id, department_id) IN … AND first_name <> 'John'; Continue the missing place
A. (SELECT manager_id, department_id FROM employees WHERE first_name
B. (SELECT manager_id, department_id FROM employees WHERE first_name!
C. (SELECT department_id FROM employees WHERE first_name
D. (SELECT manager_id FROM employees WHERE first_name
A scalar subquery expression is
A. A subquery that returns several columns value from one row.
B. A query that returns exactly one column value from several rows.
C. A query that returns one row.
D. A subquery that returns exactly one column value from one row.
{"name":"Oracle", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"Which view displays indirect dependencies, indenting each dependency?, Which three are valid ways to minimize dependency failure? (Choose three), What happens during the execute phase with dynamic SQL for INSERT, UPDATE, and DELETE operations?","img":"https://www.quiz-maker.com/3012/images/ogquiz.png"}
More Quizzes
What should be your favorite Christmas song?
940
Identidad Costarricense
320
F Block Awards
28140
100
Quiz
210
Test na bycie gejem 5 punktow = 100% pedal 4 punkty=80%pedal 3 punkty= 50%pedal ponizej 3 = 0% pedal
520
What Lab Equipment Are You?
10573
Heather
420
Tudod, ki festette ezeket a híres festményeket?
520
Philippines: How Much Do You Know?
1050
MADDE BAĞIMLILIĞI FİNAL (MELİKE EKİNCİBAŞ)
66330
Geografija: Azija
11620