MCQs

Disclaimer:

Educational Use Only:

The website links provided are to be used strictly for educational and knowledge-gaining purposes only.

No Misuse:

Do not misuse the links or the information contained therein for any commercial, illegal, or unethical activities.

Respect for Websites and Businesses:

Respect the intellectual property and business interests of the websites and their owners. Do not attempt to alter, copy, or redistribute content without proper authorization.

Acknowledge Value of Knowledge:

Recognize and value the knowledge and resources shared by these websites. Use the information responsibly and ethically.

No Endorsement:

The provision of these links does not imply endorsement of the linked sites, their content, or their products and services. Users are responsible for evaluating the suitability and accuracy of the information.

User Responsibility:

By accessing these links, you agree to use the information at your own risk and to comply with all applicable laws and website terms of use.

Overall MCQs for Reference

Which method is used to insert a new column at a specific position in a pandas DataFrame?
a. add()
b. insert()
c. append()
d. concat()
Answer: b. insert()studyopedia
In Excel, what is the shortcut to insert a new row?
a. Ctrl + Shift + Plus (+)
b. Ctrl + Shift + Minus (-)
c. Ctrl + T
d. Ctrl + C
Answer: a. Ctrl + Shift + Plus (+)sanfoundry
Which clause is mandatory in SQL to insert values into a table?
a. Add
b. New
c. Values
d. Insert Row
Answer: c. Valuessanfoundry
To insert new cells in an Excel worksheet, you should:
a. Use File menu
b. Right-click and select Insert
c. Use Data tab
d. Use Review tab
Answer: b. Right-click and select Insertreadmcqs
Which pandas method allows adding a new row to a DataFrame?
a. append()
b. insert_row()
c. newRow()
d. add()
Answer: a. append()scribd
In spreadsheet software, which menu provides options to insert cells, rows, or columns?
a. File
b. Insert
c. Data
d. Home
Answer: b. Insertcsiplearninghub
When inserting a new cell in Excel, what happens to existing cells?
a. They are deleted
b. They shift down or right
c. They shift up only
d. There’s no effect
Answer: b. They shift down or righttestbook
In pandas, which method can be used to add a new column?
a. df.assign()
b. df.insert()
c. Both a and b
d. Neither
Answer: c. Both a and btechtipnow+1
In SQL, which statement copies rows from one table to another?
a. INSERT INTO first VALUES SELECT *
b. INSERT INTO first SELECT * FROM second
c. INSERT INTO first COPY SELECT *
d. INSERT INTO first FROM second
Answer: b. INSERT INTO first SELECT * FROM secondsanfoundry
In Excel, merging two cells creates:
a. Two empty cells
b. A new larger cell
c. A new worksheet
d. A separate column
Answer: b. A new larger celltestbook
In pandas, which attribute is used to access a column directly?
a. by position
b. by index
c. by column label
d. by function
Answer: c. by column labeltechtipnow
What is the default behavior when inserting a cell in Excel with “Shift cells down”?
a. Shift entire column left
b. Shift cells below down
c. Shift row up
d. Delete cell
Answer: b. Shift cells below downtestbook
How do you insert a new worksheet in Excel?
a. Press Ctrl + N
b. Right-click on a worksheet tab and select Insert
c. Right-click on a cell and select Insert
d. Use Insert tab in the Ribbon
Answer: b. Right-click on a worksheet tab and select Insertsanfoundry
Which method is NOT used to insert a new row in pandas?
a. append()
b. loc[]
c. insert_row()
d. concat()
Answer: c. insert_row()askfilo+1
In SQL, to assign a NULL value to a column using INSERT, which syntax is used?
a. INSERT INTO table VALUES (NULL)
b. INSERT NULL INTO table
c. VALUES (BLANK)
d. INSERT INTO table (no values)
Answer: a. INSERT INTO table VALUES (NULL)sanfoundry
In Excel, to insert multiple contiguous rows at once, select rows and:
a. Right-click and choose Insert
b. Click File menu
c. Use Alt + Enter
d. Press F5
Answer: a. Right-click and choose Insertreadmcqs
What does the ‘loc’ method do in pandas?
a. Add a column
b. Add a row by label
c. Insert a cell
d. Remove a column
Answer: b. Add a row by labeltechtipnow
In SQL, which command is used to add new rows?
a. UPDATE
b. ADD
c. INSERT INTO
d. MERGE
Answer: c. INSERT INTOsanfoundry
In Excel, to insert a new column to the left, use:
a. Insert > Insert Sheet Rows
b. Insert > Insert Sheet Columns
c. Data > Insert Column
d. Review > Insert
Answer: b. Insert > Insert Sheet Columnscsiplearninghub
In pandas, which argument places a new column as the first column?
a. insert(loc=0, …)
b. insert(position=1, …)
c. append()
d. add()
Answer: a. insert(loc=0, …)studyopedia
What happens if you press Ctrl + D in Excel?
a. Delete cell
b. Fill down
c. Insert row
d. Cut row
Answer: b. Fill downreadmcqs
In pandas, appending a row requires:
a. List
b. DataFrame or Series
c. Integer
d. Float
Answer: b. DataFrame or Seriesscribd
Which option adds a blank cell in spreadsheet software?
a. Insert > Shift cells left
b. Insert > Shift cells down
c. Delete cell
d. Format cell
Answer: b. Insert > Shift cells downtestbook
Which of the following can insert a new column in pandas?
a. <DataFrame>[‘new_col’] = …
b. insert()
c. assign()
d. All of the above
Answer: d. All of the abovestudyopedia+1
In SQL, which is true when values are inserted without specifying column names?
a. Columns must be in order
b. Only some columns filled
c. Random order is allowed
d. Values ignored
Answer: a. Columns must be in ordersanfoundry
Excel’s “Ctrl + Shift + Plus (+)” is a shortcut for:
a. Adding a worksheet
b. Inserting a new cell/row/column
c. Merging cells
d. Deleting a row
Answer: b. Inserting a new cell/row/columnsanfoundry
Inserted cells in Excel can shift:
a. Down only
b. Right only
c. Both a and b
d. Left only
Answer: c. Both a and btestbook
In pandas, what does axis=1 mean when inserting?
a. Row operation
b. Column operation
c. Index change
d. Delete operation
Answer: b. Column operationcsiplearninghub+1
SQL allows inserting how many rows at a time with VALUES clause directly?
a. Only one row
b. Any number of rows
c. One to ten rows
d. Ten rows only
Answer: a. Only one rowsanfoundry
In Excel, how do you insert a new cell using right-click?
a. Right-click cell > Insert
b. Right-click tab > Insert
c. Drag cell > Insert
d. Type “Insert” in cell
Answer: a. Right-click cell > Insertreadmcqs
In pandas, to insert a row by index, which method is preferred?
a. append()
b. loc[]
c. iloc[]
d. There is no direct method, use concat()
Answer: d. There is no direct method, use concat()askfilo
In SQL, to copy data from one table to another, the source and target should:
a. Have same number of columns and types
b. Be empty
c. Be indexed only
d. Use primary keys
Answer: a. Have same number of columns and typessanfoundry
Which menu in Excel has “Insert Cells”?
a. Home
b. File
c. Data
d. Review
Answer: a. Homereadmcqs
Inserting a cell in Excel can shift:
a. Cells right
b. Cells down
c. Either a or b
d. Cells up
Answer: c. Either a or btestbook
To add a new row in pandas at a given position, use:
a. insert()
b. concat() with index adjustment
c. append()
d. at()
Answer: b. concat() with index adjustmentscribd+1
What happens when using df[‘new_col’] = value in pandas?
a. Modifies DataFrame in place
b. Returns a new DataFrame
c. Deletes the column
d. Raises error
Answer: a. Modifies DataFrame in placetechtipnow
In SQL, omitting the VALUES clause in INSERT INTO can be replaced by:
a. SELECT
b. CREATE
c. UPDATE
d. DROP
Answer: a. SELECTsanfoundry
In spreadsheets, the Insert menu can add:
a. Rows
b. Columns
c. Cells
d. All of the above
Answer: d. All of the abovecsiplearninghub
In pandas, the DataFrame method insert requires:
a. index (position)
b. column name
c. column values
d. All of the above
Answer: d. All of the abovestudyopedia
The result of merging cells A1 and B1 in Excel is:
a. Only A1’s content remains
b. Both values concatenated
c. Both values deleted
d. B1’s content only
Answer: a. Only A1’s content remainstestbook
In pandas, which method can NOT add a row?
a. append()
b. loc[]
c. insert()
d. concat()
Answer: c. insert()askfilo+1
In SQL, what is required in the INSERT INTO statement to insert data?
a. Table name only
b. Table name and values
c. Table schema only
d. Column types only
Answer: b. Table name and valuessanfoundry
In Excel, inserting a column shifts:
a. Data left
b. Data right
c. Data down
d. Data up
Answer: b. Data rightcsiplearninghub+1
Using df.at[row, col] = value in pandas:
a. Inserts a value
b. Deletes a value
c. Drops a column
d. Concatenates columns
Answer: a. Inserts a valuecsiplearninghub+1
In SQL, to avoid column order requirements when inserting, specify:
a. Column names in the INSERT statement
b. Only the table name
c. Only primary key
d. Omit the table name
Answer: a. Column names in the INSERT statementsanfoundry
The shortcut for inserting a new worksheet in Excel is:
a. Ctrl + N
b. Shift + F11
c. Alt + Insert
d. Ctrl + W
Answer: b. Shift + F11sanfoundry+1
In pandas, insert() method changes the DataFrame:
a. In place
b. Returns a copy
c. Does not modify
d. Deletes previous columns
Answer: a. In placestudyopedia
In spreadsheet software, inserting new cells can cause:
a. Data overwrite
b. Data shift
c. Data loss always
d. No change
Answer: b. Data shifttestbook+1
In pandas, to insert multiple new columns efficiently use:
a. assign()
b. insert() in loop
c. Both a and b
d. append()
Answer: c. Both a and btechtipnow+1
Inserting values in SQL without specifying columns assumes:
a. All columns must be filled
b. Only some columns filled
c. Any order allowed
d. Random values permitted
Answer: a. All columns must be filledsanfoundry

Blog

Systemethic Technologies

Leave a Reply Cancel reply

Useful links

Other Terms & Policies

Contact Info