1Z1-082 무료 덤프문제 온라인 액세스

Which four statements are true regarding primary and foreign key constraints and the effect they can have on table data? (Choose four.)

• A.Only the primary key can be defined at the column and table level
• B.A table can have only one primary key but multiple foreign keys
• C.Primary key and foreign key constraints can be defined at both the column and table level
• D.It is possible for child rows that have a foreign key to be deleted automatically from the child table at the time the parent row is deleted
• E.It is possible for child rows that have a foreign key to remain in the child table at the time the parent row is deleted
• F.The foreign key columns and parent table primary key columns must have the same names
• G.A table can have only one primary key and one foreign key

Which three statements are true about the Oracle Data Dictionary? (Choose three.)

• A.Base tables can be queried directly
• B.Data dictionary views are created by joins of dictionary base tables and DBA-defined tables
• C.It is owned by the SYSTEM user
• D.Usernames of all users including database administrators are stored in the data dictionary
• E.The data dictionary is created and maintained by the database administrator
• F.Views with the same name but different prefixes, such as CDB, DBA, ALL and USER, reference the same base tables from the data dictionary

Which three statements are true about single-row functions? (Choose three.)

• A.They can accept only one argument
• B.The data type returned can be different from the data type of the argument
• C.They can be nested to any level
• D.They can be used only in the WHERE clause of a SELECT statement
• E.They return a single result row per table
• F.The argument can be a column name, variable, literal or an expression

The CUSTOMERS table has a CUST_CREDIT_LIMIT column of data type NUMBER.
Which two queries execute successfully? (Choose two.)

• A.SELECT NVL(TO_CHAR(cust_credit_limit * .15), `Not Available') FROM customers;
• B.SELECT NVL2(cust_credit_limit, TO_CHAR(cust_credit_limit * .15), `Not Available') FROM customers;
• C.SELECT NVL(cust_credit_limit * .15, `Not Available') FROM customers;
• D.SELECT TO_CHAR(NVL(cust_credit_limit * .15, `Not Available')) FROM customers;
• E.SELECT NVL2(cust_credit_limit * .15, `Not Available') FROM customers;

Which two statements are true about substitution variables?

• A.A substitution variable prefixed with to prompts only once for a value in a session unless it is set to undefined in the session
• B.A substitution variable used to prompt for a column name must be enclosed in double quotation marks.
• C.A substitution variable can be used only in a select statement.
• D.A substitution variable can be used with any clause in a select statement.
• E.A substitution variable used to prompt for a column name must be enclosed in single quotation marks.
• F.A substitution variable prefixed with & always prompts only once for a value in a session.