Question 1

Distinguish between Char and VarChar data types.

Accepted Answer

Char data type is fixed length,so that no matter what the actual length of the data entered is,it will always take exactly the same storage space.For example,Char(10)indicates that 10 characters will always be stored for each value of that column.If the actual data entered is less than the specified fixed length,the data will be padded with blanks.VarChar data type is variable length so that only the amount of space actually needed to store the data is used.Although VarChar may be more efficient in its use of space,it is not always preferred.VarChar requires the storage of some extra data to indicate the length of the data values,plus it requires some extra processing by the DBMS to arrange the variable length data.

Question 2

Given the table STUDENT(StudentID,Name,Advisor),which of the following SQL statements would be used to add new student data to the STUDENT table?

Accepted Answer

A)  INSERT DATA STUDENT SET StudentID=123, Name='Jones', Advisor='Smith'; 
B)  INSERT INTO STUDENT VALUES (123, 'Jones', 'Smith'); 
C)  INSERT INTO STUDENT (New Student Data) VALUES (123, 'Jones', 'Smith'); 
D)  INPUT DATA STUDENT SET StudentID=123, Name=' Jones', Advisor='Smith'; 
E)  INPUT INTO STUDENT (123, 'Jones', 'Smith'); 
A)  INSERT DATA STUDENT SET StudentID=123, Name='Jones', Advisor='Smith'; 
B)  INSERT INTO STUDENT VALUES (123, 'Jones', 'Smith'); 
C)  INSERT INTO STUDENT (New Student Data) VALUES (123, 'Jones', 'Smith'); 
D)  INPUT DATA STUDENT SET StudentID=123, Name=' Jones', Advisor='Smith'; 
E)  INPUT INTO STUDENT (123, 'Jones', 'Smith'); B

Question 3

When using SQL to create a table,specifying the NULL property for a column indicates that only null values may be stored in that column.

Accepted Answer

A) True 
 B)False  False

Question 4

The SUM built-in function in SQL is used to total the values in a numeric column.

Accepted Answer

A) True 
 B)False

Question 5

Which of the following is not one of the five SQL built-in functions?

Accepted Answer

A)  MODE 
B)  SUM 
C)  COUNT 
D)  MAX 
E)  AVG 
A)  MODE 
B)  SUM 
C)  COUNT 
D)  MAX 
E)  AVG

Question 6

Microsoft Access SQL supports and will correctly implement the numeric data type with (m,n)notation.

Accepted Answer

A) True 
 B)False

Question 7

In Microsoft Access,the default method of creating and running a query is ________.

Accepted Answer

Query By E

Question 8

Referential integrity constraints using the ON DELETE NO ACTION phrase may be explicitly stated when the table is created using the CREATE TABLE statement.

Accepted Answer

A) True 
 B)False

Question 9

In SQL,the LIKE keyword can be combined with the NOT keyword to form the NOT LIKE condition for selecting values.

Accepted Answer

A) True 
 B)False

Question 10

To open a new Microsoft Access Query window:

Accepted Answer

A)  click the New button on the Home command tab. 
B)  click the New Query button on the Home command tab. 
C)  click the Create Query button on the Create command tab. 
D)  click the New Query in Design view button on the Create command tab. 
E)  click the Query Design button on the Command tab. 
A)  click the New button on the Home command tab. 
B)  click the New Query button on the Home command tab. 
C)  click the Create Query button on the Create command tab. 
D)  click the New Query in Design view button on the Create command tab. 
E)  click the Query Design button on the Command tab.

Question 11

Explain the essential format of the CREATE TABLE statement.

Accepted Answer

The essential format for the CREATE TABL

Question 12

To open a new Microsoft Access Query window,click the Query Design button on the Create command tab.

Accepted Answer

A) True 
 B)False

Question 13

Which of the following data types used in SQL would define a fixed-length text field of 10 characters?

Accepted Answer

A)  text(10) 
B)  char(10) 
C)  varchar(10) 
D)  fixed(10) 
E)  length(10) 
A)  text(10) 
B)  char(10) 
C)  varchar(10) 
D)  fixed(10) 
E)  length(10)

Question 14

The SQL keyword(s)________ mean(s)that a value must be supplied before a new row can be created.

Accepted Answer

The answer of The SQL keyword(s)________ mean(s)that a value must...

Question 15

SQL stands for ________.

Accepted Answer

Structured

Question 16

SQL is a data sublanguage,not a complete programming language.

Accepted Answer

A) True 
 B)False

Question 17

Which symbol is used in standard SQL as a wildcard to represent a series of one or more unspecified characters?

Accepted Answer

A)   (percent sign) % 
B)   (exclamation mark) ! 
C)  (underscore)  _ 
D)  (question mark) ? 
E)   (semi-colon) ; 
A)   (percent sign) % 
B)   (exclamation mark) ! 
C)  (underscore)  _ 
D)  (question mark) ? 
E)   (semi-colon) ;

Question 18

Given the tables STUDENT(StudentID,StudentName,AdvisorID)
ADVISOR(AdvisorID,AdvisorName,Office,Phone)
Which of the following SQL statements would be used to implant a join between the two tables?

Accepted Answer

A)  WHERE STUDENT MATCH ADVISOR 
B)  WHERE STUDENT.AdvisorID MATCH ADVISOR.AdvisorID 
C)  WHERE STUDENT = ADVISOR 
D)  WHERE STUDENT JOIN ADVISOR 
E)  WHERE STUDENT JOIN ADVISOR ON STUDENT.AdvisorID = ADVISOR.AdvisorID 
A)  WHERE STUDENT MATCH ADVISOR 
B)  WHERE STUDENT.AdvisorID MATCH ADVISOR.AdvisorID 
C)  WHERE STUDENT = ADVISOR 
D)  WHERE STUDENT JOIN ADVISOR 
E)  WHERE STUDENT JOIN ADVISOR ON STUDENT.AdvisorID = ADVISOR.AdvisorID

Question 19

The basic idea of a join is to combine the contents of two or more relations into a new relation.

Accepted Answer

A) True 
 B)False

Question 20

Given the table
CUSTOMER(CustID,Name,PhoneNumber,AccountBalance)
write the standard SQL query to retrieve the Name and Phone Number of customers with a balance greater than 50.

Accepted Answer

SELECT Name,PhoneNum

Distinguish between Char and VarChar data types.

Given the table STUDENT(StudentID,Name,Advisor),which of the following SQL statements would be used to add new student data to the STUDENT table?

When using SQL to create a table,specifying the NULL property for a column indicates that only null values may be stored in that column.

The SUM built-in function in SQL is used to total the values in a numeric column.

Which of the following is not one of the five SQL built-in functions?

Microsoft Access SQL supports and will correctly implement the numeric data type with (m,n)notation.

In Microsoft Access,the default method of creating and running a query is ________.

Referential integrity constraints using the ON DELETE NO ACTION phrase may be explicitly stated when the table is created using the CREATE TABLE statement.

In SQL,the LIKE keyword can be combined with the NOT keyword to form the NOT LIKE condition for selecting values.

To open a new Microsoft Access Query window:

Explain the essential format of the CREATE TABLE statement.

To open a new Microsoft Access Query window,click the Query Design button on the Create command tab.

Which of the following data types used in SQL would define a fixed-length text field of 10 characters?

The SQL keyword(s)________ mean(s)that a value must be supplied before a new row can be created.

SQL stands for ________.

SQL is a data sublanguage,not a complete programming language.

Which symbol is used in standard SQL as a wildcard to represent a series of one or more unspecified characters?

Given the tables STUDENT(StudentID,StudentName,AdvisorID) ADVISOR(AdvisorID,AdvisorName,Office,Phone) Which of the following SQL statements would be used to implant a join between the two tables?

The basic idea of a join is to combine the contents of two or more relations into a new relation.

Given the table CUSTOMER(CustID,Name,PhoneNumber,AccountBalance) write the standard SQL query to retrieve the Name and Phone Number of customers with a balance greater than 50.

Getting Started

The Relational Model

Data Modeling and the Entity-Relationship Model

Database Design

Database Administration

Database Processing Applications

Big Data, data Warehouses, and Business Intelligence Systems

Getting Started With Microsoft Sql Server 2012

Getting Started With Oracle Database 11g Release 2

Getting Started With Mysql 56 Community Server

James River Jewelry Project Questions

Sql Views

Getting Started in Systems Analysis and Design

Getting Started With Microsoft Visio 2010

The Access Workbench-section Microsoft Access

Getting Started With Web Servers, php, and the Netbeans IDE

Business Intelligence Systems

Filters

Exam 3: Structured Query Language

Distinguish between Char and VarChar data types.

Given the table STUDENT(StudentID,Name,Advisor),which of the following SQL statements would be used to add new student data to the STUDENT table?

When using SQL to create a table,specifying the NULL property for a column indicates that only null values may be stored in that column.

The SUM built-in function in SQL is used to total the values in a numeric column.

Which of the following is not one of the five SQL built-in functions?

Microsoft Access SQL supports and will correctly implement the numeric data type with (m,n)notation.

In Microsoft Access,the default method of creating and running a query is ________.

Referential integrity constraints using the ON DELETE NO ACTION phrase may be explicitly stated when the table is created using the CREATE TABLE statement.

In SQL,the LIKE keyword can be combined with the NOT keyword to form the NOT LIKE condition for selecting values.

To open a new Microsoft Access Query window:

Explain the essential format of the CREATE TABLE statement.

To open a new Microsoft Access Query window,click the Query Design button on the Create command tab.

Which of the following data types used in SQL would define a fixed-length text field of 10 characters?

The SQL keyword(s)________ mean(s)that a value must be supplied before a new row can be created.

SQL stands for ________.

SQL is a data sublanguage,not a complete programming language.

Which symbol is used in standard SQL as a wildcard to represent a series of one or more unspecified characters?

Given the tables STUDENT(StudentID,StudentName,AdvisorID) ADVISOR(AdvisorID,AdvisorName,Office,Phone) Which of the following SQL statements would be used to implant a join between the two tables?

The basic idea of a join is to combine the contents of two or more relations into a new relation.

Given the table CUSTOMER(CustID,Name,PhoneNumber,AccountBalance) write the standard SQL query to retrieve the Name and Phone Number of customers with a balance greater than 50.

Getting Started

The Relational Model

Data Modeling and the Entity-Relationship Model

Database Design

Database Administration

Database Processing Applications

Big Data, data Warehouses, and Business Intelligence Systems

Getting Started With Microsoft Sql Server 2012

Getting Started With Oracle Database 11g Release 2

Getting Started With Mysql 56 Community Server

James River Jewelry Project Questions

Sql Views

Getting Started in Systems Analysis and Design

Getting Started With Microsoft Visio 2010

The Access Workbench-section Microsoft Access

Getting Started With Web Servers, php, and the Netbeans IDE

Business Intelligence Systems

Filters