Category «1Z0-071»

Which statement is true regarding the outcome?

View the exhibit for the structure of the STUDENT and FACULTY tables.STUDENTName Null? Type—————— ——————- ————-STUDENT_ID NOT NULL NUMBER(2)STUDENT_NAME VARCHAR2(20)FACULTY_ID VARCHAR2(2)LOCATION_ID NUMBER(2)FACULTYName Null? Type—————— ——————- ————-FACULTY_ID NOT NULL NUMBER(2)FACULTY_NAME VARCHAR2(20)LOCATION_ID NUMBER(2)You need to display the faculty name followed by the number of students handled by the faculty at the baselocation.Examine the following two SQL statements:Statement …

Which two tasks can be performed by using Oracle SQL statements?

Which two tasks can be performed by using Oracle SQL statements? A. changing the password for an existing database user B. connecting to a database instance C. querying data from tables across databases D. starting up a database instance E. executing operating system (OS) commands in a session Explanation:http://www.techonthenet.com/oracle/password.phphttps://docs.oracle.com/cd/B28359_01/server.111/b28324/tdpii_distdbs.htm Show Answer

Which SQL statement must you use?

Examine the commands used to create DEPARTMENT_DETAILS and COURSE_DETAILS:SQL>CREATE TABLE DEPARTMENT_DETAILS(DEPARTMENT_ID NUMBER PRIMARY KEY,DEPARTMENT_NAME VARCHAR2(50),HOD VARCHAR2(50));SQL>CREATE TABLE COURSE_DETAILS(COURSE_ID NUMBER PRIMARY KEY,COURSE_NAME VARCHAR2(50),DEPARTMENT_ID VARCHAR2(50));You want to generate a list of all department IDs along with any course IDs that may have been assigned tothem.Which SQL statement must you use? A. SELECT d.department_id, c.course_id FROM department_details d …

What is the outcome?

You want to display the date for the first Monday of the next month and issue the following command:SQL>SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE), ‘MON’),’dd “is the first Monday for” fmmonth rrrr’)FROM DUAL;What is the outcome? A. In generates an error because rrrr should be replaced by rr in the format string. B. It executes successfully but does not …

Which two options define the data types that satisfy these requirements most efficiently?

You are designing the structure of a table in which two columns have the specifications:COMPONENT_ID – must be able to contain a maximum of 12 alphanumeric characters and uniquely identify therowEXECUTION_DATETIME – contains Century, Year, Month, Day, Hour, Minute, Second to the maximumprecision and is used for calculations and comparisons between components.Which two options define …