List of top Questions asked in CUET (UG)

What is the output of the following SQL query ?
SELECT * FROM STUDENTS WHERE SName like ‘%S’ and age > 18;

Which of the following statements is/are true ?
A. Group by function is used to group rows of a table that contain same values in a specified column.
B. The BETWEEN operator used for pattern matching
C. The IN operator selects the value that match any value in the given list of values
D. COUNT, MAX, MIN, AVG and SUM are multiple row functions works on a set of records and return a single value
E. Update table is used to change the data in a table
Choose the correct answer from the options given below :

Which of the following is the limitation of DBMS ?

Which of the following statement is not true ?

Consider the following table -

SID	SName	Contact No	Age	Course	Year
2301	Rajat	8167782923	0	CS	2022
2302	Kamal	8168842399	21	HIS	2023
2303	Amit	8167832455	20	ECO	2022
2304	Sujata	7987235422	20	MATH	2022
2305	Amita	6276542311	21	ENG	2023

Identify the correct pair of values :

<a+> opens the file in _____ and _____ mode.

Match List I with List II

List I		List II
A.	DML	I.	Not NULL
B.	Primary Key	II.	Create relations
C.	Alter table	III.	Insert records
D.	DDL	IV.	Add attribute

Choose the correct answer from the options given below :

A row in a table is called _____

The file offset position in <wb+> file mode is _____

Which method is used to write multiple strings of a file ?

Y and Z are partners in a firm. If W is admitted as a new partner, what will happen?

Ninza Ltd. forfeited \(1,200\) shares of \(₹ 10\) each, on which \(₹ 8 \) per share as called up and \(₹ 6\) per share was paid up. The amount with which share Capital Account will be debited at the time of forfeiture of Share will be:

At the time of admission of a new partner, general reserve appearing in the old Balance Sheet is transferred to:

Calculate Debt equity Ratio :
\(13\%\) Debentures \( ₹6,00,000\) 
Shareholders fund Z \(₹8,00,000\) 
Net Profit before tax \(₹3,51,000 \)
Current Liabilities \(₹1,60,000 \)

Arrange the following items in Correct order as per the Statement of Profit and Loss of a Company.
(A) Employee Benefit Expenses
(B)Finance Costs
(C) Depreciation and Amortisation
(D) Purchase of Stock in Trade
(E)Exceptional Items
Choose the correct answer from the options given below:

Which of the following items will be recorded in Revaluation A/c.
(A) Capital brought in by New partner 
(B) Plant is to depreciated by \( 20\% \)
(C) \(60,000\) brought in by new Partner for Goodwill 
(D) Stock overvalued by \( 5,000 \)
(E) Unrecorded creditors to the extent of \(₹ 1,500 \)
Choose the correct answer from the options given below: 

Arrange the following steps in correct order for calculation of Proportionate Capital of New Partner.
(A) Balancing the capital account of old partners 
(B) Calculation of Gain/Loss on Revaluation and transferring to Capital Account 
(C) Transferring Accumulated Profit to Capital account 
(D) Calculation of Proportionate Capital for New Partner 
(E) Adjustment for Goodwill in Partner's capital account 
Choose the correct answer from the options given below: 

Reserves and Surplus includes:
(A) Statement of Profits and Loss (Credit Balance) 
(B) Reserve Capital 
(C) Securities Premium Reserve 
(D) Capital Redemption Reserve 
(E) Share Application Money Pending Allotment 
Choose the correct answer from the options given below:

Match LIST I with LIST II

LIST I		LIST II
A	Liquidity Ratio	I	To check ability to meet long term contractual obligations
B	Solvency Ratio	II	To analyse the earning capacity of Business
C	Activity Ratio	III	To measure the short term Solvency
D	Profitability Ratio	IV	To measure the speed at which the activities of the business are being performed

Choose the correct answer from the options given below

Hem and Nem are partners in a firm Sharing Profits in the ratio of \( 3: 2\). Their Capitals were \(₹ 80,000\) and \(₹ 50,000\) respectively. They admitted Sam for \(\frac{1}{5}\) share and he brought \(₹ 60,000 \) as his Capital. Goodwill of the firm will be: 

Solvency Ratios include:
(A) Proprietory Ratio 
(B) Interest Coverage Ratio 
(C) Fixed Assets Turnover 
(D) Debt to Capital Employed Ratio 
(E) Operating Ratio 
Choose the correct answer from the options given below: 

Match LIST I with LIST II

LIST I		LIST II
A	Gain on sale of sports material	I	Liability side of Balance Sheet
B	Donation for Library	II	Income side of Income and Expenditure A/c
C	Grass seeds purchased	III	Assets side of Balance Sheet
D	Accrued Subscription	IV	Expenditure side of Income and Expenditure A/c

Choose the correct answer from the options given below

The correct order of items in the Cash Flow Statement should be:
(A) Calculate Net Profit before Tax and Extraordinary items 
(B) Cash generated from operation 
(C) Net profit as per Balance sheet 
(D) Cash flow from Operating Activities 
(E) Calculating Operating Profit before working Capital Changes
 Choose the correct answer from the options given below: 

Debit side of partner's current Account shows:
(A) Drawings made out of Capital 
(B) Interest on Drawings 
(C) Share of Loss on Revaluation 
(D) Additional Capital Introduced 
(E) Adjustment of Goodwill already appearing in Balance Sheet 
Choose the correct answer from the options given below: 
 

Arrange the following steps in correct sequence.
(A) Appropriation of profit like Interest on capital 
(B) Charge against profit 
(C) Distribution of profits among the partners 
(D) Transfer to General Reserve as a part of Divisible profits 
(E) Calculation of Net profit 
Choose the correct answer from the options given below: