1Z0-171 Exam Question 46
Which of the following is true about foreign key constraints in SQL?
1Z0-171 Exam Question 47
The column data type is converted to a primary key.
1Z0-171 Exam Question 48
What is the output of the following query?
SELECT CURRENT_DATE FROM dual;
SELECT CURRENT_DATE FROM dual;
1Z0-171 Exam Question 49
Which function returns the current system date and time in the database session's time zone?
1Z0-171 Exam Question 50
What does the following SQL statement do?
CREATE TABLE employees (
employee_id NUMBER PRIMARY KEY,
first_name VARCHAR2(50),
hire_date DATE NOT NULL
);
CREATE TABLE employees (
employee_id NUMBER PRIMARY KEY,
first_name VARCHAR2(50),
hire_date DATE NOT NULL
);