Need help with this Multiple Choice:

Question31

Not yet answered

Marked out of 1.00

Flag question

Question text

Using INSERT INTO statement, several rows can be added at a time.

Select one:

True

False

Question32

Not yet answered

Marked out of 1.00

Flag question

Question text

tblProducts Table

ProductID

SupplierID

CategoryID

ProductName

1

1

1

Chai

2

1

1

Chang

3

1

2

Aniseed Syrup

4

2

2

Chef Anto's Cajun

Using the tblProducts Table shown above, which of the following SQL statements returns just the ProductID and ProductName of all the products whose CategoryID is either 2 or 3?

Select one:

a.Select ProductID, ProductName from tblProducts;

b.Select ProductID, ProductName from tblProducts Where CategoryID = 2 and CategoryID = 3;

c.Select ProductID, ProductName from tblProducts Where CategoryID 1;

d.Select ProductID, ProductName from tblProducts Where CategoryID = 2 or CategoryID = 3;

Clear my choice

Question33

Not yet answered

Marked out of 1.00

Flag question

Question text

After a database has been created, there are two ways of populating the tables - either from existing data or through the use of the user applications developed for the database.

Select one:

True

False

Question34

Answer saved

Marked out of 1.00

Flag question

Question text

Which of the following is wrong about domains of a relation?

Select one:

a.Two or more attributes canbe defined on the same domain

b.Two attributes that include values from different domains can easily be compared

c.A tuple can draw values from different domains

d.A pool of atomic values constitutes a domain

Clear my choice

Question35

Not yet answered

Marked out of 1.00

Flag question

Question text

Which of the following is true about a relation?

Select one:

a.There is a single attribute in each relation

b.The order of the tuples of a relation is determined by the primary key

c.A relation is a one-dimensional table

d.All the values in any column must be of the same type

Question36

Answer saved

Marked out of 1.00

Flag question

Question text

Data analysis begins with the statement of data design.

Select one:

True

False

Question37

Not yet answered

Marked out of 1.00

Flag question

Question text

To be in third normal form, the relation doesn't need to be in second normal form.

Select one:

True

False

Question38

Not yet answered

Marked out of 1.00

Flag question

Question text

Look at the below SQL create command. Consider that there is only one profession which is named as "Student". Which of the following statements is wrong about this SQL create statement?

CREATE TABLE USERS

(NAME CHAR(20),

AGE INTEGER,

PROFESSION VARCHAR(30))

Select one:

a.Stored data for the NAME column requires more database space than stored data for the PROFESSION column.

b.Table name is USERS.

c.There are three columns in this table.

d.CHAR (7) can also be used for the PROFESSION column.

Question39

Answer saved

Marked out of 1.00

Flag question

Question text

A relational database query normally returns many rows of data. But an application program usually deals with one row at a time. Which of the following is used to bridge this gap allowing the program to deal with on row at a time?

Select one:

a.Cursor

b.Trigger

c.PL/SQL

d.Sub select join

Clear my choice

Question40

Answer saved

Marked out of 1.00

Flag question

Question text

tblProducts Table

ProductID

SupplierID

CategoryID

ProductName

1

1

1

Chai

2

1

1

Chang

3

1

2

Aniseed Syrup

4

2

2

Chef Anto's Cajun

Using the tblProducts Table shown above, which of the following SQL statements returns just the ProductID, CategoryID andProductName of all the products with SupplierID of 1?

Select one:

a.Select * from tblProducts;

b.Select * from tblProducts Where ProductID=1;

c.Select ProductID, CategoryID, ProductName from tblProducts Where SupplierID =1;

d.Select ProductID=1, CategoryID, ProductName from tblProducts;

Clear my choice

Question21

Answer saved

Marked out of 1.00

Flag question

Question text

The SQL ALTER statement can be used to:

Select one:

a.change the table structure.

b.change the table data.

c.add rows to the table.

d.delete rows from the table.

Clear my choice

Question22

Answer saved

Marked out of 1.00

Flag question

Question text

Which of the following is wrong?

Select one:

a.If A BC, then A B and B C

b.If A B and B C, then A C

c.If A B and A C, then A BC

d.If A B and C is another attribute, then AC BC

Clear my choice

Question23

Not yet answered

Marked out of 1.00

Flag question

Question text

A relational database can be defined as a self-describing collection of non-integrated relations.

Select one:

True

False

Question24

Answer saved

Marked out of 1.00

Flag question

Question text

Given only the following part of an E-R diagram, what does the foot mark across the relationship line near the entity in the figure below indicate?

Select one:

a.A minimum cardinality of zero

b.A minimum cardinality of one

c.A maximum cardinality of one

d.A maximum cardinality of many

Clear my choice

Question25

Answer saved

Marked out of 1.00

Flag question

Question text

The Database Administrator is responsible for developing the logical data model.

Select one:

True

False

Question26

Answer saved

Marked out of 1.00

Flag question

Question text

tblProducts Table

ProductID

SupplierID

CategoryID

ProductName

1

1

1

Chai

2

1

1

Chang

3

1

2

Aniseed Syrup

4

2

2

Chef Anto's Cajun

Using the tblProducts Table shown above, which of the columns could be a Primary Key of another table?

Select one:

a.SupplierID

b.CategoryID

c.ProductName

d.All of the above

Clear my choice

Question27

Not yet answered

Marked out of 1.00

Flag question

Question text

Which of the following is not an element of the E-R Model?

Select one:

a.Use case

b.Entity

c.Cardinality

d.Relationship

Question28

Answer saved

Marked out of 1.00

Flag question

Question text

Considering all the other tables exist in the database, which of the following SQL statements that are used to create tables gives an error?

Select one:

a.Create Table Instructor(

ID integer Not Null,

Name varchar (40),

SureName varchar (40),

Primary Key (ID),

Unique (ID)

);

b.Create Table Instructor(

ID integer Not Null,

Name varchar (40),

SureName varchar (40),

CONSTRAINT pk Primary Key (ID)

);

c.Create Table Instructor(

ID integer Not Null,

Name varchar (40),

SureName varchar (40),

Primary Key (ID),

Foreign Key (Name)

);

d.Create Table Instructor(

ID integer Not Null,

Name varchar (40),

SureName varchar (40),

Primary Key (ID),

Foreign Key (Name) References Departments

);

Clear my choice

Question29

Answer saved

Marked out of 1.00

Flag question

Question text

What is wrong about a surrogate key?

Select one:

a.A surrogate is an attribute or set of attributes that uniquelyidentifies a record in a relation

b.A surrogate key does not exist in the real world as a real attribute of an entity set

c.A surrogate key is usually a generated unique number

d.It is not a good practice to use a surrogate key

Clear my choice

Question30

Answer saved

Marked out of 1.00

Flag question

Question text

What type of join is needed when you wish to include rows that do not have matching values?

Select one:

a.Equi-join

b.Natural join

c.Outer Join

d.All of the above

Clear my choice

Question11

Not yet answered

Marked out of 1.00

Flag question

Question text

Which of the following statements is wrong?

Select one:

a.SQL INSERT command is used to add data to a table

b.A data type of Char(30) indicates a fixed-length field of 30 characters

c.SQL was developed by IBM in the late 1970s

d.While creating a table using SQL, specifying the NULL property for a column means that only null values can be stored in that column

Question12

Not yet answered

Marked out of 1.00

Flag question

Question text

Which of the following is NOT true about the functional dependency A (B, C)?

Select one:

a.B is functionally dependent on A

b.A determines C

c.B and C together determine A

d.B and C are functionally dependent on A

Question13

Answer saved

Marked out of 1.00

Flag question

Question text

Which of the following is an incorrect statement?

Select one:

a.A precompiler is required to translate embedded SQL.

b.A precompiler is required to translate SQLJ.

c.Embedded SQL uses variables in the host language to pass parameters to SQL queries.

d.JDBC uses variables in the host language to pass parameters to SQL queries.

Clear my choice

Question14

Answer saved

Marked out of 1.00

Flag question

Question text

The following SQL is which type of join: SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T ;

Select one:

a.Equi-join

b.Natural join

c.Outer Join

d.Cartesian Join

Clear my choice

Question15

Answer saved

Marked out of 1.00

Flag question

Question text

A data model is a plan for a database design.

Select one:

True

False

Question16

Answer saved

Marked out of 1.00

Flag question

Question text

Given a relation R with three attributes A, B, C with the following dependencies:

C A

C B

Assume that there is not any multivalued attribute, what is the best normal form that R satisfies (1NF, 2NF, 3NF, or BCNF)?

Select one:

a.1NF

b.2NF

c.3NF

d.BCNF

Clear my choice

Question17

Not yet answered

Marked out of 1.00

Flag question

Question text

Referential integrity constraints are concerned with checking INSERT and UPDATE operations that affect the parent child relationships.

Select one:

True

False

Question18

Not yet answered

Marked out of 1.00

Flag question

Question text

Database application development is the process of obtaining real-world requirements, analyzing requirements, designing the data and functions of the system, and then implementing the operations in the system.

Select one:

True

False

Question19

Answer saved

Marked out of 1.00

Flag question

Question text

There could be static embedded SQL applications.

Select one:

True

False

Question20

Answer saved

Marked out of 1.00

Flag question

Question text

The result of a SELECT statement can contain duplicate rows.

Select one:

True

False

Which of the following statements is wrong?

Select one:

a.AVG() outputs the average (arithmetic mean) of the column values addressed by the query.

b.MAX() outputs the maximum, the largest, column value from those that are addressed by the query.

c.SUM() outputs the sum total of all the column values that are addressed by the query. This function can be used with every column.

d.MIN() outputs the minimum, the smallest, column value from those that are addressed by the query.

Question2

Answer saved

Marked out of 1.00

Flag question

Question text

ODBC can be directly used with Java because it uses a C interface.

Select one:

True

False

Question3

Not yet answered

Marked out of 1.00

Flag question

Question text

Which of the following SQL data types should not be used to define the numeric data: 111.11?

Select one:

a.integer(3,2)

b.numeric(3,2)

c.numeric(4,2)

d.numeric(5,2)

Question4

Not yet answered

Marked out of 1.00

Flag question

Question text

If a bank has to transfer 1,000 dollars from account A to account B, the step that increases the balance of account B by the amount of 1,000 dollars is called a transaction.

Select one:

True

False

Question5

Answer saved

Marked out of 1.00

Flag question

Question text

Create Table EXAMS (

SUB_NO integer Not Null,

STUDENT_NO integer Not Null,

MARK decimal (3),

DATE_TAKEN date,

Primary Key (SUB_NO)

);

The above SQL statement is used to create the EXAMS table. Considering the EXAMS table; which of the following table contents can't be inserted to the EXAMS table (assume date format is correct)?

Select one:

a.

SUB_NO

STUDENT_NO

MARK

DATE_TAKEN

1

1

2

2

85

b.

SUB_NO

STUDENT_NO

MARK

DATE_TAKEN

1

1

05-23-2020

2

1

85

02-23-2020

c.

SUB_NO

STUDENT_NO

MARK

DATE_TAKEN

1

1

05-23-2020

1

2

d.

SUB_NO

STUDENT_NO

MARK

DATE_TAKEN

1

1

2

2

Clear my choice

Question6

Not yet answered

Marked out of 1.00

Flag question

Question text

Which of the following is an incorrect statement?

Select one:

a.Access plans for dynamic SQL statements are generated only at runtime.

b.Dynamic SQL applications are slower than static SQL applications.

c.The access plan generated for a static SQL statement is stored in advance.

d.If the static SQL part of the application is modified, then the regeneration of access plans is not needed.

Question7

Answer saved

Marked out of 1.00

Flag question

Question text

Once the view is created, you can use it just like any table.

Select one:

True

False

Question8

Answer saved

Marked out of 1.00

Flag question

Question text

SQL can only be used as a Data Manipulation Language (DML).

Select one:

True

False

Question9

Not yet answered

Marked out of 1.00

Flag question

Question text

In an E-R diagram, it is possible that an entity can have a relationship to itself.

Select one:

True

False

Question10

Not yet answered

Marked out of 1.00

Flag question

Question text

Create Table EXAMS (

SUB_NO integer Not Null,

STUDENT_NO integer Not Null,

MARK decimal (3),

DATE_TAKEN date

);

The above SQL statement is used to create the EXAMS table. Considering the EXAMS table; which of the following SQL statements can be used to drop the DATE_TAKEN column of the EXAMS table?

Select one:

a.Alter Table EXAMS Drop DATE_TAKEN;

b.Alter EXAMS Drop DATE_TAKEN;

c.Alter Table DATE_TAKEN Drop EXAMS;

d.Alter Table Drop DATE_TAKEN;