Answered: 1) What happens if myfile.txt does not…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

1) What happens if myfile.txt does not exist?

Group of answer choices

fopen("myfile.txt", "r") returns FALSE

fread("myfile.txt") returns 0 bytes

fopen("myfile.txt", "r") creates "myfile.txt"

fread("myfile.txt", filesize("myfile.txt")) returns FALSE

2) The mysql command-line tool is used to _____.

perform administrative functions in MySQL server

access a database without using a username and password

connect to any database that exists on the same machine

develop websites that need to access a MySQL database

Fill in the blank to have this code block display selected information using PDO.

$sql = "SELECT itemName, quantity FROM inventory WHERE quantity > 1"; $result = $pdo->query($sql);foreach (_____) { echo "There are $row[quantity] of $row[itemName].<br>\n";}

Group of answer choices

$result as $row

$row = $result->fetch()

$row as $result->fetch()

$result in $row

What MySQL error code is returned when the following SQL statement attempts to insert into the table "devices" with the following columns: devId INTEGER, devType CHARACTER(10), devName VARCHAR(45)?

INSERTINTOdevices(deviceId,name)VALUES(789,'HP Pavilion');

Group of answer choices

1054: Unknown column name

1146: Table doesn't exist

1136: Number of values given in INSERT does not match number of columns

1064: Parsing error, bad syntax

5) Compare and contrast MySQLi Improved Extension (MySQLi) with PHP Data Objects (PDO).

Group of answer choices

PDO supports many RDBMS's, and MySQLi only supports MySQL

MySQLi supports MySQL, and PDO does not

MySQLi supports "prepared statements", and PDO does not

PDO supports "prepared statements", and MySQLi does not

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions