MCQ-Grade12-computer-NEB

Multiple Choice Questions

1) The presence of a primary key attribute of a master table in a child table for setting a relationship is known as:

                a) Primary key
                b) Candidate key
                c) Foreign key

2) Which function is used to connect to the MySQL database in PHP?

                a) mysqli_connect()
                b) mysqli_Open()
                c) mysqli_query()
                d) $mysqli_con()

3) With SQL, how do you select all the records from a table named Persons where the value of the column FirstName starts with "a"?

                a) SELECT * FROM Persons WHERE FirstName="a";
                b) SELECT * FROM Persons WHERE FirstName="a%";
                c) SELECT * FROM Persons WHERE FirstName="%a";
                d) SELECT * FROM Persons WHERE FirstName="%a%";

4) Which statement is used to print the values in PHP?

                a) Cho
                b) Eecho
                c) echo
                d) Echho

5) Which syntax is used for opening and closing a PHP script?

                a) <php> ... </php>
                b) <?php ... ?>
                c) ?php ... ?php
                d) <p> ... </p>

6) What is the output of the statement printf("%d", (++a))?

                a) The value of a will be increased by 1 after the process
                b) The current value will be printed
                c) Error message
                d) The value of a will be increased by 1 and printed

7) Which of the following is an incorrect IP address?

                a) 192.168.0.1
                b) 192.168.1.256
                c) 172.255.0.0
                d) 202.10.79.4

8) Which of the following represents the fastest data transmission speed?

                a) Gbps
                b) Kbps
                c) Bps
                d) Mbps

9) What is the full form of Mbps?

                a) Mega Bits Per Second
                b) Mega Bytes Per Second
                c) Mega Bands Per Second
                d) Mega Bites Per Second

10) A key attribute of a master table being used in a child table for setting a relationship is known as:

                a) Primary key
                b) Candidate key
                c) Foreign key
                d) Super key

11) Which SQL keyword is used to retrieve data from a table?

                a) SELECT
                b) FROM
                c) WHERE
                d) JOIN

12) With SQL, how do you select all the records from a table named Persons where the value of the column FirstName ends with "a"?

                a) SELECT * FROM Persons WHERE FirstName="a";
                b) SELECT * FROM Persons WHERE FirstName="a%";
                c) SELECT * FROM Persons WHERE FirstName="%a";
                d) SELECT * FROM Persons WHERE FirstName="%a%";

13) What is the output of this statement printf("%d", (a++))?

                a) The value of (a + 1)
                b) Error message
                c) The current value of a
                d) Garbage

14) Which of the following methods is used to access HTML elements using JavaScript?

                a) getElementById()
                b) getElementByClassName()
                c) getElementsByTagName()
                d) All of the above

15) Which function is used to connect to the MySQL database?

                a) mysqli_connect()
                b) mysqli_query()
                c) mysqli_Open()
                d) $mysqli_con()

16 Which of the following is a remote login service?

                a) Video Conference
                b) Telnet
                c) FTP
                d) All

17) Which protocol is used to deliver messages to the mail server?

                a) FTP
                b) TCP
                c) SMTP
                d) POP

18) Which layer of OSI is responsible for controlling the flow of data and error correction?

                a) Transport
                b) Network
                c) Application
                d) Session