Question: 1. Which is the correct format to create table? CREATE Customer TABLE (Customer_id Number, Customer_name Varchar(25), Birthday); CREATE TABLE Customer (Customer_id Number, Customer_name Varchar(25), Birthday);

1.

Which is the correct format to create table?

"CREATE Customer TABLE (Customer_id Number, Customer_name Varchar(25), Birthday);"

"CREATE TABLE Customer (Customer_id Number, Customer_name Varchar(25), Birthday);"

"CREATE TABLE (Customer_id Number, Customer_name Varchar(25), Birthday) INTO Customer;"

"CREATE Customer TABLES (Customer_id Number, Customer_name Varchar(25), Birthday);"

2.

Select the correct answer for each blank below to create a table with three columns: id as a primary key, username and email of type varchar.

_____ test (id int, username _____(30), email varchar(20), _____(id))

CREATE TABLE , Char, Primary Key

CREATE DATABASE , Primary Key, Varchar

CREATE TABLE , Varchar, Primary Key

CREATE , Varchar, Primary Key

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Q:

CREATE TABLE customer ( customer_id INTEGER NOT NULL, customer_name VARCHAR (25) NOT NULL, address_line_1 VARCHAR (200), city VARCHAR (100), state_province CHAR (25), postal_code VARCHAR (50),...

Q:

CREATE TABLE customer ( customer_id INTEGER NOT NULL, customer_name VARCHAR (25) NOT NULL, address_line_1 VARCHAR (200), city VARCHAR (100), state_province CHAR (25), postal_code VARCHAR (50),...

Q:

CREATE TABLE customer ( customer_id INTEGER NOT NULL, customer_name VARCHAR (25) NOT NULL, address_line_1 VARCHAR (200), city VARCHAR (100), state_province CHAR (25), postal_code VARCHAR (50),...

Q:

Problem 1. (70 points) Consider the relational database defined below: create table customer ( customer_ID varchar ( 1 0 ) , customer_name varchar ( 3 0 ) , ZIP_code char ( 5 ) , primary key (...

Q:

create table customer ( customer_ID varchar ( 1 0 ) , customer_name varchar ( 3 0 ) , ZIP_code char ( 5 ) , primary key ( customer_ID ) ) ; create table product ( product_name varchar ( 1 0 ) , price...

Q:

EXPRESS in RELATIONAL algebra create table customer ( customer_ID varchar ( 1 0 ) , customer_name varchar ( 3 0 ) , ZIP_code char ( 5 ) , primary key ( customer_ID ) ) ; create table product (...

Q:

Consider the relational database defined below: create table customer ( customer_ID varchar ( 1 0 ) , customer_name varchar ( 3 0 ) , ZIP_code char ( 5 ) , primary key ( customer_ID ) ) ; create...

Q:

SQL Which is the correct format for create table? Select one: A. CREATE EMP.SCOTt table ( EmpNo NUMBER, EName VARCHAR (25), Job CHAR (10), Hiredate DATE ) B. CREATE EMP TABLE ( EmpNo NUMBER, EName...

Q:

Use postgresql to complete this Assignment steps Run the script from Lab 3. to create/reset all tables, constraints and data. Write one or more commands for the given requirements listed below....

Q:

WRITE IN PL SQL CODE GIVEN THE BELOW TABLES : create table room_info ( Reservation_ID int, room_number number not null, hotel_code number, room_type varchar (200), room_rate varchar (50), room_status...

Q:

Why proto-oncogenes were not eliminated during evolution?

Q:

For the data in Exercise 4, a) Test the null hypothesis at = 0.05 using the pooled t-test. (Show the t-statistic, P-value, and conclusion.) b) Find a 95% confidence interval using the pooled degrees...

Q:

The method of drug administration that is consideraded percutaneusous is

Q:

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...