Answered: All the following instructions…

All the following instructions represent DDL functions EXCEPT _________. a. Alter Table b. Insert data inside a table c. Drop Table d. Create index

Programming with Microsoft Visual Basic 2017

8th Edition

ISBN:9781337102124

Author:Diane Zak

Publisher:Diane Zak

Chapter9: Sequential Access Files And Menus

Section: Chapter Questions

Problem 3RQ: Which of the following reads a line of text from a sequential access file and assigns the line...

See similar textbooks

Related questions

Q: The swap function shown below does not swap the values of x and y? def main(): X = 1 y = 2 swap(x,…

A: Note: In-order to run the code successfully, use the proper indentation as made in the program…

Q: #include main() { int eno; char enam[20],sc,pc,s,p; float nhw,rph,gp,ot,sss,med,wtax,ins,td,np;…

A: The edited code is running successfully. If you are running the code in turboC include clrscr(). If…

Q: Process Arrival time Burst time P1 7 P2 1 P3 P4 3 10 P5 6 3 Now apply the Round Robin (q = 4)…

Q: Which correctly calls the add) function? 0. def add(a, b, c): return a +b+c O add(2 4 6) O add(2 + 4…

Q: Which of the following statements shows the command used to input a char array with 30 members?

A: Which of the following statements shows the command used to input a char array with 30 members?…

Q: Complete and modify the code: 1 def match(x,y): 2 """Return the number with the…

A: Here we have a function match with have two parameters and will return the smaller number between…

Q: 0.5) (a) Create a Series object named sl from x, s2 from y, and s3 from z. Set the index of each…

A: the code is an given below : 995 answers PLEASE NOTE : FEEL FREE TO ASK ANY DOUBTS by COMMENTING…

Q: In python which of the following functions returns the first position position number of where value…

A: The above mentioned functions are used to find the position of the value occuring . These are…

Q: Fill in the following functions in a program that maps GIS data from NYC OpenData CSV files and…

A: I am assuming that each CSV has only Location's Latitude and Longitudes

Q: Which of the following function returns a list containing all the matches.? a. matches() b. find()…

A: matches() function in Python will search the regular expression pattern and return the first…

Q: Fill in the following functions in a program that maps GIS data from NYC OpenData CSV files and…

A: AS PER Python 3:I am filling the methods Defination as the description provided above.Any other…

Q: Which statement is TRUE about a pointer? The datatype of a pointer can only be initialised to 0.0.…

A: Answer:-(c)

Q: Using PHP Write a program using PHP programming language that trads the user name and password from…

A: <!DOCTYPE html> <html> <head> <title>LOGIN FORM</title>…

Q: want to add update function .c and .h class in that code

A: you mentioned also the update code . so we will arrange that code accordingly.also we add update.h…

Q: ''' In this function, you will try to make a transfer between two user accounts. bank is a…

A: Note that there were no restriction stated hence made this way. Note that in step2 only function is…

Q: Which of the following is the first operation in AES decryption algorithm? a. Shift rows. b.…

A: ANSWER:- C. Add Round Key

Q: 3. Index practice (a) Use $ notation to pull the OperatingSystem column from the survey data In…

A: To use R language in jupyter notebook Go to Anaconda navigator (type in search bar ) and create a…

Q: Which of the following is the correct function call for a swap function? Assume the purpose of swap…

Q: Build an application for a car rental company. It should offer the following features: 1-• Maintain…

A: The program is written in C language. Please find the solution in step2.

Q: Which of the following functions allocates multiple blocks of memory, each block of the a) malloc()…

A: Solution :

Q: Please create a Java Function called "ConnectToDbase" that will connect to the database. Assume…

A: getConnection() method of DriverManager class is used to establish connection with the database.…

Q: Which of the following statement is correct about dictionary clear() method.? a. delete only…

A: Please find the answer below

Q: 4. Three words are stored in the variables wordl, word2, and word3. The values of the variables are…

A: From the table, it is clear that the first and third words are swapped

Q: Which of the following is true? O when you use a dataAdapter.fill, you are copying the schema of a…

A: the correct answer with explanation given below

Q: randdf.py -> using "sys.argv" Create a program called randdf.py that has a function that takes two…

A: import pandas as pdimport random def createPanda(x,y): random.seed(10) #Create a list…

Q: Which statement is TRUE about a pointer? The datatype of a pointer can only be initialised to 0.0.…

A: Pointer: Pointer is used to point to a memory location of the datatype of which it is defined. For…

Q: Which of the following options correctly describes the result of the following C/C++ code? int a=6,…

A: Answer D. The value of variable a is changed to the value of variable b. #include <stdio.h>…

Q: Ques) cin.getline(n,20,'8'); reads characters entered by the user till??

A: In C++, getline() is used for input and output functions. getline() is q function that is used to…

Q: 7.Which of the following statements correctly describe functions in ANSI C? O The maximum number of…

A: Answer: our guidelines is answer first three question from the first question if multiple choice…

Q: In this function, you will try to make a transfer between two user accounts. bank is a…

A: def transfer(bank, log_in, userA, userB, amount):'''In this function, you will try to make a…

Q: Which of the following function calls requires the most memory (as would be visible in a memory…

A: The question is on choosing correct option from the given options.

Q: Write a statement that declares a pointer named 'qptr'. The pointer will be used to store the…

A: Write a statement that declares a pointer named aptr'. The pointer will be used to store the address…

Q: Choose the correct option 1)Which functions allow to change the location of the get and put…

A: Given: Choose the correct option 1)Which functions allow to change the location of the get and put…

Q: Which of the following declarations represents a pointer that cannot change the data it points to…

A: const Pointer: It is a pointer whose value cannot be changed after initialization. For Example: int…

Q: This function is used to create an user accounts dictionary and another login dictionary. The given…

A: Please find the complete code below: Commnet if you need any help # function valid to check for…

Q: Which of the following statement is TRUE? A. O A char datatype can only hold numbers. A char…

A: Given: To choose correct statement.

Q: Which of the statement is false and why? i) pCount = &count; ii) *pCount = &count; iii) int* pCount…

A: Answer is option 2 *pCount = &count; Because * appears before the pointer variable.

Q: Question 7 Consider these two Oracle Stored Functions: Assume that both have been successfully…

A: Anonymous block using Oracle is written and explained below .

Q: Which of the following statements a), b) or c) is false? O a. You interact with an object via a…

A: EXPLANATION: In context of programming, the object is basically the variable or the data structure…

Q: Create the following c functions: - void acceptSubscribers(Subscriber *, int size); // accept all…

A: According to the question, we have to create the c functions for the desired output. Note : we will…

Q: What function was used in cell C16?

A: Option (A) - COUNTIF() function is used to calculate or count the number of cells that is meet the…

Q: Which of the following functions allocates multiple blocks of memory, each block of the same size?…

A: The Answer is

Q: Which of the following is TRUE about a postfix expression? Stack of bricks The operator follows its…

A: The above is about postfix expression and option B is correct answer

Q: Which of the following statement is correct? Destructor destroys only float data members of…

A: Given question are multiple choice selected question.

Q: I am having an issue creating this function with a trigger using postgreSQL (plpgsql). Could someone…

A: Below is the required answer with explanation:

Q: Which of the following statements is the correct format to delete a dynamic array from the pointer…

A: About the correct format to delete a dynamic array from the pointer named blue

Q: (a) Write a program to add multiple employe details with validation Employee Details - ID - Name -…

A: As no language has been mentioned, C language has been used to design the code.

Q: 9. What function was used in cell C15? a. =COUNTIF() b. =COUNT() c. =COUNTA() d. =LEN()

A: Correct answer: COUNTIF()

Q: javascript

A: function edit() { var code = prompt("Enter the unique code"); if (code == user.random-generated…

Q: Create a dedicated functions for each of the following: 1. A function to Read the contents of an…

A: Solution: 1.xlsread function 2.dims() function 3.array2table

Concept explainers

Passing Array as Argument

An array is a data structure that holds only fixed-size data and its contents are arranged in contiguous memory slots. The primary purpose of using an array is to store data items of the identical type together. An array can stockpile any one of the following types of data: int, float, char and so forth. The elements are stored from index 0, and the difference between the two indexes of the array is termed as an offset. The array has a fixed size. Once the size is defined during array declaration, it cannot be changed later.

Question

All the following instructions represent DDL functions EXCEPT _________. a. Alter Table b. Insert data inside a table c. Drop Table d. Create index

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

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

The following code DOES NOT STOP to request the value for lname or ID. What line of code could you include to ensure the user can enter the requested integer and line of text? Modify the code below. Place the line of code in the correct place to fix the problem. Note: remember the file read pointer. int choice; string lname, Id; cout << “Welcome to the student record search system” << endl; cout << "Please enter 1 to search by last name or 2 to search by ID " << endl; cin >> choice; if (choice == 1) { cout << “Please enter the last name “ << endl; getline(cin, lname); } else { cout << "Please enter the ID “ << endl; getline(cin, Id); }
Which of the following are true with respect to the functionality provided by scanf and printf? Choose ONLY the correct options (one or more). Question 7 options: Although printf is not passed the pointer to an integer variable, it can still access the original integer variable's memory location to read its contents. None of the other options given are true. scanf needs to be passed the pointer to an integer variable because it needs to modify the original variable. scanf's functionality can also be implemented so that it can be given the original integer variable directly without having to pass its address.
Please create a Java Function called "ConnectToDbase" that will connect to the database. Assume that the middleware API is named "JDBCConnect". The details of the "JDBCConnect" function are below. // Returns true if successful, false if not successful boolean JDBCConnect(hostname, username, pass, database); // This is the Function you will call. You will code a Java function called "ConnectToDbase" that will call JDBCConnect. Assume that it returns a boolean value (true if successful, false if unsuccessful) Assume that it will have parameters for the values it will need to connect (e.g. hostname, ...) Print out an Error statement if you cannot connect.
MATCH OUTPUT AS IT IS . FOLLOW QUESTION ----------------------------------------- Dr. Varun needs an application for his clinic to maintain all the appointments for the day. The application should make appointments on the basis of first come first serve basis. And it should also perform the following functions: insert new appointment, delete an appointment, display all the appointments, show next appointment, check if there is no appointment or number of appointments are full for a day. Use class templates to perform the above-mentioned operations. Write a C++ program to perform the Queue operation. Note:Use the following class template for Queue creation. template <class T>class Queue{ private: int front,rear; T *queue; int maxsize;}; Define the following function in the class Queue class Method name Description int isFull() The method is used to check whether the queue is full or not. void insert(T) The method is used to display the rear…
Please use javascript to write the function. write the code for the edit() function. This function prompts the user for a unique code. If the entered unique code is matched with the random-generated unique code for the respective user, store the user index and reason index to the local storage with their relevant key. Then redirect the user to the edit page. Otherwise, if the unique code cannot match with the user’s random-generated unique code, alert the user by mentioning that incorrect unique code.
MAKE SURE THE WHOLE PROGRAM IS DONE ON WINDOWS DEV C++ with no ERRORS. This program should not include "outFile.close". Please make sure you can compile this code!!! Design a C++ program to store AND retrieve grocery information using the following guidelines: (1) Write a function named CreateGrocery List that repeatedly asks the user for grocery item and its cost and stores the information into a text file named grocery.txt (2) Your function must store at least 5 grocery items in grocery.txt (3) Write another function named ReadGrocery List that reads the information from grocery. txt and displays the information on the screen like Item Cost Apple $4.5 Banana $1.20 (4) Your program must include your information and algorithm as specified in class
Which line of the below code segment(s) is the wrong syntax that will cause an compilation error (choose all that apply): #include <stdio.h> void main void() { { A: #include <stdio.h> B: void main void() C:The first { D:The second {
Which of the following reads a line of text from a sequential access file and assigns the line (excluding the newline character) to the strText variable? inFile.Read(strText) inFile.ReadLine(strText) strText = inFile.ReadLine strText = inFile.Read(line)
Which of the following statements can be used to code a loop whose instructions you want processed 10 times? a. DoLoop b. ForNext c. All of the above.
In Chapter 11, you created the most recent version of the MarshallsRevenue program, which prompts the user for customer data for scheduled mural painting. Now, save all the entered data to a file that is closed when data entry is complete and then reopened and read in, allowing the user to view lists of customer orders for mural types.
1. Use the RAND function and the Copy command to generate 100 random numbers. a. What fraction of the random numbers are smaller than 0.5? b. What fraction of the time is a random number less than 0.5 followed by a random number greater than 0.5? c. What fraction of the random numbers are larger than 0.8? d. Freeze these random numbers. However, insteadof pasting them over the original random numbers, paste them onto a new range. Then press the F9 recalculate key. The original random numbers should change, but the pasted copy should remainthe same
Two of the menu options (#2 and #3) are unfinished, and you need to complete the code necessary to write to and read from a binary file. You will need to read through the code to find the functions that are called by these options, and then supply the missing code. Please help me get menu 2 and 3 to display properly.the .cpp and .h have the information:.cpp file: // Corporate Sales Data Outputusing namespace std; #include <iostream>#include <fstream>#include <stdlib.h>#include "HeaderClassActivity1.h" int main() { Sales qtrSales[NUM_QTRS]; while (true) { cout << "Select an option: " << endl; cout << "1. Input data" << endl; cout << "2. Write data to file" << endl; cout << "3. Read data from file" << endl; cout << "4. Display sales" << endl; cout << "99. End program" << endl; int menuItem; cin >> menuItem; if (menuItem ==…