Oracle Exam 1Z0-770 Topic 2 Question 43 Discussion

Actual exam question for Oracle's 1Z0-770 exam

Question #: 43
Topic #: 2

[All 1Z0-770 Questions]

Examine this code used in Quick SQL:

students

name

roll no num

Quick SQL is using default settings.

Which table creation script or other output is produced?

AAn Invalid column definition error message will be displayed.

Bcreate table students (
id number generated by default on null as identity constraint students id pk primary
key,
name varchar2 (255 char) not null,
roll no number
)
;

Ccreate table students (
id number generated by default on null as identity constraint students_id_pk primary
key,
name varchar2 (255 char),
roll_no number
)
;

Show Suggested Answer

Suggested Answer: C

The table creation script produced by Quick SQL is:

create table emp_salary ( id number generated by default on null as identity constraint emp_salary_id_pk primary key, name varchar2 (255 char) not null, salary number, commission_yn varchar2 (1 char) check (commission_yn in ('Y','N')) default 'N' not null );

The commission_yn column will default to 'N' because of the default clause in the column definition. It will also restrict acceptable values to 'Y' or 'N' because of the check constraint. The other options are incorrect because they do not match the output of Quick SQL. Verified References:Using Quick SQLAbout Quick SQL Shorthand Syntax

by Avery at May 04, 2025, 01:40 AM

Limited Time Offer

25%

Off

Get Premium 1Z0-770 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!