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 […]

Read More

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

Read More

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 […]

Read More

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 […]

Read More

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 […]

Read More

What correction needs to be done to the above statement?

The user SCOTT who is the owner of ORDERS and ORDER_ITEMS tables issues the following GRANT command:GRANT ALLON orders, order_itemsTO PUBLIC;What correction needs to be done to the above statement? A. PUBLIC should be replaced with specific usernames. B. ALL should be replaced with a list of specific privileges. C. WITH GRANT OPTION should be […]

Read More

Which three statements are true about the ALTER TABLE….

Which three statements are true about the ALTER TABLE….DROP COLUMN…. command? A. A column can be dropped only if it does not contain any data. B. A column can be dropped only if another column exists in the table. C. A dropped column can be rolled back. D. The column in a composite PRIMARY KEY […]

Read More