Hub for All Education Needs
Which two statements are true regarding constraints? (Choose two) Question: Which two statements are true regarding constraints? Options: A constraint is enforced only for an INSERT operation on a table. A foreign key cannot contain NULL values. The column with a UNIQUE constraint can store NULLS. You can have more than one column in a … Read more
You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference. Which method or feature should you use? Question: Which method or feature should you use? Options: Compare Period ADDM report. AWR Compare Period report. Active Session History (ASH) report. Taking a new snapshot and … Read more
Examine the types and examples of relationship that follows: (Choose the best answer.)1One-to-one a) teacher to Student2One-to-many b) Employees to Manager3Many-to-one c) Person to SSN4Many-to-many d) Customers to ProductsWhich option indicates correctly matched relationships? Question: Which option indicates correctly matched relationships? Options: 1-d, 2-b, 3-a, and 4-c 1-c, 2-d, 3-a, and4-b 1-a, 2-b, 3-c, and … Read more
Which normal form is a table in if it has no multi-valued attributes and no partial dependencies?References:https://blog.udemy.com/database-normal-forms/ Question: Which normal form is a table in if it has no multi-valued attributes and no partial dependencies? Options: second normal form first normal form third normal form fourth normal form Correct Answer The Correct Answer for this … Read more
A subquery is called a single-row subquery when________. Question: When________. Options: There is only one subquery in the outer query and the inner query returns one or more values The inner query returns a single value to the outer query. The inner query uses an aggregating function and returns one or more values. The inner … Read more
Which statement correctly grants a system privilege?ON table1 TO user1;TO PUBLIC;TO user1, user2;TO ALL; Question: Which statement correctly grants a system privilege? Options: GRANT CREATE VIEW GRANT ALTER TABLE GRANT CREATE TABLE GRANT CREATE SESSION Correct Answer The Correct Answer for this Question is GRANT CREATE TABLE
Which statement is true regarding the UNION operator? Question: Which statement is true regarding the UNION operator? Options: By default, the output is not sorted. Null values are not ignored during duplicate checking. Names of all columns must be identical across all select statements. The number of columns selected in all select statements need not … Read more
Which task can be performed by using a single Data Manipulation Language (DML) statement? Question: Which task can be performed by using a single Data Manipulation Language (DML) statement? Options: adding a column constraint when inserting a row into a table adding a column with a default value when inserting a row into a table … Read more
The first DROP operation is performed on PRODUCTS table using the following command:DROP TABLE products PURGE;Then you performed the FLASHBACK operation by using the following command:FLASHBACK TABLE products TO BEFORE DROP;Which statement describes the outcome of the FLASHBACK command?References:https://docs.oracle.com/cd/B19306_01 /server. 102/b14200/ statements_9003.htm Question: Which statement describes the outcome of the FLASHBACK command? Options: It recovers … Read more
Which statement is true regarding the default behavior of the ORDER BY clause? Question: Which statement is true regarding the default behavior of the ORDER BY clause? Options: In a character sort, the values are case-sensitive. NULL values are not considered at all by the sort operation. Only those columns that are specified in the … Read more