PassLeader now are offering 100% pass ensure 1Z0-071 dumps! All 1Z0-071 exam questions have been updated with correct answers, welcome to download the newest PassLeader 1Z0-071 VCE dumps and PDF dumps: https://www.passleader.com/1z0-071.html (410 Q&As)
BTW: Download PassLeader 1Z0-071 dumps from Google Drive for free: https://drive.google.com/drive/folders/0B-ob6L_QjGLpeVRsVFFJRFZfdDQ
NEW QUESTION 390
Which two are true about savepoints? (Choose two.)
A. After issuing a savepoints, you can roll back to the savepoint name within the current transaction.
B. A ROLLBACK TO SAVEPOINT command issued before the start of a transaction results in an error.
C. They make uncommitted updates visible to other sessions owned by the same user.
D. After issuing a savepoint, you cannot roll back the complete transaction.
E. You can commit updates done between two savepoints without committing other updates in the current transaction.
F. They make uncommitted updates visible to sessions owned by other users.
Answer: AE
Explanation:
https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/SQLReferenceManual/Statements/SAVEPOINT.htm
NEW QUESTION 391
The SYSDATE function displays the current Oracle Server date as:
21-MAY-19
You wish to display the date as:
MONDAY, 21 MAY, 2019
Which statement will do this?
A. SELECT TO_DATE(SYSDATE, `FMDAY, DD MONTH, YYYY’) FROM DUAL;
B. SELECT TO_CHAR(SYSDATE, `FMDD, DAY MONTH, YYYY’) FROM DUAL;
C. SELECT TO_CHAR(SYSDATE, `FMDAY, DDTH MONTH, YYYY’) FROM DUAL;
D. SELECT TO_CHAR(SYSDATE, `FMDAY, DD MONTH, YYYY’) FROM DUAL;
Answer: D
Explanation:
SELECT ID, TO_CHAR(Start_Date,’fmDay Month fmDD, YYYY’) AS “Start Date” FROM Employee;
http://www.java2s.com/Code/Oracle/Data-Type/TOCHARDatefmDayMonthfmDDYYYYEmbeddedspacescanberemovedbyplacingthefmprefix.htm
NEW QUESTION 392
Which two are SQL features? (Choose two.)
A. processing sets of data
B. providing update capabilities for data in external files
C. providing graphical capabilities
D. providing variable definition capabilities
E. providing database transaction control
Answer: AE
Explanation:
https://docs.oracle.com/database/121/TGSQL/tgsql_sqlproc.htm#TGSQL175 https://www.tutorialspoint.com/sql/sql-transactions.htm
NEW QUESTION 393
Which two are true about scalar subquery expressions? (Choose two.)
A. They can return at most one row.
B. You can use them as a default value for a column.
C. You cannot correlate them with a table in the parent statement.
D. You must enclose them in parentheses.
E. They can return two columns.
Answer: AD
NEW QUESTION 394
You have the privileges to create any type of synonym. Which statement will create a synonym called EMP for the HCM.EMPLOYEE_RECORDS table that is accessible to all users?
A. CREATE PUBLIC SYNONIM emp FOR hcm.employee_records;
B. CREATE GLOBAL SYNONIM emp FOR hcm.employee_records;
C. CREATE SYNONIM emp FOR hcm.employee_records;
D. CREATE SYNONIM PUBLIC.emp FOR hcm.employee_records;
E. CREATE SYNONIM SYS.emp FOR hcm.employee_records;
Answer: A
Explanation:
CREATE PUBLIC SYNONYM emp_table;
https://docs.oracle.com/database/121/SQLRF/statements_7001.htm#SQLRF01401
NEW QUESTION 395
A session’s NLS_DATE_FORMAT is set to DD Mon YYYY. Which two queries return the value 1 Jan 2019? (Choose two.)
A. SELECT TO_DATE(`2019-01-01′) FROM DUAL;
B. SELECT DATE `2019-01-01′ FROM DUAL;
C. SELECT `2019-01-01′ FROM DUAL;
D. SELECT TO_CHAR(`2019-01-01′) FROM DUAL;
E. SELECT TO_DATE(`2019-01-01′, `YYYY-MM-DD’) FROM DUAL;
Answer: BE
Explanation:
select date’2015-01-10′ d from dual union;
SELECT to_date( ’01-01-2007′ , ‘DD-MM-YYYY’) Tarih FROM dual;
https://livesql.oracle.com/apex/livesql/file/content_BFKOA5UQHDV1MV7HRUDDUEPM4.html
https://www.baskent.edu.tr/~tkaracay/etudio/ders/dbase/sql/pdfSQL/DateConversions.pdf
NEW QUESTION 396
No-user-defined locks are used in your database. Which three are true about Transaction Control Language (TCL)? (Choose three.)
A. COMMIT erases all the transaction’s savepoints and releases its locks.
B. ROLLBACK TO SAVEPOINT undoes the transaction’s changes made since the named savepoint and then ends the transaction.
C. COMMIT ends the transaction and makes all its changes permanent.
D. ROLLBACK without the TO SAVEPOINT clause undoes all the transaction’s changes but does not erase its savepoints.
E. ROLLBACK without the TO SAVEPOINT clause undoes all the transaction’s changes but does not release its locks.
F. ROLLBACK without the TO SAVEPOINT clause undoes all the transaction’s changes, releases its locks and erases its savepoints.
Answer: ACF
Explanation:
https://docs.oracle.com/cd/A58617_01/server.804/a58233/trans.htm
https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_9021.htm
NEW QUESTION 397
Which three are key components of an Entity Relationship Model? (Choose three.)
A. an activity
B. a table
C. a relationship
D. an attribute
E. a unique identifier
F. an entity
Answer: CDF
Explanation:
The three main components of the ER Model are entities, attributes and relationships.
https://www.dlsweb.rmit.edu.au/Toolbox/knowmang/content/data_concepts/e_r_model.htm
NEW QUESTION 398
Which two are true about external tables that use the ORACLE_DATAPUMP access driver? (Choose two.)
A. When creating an external table, data can be selected from another external table or from a table whose rows are stored in database blocks.
B. Creating an external table creates a dump file that can be used only by an external table in the same database.
C. When creating an external table, data can be selected only from a table whose rows are stored in database blocks.
D. Creating an external table creates a directory object.
E. Creating an external table creates a dump file that can be used by an external table in the same or a different database.
Answer: AD
Explanation:
The external tables feature is a complement to existing SQL*Loader functionality. It enables you to access data in external sources as if it were in a table in the database. You must create the directory object before you create the external table.
https://docs.oracle.com/cd/B19306_01/server.102/b14215/et_concepts.htm
https://docs.oracle.com/cd/E11882_01/server.112/e22490/et_concepts.htm#SUTIL011
NEW QUESTION 399
Which statement is true about TRUNCATE and DELETE?
A. You can never TRUNCATE a table if foreign key constraints will be violated.
B. For large tables, DELETE is faster than TRUNCATE.
C. For tables with multiple indexes and triggers, DELETE is faster than TRUNCATE.
D. You can DELETE rows from a table with referential integrity constraints.
Answer: A
Explanation:
Cannot truncate table ‘Table’ because it is being referenced by a FOREIGN KEY constraint.
https://dba.stackexchange.com/questions/190073/truncate-tables-with-dependent-foreign-key-constraints
NEW QUESTION 400
Which three statements are true about external tables? (Choose three.)
A. DML statements can modify them.
B. They can be temporary tables.
C. They can be used in queries containing joins.
D. They can be indexed.
E. They can be used in queries containing sorts.
F. Their metadata is stored in the database.
Answer: CEF
Explanation:
https://oracle-base.com/articles/9i/external-tables-9i https://docs.oracle.com/html/E25494_01/tables013.htm
NEW QUESTION 401
Which three are true about privileges? (Choose three.)
A. Only users with the DBA role can create roles.
B. A combination of object and system privileges can be granted to a role.
C. All schema objects have associated object privileges.
D. Object privileges granted on a table automatically apply to all synonyms for that table.
E. Only users with the GRANT ANY PRIVILEGE privilege can grant and revoke system privileges from other users.
F. Schema owners can grant any object privilege on any object in their schema to any other user or role.
Answer: DEF
Explanation:
Object privileges granted for a table, view, sequence, procedure, function, or package apply whether referencing the base object by name or by using a synonym. A user with the GRANT ANY OBJECT PRIVILEGE can grant or revoke any specified object privilege to another user. A user can grant any object privilege on any schema object he or she owns to any other user or role.
https://docs.oracle.com/cd/B19306_01/network.102/b14266/authoriz.htm#DBSEG5000
NEW QUESTION 402
Which three statements about roles are true? (Choose three.)
A. Roles are assigned to roles using the ALTER ROLE statement.
B. A single role can be assigned to multiple users.
C. A single user can be assigned multiple roles.
D. Privileges are assigned to a role using the ALTER ROLE statement.
E. A role is named group of related privileges that can only be assigned to a user.
F. Privileges are assigned to a role using the GRANT statement.
G. Roles are assigned to users using the ALTER USER statement.
Answer: BCF
Explanation:
Use the GRANT statement to assign access privileges and roles.
http://archive.dnnsoftware.com/docs/85/administrators/security/roles/assign-multiple-users-to-role.html
https://www.dnnsoftware.com/docs/administrators/user-accounts/assign-user-to-multiple-roles.html
https://www.ibm.com/support/knowledgecenter/en/SSGU8G_11.70.0/com.ibm.sqls.doc/ids_sqs_0828.htm
NEW QUESTION 403
Which two statements are true about an Oracle database? (Choose two.)
A. A table can have multiple foreign keys.
B. A column definition can specify multiple data types.
C. A VARCHAR2 column without data has a NULL value.
D. A NUMBER column without data has a zero value.
E. A table can have multiple primary keys.
Answer: AD
NEW QUESTION 404
Which two statements are true about the data dictionary? (Choose two.)
A. Views with the prefix ALL_, DBA_ and USER_ are not all available for every type of metadata.
B. Views with the prefix ALL_ display metadata for objects to which the current user has access.
C. Views with the prefix DBA_ display only metadata for objects in the SYS schema.
D. The data dictionary does not store metadata in tables.
E. The data dictionary is accessible when the database is closed.
Answer: BC
Explanation:
ALL_ -include objects all objects (from all schemas) accessible to the current user.
https://dataedo.com/blog/useful-oracle-data-dictionary-queries-every-dba-should-have
https://docs.oracle.com/cd/E11882_01/server.112/e40540/datadict.htm
NEW QUESTION 405
Which two will execute successfully? (Choose two.)
A. SELECT COALESCE(‘DATE’, SYSDATE) FROM (SELECT NULL AS “DATE” FROM DUAL);
B. SELECT COALESCE(‘DATE’, SYSDATE) FROM DUAL;
C. SELECT NVL(‘DATE’, SYSDATE) FROM DUAL;
D. SELECT COALESCE(0, SYSDATE) FROM DUAL;
E. SELECT NVL(‘DATE’, 200) FROM (SELECT NULL AS “DATE” FROM DUAL);
Answer: AD
NEW QUESTION 406
Which two statements are true about dropping views? (Choose two.)
A. Data selected by a view’s defining query is deleted from its underlying tables when the view is dropped.
B. Read only views cannot be dropped.
C. The creator of a view to be dropped must have the DROP ANY VIEW privilege.
D. CASCADE CONSTRAINTS must be specified when referential integrity constraints on other objects refer to primary or unique keys in the view to be dropped.
E. Views referencing a dropped view become invalid.
Answer: CD
Explanation:
The view must be in your own schema or you must have the DROP ANY VIEW system privilege. Specify CASCADE CONSTRAINTS to drop all referential integrity constraints that refer to primary and unique keys in the view to be dropped.
https://docs.oracle.com/cd/B12037_01/server.101/b10759/statements_9009.htm
NEW QUESTION 407
Which two are true about using constraints? (Choose two.)
A. A table can have only one PRIMARY KEY but may have multiple FOREIGN KEY constraints.
B. A table can have multiple PRIMARY KEY and multiple FOREIGN KEY constraints.
C. PRIMARY KEY and FOREIGN KEY constraints can be specified at the column and at the table level.
D. NOT NULL can be specified at the column and at the table level.
E. A FOREIGN KEY column in a child table and the referenced PRIMARY KEY column in the parent table must have the same names.
F. A table can have only one PRIMARY KEY and one FOREIGN KEY constraint.
Answer: AD
Explanation:
FOREIGN KEY constraint can only point to one table and each table can only have one PRIMARY KEY constraint. Or you can have multiple FOREIGN KEY constraints on the same column(s) referencing one PRIMARY KEY. The identified columns must be defined as NOT NULL.
https://stackoverflow.com/questions/42268886/how-to-have-a-foreign-key-pointing-to-two-primary-keys
https://docs.oracle.com/javadb/10.8.3.0/ref/rrefsqlj13590.html
NEW QUESTION 408
……
PassLeader now are offering 100% pass ensure 1Z0-071 dumps! All 1Z0-071 exam questions have been updated with correct answers, welcome to download the newest PassLeader 1Z0-071 VCE dumps and PDF dumps: https://www.passleader.com/1z0-071.html (410 Q&As)
BTW: Download PassLeader 1Z0-071 dumps from Google Drive for free: https://drive.google.com/drive/folders/0B-ob6L_QjGLpeVRsVFFJRFZfdDQ