Font size
WorksheetsSemester 1 Exam Review
Total questions: 94
Worksheet time: 55mins
If a user enters "eight books," using parseInt on this input would give:
NaN
eight
8
Undefined
In a relational database, a "one-to-many" relationship means:
Each record in one table links to multiple records in another
Each record links to only one record in another table
All records link to only one field
Each table has only one record
To format data in columns and rows in Access, use:
Form
Query
Table
Report
If "45 apples" is processed using parseInt, it will return:
NaN
45
apples
0
The purpose of "const" in JavaScript is to:
Declare variables that cannot be reassigned
Make values mutable
Declare local variables only
Create arrays only
If a user enters "45.78" and parseInt is used, the result is:
45.78
45
NaN
78
What data type is appropriate for a field in a database that stores dates?
Integer
Text
Currency
Date/Time
To link related data across tables in MS Access, you use:
Primary keys only
Foreign keys
Text fields
Only numeric fields
To ensure a prompt value is stored as a number, you could use:
parseFloat()
Int()
Num()
parse()
What will "parseFloat('87.45.67')" return in JavaScript?
87.45
NaN
67
45
Which is NOT an available object type in Microsoft Access?
Report
Form
Query
Spreadsheet
In a relational database, a primary key:
Uniquely identifies each record
Ensures data consistency across tables
Is always numeric
Tracks all modifications in a record
For storing currency values in MS Access, which data type is best?
Memo
Number
Currency
Date/Time
A foreign key in a database is primarily used to:
Connect related tables
Store unique records only
Track deleted records
Make tables more readable
In a database, linking "CustomerID" in "Orders" to "CustomerID" in "Customers" represents:
One-to-One relationship
One-to-Many relationship
Many-to-One relationship
Many-to-Many relationship
Which JavaScript function extracts the integer 123 from "123 oranges"?
Number("123 oranges")
parseInt("oranges 123")
parseInt("123 oranges")
parseFloat("oranges 123")
In MS Access, the default view when a table opens is:
Report View
Datasheet View
Design View
Layout View
A relational database is defined as:
A flat database file
One with linked tables
A data storage in a single row
A read-only database structure
Which operator checks for strict equality in JavaScript (same type and value)?
==
===
!=
<=
The result of parseInt("67.89") in JavaScript is:
67.89
67
89
NaN
The correct syntax to declare a constant in JavaScript is:
const variableName = value;
var variableName = value;
constant variableName = value;
let variableName = value;
To treat a dropdown selection as an integer in JavaScript, use:
parseFloat()
Number()
parseInt()
toString()
If the user inputs "Chris" into a prompt box, what is displayed using alert?
"Chris has logged in."
An alert saying "Chris"
The prompt asks for input again
A message "Hello, Chris!"
Which rule is correct for variable names in JavaScript?
Variable names are not case-sensitive
They can contain spaces
They may start with a symbol like $
They cannot start with numbers
In JavaScript, == checks:
Type and value equality
Only value equality
Type only
Length of values
What does a database query return?
All records from a specific table
A subset of data based on given criteria
All unique records in a table
A full backup of the database
Changing rows="50%,50%" to rows="25%,75%" will:
Have the bottom frame take up 75%
Resize both frames equally
Stack frames vertically
Place top frame at 50% height
In JavaScript, "document.write" can be used to:
Alert a message
Log to the console
Directly write to HTML
Open a prompt box
To add two values in JavaScript and avoid concatenation, you use:
parseFloat()
parseInt()
All of the above
When using prompt(), user input is by default treated as:
Integer
Float
Boolean
String
parseFloat("45.9abc") will result in:
45.9
NaN
9
Undefined
The correct way to assign 2024 as a constant in JavaScript is:
let year = 2024;
const year = 2024;
variable year = 2024;
year = 2024;
A prompt() with a string value, "4 oranges", if parsed with parseInt, will result in:
4
oranges
NaN
0
"===" in JavaScript checks for:
Value equality only
Reference equality
Both value and type equality
Length equality
The default function to open a table in MS Access is:
Query View
Design View
Data Sheet View
Report View
A foreign key ensures that:
Data is unique
Tables are connected by key fields
Tables only hold integer values
Only one record is present per table
Which operator is used for "not equal to" in JavaScript?
!==
<>
!=
==
What does parseInt("abc123") return?
123
NaN
abc
0
A prompt for "123.456" with parseFloat() will result in:
123
456
NaN
123.456
Write a statement that asks for 2 inputs: totalAmount and discount. Subtracts the two variables and store the result in a variable called finalPrice. Use parseFloat to treat the inputs as decimal values.stores
Write a statement that multiplies two variables, price and quantity, and stores the result in a variable called totalCost. Use parseFloat to treat the inputs as decimal values, and use prompt() to get the inputs.
Which of the following code snippets correctly calculates the interest by multiplying principalAmount, rateOfInterest, and timePeriod, and stores the result in a variable called interest? It also uses parseFloat to treat the inputs as decimal values, and window.prompt() to get the inputs.
Which of the following code snippets correctly calculates the total cost by multiplying pricePerItem and quantity, then adding tax, and stores the result in a variable called totalCost? It also uses parseFloat to treat the inputs as decimal values, and window.prompt() to get the inputs.
What will be the output of parseInt("100.5 apples")?
100.5
100
NaN
0
Which of the following is a valid way to declare a variable in JavaScript?
var myVar = 10;
let myVar = 10;
const myVar = 10;
All of the above
In MS Access, which object is used to create a user interface for data entry?
Form
Table
Query
Report
What will be the output of parseInt("12.34abc")?
12.34
12
NaN
34
Which of the following is NOT a valid way to declare a variable in JavaScript?
var myVar = 10;
let myVar = 10;
const myVar = 10;
declare myVar = 10;
If a user inputs "3.14 pies" and parseFloat is used, the result will be:
3.14
3
NaN
pies
What will be the output of "5" + 3 in JavaScript?
8
53
NaN
5
In MS Access, which of the following is used to filter records?
Sort
Query
Form
Report
The rows in a database are called:
Records
Fields
Attribute
Coloum
Which of the following is not a valid JavaScript variable name?
2names
_first_and_last_names
FirstAndLast
None of the above
Which of the following is the correct syntax to display "Letsfindcourse" in an alert box using JavaScript?
alert-box("Letsfindcourse");
confirm("Letsfindcourse");
msgbox("Letsfindcourse");
alert("Letsfindcourse");
What will be the output of the following Javascript code?
var string1 = "Hello World";
var intvalue = 30;
alert( string1 + intvalue );
Hello World 30
30
Hello World30
Exception
Which symbol is used for comments in Javascript?
\\
//
\* *\
\* */
What are the types of Pop up boxes available in JavaScript?
Alert
Prompt
Confirm
All of the above
What is the primary purpose of the <frameset> tag in HTML?
To define the structure of a webpage
To divide a webpage into multiple sections
To apply styles to a webpage
To create hyperlinks
Which HTML element is replaced by `<frameset> in a frameset-based page?
<html>
<head>
<body>
<meta>
What is the correct syntax for defining a frameset with two horizontal frames?
<frameset rows="50%, 50%">`
<frameset cols="50%, 50%">
<frameset horizontal="50%, 50%">
<frameset frame="50%, 50%">
How do you define three vertical frames in HTML?
`<frameset rows="33%, 33%, 33%">`
`<frameset cols="33%, 33%, 33%">`
`<frameset cols="33%, 33%, 34%">`
Both b and c
Which attribute of the `<frameset>` tag is used to define the number of columns?
rows
cols
column
grid
What does the ``<frame>`` tag do?
Defines the contents of each frame
Divides the page into multiple sections
Embeds multimedia files
Links external stylesheets
In the syntax `<frameset rows="30%, 70%">`,what does the 30% and 70% indicate?
Width of the frames
Height of the frames
Both width and height
Space between frames
Which attribute is used in a frame to prevent scrolling?
noscroll
scrolling
preventscroll
disable_scroll
A special symbol or sign that indicates the remaining size of the frame.
&
@
*
$
Which view of table is used to insert a field name in table.
Date sheet
Design
Database
all of the above
The default extension of Ms-Access file is __________
.acccdb
.accdb
.abccd
.acbdc
Which datatype will be used to generate numbers automatically while inserting data?
Number
Auto number
Automatic Number
Integer
Each item from this list is classified as...
Name
Birthdate
Social Security No.
Street
City
State
Zip
table
record
field/Attribute Name
Data Type
Which data type would be most suitable for the 'Price' field?
Currency
Date/Time
Yes/No
Memo
A unique identifier used in creating a table that assures there will be no duplicate data.
Primary Key
Query
Data Type
__________allows to divide the web page into several independent parts.
Frameset
Frame
Nested Frame
________is defined as a set of frames inserted in an HTML web page
Frameset
Frame
Nested Frame
If you need to display a message in browser you have to select following syntax
Object.method()
document.write()
window.prompt
print()
_________________are the name assigned to memory location that can be used for storing data
JavaScript
Variables
Operators
variable can have a short name like x or more descriptive name like Fname
True
False
The __________ attribute indicates the number of columns in a frameset.
TABLE
VERT
COLUMNS
COLS
Variable x has a value of 5. Variable y has a value of 7
how does x < 7 && y > 6 evaluate ?
True
false
typeError
undefined
which of these is not a logical operator ?
!
&
&&
||
var typeOfApples="Fuji";
Which of the following platform(s) can be used to run Javascript Code
Google Chrome
Firefox
Microsoft Edge
Safari
His name is George and he is more than 16 years old
Which of the following is the best way to write the above statement?
if (name != "George" && age > 16 )
if (name == "George" && age > 16 )
if (name = "George" || age > 16 )
if (name == "George" || age > 16 )
A store has 20 apples in its inventory. How can you store this information in a JavaScript variable?
var numApples == 20;
20 = numApples;
var numApples = 20;
var num apples = 20;
