NEW
Font size
WorksheetsCS2-QUIZ1
Total questions: 30
Worksheet time: 16mins
Jhaz is a second year college taking medicine. In database, name, year and course is an example of what terms used in database?
DBMS
RDBMS
Linked Data
Fieldname
Which of the following data types is consider as primary key?
Number
Short Text
AutoNumber
HyperLink
Which of the following is can be an example of database?
Gender
Name
Age
Address
What is the difference between a database and Database Management System (DBMS)?
None
Database is any records while DBMS data stored in a computer.
Database is any records while DBMS is a table represented the information
Database is inter-related information while DBMS is a collection of inter-related information.
Yuan upload his recent curriculum vitae to XYZ Organization because he is applying for a job. What data type in database is used to store the curriculum vitae of Yuan?
Hyperlink
OLE
Long Text
Attachment
Vien owns a money exchange for foreign currency, If Vien will decide to use a database for the conversion of foreign currency to Philippine peso, what database data type, he needed?
Number
Look up
Currency
Calculated
You are hired as new Quality Assurance in a company, and your first task is to list down the products, their description and classification. What kind of database are you going to use?
Database
DBMS
RDBMS
Which of the following is NOT an example of Database?
Birth Certificate
Student ID
SSS ID
Student Grade
Using MS Access, what part of the MS Access user can identify the data types of a fieldname?
Database Sheet View
Navigation Pane
SQL View
Design View
Which of the following is the fieldname for AutoNumber?
ID
Age
Grade
Birthday
What is the correct data type for teacher's class record pertaining to the equivalent of numeric grade like 1.25, 1.50. 1.75......?
Number
Look up
Calculated
Attachment
What is the correct phrase to differentiate database, DBMS and RDBMS?
quantity
speed
relationship
reliability
In a records, how to determine if the database is RDBMS?
TABLE
LINKED
COPY, DETELE, UPDATE, DISPLAY
PRIMARY KEY
MS Access is an example of what based on the following below?
Database
DBMS
RDBMS
Daryl is a billing clerk, recording daily the transaction of the bills the company incoming and out-going expenses/income. What is the most important fieldname is Daryl's database?
Currency
Look-up
Long Text
Date
Enter Parameter value is a kind of warning as error. This error pertains to what statement below?
Invalid data types for fieldname
SQL wrong or invalid fieldname
Hierarchy in using SQL commands
Adding additional command line after semi-colon
In the Books Table, if you wanted to view all books published in 2020 onwards, what is the correct SQL Code?
Select *
From Books
Where YearPub=2020
Select *
From Books
Where B_YearPub=2020
Select *
From Books
Where B_YearPub>=2020
Select *
From Books
Where B_YearPub<=2020
Character found is a kind of warning as error. This error pertains to what statement below?
Invalid data types for fieldname
SQL wrong or invalid fieldname
Hierarchy in using SQL commands
Adding additional command line after semi-colon
Select * From Table1
Order by age
Where age>=18
Based on the command line above, which of the following makes the SQL incorrect
Select * From Table1
Order by Age
Where age>=18
no error
Using the stud table, which of the following SQL codes is BEST code that will output the information of Jennifer Tadeo.
SELECT * FROM STUD
WHERE S_ID=4578
SELECT * FROM STUD
WHERE S_SURNAME="TADEO"
SELECT * FROM STUD
WHERE S_ZCODE=3000
ALL OF THE CHOICES ARE CORRECT
Which of the following SQL Code is CORRECT?
SELECT * FROM STUD
WHERE S_ADDRESS=MALOLOS
SELECT * FROM STUD
WHERE S_ZCODE=3000
SELECT * FROM STUD
WHERE S_ZCODE="3000"
SELECT * FROM STUD
WHERE ADDRESS="MALOLOS"
Which of the following fieldname is applicable to input mask?
ID
CC_NUMBER
CC_NAME
NONE OF THE CHOICES
Which of the following can be used to replication id?
ID
CC_NUMBER
CC_NAME
NONE OF THE CHOICES
Is number 1229-9083 is acceptable value for CC_number once change the format to replication ID?
Yes! accepted value
No! Invalid value
Which of the following cannot be converted to replication ID?
ID
CC_NUMBER
CC_NAME
ALL OF THE CHOICES
Which of the following is the correct DML code?
insert into creditcard
values (1,1,"1")
update creditcard
set tablename=ccard
insert into creditcard
values (11111,11111,"111111")
ALL OF THE CHOICES
This command means to append records?
Select-From
Update-Set
Insert into - Values
Delete From-Fieldname
Using the design view of the table cc, what is the possible error for SQL?
characters found
parameter value
data mismatch
syntax error
What is the correct and BEST application of DML?
Database
DBMS
RDBMS
Mailmerge
Which of the following statement is CORRECT?
You can update multiple records of data/information in a single DML command line
You can insert multiple records of data/information in a single DML command line
DML Is SQL
QBE uses DML
